[Home] [Help] [Dependency Information]
Object Name: | POR_APPROVER_LOV_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | ICX.POR_APPROVER_LOV_V |
Subobject Name: | |
Status: | VALID |
A Web view designed to simplify access from Oracle Self-Service Web Applications.
The POR_APPROVER_LOV_V view returns a list of approver that allows the user to choose who will give approval on the purchasing item.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
FULL_NAME | VARCHAR2 | (240) | Approver Full Name | |
EMAIL_ADDRESS | VARCHAR2 | (240) | Approver Email Address | |
EMPLOYEE_NUM | VARCHAR2 | (30) | Approver Employee Number | |
EMPLOYEE_ID | NUMBER | (10) | Yes | Approver Employee ID |
ORGANIZATION_NAME | VARCHAR2 | (240) | Yes | Organization Name |
BUSINESS_GROUP_NAME | VARCHAR2 | (240) | Yes | Business group name |
Cut, paste (and edit) the following text to query this object:
SELECT FULL_NAME
, EMAIL_ADDRESS
, EMPLOYEE_NUM
, EMPLOYEE_ID
, ORGANIZATION_NAME
, BUSINESS_GROUP_NAME
FROM APPS.POR_APPROVER_LOV_V;
APPS.POR_APPROVER_LOV_V is not referenced by any database object
|
|
|