VIEW: APPS.IGF_GR_RFMS_DISB

Source

View Text - Preformatted

SELECT RFMD.ROWID, RFMD.RFMD_ID, RFMD.ORIGINATION_ID, RFMD.DISB_REF_NUM, RFMD.DISB_DT, RFMD.DISB_AMT, RFMD.DB_CR_FLAG, RFMD.DISB_ACK_ACT_STATUS, RFMD.DISB_STATUS_DT, RFMD.ACCPT_DISB_DT, RFMD.DISB_ACCPT_AMT, RFMD.ACCPT_DB_CR_FLAG, RFMD.DISB_YTD_AMT, RFMD.PYMT_PRD_START_DT, RFMD.ACCPT_PYMT_PRD_START_DT, RFMD.EDIT_CODE, RFMD.RFMB_ID, RFMD.CREATED_BY, RFMD.CREATION_DATE, RFMD.LAST_UPDATED_BY, RFMD.LAST_UPDATE_DATE, RFMD.LAST_UPDATE_LOGIN, RFMD.PROGRAM_APPLICATION_ID, RFMD.PROGRAM_ID, RFMD.PROGRAM_UPDATE_DATE, RFMD.REQUEST_ID, RFMD.ORG_ID, RFMD.ed_use_flags FROM IGF_GR_RFMS_DISB_ALL RFMD WHERE NVL (RFMD.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 RFMD.ROWID
, RFMD.RFMD_ID
, RFMD.ORIGINATION_ID
, RFMD.DISB_REF_NUM
, RFMD.DISB_DT
, RFMD.DISB_AMT
, RFMD.DB_CR_FLAG
, RFMD.DISB_ACK_ACT_STATUS
, RFMD.DISB_STATUS_DT
, RFMD.ACCPT_DISB_DT
, RFMD.DISB_ACCPT_AMT
, RFMD.ACCPT_DB_CR_FLAG
, RFMD.DISB_YTD_AMT
, RFMD.PYMT_PRD_START_DT
, RFMD.ACCPT_PYMT_PRD_START_DT
, RFMD.EDIT_CODE
, RFMD.RFMB_ID
, RFMD.CREATED_BY
, RFMD.CREATION_DATE
, RFMD.LAST_UPDATED_BY
, RFMD.LAST_UPDATE_DATE
, RFMD.LAST_UPDATE_LOGIN
, RFMD.PROGRAM_APPLICATION_ID
, RFMD.PROGRAM_ID
, RFMD.PROGRAM_UPDATE_DATE
, RFMD.REQUEST_ID
, RFMD.ORG_ID
, RFMD.ED_USE_FLAGS
FROM IGF_GR_RFMS_DISB_ALL RFMD
WHERE NVL (RFMD.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)