APPS.WSH_PARTY_MERGE dependencies on PO_VENDORS

Line 55: FROM po_vendors

51: -- R12 Vendor Merge
52: --
53: CURSOR c_GetVendorId(p_partyId IN NUMBER) IS
54: SELECT vendor_id, vendor_name
55: FROM po_vendors
56: WHERE party_id = p_partyId;
57: --
58: l_fromVendorID NUMBER;
59: l_toVendorID NUMBER;

Line 307: FROM hz_relationships r, po_vendors v

303: FROM wsh_carriers c
304: WHERE c.carrier_id = c_party_id
305: UNION ALL
306: SELECT 4
307: FROM hz_relationships r, po_vendors v
308: WHERE r.relationship_type = 'POS_VENDOR_PARTY' AND
309: r.subject_id = v.vendor_id AND
310: r.object_id = c_party_id;
311:

Line 493: FROM po_vendors

489: WHERE party_site_id = p_party_site_id;
490: --
491: CURSOR getVendorID(p_party_id IN NUMBER) IS
492: SELECT vendor_id
493: FROM po_vendors
494: WHERE party_id = p_party_id;
495: --
496: CURSOR getLocationID(p_party_site_id NUMBER) IS
497: SELECT location_id