VIEW: APPS.IGS_FI_BILL_PLN_CRD_V

Source

View Text - Preformatted

SELECT PLN.ROWID , PLN.BILL_ID , PLN.PLN_CREDIT_DATE , PLN.AWARD_ID , PLN.DISB_NUM , PLN.FUND_ID , FMAST.FUND_CODE , PLN.FEE_CAL_TYPE , PLN.FEE_CI_SEQUENCE_NUMBER, PLN.PLN_CREDIT_AMOUNT, INST.START_DT , INST.END_DT , PLN.BILL_DESC , PLN.CREATED_BY , PLN.CREATION_DATE , PLN.LAST_UPDATED_BY , PLN.LAST_UPDATE_DATE , PLN.LAST_UPDATE_LOGIN , PLN.REQUEST_ID , PLN.PROGRAM_APPLICATION_ID, PLN.PROGRAM_ID , PLN.PROGRAM_UPDATE_DATE FROM IGS_FI_BILL_PLN_CRD PLN, IGF_AW_FUND_MAST FMAST, IGS_CA_INST INST WHERE PLN.FEE_CAL_TYPE = INST.CAL_TYPE (+) AND PLN.FEE_CI_SEQUENCE_NUMBER = INST.SEQUENCE_NUMBER (+) AND PLN.FUND_ID = FMAST.FUND_ID

View Text - HTML Formatted

SELECT PLN.ROWID
, PLN.BILL_ID
, PLN.PLN_CREDIT_DATE
, PLN.AWARD_ID
, PLN.DISB_NUM
, PLN.FUND_ID
, FMAST.FUND_CODE
, PLN.FEE_CAL_TYPE
, PLN.FEE_CI_SEQUENCE_NUMBER
, PLN.PLN_CREDIT_AMOUNT
, INST.START_DT
, INST.END_DT
, PLN.BILL_DESC
, PLN.CREATED_BY
, PLN.CREATION_DATE
, PLN.LAST_UPDATED_BY
, PLN.LAST_UPDATE_DATE
, PLN.LAST_UPDATE_LOGIN
, PLN.REQUEST_ID
, PLN.PROGRAM_APPLICATION_ID
, PLN.PROGRAM_ID
, PLN.PROGRAM_UPDATE_DATE
FROM IGS_FI_BILL_PLN_CRD PLN
, IGF_AW_FUND_MAST FMAST
, IGS_CA_INST INST
WHERE PLN.FEE_CAL_TYPE = INST.CAL_TYPE (+)
AND PLN.FEE_CI_SEQUENCE_NUMBER = INST.SEQUENCE_NUMBER (+)
AND PLN.FUND_ID = FMAST.FUND_ID