APPS.MRP_MANAGER_PK dependencies on OE_ORDER_LINES_ALL

Line 602: oe_order_lines_all dem,

598: -1),
599: dem.ato_line_id,
600: upd.rowid
601: FROM
602: oe_order_lines_all dem,
603: mrp_sales_order_updates upd,
604: mtl_parameters param
605: WHERE NVL(upd.process_status, -1) <> 3
606: AND upd.sales_order_id(+) = dem.line_id

Line 725: oe_order_lines_all dem,

721: (SELECT DISTINCT line_id
722: FROM MRP_SO_LINES_TEMP
723: WHERE process_status = 3
724: AND request_id = arg_request_id) V,
725: oe_order_lines_all dem,
726: mrp_sales_order_updates upd,
727: mtl_parameters param
728: WHERE NVL(upd.process_status, -1) <> 3
729: AND upd.sales_order_id(+) = dem.line_id

Line 796: FROM oe_order_lines_all

792: order by calendar_code, calendar_exception_set_id;
793:
794: CURSOR cur_model_opt is
795: SELECT line_id
796: FROM oe_order_lines_all
797: WHERE ato_line_id = var_ato_line_id
798: AND line_id <> var_dem_demand_id
799: AND item_type_code <> 'CONFIG'
800: AND header_id = var_dem_header_id;

Line 804: * oe_order_lines_ALL in the cursor

800: AND header_id = var_dem_header_id;
801:
802: /* Bug 1997355.
803: * Changing oe_order_lines to
804: * oe_order_lines_ALL in the cursor
805: * cur_header.
806: */
807:
808: /* Bug 2504542.

Line 818: FROM oe_order_lines_all

814: */
815:
816: CURSOR config_lines is
817: SELECT line_id
818: FROM oe_order_lines_all
819: WHERE
820: ato_line_id = var_ato_line_id
821: AND item_type_code = 'CONFIG';
822:

Line 824: SELECT header_id from oe_order_lines_all

820: ato_line_id = var_ato_line_id
821: AND item_type_code = 'CONFIG';
822:
823: CURSOR cur_header is
824: SELECT header_id from oe_order_lines_all
825: where line_id = var_dem_demand_id;
826:
827: /* Bug 2848262
828: * Introduced a new cursor -

Line 1807: * table oe_order_lines_all as they have been deleted.

1803: * model item.
1804: * In this case, there will be some records in the table
1805: * mrp_so_lines_temp, with the process_status as 3
1806: * but their corresponding record is not found in the
1807: * table oe_order_lines_all as they have been deleted.
1808: */
1809: UPDATE mrp_sales_order_updates upd
1810: SET
1811: last_update_date = SYSDATE,

Line 2331: FROM oe_order_lines_all

2327: BEGIN
2328:
2329: SELECT project_id
2330: INTO v_project_id
2331: FROM oe_order_lines_all
2332: WHERE line_id = p_demand_id
2333: AND visible_demand_flag = 'Y';
2334:
2335: RETURN v_project_id;

Line 2349: FROM oe_order_lines_all

2345: BEGIN
2346:
2347: SELECT task_id
2348: INTO v_task_id
2349: FROM oe_order_lines_all
2350: WHERE line_id = p_demand_id
2351: AND visible_demand_flag = 'Y';
2352:
2353: RETURN v_task_id;

Line 2394: FROM oe_order_lines_all sl,

2390: multiple lots.
2391: */
2392: SELECT slp.end_item_unit_number
2393: INTO v_unit_number
2394: FROM oe_order_lines_all sl,
2395: oe_order_lines_all slp
2396: WHERE slp.line_id = nvl(sl.top_model_line_id,sl.line_id)
2397: AND sl.line_id = p_demand_id;
2398:

Line 2395: oe_order_lines_all slp

2391: */
2392: SELECT slp.end_item_unit_number
2393: INTO v_unit_number
2394: FROM oe_order_lines_all sl,
2395: oe_order_lines_all slp
2396: WHERE slp.line_id = nvl(sl.top_model_line_id,sl.line_id)
2397: AND sl.line_id = p_demand_id;
2398:
2399: END IF;