DBA Data[Home] [Help]

APPS.WMS_RULES_WORKBENCH_PVT dependencies on PO_VENDOR_SITES_ALL

Line 457: ,PO_VENDOR_SITES_ALL pvsa

453:
454: SELECT pv.vendor_name
455: INTO l_vendor_name
456: FROM PO_VENDORS pv
457: ,PO_VENDOR_SITES_ALL pvsa
458: ,ORG_ORGANIZATION_DEFINITIONS ood
459: WHERE ood.ORGANIZATION_ID = p_org_id
460: AND nvl(pvsa.ORG_ID,-99) = nvl(ood.OPERATING_UNIT,-99)
461: AND pvsa.PURCHASING_SITE_FLAG = 'Y'