APPS.WSH_INBOUND_UTIL_PKG dependencies on WSH_DELIVERY_DETAILS

Line 55: from wsh_delivery_details

51: p_po_shipment_line_id IN NUMBER) is
52:
53: select fob_code,
54: freight_terms_code
55: from wsh_delivery_details
56: where source_line_id = p_source_line_id
57: and source_header_id = p_source_header_id
58: and po_shipment_line_id = p_po_shipment_line_id
59: and source_code = 'PO'

Line 1277: FROM wsh_delivery_details

1273: IS
1274: SELECT lpn_id,
1275: tracking_number,
1276: container_name
1277: FROM wsh_delivery_details
1278: WHERE delivery_detail_id = p_delivery_detail_id;
1279: --
1280: l_lpn_id NUMBER;
1281: l_lpn_name VARCHAR2(50);

Line 1289: FROM wsh_delivery_details wdd,

1285: CURSOR wda_csr(p_delivery_id IN NUMBER)
1286: IS
1287: SELECT wdd.delivery_detail_id,
1288: wda.parent_delivery_detail_id
1289: FROM wsh_delivery_details wdd,
1290: wsh_delivery_assignments wda,
1291: wsh_wms_sync_tmp wwst
1292: WHERE wwst.delivery_id = p_delivery_id
1293: AND nvl(wda.type,'S') IN ('S','O')

Line 1534: FROM wsh_delivery_Details wdd,

1530: BEGIN
1531: --{
1532: SELECT wdd.delivery_detail_id
1533: INTO l_new_parent_wdd_id
1534: FROM wsh_delivery_Details wdd,
1535: wsh_delivery_assignments wda
1536: WHERE wda.delivery_id = l_delivery_id
1537: AND wda.delivery_detail_id = wdd.delivery_detail_id
1538: AND NVL(wda.type,'S') IN ('S','O')

Line 1619: DELETE FROM wsh_delivery_details

1615: --{
1616: DELETE FROM wsh_delivery_assignments
1617: WHERE delivery_detail_id = l_parent_wdd_id;
1618: --
1619: DELETE FROM wsh_delivery_details
1620: WHERE delivery_detail_id = l_parent_wdd_id;
1621: --
1622: IF l_debug_on THEN
1623: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_INTEGRATION.DBI_UPDATE_DETAIL_LOG',WSH_DEBUG_SV.C_PROC_LEVEL);