[Home] [Help] [Dependency Information]
Object Name: | IGW_REPORT_BUDGET |
---|---|
Object Type: | TABLE |
Owner: | IGW |
FND Design Data: | IGW.IGW_REPORT_BUDGET |
Subobject Name: | |
Status: | VALID |
IGW_REPORT_BUDGET stores direct costs for all budget periods in the proposal. The data is grouped into budget categories and their period totals.
This is a processing table used in printing proposals.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IGW_REPORT_BUDGET_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
PROPOSAL_ID
VERSION_ID BUDGET_PERIOD_ID PROPOSAL_BUDGET_CATEGORY_CODE PROPOSAL_FORM_NUMBER |
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 |
PROPOSAL_BUDGET_CATEGORY | VARCHAR2 | (80) | Sponsor budget category for the proposal | |
PROPOSAL_BUDGET_CATEGORY_CODE | VARCHAR2 | (30) | Yes | Unique code that identifies sponsor budget category |
PERIOD_TOTAL_DIRECT_COST | NUMBER | (17) | Period total direct cost | |
EB_TOTAL | VARCHAR2 | (17) | Employee benefits amount | |
PROPOSAL_FORM_NUMBER | VARCHAR2 | (30) | Yes | Proposal form number or EDI transaction set number. Examples are PHS 398 and 194TS. |
RECENTLY_UPDATED_FLAG | VARCHAR2 | (1) | Flag for internal processing of data. Default value is N. |
Cut, paste (and edit) the following text to query this object:
SELECT PROPOSAL_ID
, VERSION_ID
, BUDGET_PERIOD_ID
, PROPOSAL_BUDGET_CATEGORY
, PROPOSAL_BUDGET_CATEGORY_CODE
, PERIOD_TOTAL_DIRECT_COST
, EB_TOTAL
, PROPOSAL_FORM_NUMBER
, RECENTLY_UPDATED_FLAG
FROM IGW.IGW_REPORT_BUDGET;
IGW.IGW_REPORT_BUDGET does not reference any database object
IGW.IGW_REPORT_BUDGET is referenced by following:
|
|
|