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.

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

TABLE: IGW.IGW_EXPENDITURE_CATEGORIES

Object Details

Object Name:	IGW_EXPENDITURE_CATEGORIES
Object Type:	TABLE
Owner:	IGW
FND Design Data:	IGW.IGW_EXPENDITURE_CATEGORIES
Subobject Name:
Status:	VALID

IGW_EXPENDITURE_CATEGORIES stores the expenditure categories used for budgeting purposes.
Each expenditure category is associated with a budget category. PERSONNEL_ATTACHED_FLAG can be used to determine whether there will be personnel attached to an expenditure
category while preparing a budget.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGW_EXPENDITURE_CATEGORIES_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	EXPENDITURE_CATEGORY

Columns

Name	Datatype	Length	Mandatory	Comments
EXPENDITURE_CATEGORY	VARCHAR2	(30)	Yes	Expenditure category
DESCRIPTION	VARCHAR2	(250)		Expenditure category description
BUDGET_CATEGORY_CODE	VARCHAR2	(30)	Yes	Indicates sponsor budget category. Values are taken from the lookups IGW_BUDGET_CATEGORY.
PERSONNEL_ATTACHED_FLAG	VARCHAR2	(1)	Yes	Flag indicates if personnel are attached to the expenditure category
START_DATE_ACTIVE	DATE			First effective date for expenditure category
END_DATE_ACTIVE	DATE			Last effective date for expenditure category
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who column
CREATION_DATE	DATE		Yes	Standard Who column
CREATED_BY	NUMBER	(15)	Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER	(15)	Yes	Standard Who column

Query Text

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


SELECT EXPENDITURE_CATEGORY
,      DESCRIPTION
,      BUDGET_CATEGORY_CODE
,      PERSONNEL_ATTACHED_FLAG
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
FROM IGW.IGW_EXPENDITURE_CATEGORIES;

Dependencies

[top of page]

IGW.IGW_EXPENDITURE_CATEGORIES does not reference any database object

IGW.IGW_EXPENDITURE_CATEGORIES is referenced by following:

APPS: IGW_EXPENDITURE_CATEGORIES