APPS.AHL_VWP_RULES_PVT dependencies on INV_ORGANIZATION_INFO_V

Line 219: FROM INV_ORGANIZATION_INFO_V org,

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
219: FROM INV_ORGANIZATION_INFO_V org,
220: mtl_parameters m
221: WHERE org.organization_id = m.organization_id
222: AND NVL(org.operating_unit,mo_global.get_current_org_id()) = mo_global.get_current_org_id()
223: ) ;

Line 247: FROM inv_organization_info_v org,

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
249: WHERE org.organization_id = m.organization_id
250: AND NVL(org.operating_unit,mo_global.get_current_org_id())
251: = mo_global.get_current_org_id()

Line 315: FROM INV_ORGANIZATION_INFO_V

311: -- Check removed to avoid having to setup Project's
312: -- Carrying-out Org as an Inventory Org
313: AND carrying_out_organization_id IN
314: ( SELECT organization_id
315: FROM INV_ORGANIZATION_INFO_V
316: WHERE NVL(operating_unit,mo_global.get_current_org_id()) =
317: mo_global.get_current_org_id()
318: );
319: */

Line 532: FROM INV_ORGANIZATION_INFO_V

528: WHERE hou.organization_id = mp.organization_id
529: AND hou.organization_id = p_organization_id
530: AND hou.organization_id IN
531: (SELECT organization_id
532: FROM INV_ORGANIZATION_INFO_V
533: WHERE hou.organization_id = mp.organization_id
534: AND NVL(operating_unit, mo_global.get_current_org_id()) = mo_global.get_current_org_id())
535: AND MP.EAM_enabled_flag='Y';
536: ELSE

Line 545: FROM INV_ORGANIZATION_INFO_V

541: WHERE hou.organization_id = mp.organization_id
542: AND hou.Name = p_org_name
543: AND hou.organization_id IN
544: (SELECT organization_id
545: FROM INV_ORGANIZATION_INFO_V
546: WHERE hou.organization_id = mp.organization_id
547: AND NVL(operating_unit, mo_global.get_current_org_id()) = mo_global.get_current_org_id())
548: AND MP.EAM_enabled_flag='Y';
549: END IF;