VIEW: APPS.IGF_AW_COA_ITEMS_V

Source

View Text - Preformatted

SELECT COAI.ROWID, COAI.BASE_ID, COAI.ITEM_CODE, AWITEM.DESCRIPTION, COAI.AMOUNT, COAI.PELL_COA_AMOUNT, COAI.ALT_PELL_AMOUNT, COAI.FIXED_COST, coai.legacy_record_flag, COAI.CREATED_BY, COAI.CREATION_DATE, COAI.LAST_UPDATED_BY, COAI.LAST_UPDATE_DATE, COAI.LAST_UPDATE_LOGIN, COAI.REQUEST_ID, COAI.PROGRAM_APPLICATION_ID, COAI.PROGRAM_ID, COAI.PROGRAM_UPDATE_DATE, DECODE(AWITEM.ITEM_CATEGORY_CODE,'TUITION', COAI.PELL_COA_AMOUNT, 'BOOKS', COAI.PELL_COA_AMOUNT, 'FEES', COAI.PELL_COA_AMOUNT, 'TRANSPORTATION', COAI.PELL_COA_AMOUNT, 'SUPPLIES', COAI.PELL_COA_AMOUNT, 'DEPENDENT_CARE', COAI.PELL_COA_AMOUNT, NULL) LT_HT_PELL_AMT, COAI.LOCK_FLAG FROM IGF_AW_COA_ITEMS COAI, IGF_AW_ITEM AWITEM WHERE AWITEM.ITEM_CODE = COAI.ITEM_CODE

View Text - HTML Formatted

SELECT COAI.ROWID
, COAI.BASE_ID
, COAI.ITEM_CODE
, AWITEM.DESCRIPTION
, COAI.AMOUNT
, COAI.PELL_COA_AMOUNT
, COAI.ALT_PELL_AMOUNT
, COAI.FIXED_COST
, COAI.LEGACY_RECORD_FLAG
, COAI.CREATED_BY
, COAI.CREATION_DATE
, COAI.LAST_UPDATED_BY
, COAI.LAST_UPDATE_DATE
, COAI.LAST_UPDATE_LOGIN
, COAI.REQUEST_ID
, COAI.PROGRAM_APPLICATION_ID
, COAI.PROGRAM_ID
, COAI.PROGRAM_UPDATE_DATE
, DECODE(AWITEM.ITEM_CATEGORY_CODE
, 'TUITION'
, COAI.PELL_COA_AMOUNT
, 'BOOKS'
, COAI.PELL_COA_AMOUNT
, 'FEES'
, COAI.PELL_COA_AMOUNT
, 'TRANSPORTATION'
, COAI.PELL_COA_AMOUNT
, 'SUPPLIES'
, COAI.PELL_COA_AMOUNT
, 'DEPENDENT_CARE'
, COAI.PELL_COA_AMOUNT
, NULL) LT_HT_PELL_AMT
, COAI.LOCK_FLAG
FROM IGF_AW_COA_ITEMS COAI
, IGF_AW_ITEM AWITEM
WHERE AWITEM.ITEM_CODE = COAI.ITEM_CODE