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.

[Home] [Help]

APPS.AHL_COMPLETIONS_PVT dependencies on AHL_UE_RELATIONSHIPS

Line 1933: FROM AHL_UE_RELATIONSHIPS

1929: FROM AHL_UNIT_EFFECTIVITIES_B
1930: WHERE unit_effectivity_id IN
1931: (
1932: SELECT related_ue_id
1933: FROM AHL_UE_RELATIONSHIPS
1934: WHERE unit_effectivity_id = related_ue_id
1935: START WITH ue_id = c_unit_effectivity_id
1936: AND relationship_code = 'PARENT'
1937: CONNECT BY ue_id = PRIOR related_ue_id

Line 1949: FROM AHL_UE_RELATIONSHIPS

1945: unit_effectivity_id,
1946: status_code
1947: FROM AHL_UNIT_EFFECTIVITIES_B UE, (
1948: SELECT related_ue_id
1949: FROM AHL_UE_RELATIONSHIPS
1950: START WITH ue_id = c_unit_effectivity_id
1951: AND relationship_code = 'PARENT'
1952: CONNECT BY ue_id = PRIOR related_ue_id
1953: AND relationship_code = 'PARENT'

Line 3108: FROM AHL_UE_RELATIONSHIPS

3104: FROM AHL_UE_DEFERRAL_DETAILS_V
3105: WHERE unit_effectivity_id IN
3106: (
3107: SELECT related_ue_id
3108: FROM AHL_UE_RELATIONSHIPS
3109: WHERE unit_effectivity_id = related_ue_id
3110: START WITH ue_id = c_unit_effectivity_id
3111: AND relationship_code = 'PARENT'
3112: CONNECT BY ue_id = PRIOR related_ue_id

Line 3120: FROM AHL_UE_RELATIONSHIPS

3116: IS
3117: SELECT 1
3118: FROM AHL_UNIT_EFFECTIVITIES_B UE,(
3119: SELECT related_ue_id
3120: FROM AHL_UE_RELATIONSHIPS
3121: START WITH ue_id = c_unit_effectivity_id
3122: AND relationship_code = 'PARENT'
3123: CONNECT BY ue_id = PRIOR related_ue_id
3124: AND relationship_code = 'PARENT'

Line 3960: AHL_UE_RELATIONSHIPS REL

3956: SELECT UE.unit_effectivity_id unit_effectivity_id,
3957: UE.object_version_number ue_object_version_number
3958: FROM AHL_MR_HEADERS_B MR,
3959: AHL_UNIT_EFFECTIVITIES_B UE,
3960: AHL_UE_RELATIONSHIPS REL
3961: WHERE MR.mr_header_id = UE.mr_header_id
3962: AND MR.auto_signoff_flag = 'Y'
3963: AND UE.unit_effectivity_id = REL.ue_id
3964: AND REL.related_ue_id = c_unit_effectivity_id

Line 4530: from ahl_ue_relationships

4526: where CWO.visit_task_id = vst.visit_task_id
4527: AND CWO.master_workorder_flag = 'N'
4528: AND CWO.status_code IN (p_status_code)
4529: AND vst.unit_effectivity_id IN (select related_ue_id
4530: from ahl_ue_relationships
4531: start with ue_id = c_unit_effectivity_id
4532: AND relationship_code = 'PARENT'
4533: connect by prior related_ue_id = ue_id
4534: AND relationship_code = 'PARENT'

Line 4549: from ahl_ue_relationships

4545: AND CWO.master_workorder_flag = 'N'
4546: AND CWO.status_code IN (G_JOB_STATUS_PARTS_HOLD, G_JOB_STATUS_ON_HOLD,
4547: G_JOB_STATUS_DEFERRAL_PENDING)
4548: AND vst.unit_effectivity_id IN (select related_ue_id
4549: from ahl_ue_relationships
4550: start with ue_id = c_unit_effectivity_id
4551: AND relationship_code = 'PARENT'
4552: connect by prior related_ue_id = ue_id
4553: AND relationship_code = 'PARENT'

Line 4569: from ahl_ue_relationships

4565: AND CWO.master_workorder_flag = 'N'
4566: AND CWO.status_code IN (G_JOB_STATUS_CLOSED, G_JOB_STATUS_COMPLETE_NC, G_JOB_STATUS_COMPLETE)
4567: AND WIPJ.date_completed IS NOT NULL
4568: AND vst.unit_effectivity_id IN (select related_ue_id
4569: from ahl_ue_relationships
4570: start with ue_id = c_unit_effectivity_id
4571: AND relationship_code = 'PARENT'
4572: connect by prior related_ue_id = ue_id
4573: AND relationship_code = 'PARENT'

Line 4590: from ahl_ue_relationships

4586: AND CWO.master_workorder_flag = 'N'
4587: AND CWO.status_code IN (G_JOB_STATUS_CLOSED, G_JOB_STATUS_CANCELLED)
4588: AND WIPJ.date_completed IS NULL
4589: AND vst.unit_effectivity_id IN (select related_ue_id
4590: from ahl_ue_relationships
4591: start with ue_id = c_unit_effectivity_id
4592: AND relationship_code = 'PARENT'
4593: connect by prior related_ue_id = ue_id
4594: AND relationship_code = 'PARENT'

Line 5653: FROM AHL_UE_RELATIONSHIPS

5649: FROM AHL_UE_DEFERRAL_DETAILS_V
5650: WHERE unit_effectivity_id IN
5651: (
5652: SELECT related_ue_id
5653: FROM AHL_UE_RELATIONSHIPS
5654: WHERE unit_effectivity_id = related_ue_id
5655: START WITH ue_id = c_unit_effectivity_id
5656: AND relationship_code = 'PARENT'
5657: CONNECT BY ue_id = PRIOR related_ue_id

Line 5672: FROM AHL_UE_RELATIONSHIPS

5668: DECODE( UE.Mr_header_id, null,null,(select QA_INSPECTION_TYPE from AHL_MR_HEADERS_B MR where MR.mr_header_id = UE.mr_header_id )) qa_inspection_type_code,
5669: -1 qa_plan_id,
5670: qa_collection_id
5671: FROM AHL_UNIT_EFFECTIVITIES_B UE,(SELECT related_ue_id
5672: FROM AHL_UE_RELATIONSHIPS
5673: START WITH ue_id = c_unit_effectivity_id
5674: AND relationship_code = 'PARENT'
5675: CONNECT BY ue_id = PRIOR related_ue_id
5676: AND relationship_code = 'PARENT') CH

Line 7865: FROM AHL_UE_RELATIONSHIPS

7861: FROM AHL_UE_DEFERRAL_DETAILS_V
7862: WHERE unit_effectivity_id IN
7863: (
7864: SELECT related_ue_id
7865: FROM AHL_UE_RELATIONSHIPS
7866: WHERE unit_effectivity_id = related_ue_id
7867: START WITH ue_id = c_unit_effectivity_id
7868: AND relationship_code = 'PARENT'
7869: CONNECT BY ue_id = PRIOR related_ue_id

Line 7884: FROM AHL_UE_RELATIONSHIPS

7880: DECODE( UE.Mr_header_id, null,null,(select QA_INSPECTION_TYPE from AHL_MR_HEADERS_B MR where MR.mr_header_id = UE.mr_header_id )) qa_inspection_type_code,
7881: -1 qa_plan_id,
7882: qa_collection_id
7883: FROM AHL_UNIT_EFFECTIVITIES_B UE,(SELECT related_ue_id
7884: FROM AHL_UE_RELATIONSHIPS
7885: START WITH ue_id = c_unit_effectivity_id
7886: AND relationship_code = 'PARENT'
7887: CONNECT BY ue_id = PRIOR related_ue_id
7888: AND relationship_code = 'PARENT') CH

Line 9598: FROM AHL_UE_RELATIONSHIPS

9594: FROM AHL_UE_DEFERRAL_DETAILS_V
9595: WHERE unit_effectivity_id IN
9596: (
9597: SELECT related_ue_id
9598: FROM AHL_UE_RELATIONSHIPS
9599: WHERE unit_effectivity_id = related_ue_id
9600: START WITH ue_id = c_unit_effectivity_id
9601: AND relationship_code = 'PARENT'
9602: CONNECT BY ue_id = PRIOR related_ue_id