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
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
|
|
|