APPS.WSH_VENDOR_PARTY_MERGE_PKG dependencies on WSH_DELIVERY_DETAILS

Line 120: FROM wsh_delivery_details wdd,

116: -- with a particular SF location ID
117: --
118: SELECT 1
119: INTO l_query_count
120: FROM wsh_delivery_details wdd,
121: wsh_locations wl
122: WHERE wdd.ship_from_location_id = wl.wsh_location_id
123: AND wl.source_location_id = get_party_site_rec.location_id
124: AND wdd.party_id = p_party_id

Line 950: FROM wsh_delivery_details

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'
952: AND vendor_id = p_from_id
953: AND ship_from_site_id = p_from_site_id
954: AND source_header_id

Line 1539: wsh_delivery_details d,

1535: CURSOR check_po IS
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'

Line 1577: wsh_delivery_details wdd,

1573: wnd.routing_response_id,
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

Line 1606: wsh_delivery_details wdd

1602:
1603: CURSOR check_temp (p_delivery_id NUMBER) IS
1604: SELECT parent_delivery_detail_id
1605: FROM wsh_wms_sync_tmp wwst,
1606: wsh_delivery_details wdd
1607: WHERE wwst.delivery_id = p_delivery_id
1608: AND wwst.temp_col IS NOT NULL
1609: AND operation_type = 'VENDOR_MRG'
1610: AND wdd.delivery_detail_id = wwst.delivery_detail_id

Line 1634: FROM wsh_delivery_details wdd,

1630: wth.receipt_number rr_number,
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

Line 1860: UPDATE wsh_delivery_details

1856: END IF;
1857:
1858: --
1859: FORALL j IN l_dd_list.FIRST..l_dd_list.LAST
1860: UPDATE wsh_delivery_details
1861: SET vendor_id = p_to_id,
1862: ship_from_site_id = p_to_site_id,
1863: party_id = p_to_party_id,
1864: last_update_date = sysdate,

Line 1885: WSH_DEBUG_SV.logmsg(l_module_name,'Updated wsh_delivery_details. Number of Rows updated is ' || sql%rowcount, WSH_DEBUG_SV.C_STMT_LEVEL);

1881: --}
1882: END IF;
1883: IF l_debug_on THEN
1884: --{
1885: WSH_DEBUG_SV.logmsg(l_module_name,'Updated wsh_delivery_details. Number of Rows updated is ' || sql%rowcount, WSH_DEBUG_SV.C_STMT_LEVEL);
1886: --}
1887: END IF;
1888:
1889: --}

Line 2152: UPDATE wsh_delivery_details

2148: IF l_debug_on THEN
2149: wsh_debug_sv.log(l_module_name, 'Updating vendor info. on containers assigned to delivery', l_chk_delivery_id);
2150: END IF;
2151: --
2152: UPDATE wsh_delivery_details
2153: SET vendor_id = p_to_id,
2154: party_id = p_to_party_id,
2155: last_update_date = sysdate,
2156: last_updated_by = fnd_global.user_id,

Line 2399: UPDATE wsh_delivery_details

2395: wsh_debug_sv.log(l_module_name, 'WDD ID to update', l_dlvy_rr_rec.delivery_detail_id);
2396: wsh_debug_sv.log(l_module_name, 'Routing Req ID to update with', l_new_rr_id);
2397: END IF;
2398: --
2399: UPDATE wsh_delivery_details
2400: SET routing_req_Id = l_new_rr_id,
2401: last_update_date = sysdate,
2402: last_updated_by = fnd_global.user_id,
2403: last_update_login = fnd_global.login_id

Line 2408: WSH_DEBUG_SV.logmsg(l_module_name,'Updated wsh_delivery_details. Number of Rows updated is ' || sql%rowcount, WSH_DEBUG_SV.C_STMT_LEVEL);

2404: WHERE delivery_detail_id = l_dlvy_rr_rec.delivery_detail_id;
2405: --
2406: IF l_debug_on THEN
2407: --{
2408: WSH_DEBUG_SV.logmsg(l_module_name,'Updated wsh_delivery_details. Number of Rows updated is ' || sql%rowcount, WSH_DEBUG_SV.C_STMT_LEVEL);
2409: --}
2410: END IF;
2411:
2412: l_prev_old_rr_id := l_dlvy_rr_rec.routing_req_id;