VIEW: APPS.IGF_GR_RFMS_BATCH

Source

View Text - Preformatted

SELECT RFMSBT.ROWID ROW_ID , RFMSBT.RFMB_ID , RFMSBT.BATCH_ID , RFMSBT.DATA_REC_LENGTH , RFMSBT.OPE_ID , RFMSBT.SOFTWARE_PROVIDOR , RFMSBT.RFMS_PROCESS_DT , RFMSBT.RFMS_ACK_DT , RFMSBT.RFMS_ACK_BATCH_ID , RFMSBT.REJECT_REASON , RFMSBT.CREATED_BY , RFMSBT.CREATION_DATE , RFMSBT.LAST_UPDATE_DATE , RFMSBT.LAST_UPDATED_BY , RFMSBT.LAST_UPDATE_LOGIN , RFMSBT.PROGRAM_APPLICATION_ID , RFMSBT.PROGRAM_ID , RFMSBT.PROGRAM_UPDATE_DATE , RFMSBT.REQUEST_ID , RFMSBT.ORG_ID FROM IGF_GR_RFMS_BATCH_ALL RFMSBT WHERE NVL (RFMSBT.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 RFMSBT.ROWID ROW_ID
, RFMSBT.RFMB_ID
, RFMSBT.BATCH_ID
, RFMSBT.DATA_REC_LENGTH
, RFMSBT.OPE_ID
, RFMSBT.SOFTWARE_PROVIDOR
, RFMSBT.RFMS_PROCESS_DT
, RFMSBT.RFMS_ACK_DT
, RFMSBT.RFMS_ACK_BATCH_ID
, RFMSBT.REJECT_REASON
, RFMSBT.CREATED_BY
, RFMSBT.CREATION_DATE
, RFMSBT.LAST_UPDATE_DATE
, RFMSBT.LAST_UPDATED_BY
, RFMSBT.LAST_UPDATE_LOGIN
, RFMSBT.PROGRAM_APPLICATION_ID
, RFMSBT.PROGRAM_ID
, RFMSBT.PROGRAM_UPDATE_DATE
, RFMSBT.REQUEST_ID
, RFMSBT.ORG_ID
FROM IGF_GR_RFMS_BATCH_ALL RFMSBT
WHERE NVL (RFMSBT.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)