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

VIEW: APPS.IGW_BUDGET_COSTS_V

Object Details
Object Name: IGW_BUDGET_COSTS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewIGW.IGW_BUDGET_COSTS_V
Subobject Name:
Status: VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.


IGW_BUDGET_COSTS_V displays total cost, direct cost, and the proposed period for the proposal.


[View Source]

Columns
Name Datatype Length Mandatory Comments
PROPOSAL_ID NUMBER (15) Yes Proposal identifier
VERSION_ID NUMBER (4) Yes Final budget version identifier
PROPOSAL_START_DATE DATE
Yes Proposal start date
PROPOSAL_END_DATE DATE
Yes Proposal end date
DURATION_MONTHS NUMBER

Proposed project duration in months
TOTAL_COST NUMBER (15)
Proposed total cost
TOTAL_DIRECT_COST NUMBER (15)
Proposed total direct cost
TOTAL_INDIRECT_COST NUMBER (15)
Proposed total indirect cost
INITIAL_TOTAL_COST NUMBER (15)
Proposed initial budget period total cost
INITIAL_DIRECT_COST NUMBER (15)
Proposed initial budget period direct cost
INITIAL_INDIRECT_COST NUMBER (15)
Proposed initial budget period indirect cost
Query Text

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


SELECT PROPOSAL_ID
,      VERSION_ID
,      PROPOSAL_START_DATE
,      PROPOSAL_END_DATE
,      DURATION_MONTHS
,      TOTAL_COST
,      TOTAL_DIRECT_COST
,      TOTAL_INDIRECT_COST
,      INITIAL_TOTAL_COST
,      INITIAL_DIRECT_COST
,      INITIAL_INDIRECT_COST
FROM APPS.IGW_BUDGET_COSTS_V;

Dependencies

[top of page]

APPS.IGW_BUDGET_COSTS_V references the following:

SchemaAPPS
SynonymIGW_BUDGETS
SynonymIGW_BUDGET_PERIODS
SynonymIGW_PROPOSALS_ALL

APPS.IGW_BUDGET_COSTS_V is not referenced by any database object