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_UT_PKG dependencies on MTL_SALES_ORDERS

Line 1152: FROM oe_order_headers_all oh, oe_order_lines_all ol, mtl_sales_orders mso

1148: print_debug('Order ' || l_so_orders(i)(2));
1149: print_debug('Line ' || l_so_orders(i)(3));
1150: SELECT mso.sales_order_id, ol.line_id, nvl(oh.source_document_type_id,11), oh.header_id, oh.order_type_id
1151: into l_demand_source_header_id, l_demand_source_line_id, l_source_doc_type, l_o_header_id, l_o_type_id
1152: FROM oe_order_headers_all oh, oe_order_lines_all ol, mtl_sales_orders mso
1153: WHERE ol.header_id = oh.header_id
1154: AND oh.order_number = to_number(l_so_orders(i)(2))
1155: AND ol.line_number = to_number(l_so_orders(i)(3))
1156: AND mso.segment1 = to_char(oh.order_number)

Line 1480: FROM oe_order_headers_all oh, oe_order_lines_all ol, mtl_sales_orders mso

1476: WHERE request_id=l_request_id;
1477:
1478: CURSOR c_solines (p_header_id NUMBER) IS
1479: SELECT mso.sales_order_id as header_id, ol.line_id, nvl(oh.source_document_type_id,11) as source_doc_type_id
1480: FROM oe_order_headers_all oh, oe_order_lines_all ol, mtl_sales_orders mso
1481: WHERE ol.header_id = oh.header_id
1482: AND oh.header_id = p_header_id
1483: AND mso.segment1 = to_char(oh.order_number);
1484: