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.WMS_PACKING_WORKBENCH_PVT dependencies on OE_ORDER_HEADERS_ALL

Line 1695: FROM oe_order_headers_all oeoh, oe_order_lines_all oeol

1691: BEGIN
1692: SELECT oeoh.header_id, to_char(oeoh.order_number), oeol.line_id, oeol.line_number
1693: INTO l_material_rec.document_id, l_material_rec.document_number
1694: , l_material_rec.document_line_id, l_material_rec.document_line_num
1695: FROM oe_order_headers_all oeoh, oe_order_lines_all oeol
1696: WHERE oeol.line_id = l_material_rec.reference_id
1697: AND oeoh.header_id = oeol.header_id;
1698: EXCEPTION
1699: WHEN no_data_found THEN

Line 2469: FROM oe_order_headers_all oeoh, oe_order_lines_all oeol

2465: IF l_material_rec.order_line_id IS NOT NULL AND l_material_rec.order_header_id IS NOT NULL THEN
2466: BEGIN
2467: SELECT nvl(oeol.packing_instructions, oeoh.packing_instructions)
2468: INTO l_material_rec.packing_instruction
2469: FROM oe_order_headers_all oeoh, oe_order_lines_all oeol
2470: WHERE oeoh.header_id = oeol.header_id
2471: AND oeol.line_id = l_material_rec.order_line_id;
2472: EXCEPTION
2473: WHEN NO_DATA_FOUND THEN