Product: | OKL - Leasing and Finance Management |
---|---|
Description: | Accounting entry headers |
Implementation/DBA Data: | Not implemented in this database |
SELECT AEHB.ROWID ROW_ID
, AEHB.AE_HEADER_ID AE_HEADER_ID
, AEHB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, AEHB.ACCOUNTING_EVENT_ID ACCOUNTING_EVENT_ID
, AEHB.SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, AEHB.ORG_ID ORG_ID
, AEHB.AE_CATEGORY AE_CATEGORY
, AEHB.SEQUENCE_ID SEQUENCE_ID
, AEHB.SEQUENCE_VALUE SEQUENCE_VALUE
, AEHB.PERIOD_NAME PERIOD_NAME
, AEHB.ACCOUNTING_DATE ACCOUNTING_DATE
, AEHB.DESCRIPTION DESCRIPTION
, AEHB.ACCOUNTING_ERROR_CODE ACCOUNTING_ERROR_CODE
, AEHB.CROSS_CURRENCY_FLAG CROSS_CURRENCY_FLAG
, AEHB.GL_TRANSFER_FLAG GL_TRANSFER_FLAG
, AEHB.GL_TRANSFER_ERROR_CODE GL_TRANSFER_ERROR_CODE
, AEHB.GL_TRANSFER_RUN_ID GL_TRANSFER_RUN_ID
, AEHB.GL_REVERSAL_FLAG GL_REVERSAL_FLAG
, AEHB.POST_TO_GL_FLAG POST_TO_GL_FLAG
, AEHB.PROGRAM_ID PROGRAM_ID
, AEHB.PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, AEHB.PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, AEHB.REQUEST_ID REQUEST_ID
, AEHB.CREATED_BY CREATED_BY
, AEHB.CREATION_DATE CREATION_DATE
, AEHB.LAST_UPDATED_BY LAST_UPDATED_BY
, AEHB.LAST_UPDATE_DATE LAST_UPDATE_DATE
, AEHB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM OKL_AE_HEADERS AEHB
WHERE NVL(ORG_ID
, NVL(TO_NUMBER(DECODE( SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)) = NVL(TO_NUMBER(DECODE( SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)