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


VIEW: APPS.PA_PROJECT_PLAYER_V

Object Details
Object Name: PA_PROJECT_PLAYER_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPA.PA_PROJECT_PLAYER_V
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
PERSON_ID NUMBER (10)
System generated person primary key from PER_PERSON_SELECT.
FULL_NAME VARCHAR2 (240)
Concatenation of last name, title, first name, middle names and the name the person is known by.
EMPLOYEE_NUMBER VARCHAR2 (30)
Number assigned to a person if they have been an employee.
ORGANIZATION_ID NUMBER (15)
Internal identifier for the organization assignment of the person.
ORGANIZATION_NAME VARCHAR2 (240)
Name of the organization the person belongs to.
EFFECTIVE_START_DATE DATE

Effective start date of the person.
PERSON_TYPE VARCHAR2 (3)
Person Type of the person -Employee ,Applicant or Contingent Worker.
Query Text

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


SELECT PERSON_ID
,      FULL_NAME
,      EMPLOYEE_NUMBER
,      ORGANIZATION_ID
,      ORGANIZATION_NAME
,      EFFECTIVE_START_DATE
,      PERSON_TYPE
FROM APPS.PA_PROJECT_PLAYER_V;

Dependencies

[top of page]

APPS.PA_PROJECT_PLAYER_V references the following:

SchemaAPPS
SynonymHR_ALL_ORGANIZATION_UNITS_TL
PL/SQL PackageHR_GENERAL - show dependent code
PL/SQL PackageHR_PERSON_NAME - show dependent code
PL/SQL PackageHR_SECURITY - show dependent code
SynonymPER_ALL_ASSIGNMENTS_F
ViewPER_PEOPLE_F

APPS.PA_PROJECT_PLAYER_V is not referenced by any database object