APPS.MSD_SR_UTIL dependencies on MTL_SYSTEM_ITEMS_KFV

Line 78: from mtl_system_items_kfv

74: if p_item_id is NULL then return 'Other'; end if;
75: if p_org_id is NULL then
76: select concatenated_segments
77: into l_item
78: from mtl_system_items_kfv
79: where inventory_item_id = p_item_id AND organization_id is NULL;
80: else
81: select concatenated_segments
82: into l_item

Line 83: from mtl_system_items_kfv

79: where inventory_item_id = p_item_id AND organization_id is NULL;
80: else
81: select concatenated_segments
82: into l_item
83: from mtl_system_items_kfv
84: where inventory_item_id = p_item_id AND organization_id = p_org_id;
85: end if;
86: return l_item;
87:

Line 1267: from mtl_system_items_kfv

1263: BEGIN
1264:
1265: select mrp_planning_code,pick_components_flag
1266: into lv_mrp_planning_code,lv_pick_components_flag
1267: from mtl_system_items_kfv
1268: where inventory_item_id = p_inventory_item_id
1269: and organization_id = p_organization_id;
1270:
1271: If ( lv_mrp_planning_code <> 6 OR (lv_mrp_planning_code = 6 and lv_pick_components_flag ='Y')) THEN