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.

[Home] [Help]

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 959: 'mrp_so_lines_temp',

955: var_watch_id := mrp_print_pk.start_watch('GEN-updated',
956: arg_request_id,
957: arg_user_id,
958: 'ENTITY',
959: 'mrp_so_lines_temp',
960: 'N');
961:
962: */
963: -- Update the interface table

Line 964: -- mrp_so_lines_temp.

960: 'N');
961:
962: */
963: -- Update the interface table
964: -- mrp_so_lines_temp.
965: -- Keep looping until the records in mslt
966: -- can be locked.
967:
968: LOOP

Line 988: UPDATE mrp_so_lines_temp

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

Line 1029: DELETE FROM mrp_so_lines_temp;

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

Line 1206: FROM mrp_so_lines_temp t

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

Line 1218: INSERT INTO mrp_so_lines_temp

1214: END;
1215:
1216: IF (config_item_exists = 0) THEN
1217:
1218: INSERT INTO mrp_so_lines_temp
1219: (
1220: LAST_UPDATED_BY ,
1221: LAST_UPDATE_DATE,
1222: CREATION_DATE,

Line 1590: -- Update the temp table mrp_so_lines_temp

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

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

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

Line 1793: -- mrp_so_lines_temp.

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

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

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

Line 1810: * mrp_so_lines_temp, with the process_status as 3

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

Line 1827: FROM mrp_so_lines_temp

1823: error_message = NULL
1824: WHERE
1825: sales_order_id IN
1826: (SELECT line_id
1827: FROM mrp_so_lines_temp
1828: WHERE
1829: process_status = 3
1830: AND request_id = arg_request_id) ;
1831:

Line 1833: * mrp_so_lines_temp to processed.

1829: process_status = 3
1830: AND request_id = arg_request_id) ;
1831:
1832: /* Now Update these lines in the table
1833: * mrp_so_lines_temp to processed.
1834: */
1835:
1836: UPDATE mrp_so_lines_temp
1837: SET process_status = 5,

Line 1836: UPDATE mrp_so_lines_temp

1832: /* Now Update these lines in the table
1833: * mrp_so_lines_temp to processed.
1834: */
1835:
1836: UPDATE mrp_so_lines_temp
1837: SET process_status = 5,
1838: last_update_login = arg_user_id,
1839: last_update_date = sysdate
1840: WHERE