VIEW: APPS.IGFBV_STUDENT_COA_TERM_DETAILS

Source

View Text - Preformatted

SELECT COAIT.ITEM_CODE, COAIT.AMOUNT, CI.ALTERNATE_CODE, CI.DESCRIPTION, LOAD.ALTERNATE_CODE, LOAD.DESCRIPTION, LOAD.START_DT, LOAD.END_DT, PE.PARTY_NUMBER, PE.PARTY_NAME, AWITEM.DESCRIPTION, COAIT.LD_CAL_TYPE, COAIT.LD_SEQUENCE_NUMBER, COAIT.BASE_ID, COAIT.CREATED_BY, COAIT.CREATION_DATE, COAIT.LAST_UPDATED_BY, COAIT.LAST_UPDATE_DATE , BASE.PERSON_ID FROM IGF_AW_COA_ITM_TERMS COAIT, IGF_AW_ITEM AWITEM, IGS_CA_INST_ALL LOAD, IGF_AP_FA_BASE_REC_ALL BASE, IGS_CA_INST_ALL CI, HZ_PARTIES PE WHERE COAIT.ITEM_CODE = AWITEM.ITEM_CODE AND LOAD.CAL_TYPE = COAIT.LD_CAL_TYPE AND LOAD.SEQUENCE_NUMBER = COAIT.LD_SEQUENCE_NUMBER AND COAIT.BASE_ID = BASE.BASE_ID AND BASE.CI_CAL_TYPE = CI.CAL_TYPE AND BASE.CI_SEQUENCE_NUMBER = CI.SEQUENCE_NUMBER AND BASE.PERSON_ID = PE.PARTY_ID WITH READ ONLY

View Text - HTML Formatted

SELECT COAIT.ITEM_CODE
, COAIT.AMOUNT
, CI.ALTERNATE_CODE
, CI.DESCRIPTION
, LOAD.ALTERNATE_CODE
, LOAD.DESCRIPTION
, LOAD.START_DT
, LOAD.END_DT
, PE.PARTY_NUMBER
, PE.PARTY_NAME
, AWITEM.DESCRIPTION
, COAIT.LD_CAL_TYPE
, COAIT.LD_SEQUENCE_NUMBER
, COAIT.BASE_ID
, COAIT.CREATED_BY
, COAIT.CREATION_DATE
, COAIT.LAST_UPDATED_BY
, COAIT.LAST_UPDATE_DATE
, BASE.PERSON_ID
FROM IGF_AW_COA_ITM_TERMS COAIT
, IGF_AW_ITEM AWITEM
, IGS_CA_INST_ALL LOAD
, IGF_AP_FA_BASE_REC_ALL BASE
, IGS_CA_INST_ALL CI
, HZ_PARTIES PE
WHERE COAIT.ITEM_CODE = AWITEM.ITEM_CODE
AND LOAD.CAL_TYPE = COAIT.LD_CAL_TYPE
AND LOAD.SEQUENCE_NUMBER = COAIT.LD_SEQUENCE_NUMBER
AND COAIT.BASE_ID = BASE.BASE_ID
AND BASE.CI_CAL_TYPE = CI.CAL_TYPE
AND BASE.CI_SEQUENCE_NUMBER = CI.SEQUENCE_NUMBER
AND BASE.PERSON_ID = PE.PARTY_ID WITH READ ONLY