eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: APPS.POR_EMPLOYEE_LOV_V

Object Details

Object Name:	POR_EMPLOYEE_LOV_V
Object Type:	VIEW
Owner:	APPS
Subobject Name:
Status:	VALID

View Type

A Web view designed to simplify access from Oracle Self-Service Web Applications.

The POR_EMPLOYEE_LOV_V contains the full name, employee number, location code, and business group of the employees.

[View Source]

Columns

Name	Datatype	Length	Comments
FULL_NAME	VARCHAR2	(240)	Concatenation of last name, title, first name, middle names and the name the person is known by.
EMPLOYEE_NUM	VARCHAR2	(30)	Number assigned to a person if they have been an employee.
EMPLOYEE_ID	NUMBER	(10)	System generated person primary key from PER_PEOPLE_S.
LOCATION_CODE	VARCHAR2	(60)	Location code that is tied to the employee.
BUSINESS_GROUP_NAME	VARCHAR2	(240)	The name of the business group that the employee belongs to.
BUSINESS_GROUP_ID	NUMBER	(15)	System generated identifier for the business group that the employee belongs to.

Query Text

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


SELECT FULL_NAME
,      EMPLOYEE_NUM
,      EMPLOYEE_ID
,      LOCATION_CODE
,      BUSINESS_GROUP_NAME
,      BUSINESS_GROUP_ID
FROM APPS.POR_EMPLOYEE_LOV_V;

Dependencies

[top of page]

APPS.POR_EMPLOYEE_LOV_V references the following:

APPS: FND_GLOBAL - show dependent code; HR_LOCATIONS_ALL; HR_LOCATIONS_ALL_TL; PER_ALL_ASSIGNMENTS_F; PER_ALL_PEOPLE_F; PER_BUSINESS_GROUPS_PERF

APPS.POR_EMPLOYEE_LOV_V is not referenced by any database object