VIEW: APPS.IGF_SL_CL_BATCH

Source

View Text - Preformatted

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)

View Text - HTML Formatted

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)