VIEW: APPS.IGS_AS_DOC_FEE_PMNT_V

Source

View Text - Preformatted

SELECT dfpv.rowid , dfpv.person_id , hz.party_number , hz.party_name , dfpv.fee_paid_date , dfpv.fee_amount , dfpv.fee_recorded_date , dfpv.fee_recorded_by , dfpv.created_by , dfpv.creation_date , dfpv.last_updated_by , dfpv.last_update_date , dfpv.last_update_login , dfpv.plan_id , asp.plan_type , asp.quantity_limit , asp.period_of_plan , lkv.meaning , asp.total_periods_covered , dfpv.invoice_id , dfpv.plan_discon_from , dfpv.plan_discon_by, (SELECT hz1.party_number FROM hz_parties hz1 WHERE hz1.party_id = dfpv.plan_discon_by ) , dfpv.num_of_copies , dfpv.prev_paid_plan , dfpv.cal_type , dfpv.ci_sequence_number , (SELECT ci.description FROM igs_ca_inst ci WHERE ci.cal_type = dfpv.cal_type AND ci.sequence_number = dfpv.ci_sequence_number AND asp.period_of_plan IN ('ACADEMIC','TERM') ), asp.quantity_limit - dfpv.num_of_copies, dfpv.program_on_file FROM igs_as_doc_fee_pmnt dfpv, hz_parties hz, igs_as_servic_plan asp, igs_lookup_values lkv WHERE dfpv.person_id = hz.party_id AND dfpv.plan_id = asp.plan_id AND lkv.lookup_code = asp.period_of_plan AND lkv.lookup_type = 'PERIOD_OF_PLAN'

View Text - HTML Formatted

SELECT DFPV.ROWID
, DFPV.PERSON_ID
, HZ.PARTY_NUMBER
, HZ.PARTY_NAME
, DFPV.FEE_PAID_DATE
, DFPV.FEE_AMOUNT
, DFPV.FEE_RECORDED_DATE
, DFPV.FEE_RECORDED_BY
, DFPV.CREATED_BY
, DFPV.CREATION_DATE
, DFPV.LAST_UPDATED_BY
, DFPV.LAST_UPDATE_DATE
, DFPV.LAST_UPDATE_LOGIN
, DFPV.PLAN_ID
, ASP.PLAN_TYPE
, ASP.QUANTITY_LIMIT
, ASP.PERIOD_OF_PLAN
, LKV.MEANING
, ASP.TOTAL_PERIODS_COVERED
, DFPV.INVOICE_ID
, DFPV.PLAN_DISCON_FROM
, DFPV.PLAN_DISCON_BY
, (SELECT HZ1.PARTY_NUMBER
FROM HZ_PARTIES HZ1
WHERE HZ1.PARTY_ID = DFPV.PLAN_DISCON_BY )
, DFPV.NUM_OF_COPIES
, DFPV.PREV_PAID_PLAN
, DFPV.CAL_TYPE
, DFPV.CI_SEQUENCE_NUMBER
, (SELECT CI.DESCRIPTION
FROM IGS_CA_INST CI
WHERE CI.CAL_TYPE = DFPV.CAL_TYPE
AND CI.SEQUENCE_NUMBER = DFPV.CI_SEQUENCE_NUMBER
AND ASP.PERIOD_OF_PLAN IN ('ACADEMIC'
, 'TERM') )
, ASP.QUANTITY_LIMIT - DFPV.NUM_OF_COPIES
, DFPV.PROGRAM_ON_FILE
FROM IGS_AS_DOC_FEE_PMNT DFPV
, HZ_PARTIES HZ
, IGS_AS_SERVIC_PLAN ASP
, IGS_LOOKUP_VALUES LKV
WHERE DFPV.PERSON_ID = HZ.PARTY_ID
AND DFPV.PLAN_ID = ASP.PLAN_ID
AND LKV.LOOKUP_CODE = ASP.PERIOD_OF_PLAN
AND LKV.LOOKUP_TYPE = 'PERIOD_OF_PLAN'