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_FMP_PVT dependencies on AHL_MR_EFFECTIVITY_DTLS

Line 1605: --(SELECT 'Y' from ahl_mr_effectivity_dtls where mr_effectivity_id = a.mr_effectivity_id and ROWNUM < 2) eff_dtls_flag

1601: (SELECT to_date(ciea1.attribute_value, 'DD/MM/YYYY') from csi_inst_extend_attrib_v ciea1
1602: WHERE ciea1.instance_id = ii.instance_id AND ciea1.attribute_code = 'AHL_MFG_DATE'
1603: AND ciea1.attribute_level = 'GLOBAL') mfg_date,
1604: ii.serial_number --,
1605: --(SELECT 'Y' from ahl_mr_effectivity_dtls where mr_effectivity_id = a.mr_effectivity_id and ROWNUM < 2) eff_dtls_flag
1606: FROM ( SELECT a.subject_id
1607: --FROM csi_ii_relationships a
1608: FROM ahl_config_components a
1609: START WITH object_id = c_instance_id

Line 1691: --(SELECT 'Y' from ahl_mr_effectivity_dtls where mr_effectivity_id = a.mr_effectivity_id and ROWNUM < 2) eff_dtls_flag

1687: (SELECT to_date(ciea1.attribute_value, 'DD/MM/YYYY') from csi_inst_extend_attrib_v ciea1
1688: WHERE ciea1.instance_id = ii.instance_id AND ciea1.attribute_code = 'AHL_MFG_DATE'
1689: AND ciea1.attribute_level = 'GLOBAL') mfg_date,
1690: ii.serial_number --,
1691: --(SELECT 'Y' from ahl_mr_effectivity_dtls where mr_effectivity_id = a.mr_effectivity_id and ROWNUM < 2) eff_dtls_flag
1692: FROM csi_item_instances ii,
1693: ahl_mr_effectivities A, ahl_mr_headers_b MR
1694: WHERE ii.instance_id = c_instance_id
1695: --AND A.mr_header_id = NVL(c_mr_header_id, A.mr_header_id)

Line 1763: --(SELECT 'Y' from ahl_mr_effectivity_dtls where mr_effectivity_id = a.mr_effectivity_id and ROWNUM < 2) eff_dtls_flag

1759: (SELECT to_date(ciea1.attribute_value, 'DD/MM/YYYY') from csi_inst_extend_attrib_v ciea1
1760: WHERE ciea1.instance_id = cii.instance_id AND ciea1.attribute_code = 'AHL_MFG_DATE'
1761: AND ciea1.attribute_level = 'GLOBAL') mfg_date,
1762: cii.serial_number --,
1763: --(SELECT 'Y' from ahl_mr_effectivity_dtls where mr_effectivity_id = a.mr_effectivity_id and ROWNUM < 2) eff_dtls_flag
1764: FROM ahl_applicable_instances aai,csi_item_instances cii,
1765: ahl_mr_effectivities A
1766: WHERE
1767: --A.mr_header_id = NVL(c_mr_header_id, A.mr_header_id)

Line 1801: --(SELECT 'Y' from ahl_mr_effectivity_dtls where mr_effectivity_id = a.mr_effectivity_id and ROWNUM < 2) eff_dtls_flag

1797: (SELECT to_date(ciea1.attribute_value, 'DD/MM/YYYY') from csi_inst_extend_attrib_v ciea1
1798: WHERE ciea1.instance_id = cii.instance_id AND ciea1.attribute_code = 'AHL_MFG_DATE'
1799: AND ciea1.attribute_level = 'GLOBAL') mfg_date,
1800: cii.serial_number --,
1801: --(SELECT 'Y' from ahl_mr_effectivity_dtls where mr_effectivity_id = a.mr_effectivity_id and ROWNUM < 2) eff_dtls_flag
1802: FROM ahl_applicable_instances aai,csi_item_instances cii,
1803: ahl_mr_effectivities A
1804: WHERE A.mr_header_id = c_mr_header_id
1805: AND A.relationship_id IS NOT NULL

Line 1946: --(SELECT 'Y' from ahl_mr_effectivity_dtls where mr_effectivity_id = a.mr_effectivity_id and ROWNUM < 2) eff_dtls_flag

1942: (SELECT to_date(ciea1.attribute_value, 'DD/MM/YYYY') from csi_inst_extend_attrib_v ciea1
1943: WHERE ciea1.instance_id = cii.instance_id AND ciea1.attribute_code = 'AHL_MFG_DATE'
1944: AND ciea1.attribute_level = 'GLOBAL') mfg_date,
1945: cii.serial_number --,
1946: --(SELECT 'Y' from ahl_mr_effectivity_dtls where mr_effectivity_id = a.mr_effectivity_id and ROWNUM < 2) eff_dtls_flag
1947: FROM ( SELECT a.subject_id
1948: --FROM csi_ii_relationships a
1949: FROM ahl_config_components a
1950: START WITH object_id = c_instance_id

Line 1991: --(SELECT 'Y' from ahl_mr_effectivity_dtls where mr_effectivity_id = a.mr_effectivity_id and ROWNUM < 2) eff_dtls_flag

1987: (SELECT to_date(ciea1.attribute_value, 'DD/MM/YYYY') from csi_inst_extend_attrib_v ciea1
1988: WHERE cii.instance_id = ciea1.instance_id(+) AND ciea1.attribute_code(+) = 'AHL_MFG_DATE'
1989: AND ciea1.attribute_level(+) = 'GLOBAL') mfg_date,
1990: cii.serial_number --,
1991: --(SELECT 'Y' from ahl_mr_effectivity_dtls where mr_effectivity_id = a.mr_effectivity_id and ROWNUM < 2) eff_dtls_flag
1992: FROM csi_item_instances cii,ahl_mr_visit_types vis,
1993: ahl_mr_effectivities A
1994: WHERE A.mr_header_id = vis.mr_header_id
1995: AND vis.mr_visit_type_code = c_visit_type_code

Line 2024: --(SELECT 'Y' from ahl_mr_effectivity_dtls where mr_effectivity_id = a.mr_effectivity_id and ROWNUM < 2) eff_dtls_flag

2020: (SELECT to_date(ciea1.attribute_value, 'DD/MM/YYYY') from csi_inst_extend_attrib_v ciea1
2021: WHERE ciea1.instance_id = cii.instance_id AND ciea1.attribute_code = 'AHL_MFG_DATE'
2022: AND ciea1.attribute_level = 'GLOBAL') mfg_date,
2023: cii.serial_number --,
2024: --(SELECT 'Y' from ahl_mr_effectivity_dtls where mr_effectivity_id = a.mr_effectivity_id and ROWNUM < 2) eff_dtls_flag
2025: FROM ahl_applicable_instances aai,csi_item_instances cii,ahl_mr_visit_types vis,
2026: ahl_mr_effectivities A
2027: WHERE A.mr_header_id = vis.mr_header_id
2028: AND vis.mr_visit_type_code = c_visit_type_code

Line 2125: FROM ahl_mr_effectivity_dtls

2121: */
2122: CURSOR get_effect_details(c_mr_effectivity_id NUMBER) IS
2123: SELECT exclude_flag, serial_number_from, serial_number_to, manufacturer_id,
2124: manufacture_date_from, manufacture_date_to, country_code
2125: FROM ahl_mr_effectivity_dtls
2126: WHERE mr_effectivity_id = c_mr_effectivity_id
2127: ORDER BY exclude_flag ASC;
2128:
2129: -- added for perf fix 9434441

Line 3424: FROM ahl_mr_effectivity_dtls -- perf bug 6266738

3420: ) RETURN BOOLEAN IS
3421: CURSOR get_effect_detail(c_mr_effectivity_id NUMBER) IS
3422: SELECT exclude_flag, serial_number_from, serial_number_to, manufacturer_id,
3423: manufacture_date_from, manufacture_date_to, country_code
3424: FROM ahl_mr_effectivity_dtls -- perf bug 6266738
3425: WHERE mr_effectivity_id = c_mr_effectivity_id
3426: ORDER BY exclude_flag ASC;
3427:
3428: --amsriniv

Line 4699: FROM ahl_mr_effectivity_dtls

4695: */
4696: CURSOR get_effect_details(c_mr_effectivity_id NUMBER) IS
4697: SELECT exclude_flag, serial_number_from, serial_number_to, manufacturer_id,
4698: manufacture_date_from, manufacture_date_to, country_code
4699: FROM ahl_mr_effectivity_dtls
4700: WHERE mr_effectivity_id = c_mr_effectivity_id
4701: ORDER BY exclude_flag ASC;
4702:
4703: -- added for perf fix 9434441