DBA Data[Home] [Help]

APPS.AHL_VWP_VISITS_PVT dependencies on MO_GLOBAL

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

1469: AND csis.ACTIVE_START_DATE <= sysdate AND (csis.ACTIVE_END_DATE >= sysdate OR csis.ACTIVE_END_DATE
1470: IS NULL)
1471: AND csis.inv_master_organization_id IN ( SELECT mp.master_organization_id FROM org_organization_definitions org
1472: , mtl_parameters mp WHERE org.organization_id = mp.organization_id
1473: AND NVL(operating_unit, mo_global.get_current_org_id())
1474: = mo_global.get_current_org_id()); */
1475:
1476: -- AnRaj: Changed for fixing the perf bug 4919502
1477: SELECT uc.name ,

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

1470: IS NULL)
1471: AND csis.inv_master_organization_id IN ( SELECT mp.master_organization_id FROM org_organization_definitions org
1472: , mtl_parameters mp WHERE org.organization_id = mp.organization_id
1473: AND NVL(operating_unit, mo_global.get_current_org_id())
1474: = mo_global.get_current_org_id()); */
1475:
1476: -- AnRaj: Changed for fixing the perf bug 4919502
1477: SELECT uc.name ,
1478: csis.serial_number ,

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

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:
1503: /*Added by sowsubra*/
1504: CURSOR c_subinv_validate (p_subinv_code IN VARCHAR2, p_org_id IN VARCHAR2) IS