View: POA_CM_SITE_LOV_V

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

View Text

SELECT VS.VENDOR_SITE_ID
, VS.ORG_ID
, VS.VENDOR_SITE_CODE
, OP.NAME
, VS.VENDOR_ID
, VE.VENDOR_NAME
FROM PO_VENDORS VE
, PO_VENDOR_SITES_ALL VS
, HR_ALL_ORGANIZATION_UNITS OP
WHERE VS.ORG_ID = OP.ORGANIZATION_ID
AND VS.VENDOR_ID = VE.VENDOR_ID WITH READ ONLY

Columns