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_REPORT_BUDGET_SEED

Object Details

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

IGW_REPORT_BUDGET_SEED stores seed data for reporting purposes. The seed data stores the sponsor budget hierarchy as required by the sponsor. The 194 Transaction Set sponsor budget hierarchy is seeded in this table.
This is a processing table used in printing proposals.

Storage Details

Tablespace:	APPS_TS_SEED
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGW_REPORT_BUDGET_SEED_U1	NORMAL	UNIQUE	APPS_TS_SEED	PROPOSAL_FORM_NUMBER PROPOSAL_BUDGET_CATEGORY PROPOSAL_BUDGET_CATEGORY_CODE BUDGET_CATEGORY_CODE

Columns

Name	Datatype	Length	Mandatory	Comments
PROPOSAL_FORM_NUMBER	VARCHAR2	(30)	Yes	Proposal form number or EDI transaction set number. Examples are PHS 398 and194TS.
PROPOSAL_BUDGET_CATEGORY	VARCHAR2	(80)	Yes	Sponsor budget category
PROPOSAL_BUDGET_CATEGORY_CODE	VARCHAR2	(30)	Yes	Unique code that identifies the parent sponsor budget category
BUDGET_CATEGORY_CODE	VARCHAR2	(30)	Yes	Unique code that identifies child sponsor budget category
DETAILS_REQUIRED_FLAG	VARCHAR2	(1)	Yes	Flag that indicates whether details are required for that particular PROPOSAL_BUDGET_CATEGORY. If this flag is Y, IGW_REPORT_ITEMIZED_BUDGET is populated with details.
FRINGE_FLAG	VARCHAR2	(1)	Yes	Flag that indicates whether the current record is reported as fringe benefits.The flag is set to Y if the data is reported as fringe benefits.
SEED_DATA_FLAG	VARCHAR2	(1)	Yes	Flag that indicates whether the current record is seed data. If it is seed data, the value of the flag is Y.

Query Text

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


SELECT PROPOSAL_FORM_NUMBER
,      PROPOSAL_BUDGET_CATEGORY
,      PROPOSAL_BUDGET_CATEGORY_CODE
,      BUDGET_CATEGORY_CODE
,      DETAILS_REQUIRED_FLAG
,      FRINGE_FLAG
,      SEED_DATA_FLAG
FROM IGW.IGW_REPORT_BUDGET_SEED;

Dependencies

[top of page]

IGW.IGW_REPORT_BUDGET_SEED does not reference any database object

IGW.IGW_REPORT_BUDGET_SEED is referenced by following:

APPS: IGW_REPORT_BUDGET_SEED