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_HEADERS_APP_V

Line 131: FROM ahl_mr_headers_app_v

127: --check whether the given mr exists
128: CURSOR check_mr_exists(c_mr_header_id number)
129: IS
130: SELECT mr_header_id
131: FROM ahl_mr_headers_app_v
132: WHERE mr_header_id = c_mr_header_id;
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

Line 1460: ahl_mr_headers_app_v MR,

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,
1464: 0 depth

Line 1490: AND MR.version_number in (SELECT max(MRM.version_number) from ahl_mr_headers_app_v MRM where SYSDATE between trunc(MR.effective_from) and trunc(nvl(MR.effective_to,SYSDATE+1)) and title=mr.title and mr_status_code='COMPLETE' group by MRM.title)

1486: AND cir.subject_id = cii.instance_id
1487: AND MR.mr_status_code = 'COMPLETE'
1488: AND MR.program_type_code NOT IN ('MO_PROC') -- added in R12
1489: AND SYSDATE between trunc(MR.effective_from) and trunc(nvl(MR.effective_to,SYSDATE+1))
1490: AND MR.version_number in (SELECT max(MRM.version_number) from ahl_mr_headers_app_v MRM where SYSDATE between trunc(MR.effective_from) and trunc(nvl(MR.effective_to,SYSDATE+1)) and title=mr.title and mr_status_code='COMPLETE' group by MRM.title)
1491: AND (A.inventory_item_id = cii.inventory_item_id OR
1492: (A.inventory_item_id IS NULL AND A.relationship_id IS NOT NULL AND
1493: AHL_FMP_PVT.Instance_Matches_Path_Pos(cii.instance_id,A.relationship_id) = 'T'))
1494: ORDER BY cir.depth, cir.subject_id; -- depth, subject_id

Line 1539: FROM ahl_mr_headers_app_v MR, cir,

1535: -- cir.object_id,
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'

Line 1547: from ahl_mr_headers_app_v MRM

1543: AND MR.mr_status_code = 'COMPLETE'
1544: AND MR.program_type_code NOT IN ('MO_PROC') -- added in R12
1545: AND SYSDATE between trunc(MR.effective_from) and trunc(nvl(MR.effective_to,SYSDATE+1))
1546: AND MR.version_number in (SELECT max(MRM.version_number)
1547: from ahl_mr_headers_app_v MRM
1548: where SYSDATE between trunc(MR.effective_from)
1549: and trunc(nvl(MR.effective_to,SYSDATE+1))
1550: and title=mr.title and mr_status_code='COMPLETE'
1551: group by MRM.title)

Line 1563: FROM ahl_mr_headers_app_v MR, ahl_mc_path_positions mcp,

1559: --cir.object_id,
1560: cir.subject_id,
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

Line 1573: from ahl_mr_headers_app_v MRM

1569: AND MR.program_type_code NOT IN ('MO_PROC') -- added in R12
1570: AND SYSDATE between trunc(MR.effective_from)
1571: AND trunc(nvl(MR.effective_to,SYSDATE+1))
1572: AND MR.version_number in (SELECT max(MRM.version_number)
1573: from ahl_mr_headers_app_v MRM
1574: where SYSDATE between trunc(MR.effective_from)
1575: and trunc(nvl(MR.effective_to,SYSDATE+1))
1576: and title=mr.title and mr_status_code='COMPLETE'
1577: group by MRM.title)

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 1849: AND MR.version_number in (SELECT max(MRM.version_number) from ahl_mr_headers_app_v MRM where SYSDATE between trunc(MR.effective_from) and trunc(nvl(MR.effective_to,SYSDATE+1)) and title=mr.title and mr_status_code='COMPLETE' group by MRM.title)

1845: AND cir.subject_id = cii.instance_id
1846: AND MR.mr_status_code = 'COMPLETE'
1847: AND MR.program_type_code NOT IN ('MO_PROC') -- added in R12
1848: AND SYSDATE between trunc(MR.effective_from) and trunc(nvl(MR.effective_to,SYSDATE+1))
1849: AND MR.version_number in (SELECT max(MRM.version_number) from ahl_mr_headers_app_v MRM where SYSDATE between trunc(MR.effective_from) and trunc(nvl(MR.effective_to,SYSDATE+1)) and title=mr.title and mr_status_code='COMPLETE' group by MRM.title)
1850: AND (A.inventory_item_id = cii.inventory_item_id OR
1851: (A.inventory_item_id IS NULL AND A.relationship_id IS NOT NULL AND
1852: AHL_FMP_PVT.Instance_Matches_Path_Pos(cii.instance_id,A.relationship_id) = 'T'))
1853: ORDER BY cir.depth, cir.subject_id; -- depth, subject_id

Line 1880: FROM ahl_mr_headers_app_v MR, ahl_mr_visit_types vis, cir,

1876: --cir.object_id,
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

Line 1889: from ahl_mr_headers_app_v MRM

1885: AND MR.mr_status_code = 'COMPLETE'
1886: AND MR.program_type_code NOT IN ('MO_PROC') -- added in R12
1887: AND SYSDATE between trunc(MR.effective_from) and trunc(nvl(MR.effective_to,SYSDATE+1))
1888: AND MR.version_number in (SELECT max(MRM.version_number)
1889: from ahl_mr_headers_app_v MRM
1890: where SYSDATE between trunc(MR.effective_from)
1891: and trunc(nvl(MR.effective_to,SYSDATE+1))
1892: and title=mr.title and mr_status_code='COMPLETE'
1893: group by MRM.title)

Line 1905: FROM ahl_mr_headers_app_v MR, ahl_mr_visit_types vis, ahl_mc_path_positions mcp,

1901: --cir.object_id,
1902: cir.subject_id,
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

Line 1916: from ahl_mr_headers_app_v MRM

1912: AND MR.program_type_code NOT IN ('MO_PROC') -- added in R12
1913: AND SYSDATE between trunc(MR.effective_from)
1914: AND trunc(nvl(MR.effective_to,SYSDATE+1))
1915: AND MR.version_number in (SELECT max(MRM.version_number)
1916: from ahl_mr_headers_app_v MRM
1917: where SYSDATE between trunc(MR.effective_from)
1918: and trunc(nvl(MR.effective_to,SYSDATE+1))
1919: and title=mr.title and mr_status_code='COMPLETE'
1920: group by MRM.title)

Line 1965: AND exists (SELECT 'x' from ahl_mr_headers_app_v MR

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
1964: AND A.relationship_id is null
1965: AND exists (SELECT 'x' from ahl_mr_headers_app_v MR
1966: WHERE MR.mr_header_id = A.mr_header_id
1967: AND MR.program_type_code NOT IN ('MO_PROC') -- added in R12
1968: AND MR.version_number in (SELECT max(MRM.version_number)
1969: FROM ahl_mr_headers_app_v MRM

Line 1969: FROM ahl_mr_headers_app_v MRM

1965: AND exists (SELECT 'x' from ahl_mr_headers_app_v MR
1966: WHERE MR.mr_header_id = A.mr_header_id
1967: AND MR.program_type_code NOT IN ('MO_PROC') -- added in R12
1968: AND MR.version_number in (SELECT max(MRM.version_number)
1969: FROM ahl_mr_headers_app_v MRM
1970: WHERE mrm.title = mr.title
1971: AND SYSDATE between trunc(MRM.effective_from)
1972: AND trunc(nvl(MRM.effective_to,SYSDATE+1))
1973: AND mr_status_code='COMPLETE'

Line 1999: AND exists (SELECT 'x' from ahl_mr_headers_app_v MR

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
1998: AND A.relationship_id is null
1999: AND exists (SELECT 'x' from ahl_mr_headers_app_v MR
2000: WHERE MR.mr_header_id = A.mr_header_id
2001: AND MR.program_type_code NOT IN ('MO_PROC') -- added in R12
2002: AND MR.version_number in (SELECT max(MRM.version_number)
2003: FROM ahl_mr_headers_app_v MRM

Line 2003: FROM ahl_mr_headers_app_v MRM

1999: AND exists (SELECT 'x' from ahl_mr_headers_app_v MR
2000: WHERE MR.mr_header_id = A.mr_header_id
2001: AND MR.program_type_code NOT IN ('MO_PROC') -- added in R12
2002: AND MR.version_number in (SELECT max(MRM.version_number)
2003: FROM ahl_mr_headers_app_v MRM
2004: WHERE mrm.title = mr.title
2005: AND SYSDATE between trunc(MRM.effective_from)
2006: AND trunc(nvl(MRM.effective_to,SYSDATE+1))
2007: AND mr_status_code='COMPLETE'

Line 2032: AND exists (SELECT 'x' from ahl_mr_headers_app_v MR

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
2031: AND nvl(A.inventory_item_id, cii.inventory_item_id) = cii.inventory_item_id
2032: AND exists (SELECT 'x' from ahl_mr_headers_app_v MR
2033: WHERE MR.mr_header_id = A.mr_header_id
2034: AND MR.program_type_code NOT IN ('MO_PROC') -- added in R12
2035: AND MR.version_number in (SELECT max(MRM.version_number)
2036: FROM ahl_mr_headers_app_v MRM

Line 2036: FROM ahl_mr_headers_app_v MRM

2032: AND exists (SELECT 'x' from ahl_mr_headers_app_v MR
2033: WHERE MR.mr_header_id = A.mr_header_id
2034: AND MR.program_type_code NOT IN ('MO_PROC') -- added in R12
2035: AND MR.version_number in (SELECT max(MRM.version_number)
2036: FROM ahl_mr_headers_app_v MRM
2037: WHERE mrm.title = mr.title
2038: AND SYSDATE between trunc(MRM.effective_from)
2039: AND trunc(nvl(MRM.effective_to,SYSDATE+1))
2040: AND mr_status_code='COMPLETE'

Line 2056: --and exists (SELECT 'x' from ahl_mr_headers_app_v 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.
2056: --and exists (SELECT 'x' from ahl_mr_headers_app_v MR
2057: -- WHERE MR.mr_header_id = mre.mr_header_id
2058: -- AND MR.program_type_code NOT IN ('MO_PROC') -- added in R12
2059: -- AND MR.version_number in (SELECT max(MRM.version_number)
2060: -- FROM ahl_mr_headers_app_v MRM

Line 2060: -- FROM ahl_mr_headers_app_v MRM

2056: --and exists (SELECT 'x' from ahl_mr_headers_app_v MR
2057: -- WHERE MR.mr_header_id = mre.mr_header_id
2058: -- AND MR.program_type_code NOT IN ('MO_PROC') -- added in R12
2059: -- AND MR.version_number in (SELECT max(MRM.version_number)
2060: -- FROM ahl_mr_headers_app_v MRM
2061: -- WHERE mrm.title = mr.title
2062: -- AND SYSDATE between trunc(MRM.effective_from)
2063: -- AND trunc(nvl(MRM.effective_to,SYSDATE+1))
2064: -- AND mr_status_code='COMPLETE'

Line 2081: --and exists (SELECT 'x' from ahl_mr_headers_app_v MR

2077: and mre.mr_header_id = mr.mr_header_id
2078: and mre.relationship_id is not null
2079: and SYSDATE between trunc(mr.effective_from) AND trunc(nvl(mr.effective_to,SYSDATE+1))
2080: -- commented for performance bug# 9434441 and added effective date chk directly.
2081: --and exists (SELECT 'x' from ahl_mr_headers_app_v MR
2082: -- WHERE MR.mr_header_id = vis.mr_header_id
2083: -- AND MR.program_type_code NOT IN ('MO_PROC') -- added in R12
2084: -- AND MR.version_number in (SELECT max(MRM.version_number)
2085: -- FROM ahl_mr_headers_app_v MRM

Line 2085: -- FROM ahl_mr_headers_app_v MRM

2081: --and exists (SELECT 'x' from ahl_mr_headers_app_v MR
2082: -- WHERE MR.mr_header_id = vis.mr_header_id
2083: -- AND MR.program_type_code NOT IN ('MO_PROC') -- added in R12
2084: -- AND MR.version_number in (SELECT max(MRM.version_number)
2085: -- FROM ahl_mr_headers_app_v MRM
2086: -- WHERE mrm.title = mr.title
2087: -- AND SYSDATE between trunc(MRM.effective_from)
2088: -- AND trunc(nvl(MRM.effective_to,SYSDATE+1))
2089: -- AND mr_status_code='COMPLETE'

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 3937: FROM ahl_mr_headers_app_v

3933: SELECT repetitive_flag,
3934: show_repetitive_code,
3935: whichever_first_code,
3936: implement_status_code
3937: FROM ahl_mr_headers_app_v
3938: WHERE mr_header_id = c_mr_header_id;
3939: */
3940:
3941: -- validate instance and get its attributes.

Line 4626: AND exists (SELECT 'x' from ahl_mr_headers_app_v MR

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
4626: AND exists (SELECT 'x' from ahl_mr_headers_app_v MR
4627: WHERE MR.mr_header_id = c_mr_header_id
4628: AND MR.program_type_code NOT IN ('MO_PROC') -- added in R12
4629: AND mr_status_code='COMPLETE'
4630: )

Line 4648: AND exists (SELECT 'x' from ahl_mr_headers_app_v MR

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
4648: AND exists (SELECT 'x' from ahl_mr_headers_app_v MR
4649: WHERE MR.mr_header_id = c_mr_header_id
4650: AND MR.program_type_code NOT IN ('MO_PROC') -- added in R12
4651: AND mr_status_code='COMPLETE'
4652: )

Line 4672: AND exists (SELECT 'x' from ahl_mr_headers_app_v MR

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
4671: AND nvl(A.inventory_item_id,cii.inventory_item_id) = cii.inventory_item_id
4672: AND exists (SELECT 'x' from ahl_mr_headers_app_v MR
4673: WHERE MR.mr_header_id = c_mr_header_id
4674: AND MR.program_type_code NOT IN ('MO_PROC') -- added in R12
4675: AND mr_status_code='COMPLETE'
4676: )