DBA Data[Home] [Help]

APPS.AHL_VWP_VISITS_PVT dependencies on INV_ORGANIZATION_INFO_V

Line 1498: FROM inv_organization_info_v org, mtl_parameters mp

1494: AND csis.ACTIVE_START_DATE <= sysdate
1495: AND (csis.ACTIVE_END_DATE >= sysdate OR csis.ACTIVE_END_DATE IS NULL)
1496: AND csis.inv_master_organization_id IN
1497: ( SELECT mp.master_organization_id
1498: FROM inv_organization_info_v org, mtl_parameters mp
1499: WHERE org.organization_id = mp.organization_id
1500: AND NVL(operating_unit, mo_global.get_current_org_id()) = mo_global.get_current_org_id()
1501: );
1502: