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_MR_HEADERS_B

Line 3958: FROM AHL_MR_HEADERS_B MR,

3954: CURSOR get_parent_mrs( c_unit_effectivity_id NUMBER )
3955: IS
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'

Line 5591: (select title from AHL_MR_HEADERS_B MR where MR.mr_header_id = UE.mr_header_id )) ue_title,

5587: CURSOR get_ue_details( c_unit_effectivity_id NUMBER ) IS
5588: SELECT UE.unit_effectivity_id unit_effectivity_id,
5589: DECODE( UE.Mr_header_id, null,
5590: (select cit.name || '-' || cs.incident_number from cs_incidents_all_vl cs, cs_incident_types_vl cit WHERE cs.incident_type_id = cit.incident_type_id AND cs.incident_id = UE.Cs_Incident_id),
5591: (select title from AHL_MR_HEADERS_B MR where MR.mr_header_id = UE.mr_header_id )) ue_title,
5592: UE.object_version_number ue_object_version_number,
5593: UE.status_code ue_status_code,
5594: --UE.qa_inspection_type_code ue_qa_inspection_type_code,
5595: 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 )) ue_qa_inspection_type_code,

Line 5595: 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 )) ue_qa_inspection_type_code,

5591: (select title from AHL_MR_HEADERS_B MR where MR.mr_header_id = UE.mr_header_id )) ue_title,
5592: UE.object_version_number ue_object_version_number,
5593: UE.status_code ue_status_code,
5594: --UE.qa_inspection_type_code ue_qa_inspection_type_code,
5595: 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 )) ue_qa_inspection_type_code,
5596: -1 ue_qa_plan_id,
5597: UE.qa_collection_id ue_qa_collection_id,
5598: WO.workorder_id workorder_id,
5599: WIP.organization_id,

Line 5666: (select title from AHL_MR_HEADERS_B MR where MR.mr_header_id = UE.mr_header_id )) title,

5662: SELECT unit_effectivity_id,
5663: object_version_number,
5664: DECODE( UE.Mr_header_id, null,
5665: (select cit.name || '-' || cs.incident_number from cs_incidents_all_vl cs, cs_incident_types_vl cit WHERE cs.incident_type_id = cit.incident_type_id AND cs.incident_id = UE.Cs_Incident_id),
5666: (select title from AHL_MR_HEADERS_B MR where MR.mr_header_id = UE.mr_header_id )) title,
5667: status_code ump_status_code,
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

Line 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,

5664: DECODE( UE.Mr_header_id, null,
5665: (select cit.name || '-' || cs.incident_number from cs_incidents_all_vl cs, cs_incident_types_vl cit WHERE cs.incident_type_id = cit.incident_type_id AND cs.incident_id = UE.Cs_Incident_id),
5666: (select title from AHL_MR_HEADERS_B MR where MR.mr_header_id = UE.mr_header_id )) title,
5667: status_code ump_status_code,
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

Line 7813: (select title from AHL_MR_HEADERS_B MR where MR.mr_header_id = UE.mr_header_id )) title,

7809: CURSOR get_visit_ue_details( c_visit_id NUMBER ) IS
7810: SELECT UE.unit_effectivity_id unit_effectivity_id,
7811: DECODE( UE.Mr_header_id, null,
7812: (select cit.name || '-' || cs.incident_number from cs_incidents_all_vl cs, cs_incident_types_vl cit WHERE cs.incident_type_id = cit.incident_type_id AND cs.incident_id = UE.Cs_Incident_id),
7813: (select title from AHL_MR_HEADERS_B MR where MR.mr_header_id = UE.mr_header_id )) title,
7814: UE.object_version_number object_version_number,
7815: UE.status_code ump_status_code,
7816: 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,
7817: -1 qa_plan_id,

Line 7816: 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,

7812: (select cit.name || '-' || cs.incident_number from cs_incidents_all_vl cs, cs_incident_types_vl cit WHERE cs.incident_type_id = cit.incident_type_id AND cs.incident_id = UE.Cs_Incident_id),
7813: (select title from AHL_MR_HEADERS_B MR where MR.mr_header_id = UE.mr_header_id )) title,
7814: UE.object_version_number object_version_number,
7815: UE.status_code ump_status_code,
7816: 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,
7817: -1 qa_plan_id,
7818: UE.qa_collection_id qa_collection_id
7819: FROM AHL_UNIT_EFFECTIVITIES_B UE,
7820: AHL_VISIT_TASKS_B VT,

Line 7878: (select title from AHL_MR_HEADERS_B MR where MR.mr_header_id = UE.mr_header_id )) title,

7874: SELECT unit_effectivity_id,
7875: object_version_number,
7876: DECODE( UE.Mr_header_id, null,
7877: (select cit.name || '-' || cs.incident_number from cs_incidents_all_vl cs, cs_incident_types_vl cit WHERE cs.incident_type_id = cit.incident_type_id AND cs.incident_id = UE.Cs_Incident_id),
7878: (select title from AHL_MR_HEADERS_B MR where MR.mr_header_id = UE.mr_header_id )) title,
7879: status_code ump_status_code,
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

Line 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,

7876: DECODE( UE.Mr_header_id, null,
7877: (select cit.name || '-' || cs.incident_number from cs_incidents_all_vl cs, cs_incident_types_vl cit WHERE cs.incident_type_id = cit.incident_type_id AND cs.incident_id = UE.Cs_Incident_id),
7878: (select title from AHL_MR_HEADERS_B MR where MR.mr_header_id = UE.mr_header_id )) title,
7879: status_code ump_status_code,
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

Line 10910: IS select title, QA_INSPECTION_TYPE from AHL_MR_HEADERS_B MR where MR.mr_header_id = p_mr_header_id;

10906: Where FL.Lookup_type = 'AHL_PRD_MR_STATUS'
10907: AND FL.Lookup_code = p_status_code;
10908:
10909: CURSOR fmp_mr_csr (p_mr_header_id IN NUMBER )
10910: IS select title, QA_INSPECTION_TYPE from AHL_MR_HEADERS_B MR where MR.mr_header_id = p_mr_header_id;
10911:
10912: CURSOR sr_csr (p_cs_incident_id IN NUMBER )
10913: IS select cit.name || '-' || cs.incident_number
10914: from cs_incidents_all_vl cs, cs_incident_types_vl cit