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_LINE_SCHEDULE_ALGORITHM dependencies on MRP_FORM_QUERY

Line 46: FROM mrp_form_query

42: -- the production plan for each item. This is used for rounding.
43:
44: CURSOR production_round (p_date NUMBER, p_query_id IN NUMBER) IS
45: SELECT number1, number2,number3
46: FROM mrp_form_query
47: WHERE date1 = to_date(p_date,'J')
48: AND query_id = p_query_id
49: ORDER BY number3 DESC;
50:

Line 2470: FROM mrp_form_query mfq, mtl_system_items mtl

2466:
2467: -- Cursor used to determine if any items of no rounding exists.
2468: CURSOR no_round_cursor IS
2469: SELECT number1,number2
2470: FROM mrp_form_query mfq, mtl_system_items mtl
2471: WHERE mfq.date1 = to_date(v_current_date,'J')
2472: AND mfq.query_id = v_query_id
2473: AND mfq.number1 = mtl.inventory_item_id
2474: AND NVL(mtl.rounding_control_type,2) <> C_ROUND_TYPE

Line 2486: SELECT mrp_form_query_s.nextval

2482:
2483: v_begin_date := to_number(to_char(p_first_date,'J'));
2484: v_finish_date := to_number(to_char(p_last_date,'J'));
2485:
2486: SELECT mrp_form_query_s.nextval
2487: INTO v_query_id
2488: FROM DUAL;
2489:
2490: V_ERROR_LINE := 2;

Line 2519: INSERT INTO MRP_FORM_QUERY (

2515: p_cap_tab(v_current_date).capacity),2);
2516:
2517: -- dbms_output.put_line('The production is: '||to_char(v_production));
2518:
2519: INSERT INTO MRP_FORM_QUERY (
2520: QUERY_ID,
2521: LAST_UPDATE_DATE,
2522: LAST_UPDATED_BY,
2523: CREATION_DATE,

Line 2548: UPDATE MRP_FORM_QUERY

2544: IF p_demand_tab(item_list_rec.primary_item_id).roundType <> C_ROUND_TYPE THEN
2545:
2546: --dbms_output.put_line('Item '||to_char(item_list_rec.primary_item_id)||'is not a round item');
2547:
2548: UPDATE MRP_FORM_QUERY
2549: SET number2 = v_production,
2550: number3 = 0
2551: WHERE number1 = item_list_rec.primary_item_id
2552: AND query_id = v_query_id

Line 2568: FROM mrp_form_query

2564: -- Find the sum of all production for the current date.
2565:
2566: SELECT SUM(number2)
2567: INTO v_trunc_sum
2568: FROM mrp_form_query
2569: WHERE query_id = v_query_id
2570: AND date1 = to_date(v_current_date,'J');
2571:
2572: V_ERROR_LINE := 4;

Line 2599: UPDATE mrp_form_query

2595: EXIT;
2596:
2597: ELSE
2598:
2599: UPDATE mrp_form_query
2600: SET number2 = v_item_round_qty + v_cap_diff
2601: WHERE number1 = v_item_round
2602: AND date1 = to_date(v_current_date,'J')
2603: AND query_id = v_query_id;

Line 2612: UPDATE mrp_form_query

2608: ELSE
2609:
2610: -- dbms_output.put_line('Updating ...'||to_char(production_round_rec.number1));
2611:
2612: UPDATE mrp_form_query
2613: SET number2 =(SELECT number2 +1
2614: FROM mrp_form_query
2615: WHERE date1 = to_date(v_current_date,'J')
2616: AND query_id = v_query_id

Line 2614: FROM mrp_form_query

2610: -- dbms_output.put_line('Updating ...'||to_char(production_round_rec.number1));
2611:
2612: UPDATE mrp_form_query
2613: SET number2 =(SELECT number2 +1
2614: FROM mrp_form_query
2615: WHERE date1 = to_date(v_current_date,'J')
2616: AND query_id = v_query_id
2617: AND number1 = production_round_rec.number1)
2618: WHERE date1 = to_date(v_current_date,'J')

Line 2640: FROM mrp_form_query

2636: v_finish_flag := -1;
2637:
2638: SELECT number2
2639: INTO v_decrement_qty
2640: FROM mrp_form_query
2641: WHERE query_id = v_query_id
2642: AND number1 = item_list_rec.primary_item_id
2643: AND date1 = to_date(v_current_date,'J');
2644:

Line 2673: INSERT INTO MRP_FORM_QUERY (

2669:
2670: END LOOP;
2671: ELSE
2672: FOR item_list_rec IN item_list(p_org_id) LOOP
2673: INSERT INTO MRP_FORM_QUERY (
2674: QUERY_ID,
2675: LAST_UPDATE_DATE,
2676: LAST_UPDATED_BY,
2677: CREATION_DATE,

Line 2816: UPDATE mrp_form_query

2812: -- Set initial current date
2813:
2814: v_current_date := p_cap_tab.FIRST;
2815:
2816: UPDATE mrp_form_query
2817: SET number4 = C_DATE_ON
2818: WHERE query_id = v_query_id
2819: AND date1 = to_date(v_current_date,'J');
2820:

Line 2852: FROM mrp_form_query

2848: v_last_wip := fs_select_rec.wip_entity;
2849:
2850: SELECT number2, to_number(to_char(date1,'J'))
2851: INTO v_alloc_qty, v_current_date
2852: FROM mrp_form_query
2853: WHERE query_id = v_query_id
2854: AND number1 = fs_select_rec.primary_item_id
2855: AND number4 = C_DATE_ON;
2856:

Line 2866: FROM mrp_form_query

2862: WHILE v_remain_qty > 0 LOOP
2863:
2864: SELECT number5
2865: INTO v_finish_flag
2866: FROM mrp_form_query
2867: WHERE number1 = fs_select_rec.primary_item_id
2868: AND number4 = C_DATE_ON
2869: AND query_id = v_query_id;
2870:

Line 2889: FROM mrp_form_query

2885: WHILE v_alloc_qty = 0 LOOP
2886:
2887: SELECT number5
2888: INTO v_finish_flag
2889: FROM mrp_form_query
2890: WHERE number1 = fs_select_rec.primary_item_id
2891: AND number4 = C_DATE_ON
2892: AND query_id = v_query_id;
2893:

Line 2902: UPDATE mrp_form_query

2898: END IF;
2899:
2900: IF v_current_date = p_cap_tab.LAST THEN
2901:
2902: UPDATE mrp_form_query
2903: SET number5 = C_COMPLETE
2904: WHERE number4 = C_DATE_ON
2905: AND query_id = v_query_id
2906: AND number1 = fs_select_rec.primary_item_id;

Line 2912: UPDATE mrp_form_query

2908: V_ERROR_LINE := 9;
2909:
2910: ELSE
2911:
2912: UPDATE mrp_form_query
2913: SET number4 = NULL
2914: WHERE date1 = to_date(v_current_date,'J')
2915: AND query_id = v_query_id
2916: AND number1 = fs_select_rec.primary_item_id;

Line 2922: UPDATE mrp_form_query

2918: V_ERROR_LINE := 10;
2919:
2920: v_current_date := p_cap_tab.NEXT(v_current_date);
2921:
2922: UPDATE mrp_form_query
2923: SET number4 = C_DATE_ON
2924: WHERE date1 = to_date(v_current_date,'J')
2925: AND query_id = v_query_id
2926: AND number1 = fs_select_rec.primary_item_id;

Line 2932: FROM mrp_form_query

2928: V_ERROR_LINE := 11;
2929:
2930: SELECT number2
2931: INTO v_alloc_qty
2932: FROM mrp_form_query
2933: WHERE query_id = v_query_id
2934: AND number1 = fs_select_rec.primary_item_id
2935: AND number4 = C_DATE_ON;
2936:

Line 2944: FROM mrp_form_query

2940: END LOOP;
2941:
2942: SELECT number5
2943: INTO v_finish_flag
2944: FROM mrp_form_query
2945: WHERE number1 = fs_select_rec.primary_item_id
2946: AND number4 = C_DATE_ON
2947: AND query_id = v_query_id;
2948:

Line 3012: UPDATE mrp_form_query

3008:
3009: -- Decrement remaining allocation quantity for the date by the
3010: -- scheduled quantity
3011:
3012: UPDATE mrp_form_query
3013: SET number2 = (SELECT number2 - v_remain_qty
3014: FROM mrp_form_query
3015: WHERE date1 = to_date(v_current_date,'J')
3016: AND query_id = v_query_id

Line 3014: FROM mrp_form_query

3010: -- scheduled quantity
3011:
3012: UPDATE mrp_form_query
3013: SET number2 = (SELECT number2 - v_remain_qty
3014: FROM mrp_form_query
3015: WHERE date1 = to_date(v_current_date,'J')
3016: AND query_id = v_query_id
3017: AND number1 = fs_select_rec.primary_item_id)
3018: WHERE date1 = to_date(v_current_date,'J')