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

VIEW: APPS.IGW_BUDGET_PERSONNEL_V

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

[View Source]

Columns
Name Datatype Length Mandatory Comments
BUDGET_PERSONNEL_DETAIL_ID NUMBER (15) Yes
PROPOSAL_ID NUMBER (15) Yes
VERSION_ID NUMBER (4) Yes
BUDGET_PERIOD_ID NUMBER (4) Yes
LINE_ITEM_ID NUMBER (15) Yes
PERSON_ID NUMBER (15)
START_DATE DATE
Yes
END_DATE DATE
Yes
PERIOD_TYPE_CODE VARCHAR2 (30) Yes
APPOINTMENT_TYPE_CODE VARCHAR2 (30) Yes
SALARY_REQUESTED NUMBER (15)
PERCENT_CHARGED NUMBER (5)
PERCENT_EFFORT NUMBER (5)
COST_SHARING_PERCENT NUMBER (5)
COST_SHARING_AMOUNT NUMBER (15)
UNDERRECOVERY_AMOUNT 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 BUDGET_PERSONNEL_DETAIL_ID
,      PROPOSAL_ID
,      VERSION_ID
,      BUDGET_PERIOD_ID
,      LINE_ITEM_ID
,      PERSON_ID
,      START_DATE
,      END_DATE
,      PERIOD_TYPE_CODE
,      APPOINTMENT_TYPE_CODE
,      SALARY_REQUESTED
,      PERCENT_CHARGED
,      PERCENT_EFFORT
,      COST_SHARING_PERCENT
,      COST_SHARING_AMOUNT
,      UNDERRECOVERY_AMOUNT
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
FROM APPS.IGW_BUDGET_PERSONNEL_V;

Dependencies

[top of page]

APPS.IGW_BUDGET_PERSONNEL_V references the following:

SchemaAPPS
SynonymIGW_BUDGET_PERSONNEL_DETAILS

APPS.IGW_BUDGET_PERSONNEL_V is not referenced by any database object