APPS.GMD_FORMULA_ANALYSIS dependencies on FM_MATL_DTL

Line 46: FROM fm_matl_dtl d, mtl_system_items_kfv i

42:
43: -- NPD Conv.
44: CURSOR Cur_prods_byprods IS
45: SELECT d.inventory_item_id, d.qty, d.detail_uom, i.concatenated_segments
46: FROM fm_matl_dtl d, mtl_system_items_kfv i
47: WHERE formula_id = p_formula_id
48: AND line_type <> -1
49: AND i.inventory_item_id = d.inventory_item_id;
50:

Line 311: FROM fm_matl_dtl

307: /* Bug No. 6057138 - Start */
308: X_orig_qty Number :=0;
309: CURSOR Cur_get_qty(V_item_id NUMBER, V_formulaid NUMBER, V_line_no NUMBER) IS
310: SELECT qty
311: FROM fm_matl_dtl
312: WHERE inventory_item_id = V_item_id and
313: line_no = V_line_no and
314: formula_id = V_formulaid ;
315: /* Bug No. 6057138 - End */

Line 415: FROM fm_matl_dtl

411: X_vrules_tab gmd_fetch_validity_rules.recipe_validity_tbl;
412: X_vrules_tab1 gmd_fetch_validity_rules.recipe_validity_tbl;
413: CURSOR Cur_product_qty(V_formula_id NUMBER, V_item_id NUMBER) IS
414: SELECT qty, detail_uom
415: FROM fm_matl_dtl
416: WHERE formula_id = V_formula_id
417: AND line_type = 1
418: AND inventory_item_id = V_item_id;
419: CURSOR Cur_get_formula(V_formula_id NUMBER) IS

Line 813: X_tab gmd_common_scale.fm_matl_dtl_tab;

809: -- 15-Sep-2004 Jeff Baird Bug #3890191 Added X_out_tab.
810: --
811: --===================================================================== */
812: PROCEDURE scale_table(p_formula_id NUMBER, p_orgn_id NUMBER, p_scale_factor NUMBER, p_table IN OUT NOCOPY ing_tab) IS
813: X_tab gmd_common_scale.fm_matl_dtl_tab;
814: X_out_tab gmd_common_scale.fm_matl_dtl_tab;
815: -- Bug #3890191 (JKB) Added X_out_tab above.
816: X_status VARCHAR2(10);
817: X_row NUMBER := 0;

Line 814: X_out_tab gmd_common_scale.fm_matl_dtl_tab;

810: --
811: --===================================================================== */
812: PROCEDURE scale_table(p_formula_id NUMBER, p_orgn_id NUMBER, p_scale_factor NUMBER, p_table IN OUT NOCOPY ing_tab) IS
813: X_tab gmd_common_scale.fm_matl_dtl_tab;
814: X_out_tab gmd_common_scale.fm_matl_dtl_tab;
815: -- Bug #3890191 (JKB) Added X_out_tab above.
816: X_status VARCHAR2(10);
817: X_row NUMBER := 0;
818:

Line 823: FROM fm_matl_dtl

819: --NPD Conv. Use inventory_item_id and detail_uom instead of item_id and item_um
820: CURSOR Cur_get_lines IS
821: SELECT line_no, line_type, inventory_item_id, qty, detail_uom, scale_type, contribute_yield_ind,
822: scale_multiple, scale_rounding_variance
823: FROM fm_matl_dtl
824: WHERE formula_id = p_formula_id
825: ORDER BY line_type, line_no;
826:
827: BEGIN

Line 841: gmd_common_scale.scale(p_fm_matl_dtl_tab => X_tab,

837: X_tab(X_row).scale_multiple := get_rec.scale_multiple;
838: X_tab(X_row).scale_rounding_variance := get_rec.scale_rounding_variance;
839: END LOOP;
840:
841: gmd_common_scale.scale(p_fm_matl_dtl_tab => X_tab,
842: p_orgn_id => p_orgn_id,
843: p_scale_factor => p_scale_factor,
844: p_primaries => 'OUTPUTS',
845: x_fm_matl_dtl_tab => X_out_tab,

Line 845: x_fm_matl_dtl_tab => X_out_tab,

841: gmd_common_scale.scale(p_fm_matl_dtl_tab => X_tab,
842: p_orgn_id => p_orgn_id,
843: p_scale_factor => p_scale_factor,
844: p_primaries => 'OUTPUTS',
845: x_fm_matl_dtl_tab => X_out_tab,
846: x_return_status => X_status);
847: -- Bug #3890191 (JKB) Added X_out_tab above.
848: FOR i IN 1..p_table.count LOOP
849: FOR j IN 1..X_out_tab.count LOOP

Line 917: FROM fm_matl_dtl d, mtl_system_items_kfv i

913: x_return_status OUT NOCOPY VARCHAR2) IS
914: CURSOR Cur_ingred_items IS
915: SELECT d.inventory_item_id, d.line_no, i.concatenated_segments, d.qty, d.detail_uom,
916: d.iaformula_id, i.eng_item_flag, d.formula_id, d.tpformula_id
917: FROM fm_matl_dtl d, mtl_system_items_kfv i
918: WHERE d.formula_id = p_formula_id
919: AND d.line_type = -1
920: AND i.inventory_item_id = d.inventory_item_id
921: AND d.organization_id = i.organization_id