Product: | IGF - Financial Aid |
---|---|
Description: | |
Implementation/DBA Data: | APPS.IGF_SL_DL_BATCH |
SELECT DBTH.ROWID
, DBTH.DBTH_ID
, DBTH.BATCH_ID
, DBTH.MESSAGE_CLASS
, DBTH.BTH_CREATION_DATE
, DBTH.BATCH_REJ_CODE
, DBTH.END_DATE
, DBTH.BATCH_TYPE
, DBTH.SEND_RESP
, DBTH.STATUS
, DBTH.CREATED_BY
, DBTH.CREATION_DATE
, DBTH.LAST_UPDATED_BY
, DBTH.LAST_UPDATE_DATE
, DBTH.LAST_UPDATE_LOGIN
, DBTH.REQUEST_ID
, DBTH.PROGRAM_APPLICATION_ID
, DBTH.PROGRAM_ID
, DBTH.PROGRAM_UPDATE_DATE
, DBTH.ORG_ID
FROM IGF_SL_DL_BATCH_ALL DBTH
WHERE NVL (DBTH.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)