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_EFFECTIVITIES

Line 137: FROM ahl_mr_effectivities_app_v

133: --check whether the given mr_effecitivity_id exists
134: CURSOR check_mr_effect(c_mr_effectivity_id number ,c_mr_header_id number)
135: IS
136: SELECT mr_header_id, mr_effectivity_id, inventory_item_id,relationship_id, pc_node_id
137: FROM ahl_mr_effectivities_app_v
138: WHERE mr_effectivity_id = NVL(c_mr_effectivity_id,mr_effectivity_id)
139: AND mr_header_id = c_mr_header_id;
140: l_mr_effect check_mr_effect%ROWTYPE;
141:

Line 148: FROM ahl_mr_effectivities_app_v

144: --all the mr_effectivity_id's for the given MR).
145: CURSOR get_mr_effect(c_mr_header_id NUMBER, c_mr_effectivity_id NUMBER)
146: IS
147: SELECT mr_header_id, mr_effectivity_id, inventory_item_id,relationship_id, pc_node_id
148: FROM ahl_mr_effectivities_app_v
149: WHERE mr_header_id = c_mr_header_id
150: AND mr_effectivity_id = NVL(c_mr_effectivity_id, mr_effectivity_id);
151: --get distinct item instances from the global temporary table
152: CURSOR get_dist_inst

Line 763: FROM ahl_mr_effectivities MR

759: -- JKJain, NR Analysis and Forecasting : Fetch rows having fleet effectivity
760: CURSOR get_fleet_header_id(c_mr_effectivity_id NUMBER)
761: IS
762: SELECT fleet_header_id
763: FROM ahl_mr_effectivities MR
764: WHERE MR.mr_effectivity_id = c_mr_effectivity_id ;
765: l_fleet_header_id NUMBER;
766: l_var VARCHAR2(1);
767:

Line 1459: FROM ahl_mr_effectivities A,

1455: --- Performance Changes bug - 6138653
1456: CURSOR get_mr_details_csr(c_instance_id NUMBER, c_mr_header_id NUMBER, c_components_flag VARCHAR2) IS
1457: SELECT A.mr_header_id, A.mr_effectivity_id, A.relationship_id, A.pc_node_id, A.inventory_item_id,
1458: cir.object_id, cir.subject_id, cir.position_reference
1459: FROM ahl_mr_effectivities A,
1460: ahl_mr_headers_app_v MR,
1461: (select cir2.object_id,
1462: cii2.instance_id subject_id,
1463: nvl(uc.master_config_id, cir2.position_reference) position_reference,

Line 1540: ahl_mr_effectivities A

1536: cir.subject_id,
1537: --cir.position_reference ,
1538: cir.depth
1539: FROM ahl_mr_headers_app_v MR, cir,
1540: ahl_mr_effectivities A
1541: WHERE A.mr_header_id = NVL(c_mr_header_id, A.mr_header_id)
1542: AND MR.mr_header_id = A.mr_header_id
1543: AND MR.mr_status_code = 'COMPLETE'
1544: AND MR.program_type_code NOT IN ('MO_PROC') -- added in R12

Line 1565: cir, ahl_mr_effectivities A

1561: --cir.position_reference,
1562: cir.depth
1563: FROM ahl_mr_headers_app_v MR, ahl_mc_path_positions mcp,
1564: --ahl_mc_headers_b hdr, ahl_mc_relationships rel,
1565: cir, ahl_mr_effectivities A
1566: WHERE A.mr_header_id = NVL(c_mr_header_id, A.mr_header_id)
1567: AND MR.mr_header_id = A.mr_header_id
1568: AND MR.mr_status_code = 'COMPLETE'
1569: AND MR.program_type_code NOT IN ('MO_PROC') -- added in R12

Line 1618: ahl_mr_effectivities A, ahl_mr_headers_b MR

1614: --AND relationship_type_code = 'COMPONENT-OF'
1615: --AND SYSDATE between trunc(nvl(active_start_date,sysdate))
1616: --AND trunc(NVL(active_end_date,sysdate+1))
1617: ) cir, csi_item_instances ii,
1618: ahl_mr_effectivities A, ahl_mr_headers_b MR
1619: WHERE --A.mr_header_id = NVL(c_mr_header_id, A.mr_header_id)
1620: ii.instance_id = cir.subject_id
1621: AND A.inventory_item_id = ii.inventory_item_id
1622: AND A.relationship_id is null

Line 1657: ahl_mr_effectivities A, ahl_mr_headers_b MR

1653: FROM ahl_config_components a
1654: START WITH object_id = c_instance_id
1655: CONNECT BY object_id = PRIOR subject_id
1656: ) cir, csi_item_instances ii,
1657: ahl_mr_effectivities A, ahl_mr_headers_b MR
1658: WHERE A.mr_header_id = c_mr_header_id
1659: AND ii.instance_id = cir.subject_id
1660: AND A.inventory_item_id = ii.inventory_item_id
1661: AND A.relationship_id is null

Line 1693: ahl_mr_effectivities A, ahl_mr_headers_b MR

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)
1696: AND A.inventory_item_id = ii.inventory_item_id
1697: AND A.relationship_id is null

Line 1728: ahl_mr_effectivities A

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,
1728: ahl_mr_effectivities A
1729: WHERE ii.instance_id = c_instance_id
1730: AND A.mr_header_id = c_mr_header_id
1731: AND A.inventory_item_id = ii.inventory_item_id
1732: AND A.relationship_id is null

Line 1765: ahl_mr_effectivities A

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)
1768: --AND
1769: A.relationship_id IS NOT NULL

Line 1803: ahl_mr_effectivities A

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
1806: AND aai.position_id = A.relationship_id
1807: AND aai.csi_item_instance_id = cii.instance_id

Line 1829: FROM ahl_mr_effectivities A, ahl_mr_headers_app_v MR, ahl_mr_visit_types vis,

1825: /* 12 Jul 08: Modified for performance.
1826: CURSOR get_visit_mr_details_csr(c_instance_id NUMBER, c_visit_type_code VARCHAR2) IS
1827: SELECT A.mr_header_id, A.mr_effectivity_id, A.relationship_id, A.pc_node_id, A.inventory_item_id,
1828: cir.object_id, cir.subject_id, cir.position_reference
1829: FROM ahl_mr_effectivities A, ahl_mr_headers_app_v MR, ahl_mr_visit_types vis,
1830: (select cir2.object_id,
1831: cii2.instance_id subject_id,
1832: nvl(uc.master_config_id, cir2.position_reference) position_reference,
1833: 0 depth

Line 1881: ahl_mr_effectivities A

1877: cir.subject_id,
1878: --cir.position_reference ,
1879: cir.depth
1880: FROM ahl_mr_headers_app_v MR, ahl_mr_visit_types vis, cir,
1881: ahl_mr_effectivities A
1882: WHERE MR.mr_header_id = A.mr_header_id
1883: AND A.mr_header_id = vis.mr_header_id
1884: AND vis.mr_visit_type_code = c_visit_type_code
1885: AND MR.mr_status_code = 'COMPLETE'

Line 1907: cir, ahl_mr_effectivities A

1903: --cir.position_reference,
1904: cir.depth
1905: FROM ahl_mr_headers_app_v MR, ahl_mr_visit_types vis, ahl_mc_path_positions mcp,
1906: --ahl_mc_headers_b hdr, ahl_mc_relationships rel,
1907: cir, ahl_mr_effectivities A
1908: WHERE MR.mr_header_id = A.mr_header_id
1909: AND A.mr_header_id = vis.mr_header_id
1910: AND vis.mr_visit_type_code = c_visit_type_code
1911: AND MR.mr_status_code = 'COMPLETE'

Line 1959: ahl_mr_effectivities A

1955: --AND relationship_type_code = 'COMPONENT-OF'
1956: --AND SYSDATE between trunc(nvl(active_start_date,sysdate))
1957: --AND trunc(NVL(active_end_date,sysdate+1))
1958: ) cir, csi_item_instances cii, ahl_mr_visit_types vis,
1959: ahl_mr_effectivities A
1960: WHERE A.mr_header_id = vis.mr_header_id
1961: AND vis.mr_visit_type_code = c_visit_type_code
1962: AND cir.subject_id = cii.instance_id
1963: AND A.inventory_item_id = cii.inventory_item_id

Line 1993: ahl_mr_effectivities A

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
1996: AND cii.instance_id = c_instance_id
1997: AND A.inventory_item_id = cii.inventory_item_id

Line 2026: ahl_mr_effectivities A

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
2029: AND A.relationship_id IS NOT NULL
2030: AND aai.position_id = A.relationship_id

Line 2051: from ahl_mr_effectivities mre, ahl_mr_headers_b mr

2047: -- check for path position based effectivities.
2048: CURSOR relationship_csr IS
2049: SELECT 'x' from dual
2050: WHERE exists (select 'x'
2051: from ahl_mr_effectivities mre, ahl_mr_headers_b mr
2052: where mre.relationship_id is not null
2053: and mre.mr_header_id = mr.mr_header_id
2054: and SYSDATE between trunc(mr.effective_from) AND trunc(nvl(mr.effective_to,SYSDATE+1))
2055: -- commented for performance bug# 9434441 and added effective date chk directly.

Line 2074: from ahl_mr_effectivities mre, ahl_mr_visit_types vis, ahl_mr_headers_b mr

2070: -- check for path position based effectivities for visit type
2071: CURSOR relationship_vtype_csr(p_visit_type_code IN VARCHAR2) IS
2072: SELECT 'x' from dual
2073: WHERE exists (select 'x'
2074: from ahl_mr_effectivities mre, ahl_mr_visit_types vis, ahl_mr_headers_b mr
2075: where vis.mr_visit_type_code = p_visit_type_code
2076: and mre.mr_header_id = vis.mr_header_id
2077: and mre.mr_header_id = mr.mr_header_id
2078: and mre.relationship_id is not null

Line 2098: from ahl_mr_effectivities

2094: -- check for path position based effectivities for MR
2095: CURSOR relationship_mr_csr(p_mr_header_id IN NUMBER) IS
2096: SELECT 'x' from dual
2097: WHERE exists (select 'x'
2098: from ahl_mr_effectivities
2099: where mr_header_id = p_mr_header_id
2100: and relationship_id is not null);
2101:
2102:

Line 2154: FROM ahl_mr_effectivities

2150:
2151: /* not used
2152: CURSOR is_position_check_req(c_mr_effectivity_id NUMBER) IS
2153: SELECT 'X'
2154: FROM ahl_mr_effectivities
2155: WHERE mr_effectivity_id = c_mr_effectivity_id
2156: AND inventory_item_id IS NOT NULL;
2157: */
2158:

Line 3907: FROM ahl_mr_effectivities_app_v

3903: */
3904: /* modified for performance fix - bug# 6511501
3905: CURSOR get_applicable_mrs(c_inventory_item_id NUMBER) IS
3906: SELECT mr_header_id, mr_effectivity_id
3907: FROM ahl_mr_effectivities_app_v
3908: WHERE inventory_item_id = c_inventory_item_id
3909: ORDER BY mr_header_id, mr_effectivity_id;
3910: */
3911:

Line 3918: FROM ahl_mr_effectivities me, ahl_mr_headers_app_v mh

3914: SELECT mr_effectivity_id, repetitive_flag,
3915: show_repetitive_code,
3916: whichever_first_code,
3917: implement_status_code
3918: FROM ahl_mr_effectivities me, ahl_mr_headers_app_v mh
3919: WHERE me.mr_header_id = mh.mr_header_id
3920: AND mh.mr_header_id = c_mr_header_id
3921: AND me.inventory_item_id = c_inventory_item_id;
3922:

Line 4621: ahl_mr_effectivities A

4617: --AND relationship_type_code = 'COMPONENT-OF'
4618: --AND SYSDATE between trunc(nvl(active_start_date,sysdate))
4619: --AND trunc(NVL(active_end_date,sysdate+1))
4620: ) cir, csi_item_instances ii,
4621: ahl_mr_effectivities A
4622: WHERE A.mr_header_id = c_mr_header_id
4623: AND ii.instance_id = cir.subject_id
4624: AND A.inventory_item_id = ii.inventory_item_id
4625: AND A.relationship_id is null

Line 4643: ahl_mr_effectivities A

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,
4643: ahl_mr_effectivities A
4644: WHERE ii.instance_id = c_instance_id
4645: AND A.mr_header_id = c_mr_header_id
4646: AND A.inventory_item_id = ii.inventory_item_id
4647: AND A.relationship_id is null

Line 4666: ahl_mr_effectivities A

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,
4666: ahl_mr_effectivities A
4667: WHERE A.mr_header_id = c_mr_header_id
4668: AND A.relationship_id IS NOT NULL
4669: AND aai.position_id = A.relationship_id
4670: AND aai.csi_item_instance_id = cii.instance_id

Line 4684: from ahl_mr_effectivities

4680: -- check for path position based effectivities for MR
4681: CURSOR relationship_mr_csr(p_mr_header_id IN NUMBER) IS
4682: SELECT 'x' from dual
4683: WHERE exists (select 'x'
4684: from ahl_mr_effectivities
4685: where mr_header_id = p_mr_header_id
4686: and relationship_id is not null);
4687:
4688: