eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.IGFFV_STUDENT_COA

Source

View Text - Preformatted


SELECT COAI.ITEM_CODE, COAI.AMOUNT, COAI.PELL_COA_AMOUNT, COAI.ALT_PELL_AMOUNT, '_LA:COAI.FIXED_COST:IGF_LOOKUPS_VIEW:IGF_AP_YES_NO:MEANING', '_LA:COAI.LEGACY_RECORD_FLAG:IGF_LOOKUPS_VIEW:IGF_AP_YES_NO:MEANING', PE.PARTY_NUMBER, PE.PARTY_NAME, CI.ALTERNATE_CODE, CI.DESCRIPTION, AWITEM.DESCRIPTION, COAI.BASE_ID, COAI.CREATED_BY, COAI.CREATION_DATE, COAI.LAST_UPDATED_BY, COAI.LAST_UPDATE_DATE , BASE.PERSON_ID FROM IGF_AW_COA_ITEMS COAI, IGF_AW_ITEM AWITEM, IGF_AP_FA_BASE_REC_ALL BASE, IGS_CA_INST_ALL CI, HZ_PARTIES PE WHERE AWITEM.ITEM_CODE = COAI.ITEM_CODE AND COAI.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 COAI.ITEM_CODE
, COAI.AMOUNT
, COAI.PELL_COA_AMOUNT
, COAI.ALT_PELL_AMOUNT
, '_LA:COAI.FIXED_COST:IGF_LOOKUPS_VIEW:IGF_AP_YES_NO:MEANING'
, '_LA:COAI.LEGACY_RECORD_FLAG:IGF_LOOKUPS_VIEW:IGF_AP_YES_NO:MEANING'
, PE.PARTY_NUMBER
, PE.PARTY_NAME
, CI.ALTERNATE_CODE
, CI.DESCRIPTION
, AWITEM.DESCRIPTION
, COAI.BASE_ID
, COAI.CREATED_BY
, COAI.CREATION_DATE
, COAI.LAST_UPDATED_BY
, COAI.LAST_UPDATE_DATE
, BASE.PERSON_ID
FROM IGF_AW_COA_ITEMS COAI
, IGF_AW_ITEM AWITEM
, IGF_AP_FA_BASE_REC_ALL BASE
, IGS_CA_INST_ALL CI
, HZ_PARTIES PE
WHERE AWITEM.ITEM_CODE = COAI.ITEM_CODE
AND COAI.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