DBA Data[Home] [Help]

APPS.RCV_DEFAULT_PKG dependencies on PO_VENDOR_SITES_ALL

Line 693: FROM po_vendor_sites_all

689: SELECT vendor_site_id,
690: vendor_id
691: INTO x_vendor_site_id,
692: x_vendor_id
693: FROM po_vendor_sites_all
694: WHERE org_id = NVL(p_org_id, org_id)
695: AND vendor_site_code = p_vendor_site_code
696: AND vendor_id = NVL(p_vendor_id, vendor_id);
697:

Line 769: po_vendor_sites_all pvs

765: SELECT max(hps.location_id)
766: INTO x_ship_from_location_id
767: FROM hz_party_sites hps,
768: hz_party_site_uses hpsu,
769: po_vendor_sites_all pvs
770: WHERE pvs.vendor_site_id = p_vendor_site_id
771: AND hpsu.party_site_id = hps.party_site_id
772: AND hpsu.site_use_type = 'SUPPLIER_SHIP_FROM'
773: AND hps.party_site_number = p_ship_from_location_code||'|'||hps.party_id