APPS.GMO_INSTR_ENTITY_PVT dependencies on MTL_SYSTEM_ITEMS_KFV

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 126: from mtl_system_items_kfv a

122: and c.recipe_id = l_recipe_id;
123:
124: cursor get_dispense_item is
125: Select a.Concatenated_segments
126: from mtl_system_items_kfv a
127: where a.inventory_item_id = l_inventory_item_id;
128:
129: cursor get_org_dispense_item is
130: Select gmo_utilities.get_lookup_meaning ('GMO_INSTR_ENTITY_CODES', 'ORGANIZATION') || ' ' || b.organization_code || ' : ' || a.Concatenated_segments

Line 131: from mtl_system_items_kfv a, mtl_parameters b

127: where a.inventory_item_id = l_inventory_item_id;
128:
129: cursor get_org_dispense_item is
130: Select gmo_utilities.get_lookup_meaning ('GMO_INSTR_ENTITY_CODES', 'ORGANIZATION') || ' ' || b.organization_code || ' : ' || a.Concatenated_segments
131: from mtl_system_items_kfv a, mtl_parameters b
132: where a.organization_id=b.organization_id
133: and a.inventory_item_id = l_inventory_item_id
134: and a.organization_id = l_organization_id;
135:

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