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 1156: -- Purpose: Call DBI for update in wsh_delivery_details table

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

Line 1413: l_del_det_id WSH_DELIVERY_DETAILS.delivery_detail_id%type;

1409: l_action_rec WSH_DELIVERY_AUTOCREATE.action_rec_type;
1410: l_target_rec WSH_DELIVERY_AUTOCREATE.grp_attr_rec_type;
1411: l_group_tab WSH_DELIVERY_AUTOCREATE.grp_attr_tab_type;
1412: l_out_rec WSH_DELIVERY_AUTOCREATE.out_rec_type;
1413: l_del_det_id WSH_DELIVERY_DETAILS.delivery_detail_id%type;
1414: l_org_id WSH_DELIVERY_DETAILS.organization_id%type;
1415: l_param_info WSH_SHIPPING_PARAMS_PVT.Parameter_Rec_Typ;
1416:
1417: l_debug_on BOOLEAN;

Line 1414: l_org_id WSH_DELIVERY_DETAILS.organization_id%type;

1410: l_target_rec WSH_DELIVERY_AUTOCREATE.grp_attr_rec_type;
1411: l_group_tab WSH_DELIVERY_AUTOCREATE.grp_attr_tab_type;
1412: l_out_rec WSH_DELIVERY_AUTOCREATE.out_rec_type;
1413: l_del_det_id WSH_DELIVERY_DETAILS.delivery_detail_id%type;
1414: l_org_id WSH_DELIVERY_DETAILS.organization_id%type;
1415: l_param_info WSH_SHIPPING_PARAMS_PVT.Parameter_Rec_Typ;
1416:
1417: l_debug_on BOOLEAN;
1418: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'Find_Matching_Groups';

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

1486: --{
1487: -- Delivery appending limit 'N' check goes in this block.
1488: BEGIN
1489:
1490: SELECT organization_id INTO l_org_id FROM wsh_delivery_details WHERE delivery_detail_id = l_del_det_id;
1491: -- Call wsh_shipping_parameters.Get for appending_limit
1492: IF l_debug_on THEN
1493: --{
1494: WSH_DEBUG_SV.log(l_module_name, 'l_org_id', l_org_id);

Line 1642: l_requested_quantity_uom wsh_delivery_details.src_requested_quantity_uom%type;

1638: IS
1639: --
1640: l_cancel_qty_allowed number;
1641: l_src_cancel_qty_allowed number;
1642: l_requested_quantity_uom wsh_delivery_details.src_requested_quantity_uom%type;
1643: l_src_requested_quantity_uom wsh_delivery_details.src_requested_quantity_uom%type;
1644: l_cancel_allowed_quantity number;
1645: l_inventory_item_id number;
1646: --

Line 1643: l_src_requested_quantity_uom wsh_delivery_details.src_requested_quantity_uom%type;

1639: --
1640: l_cancel_qty_allowed number;
1641: l_src_cancel_qty_allowed number;
1642: l_requested_quantity_uom wsh_delivery_details.src_requested_quantity_uom%type;
1643: l_src_requested_quantity_uom wsh_delivery_details.src_requested_quantity_uom%type;
1644: l_cancel_allowed_quantity number;
1645: l_inventory_item_id number;
1646: --
1647: l_debug_on BOOLEAN;

Line 1685: from wsh_delivery_details wdd

1681: -- select stmt.
1682:
1683: select sum(wdd.requested_quantity) , requested_quantity_uom, src_requested_quantity_uom, inventory_item_id
1684: into l_cancel_qty_allowed , l_requested_quantity_uom, l_src_requested_quantity_uom, l_inventory_item_id
1685: from wsh_delivery_details wdd
1686: where
1687: wdd.source_line_id = p_source_line_id
1688: and wdd.source_code = p_source_code
1689: and not exists (select 'x' from

Line 1807: FROM wsh_delivery_assignments wda,wsh_delivery_details wdd

1803:
1804: --Get the delivery details and associated container delivery details records for the order line id passed
1805: CURSOR c_wdd_lpn_for_line (l_line_id NUMBER ) IS
1806: SELECT wdd.*
1807: FROM wsh_delivery_assignments wda,wsh_delivery_details wdd
1808: WHERE wdd.delivery_detail_id = wda.delivery_detail_id
1809: START WITH wda.delivery_detail_id in
1810: ( SELECT delivery_detail_id
1811: FROM wsh_delivery_details

Line 1811: FROM wsh_delivery_details

1807: FROM wsh_delivery_assignments wda,wsh_delivery_details wdd
1808: WHERE wdd.delivery_detail_id = wda.delivery_detail_id
1809: START WITH wda.delivery_detail_id in
1810: ( SELECT delivery_detail_id
1811: FROM wsh_delivery_details
1812: WHERE source_line_id = l_line_id
1813: AND source_code = 'OE')
1814: CONNECT BY PRIOR wda.parent_delivery_detail_id = wda.DELIVERY_DETAIL_ID ;
1815:

Line 1821: FROM wsh_delivery_details

1817:
1818: --Get the line_id assoicated to the header_id
1819: CURSOR c_line_id(l_header_id NUMBER ) IS
1820: SELECT DISTINCT source_line_id
1821: FROM wsh_delivery_details
1822: WHERE source_header_id = l_header_id
1823: AND source_code = 'OE';
1824:
1825: --Get the parent_delivery_detail_id for delivery detail

Line 1834: FROM wsh_delivery_details wdd ,

1830:
1831: ----Get the actual departure date
1832: CURSOR c_actual_ship_date(l_line_id NUMBER ) IS
1833: SELECT wts.actual_departure_date,wcs.ship_method_meaning,hp.party_name
1834: FROM wsh_delivery_details wdd ,
1835: wsh_delivery_assignments wda ,
1836: wsh_new_deliveries wnd ,
1837: wsh_delivery_legs wdl ,
1838: wsh_trip_stops wts,

Line 2116: update wsh_delivery_details dd

2112: IF l_debug_on THEN
2113: wsh_debug_sv.log(l_module_name,'delivery_detail_id', p_detail_rows(i));
2114: END IF;
2115:
2116: update wsh_delivery_details dd
2117: set inv_interfaced_flag = 'Y',
2118: program_application_id = FND_GLOBAL.Prog_Appl_Id,
2119: program_id = FND_GLOBAL.Conc_Program_Id,
2120: request_id = FND_GLOBAL.Conc_Request_Id,