PSC_COM_FIN_LEDGER_V

Details

• Schema: FUSION

• Object owner: PSC

• Object type: VIEW

Columns

Name
LEDGER_ID LEDGER_NAME LEDGER_CATEGORY_CODE OBJECT_TYPE_CODE LE_LEDGER_TYPE_CODE COMPLETION_STATUS_CODE CONFIGURATION_ID CHART_OF_ACCOUNTS_ID CURRENCY_CODE PERIOD_SET_NAME ACCOUNTED_PERIOD_TYPE CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN OBJECT_VERSION_NUMBER

Query

SQL_Statement

SELECT B.LEDGER_ID, B.NAME AS LEDGER_NAME, B.LEDGER_CATEGORY_CODE, B.OBJECT_TYPE_CODE, B.LE_LEDGER_TYPE_CODE, B.COMPLETION_STATUS_CODE, B.CONFIGURATION_ID, B.CHART_OF_ACCOUNTS_ID, B.CURRENCY_CODE, B.PERIOD_SET_NAME, B.ACCOUNTED_PERIOD_TYPE, B.CREATED_BY, B.CREATION_DATE, B.LAST_UPDATED_BY, B.LAST_UPDATE_DATE, B.LAST_UPDATE_LOGIN, B.OBJECT_VERSION_NUMBER FROM GL_LEDGERS B WHERE B.COMPLETION_STATUS_CODE='CONFIRMED'