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_WORKORDER_PVT dependencies on AHL_UNIT_EFFECTIVITIES_B

Line 2525: AHL_UNIT_EFFECTIVITIES_B UE,

2521: CSIA.summary, -- sr summary
2522: CSIT.name -- sr type attribute
2523: FROM
2524: AHL_VISIT_TASKS_B VTSK,
2525: AHL_UNIT_EFFECTIVITIES_B UE,
2526: CS_INCIDENTS_ALL CSIA,
2527: CS_INCIDENT_TYPES_VL CSIT
2528: WHERE
2529: VTSK.visit_task_id = p_visit_task_id AND

Line 2855: ahl_unit_effectivities_b aue

2851: SELECT
2852: 'X'
2853: FROM
2854: ahl_visit_tasks_b vtsk,
2855: ahl_unit_effectivities_b aue
2856: WHERE
2857: nvl(aue.manually_planned_flag, 'N') = 'N' AND
2858: vtsk.unit_effectivity_id = aue.unit_effectivity_id AND
2859: vtsk.status_code <> 'DELETED' AND

Line 3490: ahl_unit_effectivities_b aue

3486: SELECT
3487: 'X'
3488: FROM
3489: ahl_visit_tasks_b vtsk,
3490: ahl_unit_effectivities_b aue
3491: WHERE
3492: nvl(aue.manually_planned_flag, 'N') = 'N' AND
3493: vtsk.unit_effectivity_id = aue.unit_effectivity_id AND
3494: vtsk.status_code <> 'DELETED' AND

Line 6036: FROM AHL_UNIT_EFFECTIVITIES_B UE,

6032: /*
6033: CURSOR get_visit_mrs( c_visit_id NUMBER ) IS
6034: SELECT UE.unit_effectivity_id unit_effectivity_id,
6035: UE.object_version_number object_version_number
6036: FROM AHL_UNIT_EFFECTIVITIES_B UE,
6037: AHL_VISIT_TASKS_B VT
6038: WHERE UE.unit_effectivity_id = VT.unit_effectivity_id
6039: AND UE.manually_planned_flag = 'Y'
6040: -- Check added by balaji by balaji for bug # 4095002

Line 6053: FROM AHL_UNIT_EFFECTIVITIES_B UE

6049:
6050: -- To Get the Unplanned UE Details
6051: CURSOR get_ue_details( c_unit_effectivity_id NUMBER ) IS
6052: SELECT UE.object_version_number object_version_number
6053: FROM AHL_UNIT_EFFECTIVITIES_B UE
6054: WHERE UE.unit_effectivity_id = c_unit_effectivity_id
6055: AND UE.manually_planned_flag = 'Y'
6056: -- Check added by balaji by balaji for bug # 4095002
6057: -- As per the update in the bug, for Manually planned UEs of type SR

Line 6066: FROM AHL_UNIT_EFFECTIVITIES_B UE,

6062: -- To get the UnPlanned UE for a given WO
6063: CURSOR get_ue_details_for_wo( c_workorder_id NUMBER ) IS
6064: SELECT UE.unit_effectivity_id unit_effectivity_id,
6065: UE.object_version_number object_version_number
6066: FROM AHL_UNIT_EFFECTIVITIES_B UE,
6067: AHL_VISIT_TASKS_B VT,
6068: AHL_WORKORDERS WO
6069: WHERE UE.unit_effectivity_id = VT.unit_effectivity_id
6070: AND UE.manually_planned_flag = 'Y'

Line 6083: FROM AHL_UNIT_EFFECTIVITIES_B UE,

6079: -- To get all the Parent UnPlanned UEs for a given UE
6080: CURSOR get_parent_ues( c_unit_effectivity_id NUMBER ) IS
6081: SELECT UE.unit_effectivity_id unit_effectivity_id,
6082: UE.object_version_number object_version_number
6083: FROM AHL_UNIT_EFFECTIVITIES_B UE,
6084: AHL_UE_RELATIONSHIPS REL
6085: WHERE UE.unit_effectivity_id = REL.ue_id
6086: AND UE.manually_planned_flag = 'Y'
6087: -- Check added by balaji by balaji for bug # 4095002