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

VIEW: APPS.IGW_BUDGET_DETAILS_V

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

[View Source]

Columns
Name Datatype Length Mandatory Comments
PROPOSAL_ID NUMBER (15) Yes
VERSION_ID NUMBER (4) Yes
BUDGET_PERIOD_ID NUMBER (4) Yes
LINE_ITEM_ID NUMBER (15) Yes
EXPENDITURE_TYPE VARCHAR2 (30) Yes
BUDGET_CATEGORY_CODE VARCHAR2 (30) Yes
EXPENDITURE_CATEGORY_FLAG VARCHAR2 (1) Yes
LINE_ITEM_DESCRIPTION VARCHAR2 (250)
BASED_ON_LINE_ITEM NUMBER (15)
LINE_ITEM_COST NUMBER (15)
COST_SHARING_AMOUNT NUMBER (15)
UNDERRECOVERY_AMOUNT NUMBER (15)
APPLY_INFLATION_FLAG VARCHAR2 (1) Yes
BUDGET_JUSTIFICATION LONG (0)
LOCATION_CODE VARCHAR2 (30) Yes
PROJECT_ID NUMBER (15)
TASK_ID NUMBER (15)
AWARD_ID NUMBER (15)
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER (15) Yes
CREATION_DATE DATE
Yes
CREATED_BY NUMBER (15) Yes
LAST_UPDATE_LOGIN NUMBER (15) Yes
Query Text

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


SELECT PROPOSAL_ID
,      VERSION_ID
,      BUDGET_PERIOD_ID
,      LINE_ITEM_ID
,      EXPENDITURE_TYPE
,      BUDGET_CATEGORY_CODE
,      EXPENDITURE_CATEGORY_FLAG
,      LINE_ITEM_DESCRIPTION
,      BASED_ON_LINE_ITEM
,      LINE_ITEM_COST
,      COST_SHARING_AMOUNT
,      UNDERRECOVERY_AMOUNT
,      APPLY_INFLATION_FLAG
,      BUDGET_JUSTIFICATION
,      LOCATION_CODE
,      PROJECT_ID
,      TASK_ID
,      AWARD_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
FROM APPS.IGW_BUDGET_DETAILS_V;

Dependencies

[top of page]

APPS.IGW_BUDGET_DETAILS_V references the following:

SchemaAPPS
SynonymIGW_BUDGET_DETAILS

APPS.IGW_BUDGET_DETAILS_V is not referenced by any database object