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 CSI_INST_EXTEND_ATTRIB_V

Line 1336: (SELECT to_date(ciea1.attribute_value, 'DD/MM/YYYY') from csi_inst_extend_attrib_v ciea1

1332: CURSOR get_comp_mr_inv_csr(c_instance_id NUMBER, c_mr_header_id NUMBER) IS
1333: SELECT A.mr_header_id, A.mr_effectivity_id,
1334: A.pc_node_id,
1335: ii.instance_id subject_id,
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

Line 1377: (SELECT to_date(ciea1.attribute_value, 'DD/MM/YYYY') from csi_inst_extend_attrib_v ciea1

1373: CURSOR get_inst_mr_inv_csr(c_instance_id NUMBER, c_mr_header_id NUMBER) IS
1374: SELECT A.mr_header_id, A.mr_effectivity_id,
1375: A.pc_node_id,
1376: ii.instance_id subject_id,
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

Line 1408: (SELECT to_date(ciea1.attribute_value, 'DD/MM/YYYY') from csi_inst_extend_attrib_v ciea1

1404: CURSOR get_posn_mr_csr(c_mr_header_id NUMBER) IS
1405: SELECT A.mr_header_id, A.mr_effectivity_id,
1406: A.pc_node_id,
1407: cii.instance_id subject_id,
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

Line 1549: (SELECT to_date(ciea1.attribute_value, 'DD/MM/YYYY') from csi_inst_extend_attrib_v ciea1

1545: CURSOR get_comp_vst_inv_csr(c_instance_id NUMBER, c_visit_type_code VARCHAR2) IS
1546: SELECT A.mr_header_id, A.mr_effectivity_id,
1547: A.pc_node_id,
1548: cii.instance_id subject_id,
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

Line 1591: (SELECT to_date(ciea1.attribute_value, 'DD/MM/YYYY') from csi_inst_extend_attrib_v ciea1

1587: CURSOR get_inst_vst_inv_csr(c_instance_id NUMBER, c_visit_type_code VARCHAR2) IS
1588: SELECT A.mr_header_id, A.mr_effectivity_id,
1589: A.pc_node_id,
1590: cii.instance_id subject_id,
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

Line 1622: (SELECT to_date(ciea1.attribute_value, 'DD/MM/YYYY') from csi_inst_extend_attrib_v ciea1

1618: CURSOR get_posn_vst_csr(c_visit_type_code VARCHAR2) IS
1619: SELECT A.mr_header_id, A.mr_effectivity_id,
1620: A.pc_node_id,
1621: cii.instance_id subject_id,
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

Line 1733: csi_inst_extend_attrib_v ciea1

1729: to_date(ciea1.attribute_value, 'DD/MM/YYYY') mfg_date ,
1730: 'm' manufacturer_id ,
1731: 'c' country_code
1732: FROM csi_item_instances csi,
1733: csi_inst_extend_attrib_v ciea1
1734: WHERE csi.instance_id = ciea1.instance_id(+)
1735: AND ciea1.attribute_code(+) = 'AHL_MFG_DATE'
1736: AND ciea1.attribute_level(+) = 'GLOBAL'
1737: AND csi.instance_id = c_item_instance_id;

Line 2692: csi_inst_extend_attrib_v ciea1

2688: to_date(ciea1.attribute_value, 'DD/MM/YYYY') mfg_date ,
2689: 'm' manufacturer_id ,
2690: 'c' country_code
2691: FROM csi_item_instances csi,
2692: csi_inst_extend_attrib_v ciea1
2693: WHERE csi.instance_id = ciea1.instance_id(+)
2694: AND ciea1.attribute_code(+) = 'AHL_MFG_DATE'
2695: AND ciea1.attribute_level(+) = 'GLOBAL'
2696: AND csi.instance_id = c_item_instance_id;