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


VIEW: APPS.PER_PEOPLE_V4

Object Details
Object Name: PER_PEOPLE_V4
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPER.PER_PEOPLE_V4
Subobject Name:
Status: VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)

PERSON_ID NUMBER (10)

SALARY VARCHAR2 (60)

PAY_BASIS VARCHAR2 (30)

JOB_TITLE VARCHAR2 (700)

FULL_NAME VARCHAR2 (240)

ASSIGNMENT_ACTION_ID NUMBER (15)

ASSIGNMENT_ID NUMBER (10)

ASSIGNMENT_NUMBER VARCHAR2 (30)

LOCATION_ID NUMBER (15)

INTERNAL_ADDRESS_LINE VARCHAR2 (80)

NI_NUMBER VARCHAR2 (30)

EXPENSE_CHECK_SEND_TO_ADDRESS VARCHAR2 (30)

Query Text

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


SELECT ROW_ID
,      PERSON_ID
,      SALARY
,      PAY_BASIS
,      JOB_TITLE
,      FULL_NAME
,      ASSIGNMENT_ACTION_ID
,      ASSIGNMENT_ID
,      ASSIGNMENT_NUMBER
,      LOCATION_ID
,      INTERNAL_ADDRESS_LINE
,      NI_NUMBER
,      EXPENSE_CHECK_SEND_TO_ADDRESS
FROM APPS.PER_PEOPLE_V4;

Dependencies

[top of page]

APPS.PER_PEOPLE_V4 references the following:

SchemaAPPS
PL/SQL PackageHR_GENERAL - show dependent code
PL/SQL PackageHR_PERSON_NAME - show dependent code
PL/SQL PackageHR_SECURITY - show dependent code
SynonymPAY_ASSIGNMENT_ACTIONS
SynonymPAY_ELEMENT_ENTRIES_F
SynonymPAY_ELEMENT_ENTRY_VALUES_F
SynonymPAY_PAYROLL_ACTIONS
SynonymPER_ALL_ASSIGNMENTS_F
SynonymPER_JOBS_TL
SynonymPER_PAY_BASES
ViewPER_PEOPLE_F
APPS.PER_PEOPLE_V4 is referenced by following:

SchemaPUBLIC
SynonymPER_PEOPLE_V4