View: IGI_IAC_BOOK_CONTROLS_V

Product:	IGI - Public Sector Financials International
Description:
Implementation/DBA Data:	APPS.IGI_IAC_BOOK_CONTROLS_V

View Text

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)

Columns