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_COMPLETIONS_PVT dependencies on AHL_UE_RELATIONSHIPS

Line 2010: FROM AHL_UE_RELATIONSHIPS

2006: FROM AHL_UNIT_EFFECTIVITIES_B
2007: WHERE unit_effectivity_id IN
2008: (
2009: SELECT related_ue_id
2010: FROM AHL_UE_RELATIONSHIPS
2011: WHERE unit_effectivity_id = related_ue_id
2012: START WITH ue_id = c_unit_effectivity_id
2013: AND relationship_code = 'PARENT'
2014: CONNECT BY ue_id = PRIOR related_ue_id

Line 2026: FROM AHL_UE_RELATIONSHIPS

2022: unit_effectivity_id,
2023: status_code
2024: FROM AHL_UNIT_EFFECTIVITIES_B UE, (
2025: SELECT related_ue_id
2026: FROM AHL_UE_RELATIONSHIPS
2027: START WITH ue_id = c_unit_effectivity_id
2028: AND relationship_code = 'PARENT'
2029: CONNECT BY ue_id = PRIOR related_ue_id
2030: AND relationship_code = 'PARENT'

Line 3221: FROM AHL_UE_RELATIONSHIPS

3217: FROM AHL_UE_DEFERRAL_DETAILS_V
3218: WHERE unit_effectivity_id IN
3219: (
3220: SELECT related_ue_id
3221: FROM AHL_UE_RELATIONSHIPS
3222: WHERE unit_effectivity_id = related_ue_id
3223: START WITH ue_id = c_unit_effectivity_id
3224: AND relationship_code = 'PARENT'
3225: CONNECT BY ue_id = PRIOR related_ue_id

Line 3233: FROM AHL_UE_RELATIONSHIPS

3229: IS
3230: SELECT 1
3231: FROM AHL_UNIT_EFFECTIVITIES_B UE,(
3232: SELECT related_ue_id
3233: FROM AHL_UE_RELATIONSHIPS
3234: START WITH ue_id = c_unit_effectivity_id
3235: AND relationship_code = 'PARENT'
3236: CONNECT BY ue_id = PRIOR related_ue_id
3237: AND relationship_code = 'PARENT'

Line 4073: AHL_UE_RELATIONSHIPS REL

4069: SELECT UE.unit_effectivity_id unit_effectivity_id,
4070: UE.object_version_number ue_object_version_number
4071: FROM AHL_MR_HEADERS_B MR,
4072: AHL_UNIT_EFFECTIVITIES_B UE,
4073: AHL_UE_RELATIONSHIPS REL
4074: WHERE MR.mr_header_id = UE.mr_header_id
4075: AND MR.auto_signoff_flag = 'Y'
4076: AND UE.unit_effectivity_id = REL.ue_id
4077: AND REL.related_ue_id = c_unit_effectivity_id

Line 4646: from ahl_ue_relationships

4642: where CWO.visit_task_id = vst.visit_task_id
4643: AND CWO.master_workorder_flag = 'N'
4644: AND CWO.status_code IN (p_status_code)
4645: AND vst.unit_effectivity_id IN (select related_ue_id
4646: from ahl_ue_relationships
4647: start with ue_id = c_unit_effectivity_id
4648: AND relationship_code = 'PARENT'
4649: connect by prior related_ue_id = ue_id
4650: AND relationship_code = 'PARENT'

Line 4665: from ahl_ue_relationships

4661: AND CWO.master_workorder_flag = 'N'
4662: AND CWO.status_code IN (G_JOB_STATUS_PARTS_HOLD, G_JOB_STATUS_ON_HOLD,
4663: G_JOB_STATUS_DEFERRAL_PENDING)
4664: AND vst.unit_effectivity_id IN (select related_ue_id
4665: from ahl_ue_relationships
4666: start with ue_id = c_unit_effectivity_id
4667: AND relationship_code = 'PARENT'
4668: connect by prior related_ue_id = ue_id
4669: AND relationship_code = 'PARENT'

Line 4685: from ahl_ue_relationships

4681: AND CWO.master_workorder_flag = 'N'
4682: AND CWO.status_code IN (G_JOB_STATUS_CLOSED, G_JOB_STATUS_COMPLETE_NC, G_JOB_STATUS_COMPLETE)
4683: AND WIPJ.date_completed IS NOT NULL
4684: AND vst.unit_effectivity_id IN (select related_ue_id
4685: from ahl_ue_relationships
4686: start with ue_id = c_unit_effectivity_id
4687: AND relationship_code = 'PARENT'
4688: connect by prior related_ue_id = ue_id
4689: AND relationship_code = 'PARENT'

Line 4706: from ahl_ue_relationships

4702: AND CWO.master_workorder_flag = 'N'
4703: AND CWO.status_code IN (G_JOB_STATUS_CLOSED, G_JOB_STATUS_CANCELLED)
4704: AND WIPJ.date_completed IS NULL
4705: AND vst.unit_effectivity_id IN (select related_ue_id
4706: from ahl_ue_relationships
4707: start with ue_id = c_unit_effectivity_id
4708: AND relationship_code = 'PARENT'
4709: connect by prior related_ue_id = ue_id
4710: AND relationship_code = 'PARENT'

Line 5935: FROM AHL_UE_RELATIONSHIPS

5931: FROM AHL_UE_DEFERRAL_DETAILS_V
5932: WHERE unit_effectivity_id IN
5933: (
5934: SELECT related_ue_id
5935: FROM AHL_UE_RELATIONSHIPS
5936: WHERE unit_effectivity_id = related_ue_id
5937: START WITH ue_id = c_unit_effectivity_id
5938: AND relationship_code = 'PARENT'
5939: CONNECT BY ue_id = PRIOR related_ue_id

Line 5954: FROM AHL_UE_RELATIONSHIPS

5950: 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,
5951: -1 qa_plan_id,
5952: qa_collection_id
5953: FROM AHL_UNIT_EFFECTIVITIES_B UE,(SELECT related_ue_id
5954: FROM AHL_UE_RELATIONSHIPS
5955: START WITH ue_id = c_unit_effectivity_id
5956: AND relationship_code = 'PARENT'
5957: CONNECT BY ue_id = PRIOR related_ue_id
5958: AND relationship_code = 'PARENT') CH

Line 8271: FROM AHL_UE_RELATIONSHIPS

8267: FROM AHL_UE_DEFERRAL_DETAILS_V
8268: WHERE unit_effectivity_id IN
8269: (
8270: SELECT related_ue_id
8271: FROM AHL_UE_RELATIONSHIPS
8272: WHERE unit_effectivity_id = related_ue_id
8273: START WITH ue_id = c_unit_effectivity_id
8274: AND relationship_code = 'PARENT'
8275: CONNECT BY ue_id = PRIOR related_ue_id

Line 8290: FROM AHL_UE_RELATIONSHIPS

8286: 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,
8287: -1 qa_plan_id,
8288: qa_collection_id
8289: FROM AHL_UNIT_EFFECTIVITIES_B UE,(SELECT related_ue_id
8290: FROM AHL_UE_RELATIONSHIPS
8291: START WITH ue_id = c_unit_effectivity_id
8292: AND relationship_code = 'PARENT'
8293: CONNECT BY ue_id = PRIOR related_ue_id
8294: AND relationship_code = 'PARENT') CH

Line 10383: FROM AHL_UE_RELATIONSHIPS

10379: FROM AHL_UE_DEFERRAL_DETAILS_V
10380: WHERE unit_effectivity_id IN
10381: (
10382: SELECT related_ue_id
10383: FROM AHL_UE_RELATIONSHIPS
10384: WHERE unit_effectivity_id = related_ue_id
10385: START WITH ue_id = c_unit_effectivity_id
10386: AND relationship_code = 'PARENT'
10387: CONNECT BY ue_id = PRIOR related_ue_id