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 1624: FROM oe_order_headers_all oeoh, oe_order_lines_all oeol

1620: BEGIN
1621: SELECT oeoh.header_id, to_char(oeoh.order_number), oeol.line_id, oeol.line_number
1622: INTO l_material_rec.document_id, l_material_rec.document_number
1623: , l_material_rec.document_line_id, l_material_rec.document_line_num
1624: FROM oe_order_headers_all oeoh, oe_order_lines_all oeol
1625: WHERE oeol.line_id = l_material_rec.reference_id
1626: AND oeoh.header_id = oeol.header_id;
1627: EXCEPTION
1628: WHEN no_data_found THEN

Line 2396: FROM oe_order_headers_all oeoh, oe_order_lines_all oeol

2392: IF l_material_rec.order_line_id IS NOT NULL AND l_material_rec.order_header_id IS NOT NULL THEN
2393: BEGIN
2394: SELECT nvl(oeol.packing_instructions, oeoh.packing_instructions)
2395: INTO l_material_rec.packing_instruction
2396: FROM oe_order_headers_all oeoh, oe_order_lines_all oeol
2397: WHERE oeoh.header_id = oeol.header_id
2398: AND oeol.line_id = l_material_rec.order_line_id;
2399: EXCEPTION
2400: WHEN NO_DATA_FOUND THEN