APPS.AHL_VWP_RULES_PVT dependencies on MTL_SYSTEM_ITEMS_KFV

Line 197: FROM MTL_SYSTEM_ITEMS_KFV

193: -- Fix for ADS bug# 4357001.
194: -- AnRaj:Changes made for fixing bug#4919353, issue# 1
195: /* SELECT concatenated_segments, inventory_item_id, organization_id
196: INTO x_item_name, x_item_id, x_org_id
197: FROM MTL_SYSTEM_ITEMS_KFV
198: WHERE concatenated_segments = p_item_name AND organization_id = p_org_id
199: AND organization_id IN (Select DISTINCT m.master_organization_id
200: FROM org_organization_definitions org, mtl_parameters m
201: WHERE org.organization_id = m.organization_id

Line 208: FROM MTL_SYSTEM_ITEMS_KFV

204: );*/
205:
206: SELECT concatenated_segments, inventory_item_id, organization_id
207: INTO x_item_name, x_item_id, x_org_id
208: FROM MTL_SYSTEM_ITEMS_KFV
209: WHERE concatenated_segments = p_item_name
210: AND organization_id = p_org_id
211: AND organization_id IN
212: (SELECT DISTINCT m.master_organization_id

Line 227: FROM MTL_SYSTEM_ITEMS_KFV

223:
224: -- Fix for ADS bug# 4357001.
225: /* SELECT concatenated_segments, inventory_item_id, organization_id
226: INTO x_item_name, x_item_id, x_org_id
227: FROM MTL_SYSTEM_ITEMS_KFV
228: WHERE inventory_item_id = p_item_id AND organization_id = p_org_id
229: AND organization_id IN (Select DISTINCT m.master_organization_id
230: FROM org_organization_definitions org, mtl_parameters m
231: WHERE org.organization_id = m.organization_id

Line 238: FROM MTL_SYSTEM_ITEMS_KFV

234: ); */
235: -- AnRaj: Changes made for fixing bug#4919353
236: SELECT concatenated_segments, inventory_item_id, organization_id
237: INTO x_item_name, x_item_id, x_org_id
238: FROM MTL_SYSTEM_ITEMS_KFV
239: WHERE inventory_item_id = p_item_id AND organization_id = p_org_id
240: AND organization_id IN (Select DISTINCT m.master_organization_id
241: FROM inv_organization_info_v org,
242: mtl_parameters m