DBA Data[Home] [Help]

APPS.GMO_INSTR_ENTITY_PVT dependencies on MTL_PARAMETERS

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