DBA Data[Home] [Help]

APPS.AHL_VWP_VISITS_PVT dependencies on MO_GLOBAL

Line 1745: AND NVL(operating_unit, mo_global.get_current_org_id())

1741: AND csis.ACTIVE_START_DATE <= sysdate AND (csis.ACTIVE_END_DATE >= sysdate OR csis.ACTIVE_END_DATE
1742: IS NULL)
1743: AND csis.inv_master_organization_id IN ( SELECT mp.master_organization_id FROM org_organization_definitions org
1744: , mtl_parameters mp WHERE org.organization_id = mp.organization_id
1745: AND NVL(operating_unit, mo_global.get_current_org_id())
1746: = mo_global.get_current_org_id()); */
1747:
1748: -- AnRaj: Changed for fixing the perf bug 4919502
1749: SELECT uc.name ,

Line 1746: = mo_global.get_current_org_id()); */

1742: IS NULL)
1743: AND csis.inv_master_organization_id IN ( SELECT mp.master_organization_id FROM org_organization_definitions org
1744: , mtl_parameters mp WHERE org.organization_id = mp.organization_id
1745: AND NVL(operating_unit, mo_global.get_current_org_id())
1746: = mo_global.get_current_org_id()); */
1747:
1748: -- AnRaj: Changed for fixing the perf bug 4919502
1749: SELECT uc.name ,
1750: csis.serial_number ,

Line 1772: AND NVL(operating_unit, mo_global.get_current_org_id()) = mo_global.get_current_org_id()

1768: AND csis.inv_master_organization_id IN
1769: ( SELECT mp.master_organization_id
1770: FROM inv_organization_info_v org, mtl_parameters mp
1771: WHERE org.organization_id = mp.organization_id
1772: AND NVL(operating_unit, mo_global.get_current_org_id()) = mo_global.get_current_org_id()
1773: );
1774: --PRAKKUM ::FP PIE :: 13-OCT-2010
1775: --To get project id given the project name
1776: CURSOR get_project_id_csr (c_project_name IN VARCHAR2)