Results for “icx_requester_lov”
20 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
The ICX_REQUESTER_LOV view is a dictionary object owned by the APPS schema within Oracle E-Business Suite, categorised under the ICX (Oracle iProcurement) product family. Its declared status is VALID, yet Oracle's own ETRM documentation explicitly describes the object as "Obsolete." This designation indicates that the view was retained for backward compatibility with legacy code paths and customisations rather than being actively maintained or promoted for new development. In releases 12.1.1 and 12.2.2, the view remains queryable, but Oracle support directs implementers toward supported alternatives such as ICX_PO_REQUESTOR_VAL_V when building new integrations.
Functionally, ICX_REQUESTER_LOV supplies a list-of-values data set of valid requisition requesters together with their deliver-to location context — the employee's full name, employee ID, web user ID, the combined location/organisation label, and the underlying location and organisation codes.
Underlying Base Objects
The documented reference chain for this view comprises ORG_ORGANIZATION_DEFINITIONS (a view) and ICX_PO_REQUESTOR_VAL_V (a view), joined on the location organisation identifier. ICX_PO_REQUESTOR_VAL_V itself is the supported requester validation view that internally derives data from HR security and person-name APIs.
The ETRM metadata further records that the view depends on the following PL/SQL packages: FND_PROFILE (for profile-option resolution), HR_GENERAL (for session and business-group context), HR_PERSON_NAME (for formatted employee names), and HR_SECURITY (for row-level access enforcement). These dependencies explain why the LOV returns only requesters the current user is authorised to see, and why its results are sensitive to MO: Operating Unit and MO: Security Profile settings.
Key Columns
- FULL_NAME — The formatted employee name of the requester, resolved through HR_PERSON_NAME.
- EMPLOYEE_ID — The HR person identifier for the requester; useful for joins to PER_ALL_PEOPLE_F.
- WEB_USER_ID — The FND_USER identifier linking the employee to an application user account.
- DELIVER_TO_LOCATION — A concatenated display value combining the location code and the organisation code, formatted as LOCATION_CODE (ORGANIZATION_CODE). This is the column returned when users search on "deliver_to_location."
- LOCATION_CODE — The unformatted inventory or HR location code.
- ORGANIZATION_CODE — The inventory organisation code associated with the deliver-to location.
The join predicate IPRVV.LOCATION_ORGANIZATION_ID = OOD.ORGANIZATION_ID ensures that each requester row is paired with the organisation definition governing that deliver-to location.
Common Use Cases and Queries
Typical uses include validating requester/location pairings during requisition import, replicating the iProcurement requester LOV in custom OAF or Forms pages, and extracting requester-location mappings for reporting.
A basic listing:
SELECT full_name, employee_id, web_user_id,
deliver_to_location, location_code, organization_code
FROM apps.icx_requester_lov
WHERE full_name LIKE :p_name;
Filtering by organisation:
SELECT employee_id, web_user_id, deliver_to_location FROM apps.icx_requester_lov WHERE organization_code = :p_org_code;
Because the object is obsolete, production integrations should be migrated to ICX_PO_REQUESTOR_VAL_V or to ORG_ORGANIZATION_DEFINITIONS joined directly, rather than relying on this view remaining available in future patch levels.
-
View: ICX_REQUESTER_LOV 12.2.2
Obsolete
APPS.ICX_REQUESTER_LOV·↳ FND_PROFILE·↳ HR_GENERAL·↳ HR_PERSON_NAME·Explore ICX module →
-
View: ICX_REQUESTER_LOV 12.1.1
Obsolete
APPS.ICX_REQUESTER_LOV·↳ FND_PROFILE·↳ HR_GENERAL·↳ HR_PERSON_NAME·Explore ICX module →
-
VIEW: APPS.ICX_REQUESTER_LOV 12.1.1
-
VIEW: APPS.ICX_REQUESTER_LOV 12.2.2
-
12.1.1 DBA Data 12.1.1
-
12.2.2 DBA Data 12.2.2
-
12.2.2 FND Design Data 12.2.2
-
12.1.1 FND Design Data 12.1.1
-
eTRM - ICX Tables and Views 12.2.2
-
eTRM - ICX Tables and Views 12.1.1
-
12.2.2 DBA Data 12.2.2
-
12.1.1 DBA Data 12.1.1
-
eTRM - INV Tables and Views 12.1.1
-
eTRM - ICX Tables and Views 12.2.2
-
eTRM - ICX Tables and Views 12.1.1
-
eTRM - INV Tables and Views 12.1.1