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_BUDGET_DETAILS

Object Details

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

IGW_BUDGET_DETAILS stores budget line details for a budget period. A budget line may or may not involve personnel, depending on the expenditure type selected. A budget period can have multiple budget lines.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGW_BUDGET_DETAILS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	LINE_ITEM_ID

Columns

Name	Datatype	Length	Mandatory	Comments
PROPOSAL_ID	NUMBER	(15)	Yes	Proposal identifier
VERSION_ID	NUMBER	(4)	Yes	Budget version identifier
BUDGET_PERIOD_ID	NUMBER	(4)	Yes	Budget period identifier
LINE_ITEM_ID	NUMBER	(15)	Yes	Budget line identifier
EXPENDITURE_TYPE	VARCHAR2	(30)	Yes	Expenditure category or expenditure type associated with budget line
BUDGET_CATEGORY_CODE	VARCHAR2	(30)	Yes	Unique code identifying sponsor budget category
EXPENDITURE_CATEGORY_FLAG	VARCHAR2	(1)	Yes	Flag that describes whether expenditure category or expenditure type is used in the budget line. If expenditure category is used in the budget line, the value of the flag is Y. The value of the flag is N if expenditure category is used.
LINE_ITEM_DESCRIPTION	VARCHAR2	(250)		Description for a budget line
BASED_ON_LINE_ITEM	NUMBER	(15)		Identifier for the parent budget line from which the current budget line is generated
LINE_ITEM_COST	NUMBER	(15)		Line item cost or amount entered for a budget line
COST_SHARING_AMOUNT	NUMBER	(15)		Cost sharing amount for a budget line
UNDERRECOVERY_AMOUNT	NUMBER	(15)		Underrecovery amount for a budget line
APPLY_INFLATION_FLAG	VARCHAR2	(1)	Yes	Flag that indicates whether inflation is to be applied to later periods
LOCATION_CODE	VARCHAR2	(30)	Yes	Unique code defining the location for budget line. On Campus and Off Campus are examples of location.
PROJECT_ID	NUMBER	(15)		No longer used
TASK_ID	NUMBER	(15)		No longer used
AWARD_ID	NUMBER	(15)		No longer used
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
RECORD_VERSION_NUMBER	NUMBER		Yes	Field for storing locking sequence number
BUDGET_JUSTIFICATION	LONG	(0)		Justification for a budget line

Query Text

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


SELECT PROPOSAL_ID
,      VERSION_ID
,      BUDGET_PERIOD_ID
,      LINE_ITEM_ID
,      EXPENDITURE_TYPE
,      BUDGET_CATEGORY_CODE
,      EXPENDITURE_CATEGORY_FLAG
,      LINE_ITEM_DESCRIPTION
,      BASED_ON_LINE_ITEM
,      LINE_ITEM_COST
,      COST_SHARING_AMOUNT
,      UNDERRECOVERY_AMOUNT
,      APPLY_INFLATION_FLAG
,      LOCATION_CODE
,      PROJECT_ID
,      TASK_ID
,      AWARD_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      RECORD_VERSION_NUMBER
,      BUDGET_JUSTIFICATION
FROM IGW.IGW_BUDGET_DETAILS;

Dependencies

[top of page]

IGW.IGW_BUDGET_DETAILS does not reference any database object

IGW.IGW_BUDGET_DETAILS is referenced by following:

APPS: IGW_BUDGET_DETAILS