DBA Data[Home] [Help]

APPS.WSH_VENDOR_PARTY_MERGE_PKG dependencies on PO_VENDOR_SITES

Line 1140: po_vendor_sites_all b

1136: a.freight_code,
1137: b.vendor_site_code,
1138: a.calendar_code
1139: FROM wsh_calendar_assignments a,
1140: po_vendor_sites_all b
1141: WHERE a.vendor_id = p_from_id
1142: AND a.vendor_site_id = p_from_site_id
1143: AND b.vendor_site_id = a.vendor_site_id;
1144:

Line 3375: po_vendor_sites pvs,

3371:
3372: CURSOR get_loc_for_site ( c_vendor_id NUMBER, c_vendor_site NUMBER) IS
3373: SELECT pvs.location_id, hzp.party_site_use_id
3374: FROM po_vendors pov,
3375: po_vendor_sites pvs,
3376: hz_locations hz,
3377: hz_party_site_uses hzp
3378: WHERE pov.vendor_id = pvs.vendor_id
3379: AND pvs.location_id = hz.location_id