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

VIEW: APPS.IGW_PRPO_PERSON_DETAILS_V

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

View Type

A Business Intelligence System view


IGW_PRPO_PERSON_DETAILS_V displays personnel details, such as salary, fringe benefits, appointment type, and proposal roles of personnel included in budget lines. This view is used in generating a flat file for Electronic Data Interchange.


[View Source]

Columns
Name Datatype Length Mandatory Comments
BUDGET_PERIOD_ID NUMBER

LAST_NAME CHAR (9)
FIRST_NAME CHAR (10)
MIDDLE_NAMES CHAR (12)
PROPOSAL_ROLE_CODE CHAR (18)
PROPOSAL_ROLE CHAR (13)
PERIOD_TYPE_CODE CHAR (16)
PERIOD_TYPE CHAR (8)
BUDGET_CATEGORY_CODE CHAR (20)
BUDGET_CATEGORY CHAR (15)
PERIOD_BEGINNING_DATE DATE

PERIOD_END_DATE DATE

APPOINTMENT_TYPE CHAR (21)
PERSON_MONTHS NUMBER

PERCENT_DOLLAR_FLAG CHAR (2)
BASE_SALARY NUMBER

PERCENT_EFFORT NUMBER

FRINGE_BENEFITS NUMBER

FRINGE_PERCENTAGE NUMBER

LINE_ITEM_ID NUMBER

SALARY_REQUESTED NUMBER

PROPOSAL_ID NUMBER

PERSON_ID NUMBER

PARTY_ID NUMBER

Query Text

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


SELECT BUDGET_PERIOD_ID
,      LAST_NAME
,      FIRST_NAME
,      MIDDLE_NAMES
,      PROPOSAL_ROLE_CODE
,      PROPOSAL_ROLE
,      PERIOD_TYPE_CODE
,      PERIOD_TYPE
,      BUDGET_CATEGORY_CODE
,      BUDGET_CATEGORY
,      PERIOD_BEGINNING_DATE
,      PERIOD_END_DATE
,      APPOINTMENT_TYPE
,      PERSON_MONTHS
,      PERCENT_DOLLAR_FLAG
,      BASE_SALARY
,      PERCENT_EFFORT
,      FRINGE_BENEFITS
,      FRINGE_PERCENTAGE
,      LINE_ITEM_ID
,      SALARY_REQUESTED
,      PROPOSAL_ID
,      PERSON_ID
,      PARTY_ID
FROM APPS.IGW_PRPO_PERSON_DETAILS_V;

Dependencies

[top of page]

APPS.IGW_PRPO_PERSON_DETAILS_V references the following:

SchemaPUBLIC
SynonymDUAL

APPS.IGW_PRPO_PERSON_DETAILS_V is not referenced by any database object