APPS.GMD_FETCH_VALIDITY_RULES dependencies on FM_MATL_DTL

Line 108: FROM fm_matl_dtl

104: AND base_uom_flag = 'Y';
105:
106: CURSOR Cur_get_qty(V_item_id NUMBER) IS
107: SELECT qty, scale_type, detail_uom
108: FROM fm_matl_dtl
109: WHERE formula_id = l_formula_id
110: AND inventory_item_id = V_item_id
111: AND line_type = 1
112: ORDER BY line_no;

Line 437: FROM fm_matl_dtl

433: x_return_status OUT NOCOPY VARCHAR2,
434: X_output_ratio OUT NOCOPY NUMBER) IS
435: CURSOR Cur_get_prods IS
436: SELECT inventory_item_id, qty, detail_uom, scale_type
437: FROM fm_matl_dtl
438: WHERE formula_id = p_formula_id
439: AND line_type IN (1,2);
440:
441: l_batch_output NUMBER := 0;

Line 504: FROM fm_matl_dtl

500: X_ingred_prod_ratio OUT NOCOPY NUMBER,
501: x_return_status OUT NOCOPY VARCHAR2) IS
502: CURSOR Cur_get_details(V_line_type NUMBER) IS
503: SELECT inventory_item_id, qty, detail_uom, scale_type, contribute_yield_ind
504: FROM fm_matl_dtl
505: WHERE formula_id = p_formula_id
506: AND line_type = V_line_type;
507: l_sum_prods NUMBER := 0;
508: l_sum_ingreds NUMBER := 0;

Line 592: FROM fm_matl_dtl

588: X_batchformula_ratio OUT NOCOPY NUMBER,
589: X_return_status OUT NOCOPY VARCHAR2) IS
590: CURSOR Cur_get_ingreds IS
591: SELECT inventory_item_id, qty, detail_uom, scale_type
592: FROM fm_matl_dtl
593: WHERE formula_id = p_formula_id
594: AND line_type = -1;
595: CURSOR Cur_get_total_input IS
596: SELECT total_input_qty, yield_uom

Line 664: FROM fm_matl_dtl

660: X_contributing_qty OUT NOCOPY NUMBER,
661: X_return_status OUT NOCOPY VARCHAR2) IS
662: CURSOR Cur_get_ingreds IS
663: SELECT inventory_item_id, qty, detail_uom, scale_type, contribute_yield_ind
664: FROM fm_matl_dtl
665: WHERE formula_id = p_formula_id
666: AND line_type = -1;
667: l_conv_qty NUMBER := 0;
668: l_process_loss NUMBER := 0;

Line 757: FROM fm_matl_dtl

753: X_output_ratio OUT NOCOPY NUMBER,
754: X_return_status OUT NOCOPY VARCHAR2) IS
755: CURSOR Cur_get_prods IS
756: SELECT inventory_item_id, qty, detail_uom, scale_type
757: FROM fm_matl_dtl
758: WHERE formula_id = p_formula_id
759: AND line_type = 1;
760: l_contributing_qty NUMBER := 0;
761: l_formula_output NUMBER := 0;