APPS.AHL_VWP_RULES_PVT dependencies on MTL_SYSTEM_ITEMS_KFV

Line 203: FROM MTL_SYSTEM_ITEMS_KFV

199: -- Fix for ADS bug# 4357001.
200: -- AnRaj:Changes made for fixing bug#4919353, issue# 1
201: /* SELECT concatenated_segments, inventory_item_id, organization_id
202: INTO x_item_name, x_item_id, x_org_id
203: FROM MTL_SYSTEM_ITEMS_KFV
204: WHERE concatenated_segments = p_item_name AND organization_id = p_org_id
205: AND organization_id IN (Select DISTINCT m.master_organization_id
206: FROM org_organization_definitions org, mtl_parameters m
207: WHERE org.organization_id = m.organization_id

Line 214: FROM MTL_SYSTEM_ITEMS_KFV

210: );*/
211:
212: SELECT concatenated_segments, inventory_item_id, organization_id
213: INTO x_item_name, x_item_id, x_org_id
214: FROM MTL_SYSTEM_ITEMS_KFV
215: WHERE concatenated_segments = p_item_name
216: AND organization_id = p_org_id
217: AND organization_id IN
218: (SELECT DISTINCT m.master_organization_id

Line 233: FROM MTL_SYSTEM_ITEMS_KFV

229:
230: -- Fix for ADS bug# 4357001.
231: /* SELECT concatenated_segments, inventory_item_id, organization_id
232: INTO x_item_name, x_item_id, x_org_id
233: FROM MTL_SYSTEM_ITEMS_KFV
234: WHERE inventory_item_id = p_item_id AND organization_id = p_org_id
235: AND organization_id IN (Select DISTINCT m.master_organization_id
236: FROM org_organization_definitions org, mtl_parameters m
237: WHERE org.organization_id = m.organization_id

Line 244: FROM MTL_SYSTEM_ITEMS_KFV

240: ); */
241: -- AnRaj: Changes made for fixing bug#4919353
242: SELECT concatenated_segments, inventory_item_id, organization_id
243: INTO x_item_name, x_item_id, x_org_id
244: FROM MTL_SYSTEM_ITEMS_KFV
245: WHERE inventory_item_id = p_item_id AND organization_id = p_org_id
246: AND organization_id IN (Select DISTINCT m.master_organization_id
247: FROM inv_organization_info_v org,
248: mtl_parameters m