View: PO_AGENTS_NAME_V

Product:	PO - Purchasing
Description:	10SC ONLY
Implementation/DBA Data:	APPS.PO_AGENTS_NAME_V

View Text

SELECT POA.AGENT_ID BUYER_ID
, PAPF.FULL_NAME FULL_NAME
, PO_BUYER_WORKLOAD_SV.NUM_OPEN_PO( POA.AGENT_ID) NUM_OPEN_PO
FROM PO_AGENTS POA
, PER_ALL_PEOPLE_F PAPF
WHERE POA.AGENT_ID = PAPF.PERSON_ID
AND PAPF.EMPLOYEE_NUMBER IS NOT NULL
AND TRUNC(SYSDATE) BETWEEN PAPF.EFFECTIVE_START_DATE
AND PAPF.EFFECTIVE_END_DATE
AND DECODE(HR_SECURITY.VIEW_ALL
, 'Y'
, 'TRUE'
, HR_SECURITY.SHOW_RECORD('PER_ALL_PEOPLE_F'
, PAPF.PERSON_ID
, PAPF.PERSON_TYPE_ID
, PAPF.EMPLOYEE_NUMBER
, PAPF.APPLICANT_NUMBER)) = 'TRUE'
AND DECODE(HR_GENERAL.GET_XBG_PROFILE
, 'Y'
, PAPF.BUSINESS_GROUP_ID
, HR_GENERAL.GET_BUSINESS_GROUP_ID) = PAPF.BUSINESS_GROUP_ID
AND SYSDATE BETWEEN NVL(POA.START_DATE_ACTIVE
, SYSDATE-1)
AND NVL(POA.END_DATE_ACTIVE
, SYSDATE+1)

Columns