APPS.WMS_UT_PKG dependencies on OE_ORDER_LINES_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 2599: FROM oe_order_lines_all

2595: AND inventory_item_id = p_item_id;
2596:
2597: CURSOR c_sol (p_item_id NUMBER) IS
2598: SELECT line_id
2599: FROM oe_order_lines_all
2600: WHERE inventory_item_id = p_item_id
2601: AND org_id = p_org_id;
2602:
2603: l_item VARCHAR2(80);