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_UNIT_EFFECTIVITIES_B

Line 280: AHL_UNIT_EFFECTIVITIES_B UE

276: CSI.lot_number,
277: CSI.serial_number,
278: CSI.quantity
279: FROM AHL_VISITS_B VST, AHL_VISIT_TASKS_B VTS, CSI_ITEM_INSTANCES CSI,
280: AHL_UNIT_EFFECTIVITIES_B UE
281: WHERE VTS.unit_effectivity_id = UE.unit_effectivity_id
282: AND NVL(VTS.instance_id, VST.item_instance_id) = CSI.instance_id
283: AND VST.visit_id = VTS.visit_id
284: AND VTS.visit_task_id = c_visit_task_id;

Line 2006: FROM AHL_UNIT_EFFECTIVITIES_B

2002: IS
2003: SELECT mr_header_id,
2004: unit_effectivity_id,
2005: status_code
2006: FROM AHL_UNIT_EFFECTIVITIES_B
2007: WHERE unit_effectivity_id IN
2008: (
2009: SELECT related_ue_id
2010: FROM AHL_UE_RELATIONSHIPS

Line 2024: FROM AHL_UNIT_EFFECTIVITIES_B UE, (

2020: IS
2021: SELECT mr_header_id,
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'

Line 3231: FROM AHL_UNIT_EFFECTIVITIES_B UE,(

3227: );*/
3228: CURSOR Check_child_exists (c_unit_effectivity_id IN NUMBER)
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'

Line 4072: AHL_UNIT_EFFECTIVITIES_B UE,

4068: IS
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

Line 5953: FROM AHL_UNIT_EFFECTIVITIES_B UE,(SELECT related_ue_id

5949: status_code ump_status_code,
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

Line 8225: FROM AHL_UNIT_EFFECTIVITIES_B UE,

8221: UE.status_code ump_status_code,
8222: 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,
8223: -1 qa_plan_id,
8224: UE.qa_collection_id qa_collection_id
8225: FROM AHL_UNIT_EFFECTIVITIES_B UE,
8226: AHL_VISIT_TASKS_B VT,
8227: ahl_workorders awo
8228: WHERE UE.unit_effectivity_id = VT.unit_effectivity_id
8229: AND ( (VT.task_type_code = 'SUMMARY')

Line 8289: FROM AHL_UNIT_EFFECTIVITIES_B UE,(SELECT related_ue_id

8285: status_code ump_status_code,
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

Line 10364: AHL_UNIT_EFFECTIVITIES_B UE

10360: WO.wip_entity_id wip_entity_id
10361: FROM AHL_WORKORDERS WO,
10362: AHL_VISIT_TASKS_B VT,
10363: --AHL_UE_DEFERRAL_DETAILS_V UE
10364: AHL_UNIT_EFFECTIVITIES_B UE
10365: WHERE WO.visit_task_id = VT.visit_task_id
10366: AND VT.task_type_code IN ( 'SUMMARY' , 'UNASSOCIATED' )
10367: AND VT.unit_effectivity_id = UE.unit_effectivity_id
10368: AND UE.unit_effectivity_id = c_unit_effectivity_id;

Line 11753: from ahl_unit_effectivities_b UE--, FND_LOOKUP_VALUES_VL FL

11749: UE.cs_incident_id,
11750: --FL.Lookup_code,
11751: --FL.Meaning,
11752: UE.qa_collection_id
11753: from ahl_unit_effectivities_b UE--, FND_LOOKUP_VALUES_VL FL
11754: where --FL.Lookup_type = 'AHL_PRD_MR_STATUS'
11755: --AND FL.Lookup_code = AHL_COMPLETIONS_PVT.get_mr_status( p_unit_effectivity_id ) AND
11756: UE.unit_effectivity_id = p_unit_effectivity_id
11757: AND UE.object_version_number = p_ue_object_version_no;

Line 12620: AHL_UNIT_EFFECTIVITIES_B UE, AHL_VISIT_TASKS_B VT, ahl_workorders awo

12616: CURSOR c_get_unit_name_visit( c_visit_id NUMBER ) IS
12617: SELECT
12618: distinct ahl_util_uc_pkg.get_unit_name(UE.csi_item_instance_id) unit_name
12619: FROM
12620: AHL_UNIT_EFFECTIVITIES_B UE, AHL_VISIT_TASKS_B VT, ahl_workorders awo
12621: WHERE
12622: UE.unit_effectivity_id = VT.unit_effectivity_id
12623: AND ( (VT.task_type_code = 'SUMMARY') OR (TASK_TYPE_CODE = 'UNASSOCIATED' ) )
12624: AND vt.visit_task_id = awo.visit_task_id