[Home] [Help] [Dependency Information]
Object Name: | POR_EMPLOYEE_LOV_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
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.
Name | Datatype | Length | Mandatory | 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. |
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;
APPS.POR_EMPLOYEE_LOV_V is not referenced by any database object
|
|
|