VIEW: APPS.IGF_AW_AWD_DISB

Source

View Text - Preformatted

SELECT ADISB.ROWID ROW_ID, ADISB.AWARD_ID AWARD_ID, ADISB.DISB_NUM DISB_NUM, ADISB.TP_CAL_TYPE TP_CLA_TYPE, ADISB.TP_SEQUENCE_NUMBER TP_SEQUENCE_NUMBER, ADISB.DISB_GROSS_AMT DISB_GROSS_AMT, ADISB.FEE_1 FEE_1 , ADISB.FEE_2 FEE_2 , ADISB.DISB_NET_AMT DISB_NET_AMT, ADISB.DISB_DATE DISB_DATE , ADISB.TRANS_TYPE TRANS_TYPE , ADISB.ELIG_STATUS ELIG_STATUS, ADISB.ELIG_STATUS_DATE ELIG_STATUS_DATE , ADISB.AFFIRM_FLAG AFFIRM_FLAG , ADISB.HOLD_REL_IND HOLD_REL_IND, ADISB.MANUAL_HOLD_IND MANUAL_HOLD_IND, ADISB.DISB_STATUS DISB_STATUS, ADISB.DISB_STATUS_DATE DISB_STATUS_DATE , ADISB.LATE_DISB_IND LATE_DISB_IND , ADISB.FUND_DIST_MTHD FUND_DIST_MTHD , ADISB.PREV_REPORTED_IND PREV_REPORTED_IND, ADISB.FUND_RELEASE_DATE FUND_RELEASE_DATE, ADISB.FUND_STATUS FUND_STATUS , ADISB.FUND_STATUS_DATE FUND_STATUS_DATE, ADISB.FEE_PAID_1 FEE_PAID_1 , ADISB.FEE_PAID_2 FEE_PAID_2 , ADISB.CHEQUE_NUMBER CHEQUE_NUMBER , ADISB.LD_CAL_TYPE LD_CAL_TYPE, ADISB.LD_SEQUENCE_NUMBER LD_SEQUENCE_NUMBER, ADISB.DISB_ACCEPTED_AMT DISB_ACCEPTED_AMT, ADISB.DISB_PAID_AMT DISB_PAID_AMT, ADISB.RVSN_ID RVSN_ID, ADISB.INT_REBATE_AMT, ADISB.FORCE_DISB, ADISB.DISB_EXP_DT, ADISB.MIN_CREDIT_PTS, ADISB.VERF_ENFR_DT, ADISB.CREATED_BY CREATED_BY , ADISB.CREATION_DATE CREATION_DATE , ADISB.LAST_UPDATED_BY LAST_UPDATED_BY, ADISB.LAST_UPDATE_DATE LAST_UPDATE_DATE , ADISB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN , ADISB.REQUEST_ID REQUEST_ID , ADISB.PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, ADISB.PROGRAM_ID PROGRAM_ID , ADISB.PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE , NULL, NULL, NULL, NULL, ADISB.FEE_CLASS FEE_CLASS, ADISB.SHOW_ON_BILL, ADISB.ATTENDANCE_TYPE_CODE, ADISB.BASE_ATTENDANCE_TYPE_CODE, ADISB.PAYMENT_PRD_ST_DATE, ADISB.CHANGE_TYPE_CODE, ADISB.FUND_RETURN_MTHD_CODE, ADISB.DIRECT_TO_BORR_FLAG FROM IGF_AW_AWD_DISB_ALL ADISB WHERE NVL (ADISB.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 ADISB.ROWID ROW_ID
, ADISB.AWARD_ID AWARD_ID
, ADISB.DISB_NUM DISB_NUM
, ADISB.TP_CAL_TYPE TP_CLA_TYPE
, ADISB.TP_SEQUENCE_NUMBER TP_SEQUENCE_NUMBER
, ADISB.DISB_GROSS_AMT DISB_GROSS_AMT
, ADISB.FEE_1 FEE_1
, ADISB.FEE_2 FEE_2
, ADISB.DISB_NET_AMT DISB_NET_AMT
, ADISB.DISB_DATE DISB_DATE
, ADISB.TRANS_TYPE TRANS_TYPE
, ADISB.ELIG_STATUS ELIG_STATUS
, ADISB.ELIG_STATUS_DATE ELIG_STATUS_DATE
, ADISB.AFFIRM_FLAG AFFIRM_FLAG
, ADISB.HOLD_REL_IND HOLD_REL_IND
, ADISB.MANUAL_HOLD_IND MANUAL_HOLD_IND
, ADISB.DISB_STATUS DISB_STATUS
, ADISB.DISB_STATUS_DATE DISB_STATUS_DATE
, ADISB.LATE_DISB_IND LATE_DISB_IND
, ADISB.FUND_DIST_MTHD FUND_DIST_MTHD
, ADISB.PREV_REPORTED_IND PREV_REPORTED_IND
, ADISB.FUND_RELEASE_DATE FUND_RELEASE_DATE
, ADISB.FUND_STATUS FUND_STATUS
, ADISB.FUND_STATUS_DATE FUND_STATUS_DATE
, ADISB.FEE_PAID_1 FEE_PAID_1
, ADISB.FEE_PAID_2 FEE_PAID_2
, ADISB.CHEQUE_NUMBER CHEQUE_NUMBER
, ADISB.LD_CAL_TYPE LD_CAL_TYPE
, ADISB.LD_SEQUENCE_NUMBER LD_SEQUENCE_NUMBER
, ADISB.DISB_ACCEPTED_AMT DISB_ACCEPTED_AMT
, ADISB.DISB_PAID_AMT DISB_PAID_AMT
, ADISB.RVSN_ID RVSN_ID
, ADISB.INT_REBATE_AMT
, ADISB.FORCE_DISB
, ADISB.DISB_EXP_DT
, ADISB.MIN_CREDIT_PTS
, ADISB.VERF_ENFR_DT
, ADISB.CREATED_BY CREATED_BY
, ADISB.CREATION_DATE CREATION_DATE
, ADISB.LAST_UPDATED_BY LAST_UPDATED_BY
, ADISB.LAST_UPDATE_DATE LAST_UPDATE_DATE
, ADISB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, ADISB.REQUEST_ID REQUEST_ID
, ADISB.PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, ADISB.PROGRAM_ID PROGRAM_ID
, ADISB.PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, NULL
, NULL
, NULL
, NULL
, ADISB.FEE_CLASS FEE_CLASS
, ADISB.SHOW_ON_BILL
, ADISB.ATTENDANCE_TYPE_CODE
, ADISB.BASE_ATTENDANCE_TYPE_CODE
, ADISB.PAYMENT_PRD_ST_DATE
, ADISB.CHANGE_TYPE_CODE
, ADISB.FUND_RETURN_MTHD_CODE
, ADISB.DIRECT_TO_BORR_FLAG
FROM IGF_AW_AWD_DISB_ALL ADISB
WHERE NVL (ADISB.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)