DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.IGF_AW_ITEM_V

Object Details
Object Name: IGF_AW_ITEM_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewIGF.IGF_AW_ITEM_V
Subobject Name:
Status: VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
Database rowid for igf_aw_item table
ITEM_CODE VARCHAR2 (30) Yes Unique code for each cost of attendance item
DESCRIPTION VARCHAR2 (80)
Long name for cost of attendance item code
ACTIVE VARCHAR2 (30) Yes Indicator that specifies if this cost of attendance item is active or not. Setting the checkbox to inactive prevents use of the cost of attendance item in new or modified records.
CREATED_BY NUMBER (15) Yes Standard who column
CREATION_DATE DATE
Yes Standard who column
LAST_UPDATED_BY NUMBER (15) Yes Standard who column
LAST_UPDATE_DATE DATE
Yes Standard who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column
ITEM_CATEGORY_CODE VARCHAR2 (30)
COA Item Category
ITEM_CATEGORY_DESC VARCHAR2 (4000)
COA Item Category Description
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT 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
FROM APPS.IGF_AW_ITEM_V;

Dependencies

[top of page]

APPS.IGF_AW_ITEM_V references the following:

SchemaAPPS
PL/SQL PackageIGF_AW_GEN - show dependent code
SynonymIGF_AW_ITEM

APPS.IGF_AW_ITEM_V is not referenced by any database object