View: POR_BUYER_LOV_V

Product:	ICX - Oracle iProcurement
Description:	List of Values for Buyers
Implementation/DBA Data:	APPS.POR_BUYER_LOV_V

View Text

SELECT HECV.FULL_NAME
, PB.NAME
FROM PO_AGENTS PA
, PER_EMPLOYEES_CURRENT_X HECV
, PER_BUSINESS_GROUPS_PERF PB
WHERE PA.AGENT_ID = HECV.EMPLOYEE_ID
AND SYSDATE BETWEEN NVL(PA.START_DATE_ACTIVE
, SYSDATE)
AND NVL(PA.END_DATE_ACTIVE
, SYSDATE)
AND PB.BUSINESS_GROUP_ID = HECV.BUSINESS_GROUP_ID

Columns