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 1812: * table oe_order_lines_all as they have been deleted.

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

Line 2336: FROM oe_order_lines_all

2332: BEGIN
2333:
2334: SELECT project_id
2335: INTO v_project_id
2336: FROM oe_order_lines_all
2337: WHERE line_id = p_demand_id
2338: AND visible_demand_flag = 'Y';
2339:
2340: RETURN v_project_id;

Line 2354: FROM oe_order_lines_all

2350: BEGIN
2351:
2352: SELECT task_id
2353: INTO v_task_id
2354: FROM oe_order_lines_all
2355: WHERE line_id = p_demand_id
2356: AND visible_demand_flag = 'Y';
2357:
2358: RETURN v_task_id;

Line 2399: FROM oe_order_lines_all sl,

2395: multiple lots.
2396: */
2397: SELECT slp.end_item_unit_number
2398: INTO v_unit_number
2399: FROM oe_order_lines_all sl,
2400: oe_order_lines_all slp
2401: WHERE slp.line_id = nvl(sl.top_model_line_id,sl.line_id)
2402: AND sl.line_id = p_demand_id;
2403:

Line 2400: oe_order_lines_all slp

2396: */
2397: SELECT slp.end_item_unit_number
2398: INTO v_unit_number
2399: FROM oe_order_lines_all sl,
2400: oe_order_lines_all slp
2401: WHERE slp.line_id = nvl(sl.top_model_line_id,sl.line_id)
2402: AND sl.line_id = p_demand_id;
2403:
2404: -- END IF;