VIEW: APPS.PO_BUYER_NAME_NUM_V

Source

View Text - Preformatted

SELECT (substr(hre.full_name,1,207) || ',  ' ||nvl(hre.employee_number,hre.npw_number)), hre.person_id FROM PER_WORKFORCE_CURRENT_X HRE , PO_AGENTS POA WHERE HRE.PERSON_ID = POA.AGENT_ID

View Text - HTML Formatted

SELECT (SUBSTR(HRE.FULL_NAME
, 1
, 207) || '
, ' ||NVL(HRE.EMPLOYEE_NUMBER
, HRE.NPW_NUMBER))
, HRE.PERSON_ID
FROM PER_WORKFORCE_CURRENT_X HRE
, PO_AGENTS POA
WHERE HRE.PERSON_ID = POA.AGENT_ID