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_LABEL_PVT8 dependencies on OE_ORDER_LINES_ALL

Line 466: oe_order_lines_all oeol

462: wsh_delivery_details wdd,
463: wsh_delivery_assignments_v wda,
464: mtl_item_locations_kfv milk,
465: mtl_item_locations_kfv milk2,
466: oe_order_lines_all oeol
467: WHERE ((mmtt.transaction_temp_id = p_transaction_temp_id AND
468: p_transaction_temp_id IS NOT NULL) OR
469: (mmtt.cartonization_id = p_cartonization_id AND
470: p_cartonization_id IS NOT NULL))

Line 570: , oe_order_lines_all oeol

566:
567: FROM wsh_delivery_details wdd_item -- records with item info
568: , wsh_delivery_details wdd_lpn -- records of the immediate lpn
569: , wsh_delivery_assignments_v wda
570: , oe_order_lines_all oeol
571: , wms_license_plate_numbers wlpn
572: WHERE wda.delivery_detail_id = wdd_item.delivery_detail_id
573: AND wda.parent_delivery_detail_id = wdd_lpn.delivery_detail_id
574: AND (wdd_item.inventory_item_id IS NOT NULL AND

Line 673: , oe_order_lines_all oeol

669: FROM wsh_delivery_details wdd_item -- records with item info
670: , wsh_delivery_details wdd_lpn -- records of the immediate lpn
671: , wms_license_plate_numbers wlpn
672: , wsh_delivery_assignments_v wda
673: , oe_order_lines_all oeol
674: WHERE wda.delivery_detail_id = wdd_item.delivery_detail_id
675: AND (wdd_item.inventory_item_id IS NOT NULL AND
676: wdd_item.lpn_id IS NULL)
677: AND wda.parent_delivery_detail_id = wdd_lpn.delivery_detail_id

Line 771: , oe_order_lines_all oeol

767: ,wdd_item.intmed_ship_to_contact_id
768: FROM wsh_delivery_details wdd_item -- records with item info
769: , wsh_delivery_assignments_v wda
770: , mtl_item_locations_kfv milk
771: , oe_order_lines_all oeol
772: WHERE wda.delivery_detail_id = wdd_item.delivery_detail_id
773: AND (wdd_item.inventory_item_id IS NOT NULL AND
774: wdd_item.lpn_id IS NULL)
775: AND wda.delivery_id = p_delivery_id

Line 1225: FROM oe_order_lines_all oeol

1221: Decode(oeol.item_identifier_type,
1222: 'CUST', mci_oi.customer_item_number,
1223: 'INT', msik_oi.concatenated_segments,
1224: msik_oi.concatenated_segments)) ordered_item
1225: FROM oe_order_lines_all oeol
1226: , mtl_customer_items mci_oi
1227: , mtl_system_items_kfv msik_oi
1228: WHERE oeol.line_id = p_line_id
1229: AND oeol.ordered_item_id = mci_oi.customer_item_id (+)