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 MTL_DEMAND

Line 550: CURSOR MTL_DEMAND_CUR_FIRST IS

546: line_ids_except_config NUMBER;
547:
548: PRAGMA EXCEPTION_INIT(busy, -54);
549:
550: CURSOR MTL_DEMAND_CUR_FIRST IS
551: SELECT
552: dem.inventory_item_id,
553: dem.line_id,
554: dem.SHIP_FROM_ORG_ID ,

Line 669: CURSOR MTL_DEMAND_CUR_NEXT IS

665: DECODE(dem.LINE_CATEGORY_CODE, 'ORDER',2,12))
666: IN (MTL_SALES_ORDER, MTL_INT_SALES_ORDER);
667:
668:
669: CURSOR MTL_DEMAND_CUR_NEXT IS
670: SELECT /*+ ORDERED USE_NL(v, dem,upd,param) */
671: dem.inventory_item_id,
672: dem.line_id,
673: dem.SHIP_FROM_ORG_ID ,

Line 755: CURSOR MTL_DEMAND_CUR1 IS

751: * records
752: */
753:
754:
755: CURSOR MTL_DEMAND_CUR1 IS
756: SELECT demand.rowid
757: FROM mtl_demand_omoe demand
758: WHERE ((EXISTS
759: (SELECT NULL

Line 757: FROM mtl_demand_omoe demand

753:
754:
755: CURSOR MTL_DEMAND_CUR1 IS
756: SELECT demand.rowid
757: FROM mtl_demand_omoe demand
758: WHERE ((EXISTS
759: (SELECT NULL
760: FROM mrp_sales_order_updates updates
761: WHERE updates.sales_order_id = demand.demand_id

Line 876: 'mtl_demand(1)',

872: var_watch_id := mrp_print_pk.start_watch('GEN-updated',
873: arg_request_id,
874: arg_user_id,
875: 'ENTITY',
876: 'mtl_demand(1)',
877: 'N');
878:
879: */
880: /*------------------------------------------------------+

Line 889: OPEN mtl_demand_cur1;

885: | |
886: +------------------------------------------------------*/
887: LOOP
888: BEGIN
889: OPEN mtl_demand_cur1;
890: EXIT;
891: EXCEPTION
892: WHEN busy THEN
893: NULL;

Line 899: FETCH mtl_demand_cur1 INTO

895: END;
896: END LOOP;
897:
898: LOOP
899: FETCH mtl_demand_cur1 INTO
900: var_dem_rowid;
901: EXIT WHEN mtl_demand_cur1%NOTFOUND;
902:
903: UPDATE mtl_demand demand

Line 901: EXIT WHEN mtl_demand_cur1%NOTFOUND;

897:
898: LOOP
899: FETCH mtl_demand_cur1 INTO
900: var_dem_rowid;
901: EXIT WHEN mtl_demand_cur1%NOTFOUND;
902:
903: UPDATE mtl_demand demand
904: SET demand.updated_flag = SYS_NO
905: WHERE rowid = var_dem_rowid;

Line 903: UPDATE mtl_demand demand

899: FETCH mtl_demand_cur1 INTO
900: var_dem_rowid;
901: EXIT WHEN mtl_demand_cur1%NOTFOUND;
902:
903: UPDATE mtl_demand demand
904: SET demand.updated_flag = SYS_NO
905: WHERE rowid = var_dem_rowid;
906: rows_updated := rows_updated + SQL%ROWCOUNT;
907:

Line 910: CLOSE mtl_demand_cur1;

906: rows_updated := rows_updated + SQL%ROWCOUNT;
907:
908: END LOOP;
909:
910: CLOSE mtl_demand_cur1;
911: /*
912: mrp_print_pk.stop_watch(arg_request_id,
913: var_watch_id,
914: rows_updated);

Line 1070: OPEN mtl_demand_cur_first;

1066:
1067: LOOP
1068: BEGIN
1069: IF (var_first_time = 'Y') THEN
1070: OPEN mtl_demand_cur_first;
1071: ELSE
1072: OPEN mtl_demand_cur_next;
1073: END IF;
1074: EXIT;

Line 1072: OPEN mtl_demand_cur_next;

1068: BEGIN
1069: IF (var_first_time = 'Y') THEN
1070: OPEN mtl_demand_cur_first;
1071: ELSE
1072: OPEN mtl_demand_cur_next;
1073: END IF;
1074: EXIT;
1075: EXCEPTION
1076: WHEN busy THEN

Line 1100: FETCH mtl_demand_cur_first INTO

1096:
1097: LOOP
1098:
1099: IF (var_first_time = 'Y') THEN
1100: FETCH mtl_demand_cur_first INTO
1101: var_dem_inventory_item_id,
1102: var_dem_demand_id,
1103: var_dem_organization_id,
1104: var_dem_user_line_num,

Line 1119: EXIT WHEN mtl_demand_cur_first%NOTFOUND;

1115: var_dem_demand_type,
1116: var_ato_line_id,
1117: var_upd_rowid;
1118:
1119: EXIT WHEN mtl_demand_cur_first%NOTFOUND;
1120: ELSE
1121: FETCH mtl_demand_cur_next INTO
1122: var_dem_inventory_item_id,
1123: var_dem_demand_id,

Line 1121: FETCH mtl_demand_cur_next INTO

1117: var_upd_rowid;
1118:
1119: EXIT WHEN mtl_demand_cur_first%NOTFOUND;
1120: ELSE
1121: FETCH mtl_demand_cur_next INTO
1122: var_dem_inventory_item_id,
1123: var_dem_demand_id,
1124: var_dem_organization_id,
1125: var_dem_user_line_num,

Line 1140: EXIT WHEN mtl_demand_cur_next%NOTFOUND;

1136: var_dem_demand_type,
1137: var_ato_line_id,
1138: var_upd_rowid;
1139:
1140: EXIT WHEN mtl_demand_cur_next%NOTFOUND;
1141: END IF;
1142:
1143:
1144: /* Bug 1997355

Line 1194: * mtl_demand_cur_next, we execute this piece

1190: * Line is processed.
1191: *
1192: * Because of the order in which we are
1193: * fetching records from the cursor
1194: * mtl_demand_cur_next, we execute this piece
1195: * of code only for the ATO model.
1196: */
1197:
1198: BEGIN

Line 1313: -- the mtl_Demand_cur loop

1309: organization_id);
1310:
1311: --
1312: -- update the old values so that this row is not picked up again by
1313: -- the mtl_Demand_cur loop
1314:
1315: update_count := update_count + sql%rowcount;
1316: if (sql%rowcount = 0) then
1317:

Line 1558: UPDATE mtl_demand

1554: end if;
1555:
1556: IF g_om_installed = 'OE' THEN
1557:
1558: UPDATE mtl_demand
1559: SET updated_flag = SYS_NO
1560: WHERE rowid = var_dem_rowid;
1561:
1562: END IF;

Line 1572: counter := counter + mtl_demand_cur_first%ROWCOUNT;

1568:
1569: END LOOP;
1570:
1571: IF (var_first_time = 'Y') THEN
1572: counter := counter + mtl_demand_cur_first%ROWCOUNT;
1573: CLOSE mtl_demand_cur_first;
1574:
1575: IF counter < UPDATE_BATCH_SIZE THEN
1576: var_break_loop := SYS_YES;

Line 1573: CLOSE mtl_demand_cur_first;

1569: END LOOP;
1570:
1571: IF (var_first_time = 'Y') THEN
1572: counter := counter + mtl_demand_cur_first%ROWCOUNT;
1573: CLOSE mtl_demand_cur_first;
1574:
1575: IF counter < UPDATE_BATCH_SIZE THEN
1576: var_break_loop := SYS_YES;
1577: END IF;

Line 1579: CLOSE mtl_demand_cur_next;

1575: IF counter < UPDATE_BATCH_SIZE THEN
1576: var_break_loop := SYS_YES;
1577: END IF;
1578: ELSE
1579: CLOSE mtl_demand_cur_next;
1580: END IF;
1581:
1582:
1583: IF (var_first_time = 'N') THEN

Line 1853: CURSOR lock_mtl_demand_cur IS

1849: -- ********************** update_sales_orders *************************
1850: PROCEDURE update_sales_orders(arg_request_id IN NUMBER,
1851: arg_user_id IN NUMBER) IS
1852:
1853: CURSOR lock_mtl_demand_cur IS
1854: SELECT demand.rowid,
1855: updates1.new_schedule_quantity,
1856: updates1.new_schedule_date
1857: FROM mtl_demand demand,

Line 1857: FROM mtl_demand demand,

1853: CURSOR lock_mtl_demand_cur IS
1854: SELECT demand.rowid,
1855: updates1.new_schedule_quantity,
1856: updates1.new_schedule_date
1857: FROM mtl_demand demand,
1858: mrp_sales_order_updates updates1
1859: WHERE updates1.sales_order_id = demand.demand_id
1860: AND updates1.request_id = arg_request_id
1861: AND updates1.process_status = 3

Line 1886: 'mtl_demand',

1882: var_watch_id := mrp_print_pk.start_watch('GEN-updated',
1883: arg_request_id,
1884: arg_user_id,
1885: 'ENTITY',
1886: 'mtl_demand',
1887: 'N');
1888: LOOP
1889: BEGIN
1890: OPEN lock_mtl_demand_cur;

Line 1890: OPEN lock_mtl_demand_cur;

1886: 'mtl_demand',
1887: 'N');
1888: LOOP
1889: BEGIN
1890: OPEN lock_mtl_demand_cur;
1891: EXIT;
1892: EXCEPTION
1893: WHEN busy THEN
1894: NULL;

Line 1900: FETCH lock_mtl_demand_cur INTO

1896: END;
1897: END LOOP;
1898:
1899: LOOP
1900: FETCH lock_mtl_demand_cur INTO
1901: var_rowid,
1902: var_quantity,
1903: var_date;
1904: EXIT WHEN lock_mtl_demand_cur%NOTFOUND;

Line 1904: EXIT WHEN lock_mtl_demand_cur%NOTFOUND;

1900: FETCH lock_mtl_demand_cur INTO
1901: var_rowid,
1902: var_quantity,
1903: var_date;
1904: EXIT WHEN lock_mtl_demand_cur%NOTFOUND;
1905:
1906: UPDATE mtl_demand demand
1907: SET demand.mrp_date = var_date,
1908: demand.mrp_quantity = var_quantity

Line 1906: UPDATE mtl_demand demand

1902: var_quantity,
1903: var_date;
1904: EXIT WHEN lock_mtl_demand_cur%NOTFOUND;
1905:
1906: UPDATE mtl_demand demand
1907: SET demand.mrp_date = var_date,
1908: demand.mrp_quantity = var_quantity
1909: WHERE rowid = var_rowid;
1910:

Line 1915: CLOSE lock_mtl_demand_cur;

1911: rows_updated := rows_updated + SQL%ROWCOUNT;
1912:
1913: END LOOP;
1914:
1915: CLOSE lock_mtl_demand_cur;
1916:
1917: mrp_print_pk.stop_watch(arg_request_id,
1918: var_watch_id,
1919: rows_updated);

Line 2379: mtl_demand_omoe dem

2375: SELECT NVL(sl.end_item_unit_number, slp.end_item_unit_number)
2376: INTO v_unit_number
2377: FROM so_lines_all sl,
2378: so_lines_all slp,
2379: mtl_demand_omoe dem
2380: WHERE slp.line_id(+) = nvl(sl.parent_line_id,sl.line_id)
2381: AND to_number(dem.demand_source_line) = sl.line_id(+)
2382: AND dem.demand_source_type in (2,8)
2383: AND dem.demand_id = p_demand_id;

Line 2387: /* 1835326 - SCHAUDHA : Removed the join to mtl_demand_omoe as the

2383: AND dem.demand_id = p_demand_id;
2384:
2385: ELSE
2386:
2387: /* 1835326 - SCHAUDHA : Removed the join to mtl_demand_omoe as the
2388: query fetched multiple rows for a sales
2389: order line that is reserved against
2390: multiple lots.
2391: */