APPS.WSH_VENDOR_PARTY_MERGE_PKG dependencies on WSH_DELIVERY_ASSIGNMENTS

Line 947: FROM wsh_delivery_assignments

943: last_updated_by = fnd_global.user_id,
944: last_update_login = fnd_global.login_id
945: WHERE delivery_id
946: IN ( SELECT delivery_id
947: FROM wsh_delivery_assignments
948: WHERE delivery_detail_id
949: IN ( SELECT delivery_detail_id
950: FROM wsh_delivery_details
951: WHERE source_code = 'PO'

Line 1540: wsh_delivery_assignments w,

1536: SELECT w.delivery_id,
1537: d.delivery_detail_id
1538: FROM po_headers_all p,
1539: wsh_delivery_details d,
1540: wsh_delivery_assignments w,
1541: Wsh_new_deliveries wnd
1542: WHERE p.vendor_id = p_to_id
1543: AND d.source_code = 'PO'
1544: AND p.po_header_id = d.source_header_id

Line 1578: wsh_delivery_assignments wda

1574: wnd.name,
1575: wnd.ultimate_dropoff_location_id
1576: FROM wsh_new_deliveries wnd,
1577: wsh_delivery_details wdd,
1578: wsh_delivery_assignments wda
1579: WHERE wnd.delivery_id = p_del_id
1580: AND wnd.delivery_id = wda.delivery_id
1581: AND wdd.delivery_detail_id = wda.delivery_detail_id
1582: AND wdd.ship_from_site_id <> p_from_site_id

Line 1635: wsh_delivery_assignments wda ,

1631: wth.revision_number,
1632: wnd.ultimate_dropoff_location_id,
1633: wnd.name
1634: FROM wsh_delivery_details wdd,
1635: wsh_delivery_assignments wda ,
1636: wsh_inbound_txn_history wth,
1637: wsh_new_deliveries wnd
1638: WHERE wda.delivery_id = p_delivery_id
1639: AND nvl(wda.type,'S') IN ('S','O')

Line 2163: FROM wsh_delivery_assignments

2159: AND vendor_id = p_from_id
2160: AND delivery_detail_id
2161: IN (
2162: SELECT delivery_detail_id
2163: FROM wsh_delivery_assignments
2164: WHERE nvl(type,'S') in ('S','O')
2165: AND delivery_id = l_chk_delivery_id
2166: );
2167: --