DBA Data[Home] [Help]

APPS.GMPRELAP dependencies on MTL_SYSTEM_ITEMS_KFV

Line 1144: (select PRIMARY_UOM_CODE, inventory_item_id , organization_id , CONCATENATED_SEGMENTS from mtl_system_items_kfv) msi,

1140:
1141: -- Bug: 8663941 Vpedarla
1142: CURSOR Cur_get_item_uoms(eff_id NUMBER) IS
1143: SELECT msi.CONCATENATED_SEGMENTS , msi.inventory_item_id from
1144: (select PRIMARY_UOM_CODE, inventory_item_id , organization_id , CONCATENATED_SEGMENTS from mtl_system_items_kfv) msi,
1145: (select inventory_item_id , recipe_validity_rule_id , DETAIL_UOM from gmd_recipe_validity_rules ) gmd
1146: where msi.organization_id = p_organization_id
1147: AND msi.inventory_item_id = gmd.inventory_item_id
1148: AND gmd.recipe_validity_rule_id = eff_id ;