Product: | IGF - Financial Aid |
---|---|
Description: | |
Implementation/DBA Data: | APPS.IGF_SL_CL_BATCH |
SELECT CLBTCH.ROWID ROW_ID
, CLBTCH.CBTH_ID
, CLBTCH.BATCH_ID
, CLBTCH.FILE_CREATION_DATE
, CLBTCH.FILE_TRANS_DATE
, CLBTCH.FILE_IDENT_CODE
, CLBTCH.RECIPIENT_ID
, CLBTCH.RECIP_NON_ED_BRC_ID
, CLBTCH.SOURCE_ID
, CLBTCH.SOURCE_NON_ED_BRC_ID
, CLBTCH.SEND_RESP
, CLBTCH.CREATED_BY
, CLBTCH.CREATION_DATE
, CLBTCH.LAST_UPDATED_BY
, CLBTCH.LAST_UPDATE_DATE
, CLBTCH.LAST_UPDATE_LOGIN
, CLBTCH.REQUEST_ID
, CLBTCH.PROGRAM_APPLICATION_ID
, CLBTCH.PROGRAM_ID
, CLBTCH.PROGRAM_UPDATE_DATE
, CLBTCH.ORG_ID
, CLBTCH.RECORD_COUNT_NUM
, CLBTCH.TOTAL_NET_DISB_AMT
, CLBTCH.TOTAL_NET_EFT_AMT
, CLBTCH.TOTAL_NET_NON_EFT_AMT
, CLBTCH.TOTAL_REISSUE_AMT
, CLBTCH.TOTAL_CANCEL_AMT
, CLBTCH.TOTAL_DEFICIT_AMT
, CLBTCH.TOTAL_NET_CANCEL_AMT
, CLBTCH.TOTAL_NET_OUT_CANCEL_AMT
FROM IGF_SL_CL_BATCH_ALL CLBTCH
WHERE NVL (CLBTCH.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)