View: IGS_FI_SUB_CA_INS_V

Product:	IGS - Student System
Description:	This is for selecting the distinct records for person Id,Subaccount Id,Fee Calendar Type and Fee Calendar Instance.
Implementation/DBA Data:	APPS.IGS_FI_SUB_CA_INS_V

View Text

SELECT DISTINCT INV.PERSON_ID
, INV.SUBACCOUNT_ID
, INV.FEE_CAL_TYPE
, INV.FEE_CI_SEQUENCE_NUMBER
, CI.START_DT
, CI.END_DT
FROM IGS_FI_INV_INT INV
, IGS_CA_INST CI
WHERE INV.FEE_CAL_TYPE=CI.CAL_TYPE
AND INV.FEE_CI_SEQUENCE_NUMBER=CI.SEQUENCE_NUMBER

Columns