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


VIEW: APPS.PO_EMPLOYEES_CURRENT_X

Object Details
Object Name: PO_EMPLOYEES_CURRENT_X
Object Type: VIEW
Owner: APPS
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns
Name Datatype Length Mandatory Comments
BUSINESS_GROUP_ID NUMBER (15) Yes
ORGANIZATION_ID NUMBER (15) Yes
EMPLOYEE_ID NUMBER (10) Yes
ASSIGNMENT_ID NUMBER (10) Yes
LAST_UPDATE_DATE DATE

Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER (15)
Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
CREATION_DATE DATE

Standard who column - date when this row was created.
CREATED_BY NUMBER (15)
Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
EMPLOYEE_NUM VARCHAR2 (30)
FULL_NAME VARCHAR2 (240)
FIRST_NAME VARCHAR2 (150)
MIDDLE_NAME VARCHAR2 (60)
LAST_NAME VARCHAR2 (150) Yes
PREFIX VARCHAR2 (30)
LOCATION_ID NUMBER (15)
SUPERVISOR_ID NUMBER (10)
SET_OF_BOOKS_ID NUMBER (15)
DEFAULT_CODE_COMBINATION_ID NUMBER (15)
EXPENSE_CHECK_ADDRESS_FLAG VARCHAR2 (30)
EMAIL_ADDRESS VARCHAR2 (240)
WORK_TELEPHONE VARCHAR2 (60)
INACTIVE_DATE VARCHAR2 (0)
ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield structure definition column.
PBG_NAME VARCHAR2 (240) Yes
Query Text

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


SELECT BUSINESS_GROUP_ID
,      ORGANIZATION_ID
,      EMPLOYEE_ID
,      ASSIGNMENT_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATION_DATE
,      CREATED_BY
,      EMPLOYEE_NUM
,      FULL_NAME
,      FIRST_NAME
,      MIDDLE_NAME
,      LAST_NAME
,      PREFIX
,      LOCATION_ID
,      SUPERVISOR_ID
,      SET_OF_BOOKS_ID
,      DEFAULT_CODE_COMBINATION_ID
,      EXPENSE_CHECK_ADDRESS_FLAG
,      EMAIL_ADDRESS
,      WORK_TELEPHONE
,      INACTIVE_DATE
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE_CATEGORY
,      PBG_NAME
FROM APPS.PO_EMPLOYEES_CURRENT_X;

Dependencies

[top of page]

APPS.PO_EMPLOYEES_CURRENT_X references the following:

SchemaAPPS
SynonymFINANCIALS_SYSTEM_PARAMETERS
PL/SQL PackageFND_PROFILE - show dependent code
SynonymPER_ALL_ASSIGNMENTS_F
SynonymPER_ALL_PEOPLE_F
ViewPER_BUSINESS_GROUPS_PERF
APPS.PO_EMPLOYEES_CURRENT_X is referenced by following:

SchemaAPPS
Package BodyPO_REQAPPROVAL_FINDAPPRV1 - show dependent code