DBA Data[Home] [Help]

APPS.AHL_PRD_DF_PVT dependencies on MO_GLOBAL

Line 906: WHERE NVL (operating_unit, mo_global.get_current_org_id())

902: /* to check whether visit available in client's organization */
903: AND WO.visit_id = VS.visit_id
904: AND VS.ORGANIZATION_ID IN
905: (SELECT ORGANIZATION_ID FROM org_organization_definitions
906: WHERE NVL (operating_unit, mo_global.get_current_org_id())
907: = mo_global.get_current_org_id())
908: AND VST.visit_id = VS.visit_id
909: /* */
910: AND WO.visit_task_id = VST.visit_task_id

Line 907: = mo_global.get_current_org_id())

903: AND WO.visit_id = VS.visit_id
904: AND VS.ORGANIZATION_ID IN
905: (SELECT ORGANIZATION_ID FROM org_organization_definitions
906: WHERE NVL (operating_unit, mo_global.get_current_org_id())
907: = mo_global.get_current_org_id())
908: AND VST.visit_id = VS.visit_id
909: /* */
910: AND WO.visit_task_id = VST.visit_task_id
911: AND VST.unit_effectivity_id = UE.unit_effectivity_id

Line 3714: WHERE NVL (operating_unit, mo_global.get_current_org_id()) = mo_global.get_current_org_id()) ORG

3710: SELECT WO.workorder_id
3711: FROM ahl_workorders wo, ahl_visit_tasks_b vts,
3712: ahl_visits_b vst,
3713: (SELECT ORGANIZATION_ID FROM INV_ORGANIZATION_INFO_V
3714: WHERE NVL (operating_unit, mo_global.get_current_org_id()) = mo_global.get_current_org_id()) ORG
3715: WHERE wo.visit_task_id = vts.visit_task_id
3716: AND vts.visit_id = vst.visit_id
3717: AND vst.organization_id = org.organization_id
3718: AND WO.status_code NOT IN ( G_JOB_DRAFT,G_JOB_DELETED)

Line 5453: WHERE NVL (operating_unit, mo_global.get_current_org_id()) = mo_global.get_current_org_id()) ORG

5449: FROM ahl_workorders wo, ahl_unit_deferrals_b udf,
5450: ahl_visit_tasks_b vts, ahl_visits_b vst,
5451: (SELECT ORGANIZATION_ID
5452: FROM INV_ORGANIZATION_INFO_V
5453: WHERE NVL (operating_unit, mo_global.get_current_org_id()) = mo_global.get_current_org_id()) ORG
5454: WHERE WO.VISIT_TASK_ID=VTS.VISIT_TASK_ID
5455: AND VST.VISIT_ID=VTS.VISIT_ID
5456: AND VST.ORGANIZATION_ID=ORG.ORGANIZATION_ID
5457: AND vts.unit_effectivity_id = udf.unit_effectivity_id