APPS.AHL_PRD_WORKORDER_PVT dependencies on AHL_UNIT_EFFECTIVITIES_B

Line 3322: AHL_UNIT_EFFECTIVITIES_B UE,

3318: CSIA.summary, -- sr summary
3319: CSIT.name -- sr type attribute
3320: FROM
3321: AHL_VISIT_TASKS_B VTSK,
3322: AHL_UNIT_EFFECTIVITIES_B UE,
3323: CS_INCIDENTS_ALL CSIA,
3324: CS_INCIDENT_TYPES_VL CSIT
3325: WHERE
3326: VTSK.visit_task_id = p_visit_task_id AND

Line 3764: ahl_unit_effectivities_b aue

3760: SELECT
3761: 'X'
3762: FROM
3763: ahl_visit_tasks_b vtsk,
3764: ahl_unit_effectivities_b aue
3765: WHERE
3766: nvl(aue.manually_planned_flag, 'N') = 'N' AND
3767: vtsk.unit_effectivity_id = aue.unit_effectivity_id AND
3768: vtsk.status_code <> 'DELETED' AND

Line 4610: ahl_unit_effectivities_b aue

4606: SELECT
4607: 'X'
4608: FROM
4609: ahl_visit_tasks_b vtsk,
4610: ahl_unit_effectivities_b aue
4611: WHERE
4612: nvl(aue.manually_planned_flag, 'N') = 'N' AND
4613: vtsk.unit_effectivity_id = aue.unit_effectivity_id AND
4614: vtsk.status_code <> 'DELETED' AND

Line 8466: FROM AHL_UNIT_EFFECTIVITIES_B UE,

8462: /*
8463: CURSOR get_visit_mrs( c_visit_id NUMBER ) IS
8464: SELECT UE.unit_effectivity_id unit_effectivity_id,
8465: UE.object_version_number object_version_number
8466: FROM AHL_UNIT_EFFECTIVITIES_B UE,
8467: AHL_VISIT_TASKS_B VT
8468: WHERE UE.unit_effectivity_id = VT.unit_effectivity_id
8469: AND UE.manually_planned_flag = 'Y'
8470: -- Check added by balaji by balaji for bug # 4095002

Line 8483: FROM AHL_UNIT_EFFECTIVITIES_B UE

8479:
8480: -- To Get the Unplanned UE Details
8481: CURSOR get_ue_details( c_unit_effectivity_id NUMBER ) IS
8482: SELECT UE.object_version_number object_version_number
8483: FROM AHL_UNIT_EFFECTIVITIES_B UE
8484: WHERE UE.unit_effectivity_id = c_unit_effectivity_id
8485: AND UE.manually_planned_flag = 'Y'
8486: -- Check added by balaji by balaji for bug # 4095002
8487: -- As per the update in the bug, for Manually planned UEs of type SR

Line 8496: FROM AHL_UNIT_EFFECTIVITIES_B UE,

8492: -- To get the UnPlanned UE for a given WO
8493: CURSOR get_ue_details_for_wo( c_workorder_id NUMBER ) IS
8494: SELECT UE.unit_effectivity_id unit_effectivity_id,
8495: UE.object_version_number object_version_number
8496: FROM AHL_UNIT_EFFECTIVITIES_B UE,
8497: AHL_VISIT_TASKS_B VT,
8498: AHL_WORKORDERS WO
8499: WHERE UE.unit_effectivity_id = VT.unit_effectivity_id
8500: AND UE.manually_planned_flag = 'Y'

Line 8513: FROM AHL_UNIT_EFFECTIVITIES_B UE,

8509: -- To get all the Parent UnPlanned UEs for a given UE
8510: CURSOR get_parent_ues( c_unit_effectivity_id NUMBER ) IS
8511: SELECT UE.unit_effectivity_id unit_effectivity_id,
8512: UE.object_version_number object_version_number
8513: FROM AHL_UNIT_EFFECTIVITIES_B UE,
8514: AHL_UE_RELATIONSHIPS REL
8515: WHERE UE.unit_effectivity_id = REL.ue_id
8516: AND UE.manually_planned_flag = 'Y'
8517: -- Check added by balaji by balaji for bug # 4095002

Line 12354: FROM ahl_visit_tasks_b vtsk, ahl_unit_effectivities_b ue

12350: vtsk.unit_effectivity_id,
12351: DECODE(ue.defer_from_ue_id, NULL,
12352: decode(vtsk.service_request_id, NULL, decode(vtsk.task_type_code,'PLANNED', 'ROUTINE', 'ROUTINE_UNKNOWN'), 'NONROUTINE'),
12353: decode(vtsk.service_request_id, NULL, 'DEFER_ROUTINE','DEFER_NONROUTINE')) maintenance_type_code
12354: FROM ahl_visit_tasks_b vtsk, ahl_unit_effectivities_b ue
12355: WHERE vtsk.unit_effectivity_id = ue.unit_effectivity_id(+)
12356: AND vtsk.visit_task_id = c_visit_task_id;
12357:
12358: CURSOR get_uc_from_visit(c_visit_id NUMBER) IS