APPS.WIP_WS_DL_UTIL dependencies on OE_ORDER_LINES_ALL

Line 293: mtl_sales_orders mso, oe_order_lines_all ool

289: cursor c_num_customers(p_org_id number, p_wip_entity_id number)
290: Is
291: select count(distinct ool.sold_to_org_id)
292: from HZ_CUST_ACCOUNTS cust_accnt, mtl_reservations mr,
293: mtl_sales_orders mso, oe_order_lines_all ool
294: , wip_discrete_jobs wdj
295: where mso.sales_order_id = mr.demand_source_header_id
296: and mr.demand_source_line_id = ool.line_id
297: and mr.demand_source_type_id = 2

Line 308: mtl_reservations mr, mtl_sales_orders mso, oe_order_lines_all ool,

304: cursor c_ustomers(p_org_id number, p_wip_entity_id number)
305: Is
306: select cust_party.party_name
307: from HZ_CUST_ACCOUNTS cust_accnt, HZ_PARTIES cust_party,
308: mtl_reservations mr, mtl_sales_orders mso, oe_order_lines_all ool,
309: wip_discrete_jobs wdj
310: where mso.sales_order_id = mr.demand_source_header_id
311: and mr.demand_source_line_id = ool.line_id
312: and mr.demand_source_type_id = 2

Line 350: oe_order_lines_all ool, wip_discrete_jobs wdj

346: cursor c_num_sales_orders(p_org_id number, p_wip_entity_id number)
347: Is
348: select count(distinct mso.segment1)
349: from mtl_reservations mr, mtl_sales_orders mso,
350: oe_order_lines_all ool, wip_discrete_jobs wdj
351: where mso.sales_order_id = mr.demand_source_header_id
352: and mr.demand_source_line_id = ool.line_id
353: and mr.demand_source_type_id = 2
354: and mr.supply_source_type_id = 5

Line 364: oe_order_lines_all ool, wip_discrete_jobs wdj

360: cursor c_sales_orders(p_org_id number, p_wip_entity_id number)
361: Is
362: select mso.concatenated_segments
363: from mtl_reservations mr, mtl_sales_orders_kfv mso,
364: oe_order_lines_all ool, wip_discrete_jobs wdj
365: where mso.sales_order_id = mr.demand_source_header_id
366: and mr.demand_source_line_id = ool.line_id
367: and mr.demand_source_type_id = 2
368: and mr.supply_source_type_id = 5