[Home] [Help]
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