eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AHL_PRD_DF_PVT dependencies on MO_GLOBAL

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

928: /* to check whether visit available in client's organization */
929: AND WO.visit_id = VS.visit_id
930: AND VS.ORGANIZATION_ID IN
931: (SELECT ORGANIZATION_ID FROM org_organization_definitions
932: WHERE NVL (operating_unit, mo_global.get_current_org_id())
933: = mo_global.get_current_org_id())
934: AND VST.visit_id = VS.visit_id
935: /* */
936: AND WO.visit_task_id = VST.visit_task_id

Line 933: = mo_global.get_current_org_id())

929: AND WO.visit_id = VS.visit_id
930: AND VS.ORGANIZATION_ID IN
931: (SELECT ORGANIZATION_ID FROM org_organization_definitions
932: WHERE NVL (operating_unit, mo_global.get_current_org_id())
933: = mo_global.get_current_org_id())
934: AND VST.visit_id = VS.visit_id
935: /* */
936: AND WO.visit_task_id = VST.visit_task_id
937: AND VST.unit_effectivity_id = UE.unit_effectivity_id

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

3866: SELECT WO.workorder_id
3867: FROM ahl_workorders wo, ahl_visit_tasks_b vts,
3868: ahl_visits_b vst,
3869: (SELECT ORGANIZATION_ID FROM INV_ORGANIZATION_INFO_V
3870: WHERE NVL (operating_unit, mo_global.get_current_org_id()) = mo_global.get_current_org_id()) ORG
3871: WHERE wo.visit_task_id = vts.visit_task_id
3872: AND vts.visit_id = vst.visit_id
3873: AND vst.organization_id = org.organization_id
3874: AND WO.status_code NOT IN ( G_JOB_DRAFT,G_JOB_DELETED)

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

5922: FROM ahl_workorders wo, ahl_unit_deferrals_b udf,
5923: ahl_visit_tasks_b vts, ahl_visits_b vst,
5924: (SELECT ORGANIZATION_ID
5925: FROM INV_ORGANIZATION_INFO_V
5926: WHERE NVL (operating_unit, mo_global.get_current_org_id()) = mo_global.get_current_org_id()) ORG
5927: WHERE WO.VISIT_TASK_ID=VTS.VISIT_TASK_ID
5928: AND VST.VISIT_ID=VTS.VISIT_ID
5929: AND VST.ORGANIZATION_ID=ORG.ORGANIZATION_ID
5930: AND vts.unit_effectivity_id = udf.unit_effectivity_id