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 484: oe_order_lines_all oeol

480: wsh_delivery_details wdd,
481: wsh_delivery_assignments_v wda,
482: mtl_item_locations_kfv milk,
483: mtl_item_locations_kfv milk2,
484: oe_order_lines_all oeol
485: WHERE ((mmtt.transaction_temp_id = p_transaction_temp_id AND
486: p_transaction_temp_id IS NOT NULL) OR
487: (mmtt.cartonization_id = p_cartonization_id AND
488: p_cartonization_id IS NOT NULL))

Line 646: , oe_order_lines_all oeol

642: ,wdd_item.delivery_detail_id --Bug9261874
643: FROM wsh_delivery_details wdd_item -- records with item info
644: , wsh_delivery_details wdd_lpn -- records of the immediate lpn
645: , wsh_delivery_assignments_v wda
646: , oe_order_lines_all oeol
647: , wms_license_plate_numbers wlpn
648: WHERE wda.delivery_detail_id = wdd_item.delivery_detail_id
649: AND wda.parent_delivery_detail_id = wdd_lpn.delivery_detail_id
650: AND (wdd_item.inventory_item_id IS NOT NULL AND

Line 760: , oe_order_lines_all oeol

756: FROM wsh_delivery_details wdd_item -- records with item info
757: , wsh_delivery_details wdd_lpn -- records of the immediate lpn
758: , wms_license_plate_numbers wlpn
759: , wsh_delivery_assignments_v wda
760: , oe_order_lines_all oeol
761: WHERE wda.delivery_detail_id = wdd_item.delivery_detail_id
762: AND (wdd_item.inventory_item_id IS NOT NULL AND
763: wdd_item.lpn_id IS NULL)
764: AND wda.parent_delivery_detail_id = wdd_lpn.delivery_detail_id

Line 868: , oe_order_lines_all oeol

864: ,wdd_item.delivery_detail_id --Bug9261874
865: FROM wsh_delivery_details wdd_item -- records with item info
866: , wsh_delivery_assignments_v wda
867: , mtl_item_locations_kfv milk
868: , oe_order_lines_all oeol
869: WHERE wda.delivery_detail_id = wdd_item.delivery_detail_id
870: AND (wdd_item.inventory_item_id IS NOT NULL AND
871: wdd_item.lpn_id IS NULL)
872: AND wda.delivery_id = p_delivery_id

Line 1323: FROM oe_order_lines_all oeol

1319: Decode(oeol.item_identifier_type,
1320: 'CUST', mci_oi.customer_item_number,
1321: 'INT', msik_oi.concatenated_segments,
1322: msik_oi.concatenated_segments)) ordered_item
1323: FROM oe_order_lines_all oeol
1324: , mtl_customer_items mci_oi
1325: , mtl_system_items_kfv msik_oi
1326: WHERE oeol.line_id = p_line_id
1327: AND oeol.ordered_item_id = mci_oi.customer_item_id (+)