View: IGF_AW_COA_HIST_V

Product:	IGF - Financial Aid
Description:	Cost of Attendance History View
Implementation/DBA Data:	APPS.IGF_AW_COA_HIST_V

View Text

SELECT COA.ROWID
, COA.COAH_ID
, COA.BASE_ID
, HZ.PARTY_NUMBER
, HZ.PERSON_LAST_NAME||'
, '||HZ.PERSON_FIRST_NAME PERSON_NAME
, PIT.API_PERSON_ID SSN
, COA.TRAN_DATE
, COA.ITEM_CODE
, FA.CI_CAL_TYPE
, FA.CI_SEQUENCE_NUMBER
, COA.LD_CAL_TYPE
, COA.LD_SEQUENCE_NUMBER
, CA.ALTERNATE_CODE
, COA.OPERATION_TXT
, LK.MEANING
, COA.OLD_VALUE
, COA.NEW_VALUE
, COA.REQUEST_ID
, COA.LAST_UPDATED_BY
, FND.USER_NAME LAST_UPDATED_USER
FROM IGF_AW_COA_HIST COA
, IGS_CA_INST CA
, IGF_AP_FA_BASE_REC FA
, FND_USER FND
, IGF_LOOKUPS_VIEW LK
, HZ_PARTIES HZ
, (SELECT API_PERSON_ID
, PE_PERSON_ID
FROM IGS_PE_PERSON_ID_TYP PIT_2
, IGS_PE_ALT_PERS_ID API_2
WHERE API_2.PERSON_ID_TYPE = PIT_2.PERSON_ID_TYPE
AND PIT_2.S_PERSON_ID_TYPE = 'SSN'
AND SYSDATE BETWEEN API_2.START_DT
AND NVL(API_2.END_DT
, SYSDATE) ) PIT
WHERE CA.CAL_TYPE = COA.LD_CAL_TYPE
AND CA.SEQUENCE_NUMBER = COA.LD_SEQUENCE_NUMBER
AND FA.BASE_ID = COA.BASE_ID
AND FND.USER_ID = COA.LAST_UPDATED_BY
AND LK.LOOKUP_TYPE = 'IGF_AW_DML_OPERATION'
AND COA.OPERATION_TXT = LK.LOOKUP_CODE
AND LK.ENABLED_FLAG = 'Y'
AND HZ.PARTY_ID = FA.PERSON_ID
AND PIT.PE_PERSON_ID = FA.PERSON_ID

Columns