eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.MRP_MANAGER_PK dependencies on MRP_SO_LINES_TEMP

Line 722: FROM MRP_SO_LINES_TEMP

718: dem.ato_line_id,
719: upd.rowid
720: FROM
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,

Line 831: * table mrp_so_lines_temp that

827: /* Bug 2848262
828: * Introduced a new cursor -
829: * so_lines_temp.
830: * This selects and locks records from the
831: * table mrp_so_lines_temp that
832: * can be processed at once.
833: * With this cursor we can remove
834: * the costly exclusive lock statement
835: * on msou.

Line 840: FROM mrp_so_lines_temp mslt

836: */
837:
838: CURSOR so_lines_temp is
839: SELECT mslt.line_id
840: FROM mrp_so_lines_temp mslt
841: WHERE
842: mslt.process_status = 2
843: AND mslt.request_id is NULL
844: AND rownum <= UPDATE_BATCH_SIZE

Line 853: FROM mrp_so_lines_temp mslt1

849: upd.sales_order_id = mslt.line_id
850: AND upd.process_status = 3)
851: AND NOT EXISTS
852: (SELECT 1
853: FROM mrp_so_lines_temp mslt1
854: WHERE
855: mslt.line_id = mslt1.line_id
856: AND mslt1.process_status = 3)
857: FOR UPDATE OF process_status NOWAIT;

Line 955: 'mrp_so_lines_temp',

951: var_watch_id := mrp_print_pk.start_watch('GEN-updated',
952: arg_request_id,
953: arg_user_id,
954: 'ENTITY',
955: 'mrp_so_lines_temp',
956: 'N');
957:
958: */
959: -- Update the interface table

Line 960: -- mrp_so_lines_temp.

956: 'N');
957:
958: */
959: -- Update the interface table
960: -- mrp_so_lines_temp.
961: -- Keep looping until the records in mslt
962: -- can be locked.
963:
964: LOOP

Line 984: UPDATE mrp_so_lines_temp

980:
981: IF (line_id_arr.COUNT > 0) THEN
982:
983: FORALL i in line_id_arr.FIRST..line_id_arr.LAST
984: UPDATE mrp_so_lines_temp
985: SET process_status = 3,
986: request_id = arg_request_id,
987: last_update_login = arg_user_id,
988: last_update_date = sysdate

Line 1025: DELETE FROM mrp_so_lines_temp;

1021: -- This is the first time the planning
1022: -- manager is running after creation of
1023: -- the profile option OR it has been
1024: -- reset to 'Yes'
1025: DELETE FROM mrp_so_lines_temp;
1026:
1027: -- BUG 2848262
1028: -- Lock the table msou only if
1029: -- the planning manager is being

Line 1202: FROM mrp_so_lines_temp t

1198: BEGIN
1199:
1200: SELECT /*+ INDEX (t mrp_so_lines_n2) */ 1
1201: INTO config_item_exists
1202: FROM mrp_so_lines_temp t
1203: WHERE process_status = 3
1204: AND line_id = config_line_id
1205: AND request_id = arg_request_id
1206: AND ROWNUM = 1;

Line 1214: INSERT INTO mrp_so_lines_temp

1210: END;
1211:
1212: IF (config_item_exists = 0) THEN
1213:
1214: INSERT INTO mrp_so_lines_temp
1215: (
1216: LAST_UPDATED_BY ,
1217: LAST_UPDATE_DATE,
1218: CREATION_DATE,

Line 1585: -- Update the temp table mrp_so_lines_temp

1581:
1582:
1583: IF (var_first_time = 'N') THEN
1584: IF (var_break_loop = SYS_NO) THEN
1585: -- Update the temp table mrp_so_lines_temp
1586: -- set the line ids that have been processed
1587: -- already to process status 5.
1588: -- For the batch of rows processed.
1589: FORALL i IN 1..counter1

Line 1590: UPDATE /+ INDEX (t mrp_so_lines_n2) / mrp_so_lines_temp t

1586: -- set the line ids that have been processed
1587: -- already to process status 5.
1588: -- For the batch of rows processed.
1589: FORALL i IN 1..counter1
1590: UPDATE /*+ INDEX (t mrp_so_lines_n2) */ mrp_so_lines_temp t
1591: SET process_status = 5,
1592: last_update_login = arg_user_id,
1593: last_update_date = sysdate
1594: WHERE

Line 1788: -- mrp_so_lines_temp.

1784: END LOOP;
1785:
1786: IF (var_first_time = 'N') Then
1787: -- Update the interface table
1788: -- mrp_so_lines_temp.
1789: -- For the last batch of rows.
1790: FORALL i IN 1..counter1
1791: UPDATE /*+ INDEX (t mrp_so_lines_n2) */ mrp_so_lines_temp t
1792: SET process_status = 5,

Line 1791: UPDATE /+ INDEX (t mrp_so_lines_n2) / mrp_so_lines_temp t

1787: -- Update the interface table
1788: -- mrp_so_lines_temp.
1789: -- For the last batch of rows.
1790: FORALL i IN 1..counter1
1791: UPDATE /*+ INDEX (t mrp_so_lines_n2) */ mrp_so_lines_temp t
1792: SET process_status = 5,
1793: last_update_login = arg_user_id,
1794: last_update_date = sysdate
1795: WHERE

Line 1805: * mrp_so_lines_temp, with the process_status as 3

1801: * Need to handle a case when a sales order line is
1802: * deleted OR a configured item is delinked from it's
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

Line 1822: FROM mrp_so_lines_temp

1818: error_message = NULL
1819: WHERE
1820: sales_order_id IN
1821: (SELECT line_id
1822: FROM mrp_so_lines_temp
1823: WHERE
1824: process_status = 3
1825: AND request_id = arg_request_id) ;
1826:

Line 1828: * mrp_so_lines_temp to processed.

1824: process_status = 3
1825: AND request_id = arg_request_id) ;
1826:
1827: /* Now Update these lines in the table
1828: * mrp_so_lines_temp to processed.
1829: */
1830:
1831: UPDATE mrp_so_lines_temp
1832: SET process_status = 5,

Line 1831: UPDATE mrp_so_lines_temp

1827: /* Now Update these lines in the table
1828: * mrp_so_lines_temp to processed.
1829: */
1830:
1831: UPDATE mrp_so_lines_temp
1832: SET process_status = 5,
1833: last_update_login = arg_user_id,
1834: last_update_date = sysdate
1835: WHERE