DBA Data[Home] [Help]

APPS.AHL_PRD_WORKORDER_PVT dependencies on AHL_UE_RELATIONSHIPS

Line 3333: AHL_UE_RELATIONSHIPS UER

3329: UE.cs_incident_id IS NOT NULL AND
3330: NOT EXISTS (SELECT
3331: 'X'
3332: FROM
3333: AHL_UE_RELATIONSHIPS UER
3334: WHERE
3335: UER.related_ue_id = UE.Unit_effectivity_id OR
3336: UER.ue_id = UE.Unit_effectivity_id) AND
3337: CSIA.incident_id = UE.cs_incident_id AND

Line 8514: AHL_UE_RELATIONSHIPS REL

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