DBA Data[Home] [Help]

APPS.AHL_PRD_WORKORDER_PVT dependencies on AHL_UE_RELATIONSHIPS

Line 2536: AHL_UE_RELATIONSHIPS UER

2532: UE.cs_incident_id IS NOT NULL AND
2533: NOT EXISTS (SELECT
2534: 'X'
2535: FROM
2536: AHL_UE_RELATIONSHIPS UER
2537: WHERE
2538: UER.related_ue_id = UE.Unit_effectivity_id OR
2539: UER.ue_id = UE.Unit_effectivity_id) AND
2540: CSIA.incident_id = UE.cs_incident_id AND

Line 6084: AHL_UE_RELATIONSHIPS REL

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
6088: -- As per the update in the bug, for Manually planned UEs of type SR