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 4071: FROM AHL_MR_HEADERS_B MR,

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

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

5869: CURSOR get_ue_details( c_unit_effectivity_id NUMBER ) IS
5870: SELECT UE.unit_effectivity_id unit_effectivity_id,
5871: DECODE( UE.Mr_header_id, null,
5872: (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),
5873: (select title from AHL_MR_HEADERS_B MR where MR.mr_header_id = UE.mr_header_id )) ue_title,
5874: UE.object_version_number ue_object_version_number,
5875: UE.status_code ue_status_code,
5876: --UE.qa_inspection_type_code ue_qa_inspection_type_code,
5877: 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 5877: 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,

5873: (select title from AHL_MR_HEADERS_B MR where MR.mr_header_id = UE.mr_header_id )) ue_title,
5874: UE.object_version_number ue_object_version_number,
5875: UE.status_code ue_status_code,
5876: --UE.qa_inspection_type_code ue_qa_inspection_type_code,
5877: 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,
5878: -1 ue_qa_plan_id,
5879: UE.qa_collection_id ue_qa_collection_id,
5880: WO.workorder_id workorder_id,
5881: WIP.organization_id,

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

5944: SELECT unit_effectivity_id,
5945: object_version_number,
5946: DECODE( UE.Mr_header_id, null,
5947: (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),
5948: (select title from AHL_MR_HEADERS_B MR where MR.mr_header_id = UE.mr_header_id )) title,
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

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

5946: DECODE( UE.Mr_header_id, null,
5947: (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),
5948: (select title from AHL_MR_HEADERS_B MR where MR.mr_header_id = UE.mr_header_id )) title,
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

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

8215: CURSOR get_visit_ue_details( c_visit_id NUMBER ) IS
8216: SELECT UE.unit_effectivity_id unit_effectivity_id,
8217: DECODE( UE.Mr_header_id, null,
8218: (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),
8219: (select title from AHL_MR_HEADERS_B MR where MR.mr_header_id = UE.mr_header_id )) title,
8220: UE.object_version_number object_version_number,
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,

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

8218: (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),
8219: (select title from AHL_MR_HEADERS_B MR where MR.mr_header_id = UE.mr_header_id )) title,
8220: UE.object_version_number object_version_number,
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,

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

8280: SELECT unit_effectivity_id,
8281: object_version_number,
8282: DECODE( UE.Mr_header_id, null,
8283: (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),
8284: (select title from AHL_MR_HEADERS_B MR where MR.mr_header_id = UE.mr_header_id )) title,
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

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

8282: DECODE( UE.Mr_header_id, null,
8283: (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),
8284: (select title from AHL_MR_HEADERS_B MR where MR.mr_header_id = UE.mr_header_id )) title,
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

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

11761: Where FL.Lookup_type = 'AHL_PRD_MR_STATUS'
11762: AND FL.Lookup_code = p_status_code;
11763:
11764: CURSOR fmp_mr_csr (p_mr_header_id IN NUMBER )
11765: IS select title, QA_INSPECTION_TYPE from AHL_MR_HEADERS_B MR where MR.mr_header_id = p_mr_header_id;
11766:
11767: CURSOR sr_csr (p_cs_incident_id IN NUMBER )
11768: IS select cit.name || '-' || cs.incident_number
11769: from cs_incidents_all_vl cs, cs_incident_types_vl cit