APPS.AHL_VWP_RULES_PVT dependencies on INV_ORGANIZATION_INFO_V

Line 213: FROM INV_ORGANIZATION_INFO_V org,

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
213: FROM INV_ORGANIZATION_INFO_V org,
214: mtl_parameters m
215: WHERE org.organization_id = m.organization_id
216: AND NVL(org.operating_unit,mo_global.get_current_org_id()) = mo_global.get_current_org_id()
217: ) ;

Line 241: FROM inv_organization_info_v org,

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
243: WHERE org.organization_id = m.organization_id
244: AND NVL(org.operating_unit,mo_global.get_current_org_id())
245: = mo_global.get_current_org_id()

Line 309: FROM INV_ORGANIZATION_INFO_V

305: -- Check removed to avoid having to setup Project's
306: -- Carrying-out Org as an Inventory Org
307: AND carrying_out_organization_id IN
308: ( SELECT organization_id
309: FROM INV_ORGANIZATION_INFO_V
310: WHERE NVL(operating_unit,mo_global.get_current_org_id()) =
311: mo_global.get_current_org_id()
312: );
313: */

Line 526: FROM INV_ORGANIZATION_INFO_V

522: WHERE hou.organization_id = mp.organization_id
523: AND hou.organization_id = p_organization_id
524: AND hou.organization_id IN
525: (SELECT organization_id
526: FROM INV_ORGANIZATION_INFO_V
527: WHERE hou.organization_id = mp.organization_id
528: AND NVL(operating_unit, mo_global.get_current_org_id()) = mo_global.get_current_org_id())
529: AND MP.EAM_enabled_flag='Y';
530: ELSE

Line 539: FROM INV_ORGANIZATION_INFO_V

535: WHERE hou.organization_id = mp.organization_id
536: AND hou.Name = p_org_name
537: AND hou.organization_id IN
538: (SELECT organization_id
539: FROM INV_ORGANIZATION_INFO_V
540: WHERE hou.organization_id = mp.organization_id
541: AND NVL(operating_unit, mo_global.get_current_org_id()) = mo_global.get_current_org_id())
542: AND MP.EAM_enabled_flag='Y';
543: END IF;