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 2469: FROM mrp_form_query mfq, mtl_system_items mtl

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

Line 2485: SELECT mrp_form_query_s.nextval

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

Line 2518: INSERT INTO MRP_FORM_QUERY (

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

Line 2547: UPDATE MRP_FORM_QUERY

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

Line 2567: FROM mrp_form_query

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

Line 2598: UPDATE mrp_form_query

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

Line 2611: UPDATE mrp_form_query

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

Line 2613: FROM mrp_form_query

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

Line 2639: FROM mrp_form_query

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

Line 2672: INSERT INTO MRP_FORM_QUERY (

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

Line 2815: UPDATE mrp_form_query

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

Line 2851: FROM mrp_form_query

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

Line 2865: FROM mrp_form_query

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

Line 2888: FROM mrp_form_query

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

Line 2901: UPDATE mrp_form_query

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

Line 2911: UPDATE mrp_form_query

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

Line 2921: UPDATE mrp_form_query

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

Line 2931: FROM mrp_form_query

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

Line 2943: FROM mrp_form_query

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

Line 3011: UPDATE mrp_form_query

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

Line 3013: FROM mrp_form_query

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