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 880: 'mtl_demand(1)',

876: var_watch_id := mrp_print_pk.start_watch('GEN-updated',
877: arg_request_id,
878: arg_user_id,
879: 'ENTITY',
880: 'mtl_demand(1)',
881: 'N');
882:
883:
884: /*------------------------------------------------------+

Line 893: OPEN mtl_demand_cur1;

889: | |
890: +------------------------------------------------------
891: LOOP
892: BEGIN
893: OPEN mtl_demand_cur1;
894: EXIT;
895: EXCEPTION
896: WHEN busy THEN
897: NULL;

Line 903: FETCH mtl_demand_cur1 INTO

899: END;
900: END LOOP;
901:
902: LOOP
903: FETCH mtl_demand_cur1 INTO
904: var_dem_rowid;
905: EXIT WHEN mtl_demand_cur1%NOTFOUND;
906:
907: UPDATE mtl_demand demand

Line 905: EXIT WHEN mtl_demand_cur1%NOTFOUND;

901:
902: LOOP
903: FETCH mtl_demand_cur1 INTO
904: var_dem_rowid;
905: EXIT WHEN mtl_demand_cur1%NOTFOUND;
906:
907: UPDATE mtl_demand demand
908: SET demand.updated_flag = SYS_NO
909: WHERE rowid = var_dem_rowid;

Line 907: UPDATE mtl_demand demand

903: FETCH mtl_demand_cur1 INTO
904: var_dem_rowid;
905: EXIT WHEN mtl_demand_cur1%NOTFOUND;
906:
907: UPDATE mtl_demand demand
908: SET demand.updated_flag = SYS_NO
909: WHERE rowid = var_dem_rowid;
910: rows_updated := rows_updated + SQL%ROWCOUNT;
911:

Line 914: CLOSE mtl_demand_cur1;

910: rows_updated := rows_updated + SQL%ROWCOUNT;
911:
912: END LOOP;
913:
914: CLOSE mtl_demand_cur1;
915:
916: mrp_print_pk.stop_watch(arg_request_id,
917: var_watch_id,
918: rows_updated);

Line 1074: OPEN mtl_demand_cur_first;

1070:
1071: LOOP
1072: BEGIN
1073: IF (var_first_time = 'Y') THEN
1074: OPEN mtl_demand_cur_first;
1075: ELSE
1076: OPEN mtl_demand_cur_next;
1077: END IF;
1078: EXIT;

Line 1076: OPEN mtl_demand_cur_next;

1072: BEGIN
1073: IF (var_first_time = 'Y') THEN
1074: OPEN mtl_demand_cur_first;
1075: ELSE
1076: OPEN mtl_demand_cur_next;
1077: END IF;
1078: EXIT;
1079: EXCEPTION
1080: WHEN busy THEN

Line 1104: FETCH mtl_demand_cur_first INTO

1100:
1101: LOOP
1102:
1103: IF (var_first_time = 'Y') THEN
1104: FETCH mtl_demand_cur_first INTO
1105: var_dem_inventory_item_id,
1106: var_dem_demand_id,
1107: var_dem_organization_id,
1108: var_dem_user_line_num,

Line 1123: EXIT WHEN mtl_demand_cur_first%NOTFOUND;

1119: var_dem_demand_type,
1120: var_ato_line_id,
1121: var_upd_rowid;
1122:
1123: EXIT WHEN mtl_demand_cur_first%NOTFOUND;
1124: ELSE
1125: FETCH mtl_demand_cur_next INTO
1126: var_dem_inventory_item_id,
1127: var_dem_demand_id,

Line 1125: FETCH mtl_demand_cur_next INTO

1121: var_upd_rowid;
1122:
1123: EXIT WHEN mtl_demand_cur_first%NOTFOUND;
1124: ELSE
1125: FETCH mtl_demand_cur_next INTO
1126: var_dem_inventory_item_id,
1127: var_dem_demand_id,
1128: var_dem_organization_id,
1129: var_dem_user_line_num,

Line 1144: EXIT WHEN mtl_demand_cur_next%NOTFOUND;

1140: var_dem_demand_type,
1141: var_ato_line_id,
1142: var_upd_rowid;
1143:
1144: EXIT WHEN mtl_demand_cur_next%NOTFOUND;
1145: END IF;
1146:
1147:
1148: /* Bug 1997355

Line 1198: * mtl_demand_cur_next, we execute this piece

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

Line 1317: -- the mtl_Demand_cur loop

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

Line 1562: UPDATE mtl_demand

1558: end if;
1559:
1560: IF g_om_installed = 'OE' THEN
1561:
1562: UPDATE mtl_demand
1563: SET updated_flag = SYS_NO
1564: WHERE rowid = var_dem_rowid;
1565:
1566: END IF;*/ --bug16239252

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

1573:
1574: END LOOP;
1575:
1576: IF (var_first_time = 'Y') THEN
1577: counter := counter + mtl_demand_cur_first%ROWCOUNT;
1578: CLOSE mtl_demand_cur_first;
1579:
1580: IF counter < UPDATE_BATCH_SIZE THEN
1581: var_break_loop := SYS_YES;

Line 1578: CLOSE mtl_demand_cur_first;

1574: END LOOP;
1575:
1576: IF (var_first_time = 'Y') THEN
1577: counter := counter + mtl_demand_cur_first%ROWCOUNT;
1578: CLOSE mtl_demand_cur_first;
1579:
1580: IF counter < UPDATE_BATCH_SIZE THEN
1581: var_break_loop := SYS_YES;
1582: END IF;

Line 1584: CLOSE mtl_demand_cur_next;

1580: IF counter < UPDATE_BATCH_SIZE THEN
1581: var_break_loop := SYS_YES;
1582: END IF;
1583: ELSE
1584: CLOSE mtl_demand_cur_next;
1585: END IF;
1586:
1587:
1588: IF (var_first_time = 'N') THEN

Line 1858: CURSOR lock_mtl_demand_cur IS

1854: -- ********************** update_sales_orders *************************
1855: PROCEDURE update_sales_orders(arg_request_id IN NUMBER,
1856: arg_user_id IN NUMBER) IS
1857:
1858: CURSOR lock_mtl_demand_cur IS
1859: SELECT demand.rowid,
1860: updates1.new_schedule_quantity,
1861: updates1.new_schedule_date
1862: FROM mtl_demand demand,

Line 1862: FROM mtl_demand demand,

1858: CURSOR lock_mtl_demand_cur IS
1859: SELECT demand.rowid,
1860: updates1.new_schedule_quantity,
1861: updates1.new_schedule_date
1862: FROM mtl_demand demand,
1863: mrp_sales_order_updates updates1
1864: WHERE updates1.sales_order_id = demand.demand_id
1865: AND updates1.request_id = arg_request_id
1866: AND updates1.process_status = 3

Line 1891: 'mtl_demand',

1887: var_watch_id := mrp_print_pk.start_watch('GEN-updated',
1888: arg_request_id,
1889: arg_user_id,
1890: 'ENTITY',
1891: 'mtl_demand',
1892: 'N');
1893: LOOP
1894: BEGIN
1895: OPEN lock_mtl_demand_cur;

Line 1895: OPEN lock_mtl_demand_cur;

1891: 'mtl_demand',
1892: 'N');
1893: LOOP
1894: BEGIN
1895: OPEN lock_mtl_demand_cur;
1896: EXIT;
1897: EXCEPTION
1898: WHEN busy THEN
1899: NULL;

Line 1905: FETCH lock_mtl_demand_cur INTO

1901: END;
1902: END LOOP;
1903:
1904: LOOP
1905: FETCH lock_mtl_demand_cur INTO
1906: var_rowid,
1907: var_quantity,
1908: var_date;
1909: EXIT WHEN lock_mtl_demand_cur%NOTFOUND;

Line 1909: EXIT WHEN lock_mtl_demand_cur%NOTFOUND;

1905: FETCH lock_mtl_demand_cur INTO
1906: var_rowid,
1907: var_quantity,
1908: var_date;
1909: EXIT WHEN lock_mtl_demand_cur%NOTFOUND;
1910:
1911: UPDATE mtl_demand demand
1912: SET demand.mrp_date = var_date,
1913: demand.mrp_quantity = var_quantity

Line 1911: UPDATE mtl_demand demand

1907: var_quantity,
1908: var_date;
1909: EXIT WHEN lock_mtl_demand_cur%NOTFOUND;
1910:
1911: UPDATE mtl_demand demand
1912: SET demand.mrp_date = var_date,
1913: demand.mrp_quantity = var_quantity
1914: WHERE rowid = var_rowid;
1915:

Line 1920: CLOSE lock_mtl_demand_cur;

1916: rows_updated := rows_updated + SQL%ROWCOUNT;
1917:
1918: END LOOP;
1919:
1920: CLOSE lock_mtl_demand_cur;
1921:
1922: mrp_print_pk.stop_watch(arg_request_id,
1923: var_watch_id,
1924: rows_updated);

Line 2384: mtl_demand_omoe dem

2380: SELECT NVL(sl.end_item_unit_number, slp.end_item_unit_number)
2381: INTO v_unit_number
2382: FROM so_lines_all sl,
2383: so_lines_all slp,
2384: mtl_demand_omoe dem
2385: WHERE slp.line_id(+) = nvl(sl.parent_line_id,sl.line_id)
2386: AND to_number(dem.demand_source_line) = sl.line_id(+)
2387: AND dem.demand_source_type in (2,8)
2388: AND dem.demand_id = p_demand_id;

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

2388: AND dem.demand_id = p_demand_id;
2389:
2390: ELSE
2391:
2392: /* 1835326 - SCHAUDHA : Removed the join to mtl_demand_omoe as the
2393: query fetched multiple rows for a sales
2394: order line that is reserved against
2395: multiple lots.
2396: */