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 CS_INCIDENT_TYPES_VL

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

5586: --fix for bug number 7295717 (Sunil)
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,

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

5661: CURSOR get_child_ue_details( c_unit_effectivity_id NUMBER ) IS
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,

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

7808: --fix for bug number 7295717 (Sunil)
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,

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

7873: CURSOR get_child_ue_details( c_unit_effectivity_id NUMBER ) IS
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,

Line 10914: from cs_incidents_all_vl cs, cs_incident_types_vl cit

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
10915: WHERE cs.incident_type_id = cit.incident_type_id
10916: AND cs.incident_id = p_cs_incident_id;
10917:
10918: CURSOR visit_task_csr(p_unit_effectivity_id IN NUMBER)IS