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


VIEW: APPS.PA_EMPLOYEES_RES_V

Object Details
Object Name: PA_EMPLOYEES_RES_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPA.PA_EMPLOYEES_RES_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)
EMPLOYEE_NAME VARCHAR2 (60)
EMPLOYEE_NUMBER VARCHAR2 (30)
TRACK_AS_LABOR_FLAG CHAR (1)
UNIT_OF_MEASURE CHAR (5)
ROLLUP_QUANTITY_FLAG CHAR (1)
PERSON_TYPE VARCHAR2 (80) Yes
Query Text

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


SELECT PERSON_ID
,      EMPLOYEE_NAME
,      EMPLOYEE_NUMBER
,      TRACK_AS_LABOR_FLAG
,      UNIT_OF_MEASURE
,      ROLLUP_QUANTITY_FLAG
,      PERSON_TYPE
FROM APPS.PA_EMPLOYEES_RES_V;

Dependencies

[top of page]

APPS.PA_EMPLOYEES_RES_V 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
ViewPA_EMPLOYEES
PL/SQL PackagePA_GET_RESOURCE - show dependent code
ViewPA_LOOKUPS
ViewPER_ASSIGNMENTS_F
SynonymPER_ASSIGNMENT_STATUS_TYPES
APPS.PA_EMPLOYEES_RES_V is referenced by following:

SchemaAPPS
Package BodyPA_RESOURCE_PUB - show dependent code
Package BodyPA_TASK_MANAGER - show dependent code