Product: | IGS - Student System (Obsolete) |
---|---|
Description: | Contains the Order Document Fee Payment against a transcript service plan for student. Also captures the data regarding the unsubscription of the transcript service plan. |
Implementation/DBA Data: | Not implemented in this database |
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'