View: CLN_ITEMMST_SUPPLIER_V

Product:	CLN - Supply Chain Trading Connector for RosettaNet
Description:	View for the Supplier section of the Sync Item XML message
Implementation/DBA Data:	APPS.CLN_ITEMMST_SUPPLIER_V

View Text

SELECT HAOU.NAME NAME
, HLA.ECE_TP_LOCATION_CODE SUPPLIER_PARTNRIDX
FROM HR_ALL_ORGANIZATION_UNITS HAOU
, HR_LOCATIONS_ALL HLA
WHERE HAOU.LOCATION_ID = HLA.LOCATION_ID
AND HAOU.ORGANIZATION_ID = (SELECT FND_PROFILE.VALUE('ORG_ID')
FROM DUAL)

Columns