APPS.GMD_FORMULA_ANALYSIS dependencies on MTL_SYSTEM_ITEMS_KFV

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 302: FROM mtl_system_items_kfv

298:
299: X_class Cur_get_class%ROWTYPE;
300: CURSOR Cur_get_item(V_item_id NUMBER) IS
301: SELECT concatenated_segments
302: FROM mtl_system_items_kfv
303: WHERE inventory_item_id = V_item_id;
304: NO_TECH_CLASS EXCEPTION;
305: NO_WT_OR_VOL EXCEPTION;
306:

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