[Home] [Help]
27: (select p.party_name from csi_inst_party_details_v p
28: where p.instance_id = ii.instance_id and p.relationship_type_code = 'OWNER') owner_name,
29: (select mat.description from mtl_material_statuses mat where ii.INSTANCE_CONDITION_ID = mat.status_id) condition,
30: (select to_date(ciea.attribute_value, 'DD/MM/YYYY')
31: from csi_inst_extend_attrib_v ciea
32: where ciea.instance_id = ii.instance_id
33: AND ciea.attribute_code = 'AHL_MFG_DATE'
34: AND ciea.attribute_level = 'GLOBAL') mfg_date,
35: 'm' manufacturer_id, 'c' country_code
1597: A.pc_node_id,
1598: -- JKJain, NR Analysis and Forecasting
1599: A.fleet_header_id,
1600: ii.instance_id subject_id,
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
1644: A.pc_node_id,
1645: -- JKJain, NR Analysis and Forecasting
1646: A.fleet_header_id,
1647: ii.instance_id subject_id,
1648: (SELECT to_date(ciea1.attribute_value, 'DD/MM/YYYY') from csi_inst_extend_attrib_v ciea1
1649: WHERE ciea1.instance_id = ii.instance_id AND ciea1.attribute_code = 'AHL_MFG_DATE'
1650: AND ciea1.attribute_level = 'GLOBAL') mfg_date,
1651: ii.serial_number
1652: FROM ( SELECT a.subject_id
1683: A.pc_node_id,
1684: -- JKJain, NR Analysis and Forecasting
1685: A.fleet_header_id,
1686: ii.instance_id subject_id,
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
1719: A.pc_node_id,
1720: -- JKJain, NR Analysis and Forecasting
1721: A.fleet_header_id,
1722: ii.instance_id subject_id,
1723: (SELECT to_date(ciea1.attribute_value, 'DD/MM/YYYY') from csi_inst_extend_attrib_v ciea1
1724: WHERE ciea1.instance_id = ii.instance_id AND ciea1.attribute_code = 'AHL_MFG_DATE'
1725: AND ciea1.attribute_level = 'GLOBAL') mfg_date,
1726: ii.serial_number --,
1727: FROM csi_item_instances ii,
1755: A.pc_node_id,
1756: -- JKJain, NR Analysis and Forecasting
1757: A.fleet_header_id,
1758: cii.instance_id subject_id,
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
1793: A.pc_node_id,
1794: -- JKJain, NR Analysis and Forecasting
1795: A.fleet_header_id,
1796: cii.instance_id subject_id,
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
1938: A.pc_node_id,
1939: -- JKJain, NR Analysis and Forecasting
1940: A.fleet_header_id,
1941: cii.instance_id subject_id,
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
1983: A.pc_node_id,
1984: -- JKJain, NR Analysis and Forecasting
1985: A.fleet_header_id,
1986: cii.instance_id subject_id,
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
2016: A.pc_node_id,
2017: -- JKJain, NR Analysis and Forecasting
2018: A.fleet_header_id,
2019: cii.instance_id subject_id,
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
2140: to_date(ciea1.attribute_value, 'DD/MM/YYYY') mfg_date ,
2141: 'm' manufacturer_id ,
2142: 'c' country_code
2143: FROM csi_item_instances csi,
2144: csi_inst_extend_attrib_v ciea1
2145: WHERE csi.instance_id = ciea1.instance_id(+)
2146: AND ciea1.attribute_code(+) = 'AHL_MFG_DATE'
2147: AND ciea1.attribute_level(+) = 'GLOBAL'
2148: AND csi.instance_id = c_item_instance_id;
3431: to_date(ciea1.attribute_value, 'DD/MM/YYYY') mfg_date ,
3432: 'm' manufacturer_id ,
3433: 'c' country_code
3434: FROM csi_item_instances csi,
3435: csi_inst_extend_attrib_v ciea1
3436: WHERE csi.instance_id = ciea1.instance_id(+)
3437: AND ciea1.attribute_code(+) = 'AHL_MFG_DATE'
3438: AND ciea1.attribute_level(+) = 'GLOBAL'
3439: AND csi.instance_id = c_item_instance_id;
3533:
3534: CURSOR get_inst_ext_attributes(c_item_instance_id NUMBER) IS
3535: SELECT ciea1.attribute_code,ciea1.attribute_value
3536: FROM csi_item_instances csi,
3537: csi_inst_extend_attrib_v ciea1
3538: WHERE csi.instance_id = ciea1.instance_id(+)
3539: AND csi.instance_id = c_item_instance_id;
3540:
3541: --define record type to hold extended effectivity details.
4601: CURSOR get_comp_mr_inv_csr(c_instance_id NUMBER, c_mr_header_id NUMBER) IS
4602: SELECT A.mr_header_id, A.mr_effectivity_id,
4603: A.pc_node_id,
4604: ii.instance_id subject_id,
4605: (SELECT to_date(ciea1.attribute_value, 'DD/MM/YYYY') from csi_inst_extend_attrib_v ciea1
4606: WHERE ciea1.instance_id = ii.instance_id AND ciea1.attribute_code = 'AHL_MFG_DATE'
4607: AND ciea1.attribute_level = 'GLOBAL') mfg_date,
4608: ii.serial_number
4609: FROM ( SELECT a.subject_id
4634: CURSOR get_inst_mr_inv_csr(c_instance_id NUMBER, c_mr_header_id NUMBER) IS
4635: SELECT A.mr_header_id, A.mr_effectivity_id,
4636: A.pc_node_id,
4637: ii.instance_id subject_id,
4638: (SELECT to_date(ciea1.attribute_value, 'DD/MM/YYYY') from csi_inst_extend_attrib_v ciea1
4639: WHERE ciea1.instance_id = ii.instance_id AND ciea1.attribute_code = 'AHL_MFG_DATE'
4640: AND ciea1.attribute_level = 'GLOBAL') mfg_date,
4641: ii.serial_number
4642: FROM csi_item_instances ii,
4657: CURSOR get_posn_mr_csr(c_mr_header_id NUMBER) IS
4658: SELECT A.mr_header_id, A.mr_effectivity_id,
4659: A.pc_node_id,
4660: cii.instance_id subject_id,
4661: (SELECT to_date(ciea1.attribute_value, 'DD/MM/YYYY') from csi_inst_extend_attrib_v ciea1
4662: WHERE ciea1.instance_id = cii.instance_id AND ciea1.attribute_code = 'AHL_MFG_DATE'
4663: AND ciea1.attribute_level = 'GLOBAL') mfg_date,
4664: cii.serial_number
4665: FROM ahl_applicable_instances aai,csi_item_instances cii,