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_AWARD_BUDGETS

Object Details

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

IGW_AWARD_BUDGETS stores budget lines that can be transferred to Grants Accounting. These budget lines are created from the final budget version of the proposal.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGW_AWARD_BUDGETS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	AWARD_BUDGET_ID

Columns

Name	Datatype	Length	Mandatory	Comments
AWARD_BUDGET_ID	NUMBER	(15)	Yes	Award budget identifier
PROPOSAL_INSTALLMENT_ID	NUMBER	(15)	Yes	Proposal installment identifier
BUDGET_PERIOD_ID	NUMBER	(4)	Yes	Budget period identifier
EXPENDITURE_TYPE_CAT	VARCHAR2	(240)		Expenditure type or category
EXPENDITURE_CATEGORY_FLAG	VARCHAR2	(240)		Flag that describes whether expenditure category or expenditure type is used in the budget line
BUDGET_AMOUNT	NUMBER			Direct or indirect cost for award budget line
INDIRECT_FLAG	VARCHAR2	(1)		Indicates whether the budget amount column refers to direct or indirect cost. Possible values are Y or N. Y indicates that the budget amount column refers to indirect cost. N indicates that the budget amount column refers to direct cost.
PROJECT_ID	NUMBER	(15)		Project identifier
TASK_ID	NUMBER	(15)		Task identifier
PERIOD_NAME	VARCHAR2	(30)		PA Period for budget line
START_DATE	DATE			Start date for budget line
END_DATE	DATE			End date for budget line
TRANSFERRED_FLAG	VARCHAR2	(1)	Yes	Indicates whether the budget has been transferred to Grants Accounting. Possible values are Y and N.
RECORD_VERSION_NUMBER	NUMBER		Yes	Field for storing locking sequence number
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER		Yes	Standard Who column
CREATION_DATE	DATE		Yes	Standard Who column
CREATED_BY	NUMBER		Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER		Yes	Standard Who column

Query Text

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


SELECT AWARD_BUDGET_ID
,      PROPOSAL_INSTALLMENT_ID
,      BUDGET_PERIOD_ID
,      EXPENDITURE_TYPE_CAT
,      EXPENDITURE_CATEGORY_FLAG
,      BUDGET_AMOUNT
,      INDIRECT_FLAG
,      PROJECT_ID
,      TASK_ID
,      PERIOD_NAME
,      START_DATE
,      END_DATE
,      TRANSFERRED_FLAG
,      RECORD_VERSION_NUMBER
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
FROM IGW.IGW_AWARD_BUDGETS;

Dependencies

[top of page]

IGW.IGW_AWARD_BUDGETS does not reference any database object

IGW.IGW_AWARD_BUDGETS is referenced by following:

APPS: IGW_AWARD_BUDGETS