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_UMP_BOM_PVT dependencies on AHL_VISIT_TASKS_B

Line 2443: AND NOT EXISTS (SELECT 'x' FROM ahl_workorders wo, ahl_visit_tasks_b tsk

2439: AND UE.object_type = 'MR'
2440: AND UE.mr_header_id = p_mr_header_id
2441: AND (UE.status_code IS NULL OR UE.status_code = 'INIT-DUE')
2442: AND UE.due_date IS NOT NULL
2443: AND NOT EXISTS (SELECT 'x' FROM ahl_workorders wo, ahl_visit_tasks_b tsk
2444: WHERE wo.visit_task_id = tsk.visit_task_id
2445: AND tsk.task_type_code = 'SUMMARY'
2446: AND tsk.status_code NOT IN ('DELETED','CANCELLED')
2447: AND tsk.unit_effectivity_id = UE.unit_effectivity_id)

Line 2490: AND NOT EXISTS (SELECT 'x' FROM ahl_workorders wo, ahl_visit_tasks_b tsk

2486: AND UES.cs_incident_id IS NULL
2487: AND UES.mr_header_id = p_mr_header_id
2488: AND (UES.status_code IS NULL OR UES.status_code = 'INIT-DUE')
2489: AND UES.due_date IS NOT NULL
2490: AND NOT EXISTS (SELECT 'x' FROM ahl_workorders wo, ahl_visit_tasks_b tsk
2491: WHERE wo.visit_task_id = tsk.visit_task_id
2492: AND tsk.task_type_code = 'SUMMARY'
2493: AND tsk.status_code NOT IN ('DELETED','CANCELLED')
2494: AND tsk.unit_effectivity_id = ues.simulation_ue_id)

Line 2527: AND NOT EXISTS (select 'x' from ahl_workorders wo, ahl_visit_tasks_b tsk

2523: AND UE.APPLICATION_USG_CODE = 'AHL'
2524: AND UE.Object_type = 'SR'-- Deb: When object type is SR then mr_header_id is null. In that case all mr dependent cursor is going to fail
2525: AND (UE.status_code IS NULL OR UE.status_code = 'INIT-DUE')
2526: AND UE.due_date IS NOT NULL
2527: AND NOT EXISTS (select 'x' from ahl_workorders wo, ahl_visit_tasks_b tsk
2528: where wo.visit_task_id = tsk.visit_task_id
2529: and tsk.task_type_code = 'SUMMARY'
2530: and tsk.status_code NOT IN ('DELETED','CANCELLED')
2531: and tsk.unit_effectivity_id = UE.unit_effectivity_id)

Line 2569: AND NOT EXISTS (select 'x' from ahl_workorders wo, ahl_visit_tasks_b tsk

2565: --AND UE.APPLICATION_USG_CODE = 'AHL'
2566: AND UES.cs_incident_id IS NOT NULL-- Deb: When object type is SR them mr_header_id is null. In that case all mr dependent cursor is going to fail
2567: AND (UES.status_code IS NULL OR UES.status_code = 'INIT-DUE')
2568: AND UES.due_date IS NOT NULL
2569: AND NOT EXISTS (select 'x' from ahl_workorders wo, ahl_visit_tasks_b tsk
2570: where wo.visit_task_id = tsk.visit_task_id
2571: and tsk.task_type_code = 'SUMMARY'
2572: and tsk.status_code NOT IN ('DELETED','CANCELLED')
2573: and tsk.unit_effectivity_id = ues.simulation_ue_id)