APPS.WMS_UT_PKG dependencies on OE_ORDER_HEADERS_ALL

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:

Line 1811: from oe_order_headers_all

1807: and orig_sys_document_ref = l_orig_sys_document_ref;
1808:
1809: select order_number, header_id
1810: into l_order_number, l_o_header_id
1811: from oe_order_headers_all
1812: where ORIG_SYS_DOCUMENT_REF = L_ORIG_SYS_DOCUMENT_REF
1813: and creation_date > sysdate - 1 ;
1814: write_to_output(p_test_id, 'SORDER_NUM', 'Order Only, ' || l_order_number, p_run_id);
1815: