View: PO_BUYER_NAME_NUM_V

Product:	PO - Purchasing
Description:
Implementation/DBA Data:	APPS.PO_BUYER_NAME_NUM_V

View Text

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

Columns