VIEW: APPS.POA_CM_SITE_LOV_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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