eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WSH_INTEGRATION dependencies on WSH_DELIVERY_DETAILS

Line 212: from wsh_delivery_details wdd, wsh_delivery_assignments_v wda,

208:
209: BEGIN
210: select count(*)
211: into l_untrxd_rec_count
212: from wsh_delivery_details wdd, wsh_delivery_assignments_v wda,
213: wsh_new_deliveries wnd, wsh_delivery_legs wdl, wsh_trip_stops wts
214: where
215: wdd.source_code = 'OE'
216: and wdd.released_status = 'C'

Line 246: from wsh_delivery_details wdd, wsh_delivery_assignments wda,

242: BEGIN
243: -- Check for Expense Destination Type Code Receiving Transactions
244: select count(*)
245: into l_rec_exp_count
246: from wsh_delivery_details wdd, wsh_delivery_assignments wda,
247: wsh_new_deliveries wnd, wsh_delivery_legs wdl, wsh_trip_stops wts,
248: oe_order_lines_all oel, po_requisition_lines_all pl
249: where
250: wdd.source_code = 'OE'

Line 285: from wsh_delivery_details wdd, wsh_delivery_assignments wda,

281: BEGIN
282: -- Check for Direct Shipment which are not Expense Destination Type Code Related
283: select count(*)
284: into l_rec_direct_count
285: from wsh_delivery_details wdd, wsh_delivery_assignments wda,
286: wsh_new_deliveries wnd, wsh_delivery_legs wdl, wsh_trip_stops wts,
287: oe_order_lines_all oel, po_requisition_lines_all pl,
288: mtl_interorg_parameters mip
289: where

Line 388: from wsh_delivery_details wdd

384:
385: BEGIN
386: select sum( nvl(shipped_quantity, nvl(picked_quantity, requested_quantity)) )
387: into l_nonintf_line_qty
388: from wsh_delivery_details wdd
389: where
390: wdd.source_code = 'OE'
391: and wdd.inv_interfaced_flag in ('N' ,'P')
392: and wdd.source_line_id = l_line_id;

Line 1157: -- Purpose: Call DBI for update in wsh_delivery_details table

1153: END WSH_ID_TAB_TO_DBI_ID_TAB;
1154:
1155: --===============================================
1156: -- Name : DBI_Update_Detail_Log
1157: -- Purpose: Call DBI for update in wsh_delivery_details table
1158: -- History: Added in 11i10+. Actions covered are
1159: -- 1. Update of Requested Quantity
1160: -- 2. Update of Requested Quantity UOM
1161: -- 3. Update of Released Status

Line 1407: l_del_det_id WSH_DELIVERY_DETAILS.delivery_detail_id%type;

1403: l_action_rec WSH_DELIVERY_AUTOCREATE.action_rec_type;
1404: l_target_rec WSH_DELIVERY_AUTOCREATE.grp_attr_rec_type;
1405: l_group_tab WSH_DELIVERY_AUTOCREATE.grp_attr_tab_type;
1406: l_out_rec WSH_DELIVERY_AUTOCREATE.out_rec_type;
1407: l_del_det_id WSH_DELIVERY_DETAILS.delivery_detail_id%type;
1408: l_org_id WSH_DELIVERY_DETAILS.organization_id%type;
1409: l_param_info WSH_SHIPPING_PARAMS_PVT.Parameter_Rec_Typ;
1410:
1411: l_debug_on BOOLEAN;

Line 1408: l_org_id WSH_DELIVERY_DETAILS.organization_id%type;

1404: l_target_rec WSH_DELIVERY_AUTOCREATE.grp_attr_rec_type;
1405: l_group_tab WSH_DELIVERY_AUTOCREATE.grp_attr_tab_type;
1406: l_out_rec WSH_DELIVERY_AUTOCREATE.out_rec_type;
1407: l_del_det_id WSH_DELIVERY_DETAILS.delivery_detail_id%type;
1408: l_org_id WSH_DELIVERY_DETAILS.organization_id%type;
1409: l_param_info WSH_SHIPPING_PARAMS_PVT.Parameter_Rec_Typ;
1410:
1411: l_debug_on BOOLEAN;
1412: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'Find_Matching_Groups';

Line 1484: SELECT organization_id INTO l_org_id FROM wsh_delivery_details WHERE delivery_detail_id = l_del_det_id;

1480: --{
1481: -- Delivery appending limit 'N' check goes in this block.
1482: BEGIN
1483:
1484: SELECT organization_id INTO l_org_id FROM wsh_delivery_details WHERE delivery_detail_id = l_del_det_id;
1485: -- Call wsh_shipping_parameters.Get for appending_limit
1486: IF l_debug_on THEN
1487: --{
1488: WSH_DEBUG_SV.log(l_module_name, 'l_org_id', l_org_id);

Line 1636: l_requested_quantity_uom wsh_delivery_details.src_requested_quantity_uom%type;

1632: IS
1633: --
1634: l_cancel_qty_allowed number;
1635: l_src_cancel_qty_allowed number;
1636: l_requested_quantity_uom wsh_delivery_details.src_requested_quantity_uom%type;
1637: l_src_requested_quantity_uom wsh_delivery_details.src_requested_quantity_uom%type;
1638: l_cancel_allowed_quantity number;
1639: l_inventory_item_id number;
1640: --

Line 1637: l_src_requested_quantity_uom wsh_delivery_details.src_requested_quantity_uom%type;

1633: --
1634: l_cancel_qty_allowed number;
1635: l_src_cancel_qty_allowed number;
1636: l_requested_quantity_uom wsh_delivery_details.src_requested_quantity_uom%type;
1637: l_src_requested_quantity_uom wsh_delivery_details.src_requested_quantity_uom%type;
1638: l_cancel_allowed_quantity number;
1639: l_inventory_item_id number;
1640: --
1641: l_debug_on BOOLEAN;

Line 1679: from wsh_delivery_details wdd

1675: -- select stmt.
1676:
1677: select sum(wdd.requested_quantity) , requested_quantity_uom, src_requested_quantity_uom, inventory_item_id
1678: into l_cancel_qty_allowed , l_requested_quantity_uom, l_src_requested_quantity_uom, l_inventory_item_id
1679: from wsh_delivery_details wdd
1680: where
1681: wdd.source_line_id = p_source_line_id
1682: and wdd.source_code = p_source_code
1683: and not exists (select 'x' from