[Home] [Help]
View: IGF_AW_ITEM_V
Product: | IGF - Financial Aid |
Description: | Shows cost of attendance items details |
Implementation/DBA Data: |
APPS.IGF_AW_ITEM_V
|
View Text
SELECT ITEM.ROWID ROW_ID
, ITEM.ITEM_CODE ITEM_CODE
, ITEM.DESCRIPTION DESCRIPTION
, ITEM.ACTIVE ACTIVE
, ITEM.CREATED_BY CREATED_BY
, ITEM.CREATION_DATE CREATION_DATE
, ITEM.LAST_UPDATED_BY LAST_UPDATED_BY
, ITEM.LAST_UPDATE_DATE LAST_UPDATE_DATE
, ITEM.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, ITEM.ITEM_CATEGORY_CODE ITEM_CATEGORY_CODE
, IGF_AW_GEN.LOOKUP_DESC('IGF_AW_COA_ITEM_CATEGORY'
, ITEM.ITEM_CATEGORY_CODE) ITEM_CATEGORY_DESC
FROM IGF_AW_ITEM ITEM
Columns
Name |
ROW_ID |
ITEM_CODE |
DESCRIPTION |
ACTIVE |
CREATED_BY |
CREATION_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_DATE |
LAST_UPDATE_LOGIN |
ITEM_CATEGORY_CODE |
ITEM_CATEGORY_DESC |