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 1335: from mtl_system_items_kfv

1331: BEGIN
1332:
1333: select mrp_planning_code,pick_components_flag
1334: into lv_mrp_planning_code,lv_pick_components_flag
1335: from mtl_system_items_kfv
1336: where inventory_item_id = p_inventory_item_id
1337: and organization_id = p_organization_id;
1338:
1339: If ( lv_mrp_planning_code <> 6 OR (lv_mrp_planning_code = 6 and lv_pick_components_flag ='Y')) THEN