Product: | IGI - Public Sector Financials International |
---|---|
Description: | |
Implementation/DBA Data: | APPS.IGI_IAC_BOOK_CONTROLS_V |
SELECT IBC.ROWID ROW_ID
, IBC.BOOK_TYPE_CODE
, IBC.GL_JE_SOURCE
, IBC.JE_IAC_DEPRN_CATEGORY
, IBC.JE_IAC_REVAL_CATEGORY
, IBC.JE_IAC_TXN_CATEGORY
, IBC.PERIOD_NUM_FOR_CATCHUP
, IBC.ORG_ID
, IBC.CREATED_BY
, IBC.CREATION_DATE
, IBC.LAST_UPDATE_LOGIN
, IBC.LAST_UPDATE_DATE
, IBC.LAST_UPDATED_BY
FROM IGI_IAC_BOOK_CONTROLS IBC
WHERE NVL(ORG_ID
, NVL(TO_NUMBER(DECODE(SUBSTR(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTR(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)) = NVL(TO_NUMBER(DECODE(SUBSTR(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTR(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)