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

VIEW: APPS.IGWFV_GRANT_PRPSL_BDGT_VERSION

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

View Type

A Business Intelligence System view

[View Source]

Columns
Name Datatype Length Mandatory Comments
PROPOSAL_NUMBER VARCHAR2 (30) Yes
BUDGET_VERSION_ID NUMBER (4) Yes
START_DATE DATE
Yes
END_DATE DATE
Yes
TOTAL_COST NUMBER (15)
TOTAL_DIRECT_COST NUMBER (15)
TOTAL_INDIRECT_COST NUMBER (15)
COST_SHARING_AMOUNT NUMBER (15)
UNDERRECOVERY_AMOUNT NUMBER (15)
RESIDUAL_FUNDS_AMOUNT NUMBER (15)
TOTAL_COST_LIMIT NUMBER (15)
COMMENTS VARCHAR2 (2000)
FINAL_VERSION_FLAG VARCHAR2 (1)
_LA:BUDGET_TYPE CHAR (67)
PROPOSAL_FORM_NUMBER VARCHAR2 (30) Yes
RATE_CLASS_DESCRIPTION VARCHAR2 (250) Yes
_DF CHAR (37)
PROPOSAL_ID NUMBER (15) Yes
OH_RATE_CLASS_ID NUMBER (10) Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER (15) Yes
CREATION_DATE DATE
Yes
CREATED_BY NUMBER (15) Yes
Query Text

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


SELECT PROPOSAL_NUMBER
,      BUDGET_VERSION_ID
,      START_DATE
,      END_DATE
,      TOTAL_COST
,      TOTAL_DIRECT_COST
,      TOTAL_INDIRECT_COST
,      COST_SHARING_AMOUNT
,      UNDERRECOVERY_AMOUNT
,      RESIDUAL_FUNDS_AMOUNT
,      TOTAL_COST_LIMIT
,      COMMENTS
,      FINAL_VERSION_FLAG
,      _LA:BUDGET_TYPE
,      PROPOSAL_FORM_NUMBER
,      RATE_CLASS_DESCRIPTION
,      _DF
,      PROPOSAL_ID
,      OH_RATE_CLASS_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
FROM APPS.IGWFV_GRANT_PRPSL_BDGT_VERSION;

Dependencies

[top of page]

APPS.IGWFV_GRANT_PRPSL_BDGT_VERSION references the following:

SchemaAPPS
SynonymIGW_BUDGETS
SynonymIGW_PROPOSALS_ALL
SynonymIGW_RATE_CLASSES

APPS.IGWFV_GRANT_PRPSL_BDGT_VERSION is not referenced by any database object