VIEW: APPS.IGF_AW_ITEM_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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