VIEW: APPS.PO_AGENTS_NAME_V

Source

View Text - Preformatted

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 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)

View Text - HTML Formatted

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 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)