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.INV_RESERVATION_PVT dependencies on WSH_DELIVERY_DETAILS

Line 133: FROM wsh_delivery_details

129: debug_print('Inside source line as not null');
130: END IF;
131: SELECT nvl(sum(requested_quantity),0) ,nvl(sum(requested_quantity2),0)
132: INTO l_requested_qty ,l_requested_qty2
133: FROM wsh_delivery_details
134: WHERE source_line_id = p_demand_source_line_id
135: AND delivery_detail_id = p_demand_source_line_detail;
136:
137: EXCEPTION

Line 17866: FROM wsh_delivery_details wdd,

17862: , wdd.picked_quantity --9699014
17863: , wdd.requested_quantity_uom
17864: , wdd.delivery_detail_id
17865: , wdd2.lpn_id
17866: FROM wsh_delivery_details wdd,
17867: wsh_delivery_assignments wda,
17868: wsh_delivery_details wdd2
17869: WHERE wdd.container_flag = 'N' --bug4639858 Only want wdd lines that represent items
17870: AND wdd.delivery_detail_id = wda.delivery_detail_id

Line 17868: wsh_delivery_details wdd2

17864: , wdd.delivery_detail_id
17865: , wdd2.lpn_id
17866: FROM wsh_delivery_details wdd,
17867: wsh_delivery_assignments wda,
17868: wsh_delivery_details wdd2
17869: WHERE wdd.container_flag = 'N' --bug4639858 Only want wdd lines that represent items
17870: AND wdd.delivery_detail_id = wda.delivery_detail_id
17871: AND wda.parent_delivery_detail_id = wdd2.delivery_detail_id
17872: -- Workaround for performance issue 3631133

Line 17887: FROM wsh_delivery_details

17883:
17884: CURSOR item_deliveries(p_lot VARCHAR2) IS
17885: SELECT source_header_id
17886: , source_line_id
17887: FROM wsh_delivery_details
17888: WHERE inventory_item_id = p_inventory_item_id
17889: AND NVL(subinventory, '@@@@') = NVL(p_from_subinventory_code, '@@@@')
17890: AND NVL(revision, '@@@@') = NVL(p_revision, '@@@@')
17891: AND NVL(lot_number, '@@@@') = NVL(p_lot, '@@@@')

Line 17895: wsh_delivery_details wdd2,

17891: AND NVL(lot_number, '@@@@') = NVL(p_lot, '@@@@')
17892: AND delivery_detail_id IN
17893: (SELECT wda.delivery_detail_id
17894: FROM wsh_delivery_assignments wda,
17895: wsh_delivery_details wdd2,
17896: wms_license_plate_numbers wlpn
17897: WHERE wda.parent_delivery_detail_id = wdd2.delivery_detail_id
17898: AND wdd2.lpn_id = wlpn.lpn_id
17899: AND wlpn.outermost_lpn_id = p_lpn_id