APPS.GMO_INSTR_ENTITY_PVT dependencies on FM_MATL_DTL

Line 107: from fm_matl_dtl a, mtl_system_items_kfv b, fm_form_mst c

103: and e.resources = l_resources;
104:
105: cursor get_formula_material is
106: Select gmo_utilities.get_lookup_meaning ('GMO_INSTR_ENTITY_CODES', 'FORMULA') || ' ' || c.formula_no || ' : ' || b.Concatenated_segments
107: from fm_matl_dtl a, mtl_system_items_kfv b, fm_form_mst c
108: where a.inventory_item_id = b.inventory_item_id
109: and a.organization_id = b.organization_id
110: and a.formula_id = c.formula_id
111: and a.inventory_item_id = l_inventory_item_id

Line 116: from fm_matl_dtl a, mtl_system_items_kfv b, gmd_recipes c

112: and a.formulaline_id = l_formulaline_id;
113:
114: cursor get_recipe_material is
115: Select gmo_utilities.get_lookup_meaning ('GMO_INSTR_ENTITY_CODES', 'RECIPE') || ' ' || c.recipe_no || ' : ' || b.Concatenated_segments
116: from fm_matl_dtl a, mtl_system_items_kfv b, gmd_recipes c
117: where a.inventory_item_id = b.inventory_item_id
118: and a.organization_id=b.organization_id
119: and a.formula_id = c.formula_id
120: and a.inventory_item_id = l_inventory_item_id

Line 139: from mtl_system_items_kfv a, mtl_parameters b, gmd_recipes c, fm_matl_dtl d

135:
136:
137: cursor get_recipe_dispense_item is
138: Select gmo_utilities.get_lookup_meaning ('GMO_INSTR_ENTITY_CODES', 'RECIPE') || ' ' || c.recipe_no || ' : ' || a.Concatenated_segments
139: from mtl_system_items_kfv a, mtl_parameters b, gmd_recipes c, fm_matl_dtl d
140: where a.organization_id=b.organization_id
141: and d.formula_id = c.formula_id
142: and d.inventory_item_id = a.inventory_item_id
143: and a.inventory_item_id = l_inventory_item_id