Product: | IGF - Financial Aid |
---|---|
Description: | |
Implementation/DBA Data: | APPS.IGF_AP_INST_VER_ITEM |
SELECT IVI.ROWID ROW_ID
, IVI.BASE_ID
, IVI.UDF_VERN_ITEM_SEQ_NUM
, IVI.ITEM_VALUE
, IVI.WAIVE_FLAG
, IVI.USE_BLANK_FLAG
, IVI.LEGACY_RECORD_FLAG
, IVI.CREATED_BY
, IVI.CREATION_DATE
, IVI.LAST_UPDATED_BY
, IVI.LAST_UPDATE_DATE
, IVI.LAST_UPDATE_LOGIN
, IVI.ORG_ID
, IVI.INCL_IN_TOLERANCE
, IVI.ISIR_MAP_COL FROM IGF_AP_INST_VER_ITEM_ALL IVI
WHERE NVL (IVI.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)