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.

[Home] [Help]

APPS.AHL_FMP_PVT dependencies on AHL_MR_EFFECTIVITY_DTLS

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

1336: (SELECT to_date(ciea1.attribute_value, 'DD/MM/YYYY') from csi_inst_extend_attrib_v ciea1
1337: WHERE ciea1.instance_id = ii.instance_id AND ciea1.attribute_code = 'AHL_MFG_DATE'
1338: AND ciea1.attribute_level = 'GLOBAL') mfg_date,
1339: ii.serial_number --,
1340: --(SELECT 'Y' from ahl_mr_effectivity_dtls where mr_effectivity_id = a.mr_effectivity_id and ROWNUM < 2) eff_dtls_flag
1341: FROM ( SELECT a.subject_id
1342: FROM csi_ii_relationships a
1343: START WITH object_id = c_instance_id
1344: AND relationship_type_code = 'COMPONENT-OF'

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

1377: (SELECT to_date(ciea1.attribute_value, 'DD/MM/YYYY') from csi_inst_extend_attrib_v ciea1
1378: WHERE ciea1.instance_id = ii.instance_id AND ciea1.attribute_code = 'AHL_MFG_DATE'
1379: AND ciea1.attribute_level = 'GLOBAL') mfg_date,
1380: ii.serial_number --,
1381: --(SELECT 'Y' from ahl_mr_effectivity_dtls where mr_effectivity_id = a.mr_effectivity_id and ROWNUM < 2) eff_dtls_flag
1382: FROM csi_item_instances ii,
1383: ahl_mr_effectivities A
1384: WHERE ii.instance_id = c_instance_id
1385: AND A.mr_header_id = NVL(c_mr_header_id, A.mr_header_id)

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

1408: (SELECT to_date(ciea1.attribute_value, 'DD/MM/YYYY') from csi_inst_extend_attrib_v ciea1
1409: WHERE ciea1.instance_id = cii.instance_id AND ciea1.attribute_code = 'AHL_MFG_DATE'
1410: AND ciea1.attribute_level = 'GLOBAL') mfg_date,
1411: cii.serial_number --,
1412: --(SELECT 'Y' from ahl_mr_effectivity_dtls where mr_effectivity_id = a.mr_effectivity_id and ROWNUM < 2) eff_dtls_flag
1413: FROM ahl_applicable_instances aai,csi_item_instances cii,
1414: ahl_mr_effectivities A
1415: WHERE A.mr_header_id = NVL(c_mr_header_id, A.mr_header_id)
1416: AND A.relationship_id IS NOT NULL

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

1549: (SELECT to_date(ciea1.attribute_value, 'DD/MM/YYYY') from csi_inst_extend_attrib_v ciea1
1550: WHERE ciea1.instance_id = cii.instance_id AND ciea1.attribute_code = 'AHL_MFG_DATE'
1551: AND ciea1.attribute_level = 'GLOBAL') mfg_date,
1552: cii.serial_number --,
1553: --(SELECT 'Y' from ahl_mr_effectivity_dtls where mr_effectivity_id = a.mr_effectivity_id and ROWNUM < 2) eff_dtls_flag
1554: FROM ( SELECT a.subject_id
1555: FROM csi_ii_relationships a
1556: START WITH object_id = c_instance_id
1557: AND relationship_type_code = 'COMPONENT-OF'

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

1591: (SELECT to_date(ciea1.attribute_value, 'DD/MM/YYYY') from csi_inst_extend_attrib_v ciea1
1592: WHERE cii.instance_id = ciea1.instance_id(+) AND ciea1.attribute_code(+) = 'AHL_MFG_DATE'
1593: AND ciea1.attribute_level(+) = 'GLOBAL') mfg_date,
1594: cii.serial_number --,
1595: --(SELECT 'Y' from ahl_mr_effectivity_dtls where mr_effectivity_id = a.mr_effectivity_id and ROWNUM < 2) eff_dtls_flag
1596: FROM csi_item_instances cii,ahl_mr_visit_types vis,
1597: ahl_mr_effectivities A
1598: WHERE A.mr_header_id = vis.mr_header_id
1599: AND vis.mr_visit_type_code = c_visit_type_code

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

1622: (SELECT to_date(ciea1.attribute_value, 'DD/MM/YYYY') from csi_inst_extend_attrib_v ciea1
1623: WHERE ciea1.instance_id = cii.instance_id AND ciea1.attribute_code = 'AHL_MFG_DATE'
1624: AND ciea1.attribute_level = 'GLOBAL') mfg_date,
1625: cii.serial_number --,
1626: --(SELECT 'Y' from ahl_mr_effectivity_dtls where mr_effectivity_id = a.mr_effectivity_id and ROWNUM < 2) eff_dtls_flag
1627: FROM ahl_applicable_instances aai,csi_item_instances cii,ahl_mr_visit_types vis,
1628: ahl_mr_effectivities A
1629: WHERE A.mr_header_id = vis.mr_header_id
1630: AND vis.mr_visit_type_code = c_visit_type_code

Line 1721: FROM ahl_mr_effectivity_dtls

1717: */
1718: CURSOR get_effect_details(c_mr_effectivity_id NUMBER) IS
1719: SELECT exclude_flag, serial_number_from, serial_number_to, manufacturer_id,
1720: manufacture_date_from, manufacture_date_to, country_code
1721: FROM ahl_mr_effectivity_dtls
1722: WHERE mr_effectivity_id = c_mr_effectivity_id
1723: ORDER BY exclude_flag ASC;
1724:
1725: /* not used

Line 2681: FROM ahl_mr_effectivity_dtls -- perf bug 6266738

2677: ) RETURN BOOLEAN IS
2678: CURSOR get_effect_detail(c_mr_effectivity_id NUMBER) IS
2679: SELECT exclude_flag, serial_number_from, serial_number_to, manufacturer_id,
2680: manufacture_date_from, manufacture_date_to, country_code
2681: FROM ahl_mr_effectivity_dtls -- perf bug 6266738
2682: WHERE mr_effectivity_id = c_mr_effectivity_id
2683: ORDER BY exclude_flag ASC;
2684:
2685: --amsriniv