Search Results por_requester_lov_v

Overview

APPS.POR_REQUESTER_LOV_V is a seeded Oracle E-Business Suite view owned by the APPS schema and shipped as part of the ICX (Oracle iProcurement) product. Its stated purpose in the ETRM repository is to serve as a "List of Values for Requesters." In practice, the view supplies the row source behind requester selection fields in the iProcurement and Purchasing requisition flows, returning the set of employees who may be designated as requesters together with the descriptive and organizational attributes those pages need to render the LOV and default downstream values.

Because it is a view rather than a table, POR_REQUESTER_LOV_V holds no data of its own. It projects live information from HR and FND at query time, and its result set is deliberately scoped to the currently connected user. The view is relevant to reporting and integration work chiefly as a convenience access point to requester attributes — particularly the deliver-to organization — without requiring custom joins across HR_EMPLOYEES_CURRENT_V, FND_USER, and the financials system parameters.

Underlying Base Objects

The documented base objects underlying the view are:

• HR_EMPLOYEES_CURRENT_V (VIEW) — the primary source of requester name, email, employee number, employee ID, default code combination, location, organization, and business group.
• FND_USER (SYNONYM) — joined on EMPLOYEE_ID to link the application user to the HR person record.
• FINANCIALS_SYSTEM_PARAMETERS (SYNONYM) — source of INVENTORY_ORGANIZATION_ID, aliased in the view as DELIVER_TO_ORG_ID.
• FND_GLOBAL and FND_PROFILE (PACKAGEs) — supply the current user ID and evaluate the ICX_REQ_OVERRIDE_REQUESTOR_CODE profile option, which drives the UNION ALL branches that determine which requesters are visible.
• HR_GENERAL, HR_PERSON_NAME, and HR_SECURITY (PACKAGEs) — invoked by the HR employee view to apply name formatting and security restrictions.
• HR_LOCATIONS_ALL, HR_LOCATIONS_ALL_TL (SYNONYMs) — location lookups referenced by the HR view.

The view text is built as a UNION ALL across multiple branches; each branch shares the same projection list but applies a different predicate against ICX_REQ_OVERRIDE_REQUESTOR_CODE (NO, ORG, and ALL), governing whether the requester is restricted to the signed-on user or expanded to an organization or the entire population.

Key Columns

• USER_ID — FND_USER identifier of the requester; the typical join key back to requisition data.
• FULL_NAME, EMAIL_ADDRESS, EMPLOYEE_NUM, EMPLOYEE_ID — descriptive requester attributes.
• DEFAULT_CODE_COMBINATION_ID — default charge account associated with the employee.
• LOCATION_ID, ORGANIZATION_ID, BUSINESS_GROUP_ID — HR location and organization context; the view restricts rows where LOCATION_ID IS NULL.
• EXPENSE_CHECK_ADDRESS_FLAG — expense destination handling indicator.
• DELIVER_TO_ORG_ID — exposed from FINANCIALS_SYSTEM_PARAMETERS.INVENTORY_ORGANIZATION_ID; this is the column most commonly searched by users querying this view.

Common Use Cases and Queries

Typical uses include validating requester LOV contents, resolving the default deliver-to inventory organization for a requester, and joining requisition headers to requester names for reporting. Because the view is filtered by FND_GLOBAL.USER_ID, query results outside a session context may be restricted; testing in a specific user session or removing the security predicate in a custom query is often necessary.

Sample query to list requesters and their deliver-to organization:

• SELECT user_id, full_name, employee_num, organization_id, deliver_to_org_id
• FROM apps.por_requester_lov_v
• ORDER BY full_name;

Join to requisition headers for requester reporting:

• SELECT prh.segment1, prh.preparer_id, l.full_name, l.deliver_to_org_id
• FROM po_requisition_headers_all prh, apps.por_requester_lov_v l
• WHERE prh.preparer_id = l.user_id;

Always reference the view with the APPS schema prefix and confirm the effective profile setting, since ICX_REQ_OVERRIDE_REQUESTOR_CODE materially changes which requesters are returned.