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


VIEW: APPS.POR_REQUESTER_LOV_V

Object Details
Object Name: POR_REQUESTER_LOV_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewICX.POR_REQUESTER_LOV_V
Subobject Name:
Status: VALID

View Type

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


The POR_REQUESTER_LOV_V view returns a list of requesters that allows the user to choose to be the requester of the purchasing item.


[View Source]

Columns
Name Datatype Length Mandatory Comments
USER_ID NUMBER (15)
User Identifier
FULL_NAME VARCHAR2 (240)
Full Name
EMAIL_ADDRESS VARCHAR2 (240)
Email Address
EMPLOYEE_NUM VARCHAR2 (30)
Employee Number
EMPLOYEE_ID NUMBER (10)
Employee Identifier
DEFAULT_CODE_COMBINATION_ID NUMBER (15)
Default Code Combination
LOCATION_ID NUMBER (15)
Location Identifier
LOCATION_CODE VARCHAR2 (60)
Location Code
ORGANIZATION_ID NUMBER (15)
Organization Identifier
BUSINESS_GROUP_ID NUMBER (15)
Business Group Identifier
EXPENSE_CHECK_ADDRESS_FLAG VARCHAR2 (30)
Expense Check Address
DELIVER_TO_ORG_ID NUMBER

Inventory Organization Identifier
Query Text

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


SELECT USER_ID
,      FULL_NAME
,      EMAIL_ADDRESS
,      EMPLOYEE_NUM
,      EMPLOYEE_ID
,      DEFAULT_CODE_COMBINATION_ID
,      LOCATION_ID
,      LOCATION_CODE
,      ORGANIZATION_ID
,      BUSINESS_GROUP_ID
,      EXPENSE_CHECK_ADDRESS_FLAG
,      DELIVER_TO_ORG_ID
FROM APPS.POR_REQUESTER_LOV_V;

Dependencies

[top of page]

APPS.POR_REQUESTER_LOV_V references the following:

SchemaAPPS
SynonymFINANCIALS_SYSTEM_PARAMETERS
PL/SQL PackageFND_GLOBAL - show dependent code
PL/SQL PackageFND_PROFILE - show dependent code
SynonymFND_USER
ViewHR_EMPLOYEES_CURRENT_V
PL/SQL PackageHR_GENERAL - show dependent code
SynonymHR_LOCATIONS_ALL
SynonymHR_LOCATIONS_ALL_TL
PL/SQL PackageHR_PERSON_NAME - show dependent code
PL/SQL PackageHR_SECURITY - show dependent code

APPS.POR_REQUESTER_LOV_V is not referenced by any database object