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 129: FROM wsh_delivery_details

125: debug_print('Inside source line as not null');
126: END IF;
127: SELECT nvl(sum(requested_quantity),0)
128: INTO l_requested_qty
129: FROM wsh_delivery_details
130: WHERE source_line_id = p_demand_source_line_id
131: AND delivery_detail_id = p_demand_source_line_detail;
132:
133: EXCEPTION

Line 16699: FROM wsh_delivery_details wdd,

16695: , wdd.requested_quantity
16696: , wdd.requested_quantity_uom
16697: , wdd.delivery_detail_id
16698: , wdd2.lpn_id
16699: FROM wsh_delivery_details wdd,
16700: wsh_delivery_assignments wda,
16701: wsh_delivery_details wdd2
16702: WHERE wdd.container_flag = 'N' --bug4639858 Only want wdd lines that represent items
16703: AND wdd.delivery_detail_id = wda.delivery_detail_id

Line 16701: wsh_delivery_details wdd2

16697: , wdd.delivery_detail_id
16698: , wdd2.lpn_id
16699: FROM wsh_delivery_details wdd,
16700: wsh_delivery_assignments wda,
16701: wsh_delivery_details wdd2
16702: WHERE wdd.container_flag = 'N' --bug4639858 Only want wdd lines that represent items
16703: AND wdd.delivery_detail_id = wda.delivery_detail_id
16704: AND wda.parent_delivery_detail_id = wdd2.delivery_detail_id
16705: -- Workaround for performance issue 3631133

Line 16720: FROM wsh_delivery_details

16716:
16717: CURSOR item_deliveries(p_lot VARCHAR2) IS
16718: SELECT source_header_id
16719: , source_line_id
16720: FROM wsh_delivery_details
16721: WHERE inventory_item_id = p_inventory_item_id
16722: AND NVL(subinventory, '@@@@') = NVL(p_from_subinventory_code, '@@@@')
16723: AND NVL(revision, '@@@@') = NVL(p_revision, '@@@@')
16724: AND NVL(lot_number, '@@@@') = NVL(p_lot, '@@@@')

Line 16728: wsh_delivery_details wdd2,

16724: AND NVL(lot_number, '@@@@') = NVL(p_lot, '@@@@')
16725: AND delivery_detail_id IN
16726: (SELECT wda.delivery_detail_id
16727: FROM wsh_delivery_assignments wda,
16728: wsh_delivery_details wdd2,
16729: wms_license_plate_numbers wlpn
16730: WHERE wda.parent_delivery_detail_id = wdd2.delivery_detail_id
16731: AND wdd2.lpn_id = wlpn.lpn_id
16732: AND wlpn.outermost_lpn_id = p_lpn_id