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_HEADERS_B

Line 1412: FROM ahl_mr_headers_b mrb,

1408: (select MLC.mr_header_id
1409: from ahl_mr_loop_chain_relns MLC
1410: where MLC.mr_relationship_id = lcr.start_mr_relationship_id ) start_mr_header_id,
1411: lcr.sequence_number
1412: FROM ahl_mr_headers_b mrb,
1413: ahl_mr_loop_chain_relns lcr,
1414: ahl_mr_relationships mrr
1415: WHERE mrb.mr_header_id = c_mr_header_id
1416: AND lcr.mr_header_id(+) = mrb.mr_header_id

Line 1427: FROM ahl_mr_headers_b --perf bug 6266738. using base tables.

1423: preceding_mr_header_id,
1424: copy_accomplishment_flag,
1425: implement_status_code,
1426: count_mr_descendents(c_mr_header_id) descendent_count
1427: FROM ahl_mr_headers_b --perf bug 6266738. using base tables.
1428: WHERE mr_header_id = c_mr_header_id;
1429: */
1430: -- End changes for SB effectivity
1431:

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 1629: FROM ahl_mr_headers_b MRM

1625: AND SYSDATE between trunc(MR.effective_from) AND trunc(nvl(MR.effective_to,SYSDATE+1))
1626: AND MR.mr_status_code='COMPLETE'
1627: AND MR.application_usg_code = c_appln_usg_code
1628: AND MR.version_number in (SELECT /*+ push_subq no_unnest */ max(MRM.version_number)
1629: FROM ahl_mr_headers_b MRM
1630: WHERE mrm.title = MR.title
1631: AND SYSDATE between trunc(MRM.effective_from)
1632: AND trunc(nvl(MRM.effective_to,SYSDATE+1))
1633: AND mr_status_code='COMPLETE'

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 1669: FROM ahl_mr_headers_b MRM

1665: AND SYSDATE between trunc(MR.effective_from)
1666: AND trunc(nvl(MR.effective_to,SYSDATE+1))
1667: AND MR.mr_status_code='COMPLETE'
1668: AND MR.version_number in (SELECT max(MRM.version_number)
1669: FROM ahl_mr_headers_b MRM
1670: WHERE mrm.title = mr.title
1671: AND SYSDATE between trunc(MRM.effective_from)
1672: AND trunc(nvl(MRM.effective_to,SYSDATE+1))
1673: AND MRM.mr_status_code='COMPLETE'

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 1705: FROM ahl_mr_headers_b MRM

1701: AND SYSDATE between trunc(MR.effective_from)
1702: AND trunc(nvl(MR.effective_to,SYSDATE+1))
1703: AND MR.mr_status_code='COMPLETE'
1704: AND MR.version_number in (SELECT /*+ push_subq no_unnest */ max(MRM.version_number)
1705: FROM ahl_mr_headers_b MRM
1706: WHERE mrm.title = mr.title
1707: AND SYSDATE between trunc(MRM.effective_from)
1708: AND trunc(nvl(MRM.effective_to,SYSDATE+1))
1709: AND MRM.mr_status_code='COMPLETE'

Line 1733: AND exists (SELECT /+ PUSH_SUBQ NO_UNNEST / 'x' from ahl_mr_headers_b MR

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
1733: AND exists (SELECT /*+ PUSH_SUBQ NO_UNNEST */ 'x' from ahl_mr_headers_b MR
1734: WHERE MR.mr_header_id = A.mr_header_id
1735: AND MR.program_type_code NOT IN ('MO_PROC') -- added in R12
1736: AND MR.application_usg_code = c_appln_usg_code
1737: AND SYSDATE between trunc(MR.effective_from)

Line 1741: FROM ahl_mr_headers_b MRM

1737: AND SYSDATE between trunc(MR.effective_from)
1738: AND trunc(nvl(MR.effective_to,SYSDATE+1))
1739: AND MR.mr_status_code='COMPLETE'
1740: AND MR.version_number in (SELECT max(MRM.version_number)
1741: FROM ahl_mr_headers_b MRM
1742: WHERE mrm.title = mr.title
1743: AND SYSDATE between trunc(MRM.effective_from)
1744: AND trunc(nvl(MRM.effective_to,SYSDATE+1))
1745: AND MRM.mr_status_code='COMPLETE'

Line 1773: AND exists (SELECT /+ PUSH_SUBQ NO_UNNEST / 'x' from ahl_mr_headers_b MR

1769: A.relationship_id IS NOT NULL
1770: AND aai.position_id = A.relationship_id
1771: AND aai.csi_item_instance_id = cii.instance_id
1772: AND nvl(A.inventory_item_id,cii.inventory_item_id) = cii.inventory_item_id
1773: AND exists (SELECT /*+ PUSH_SUBQ NO_UNNEST */ 'x' from ahl_mr_headers_b MR
1774: WHERE MR.mr_header_id = A.mr_header_id
1775: AND MR.program_type_code NOT IN ('MO_PROC') -- added in R12
1776: AND MR.application_usg_code = c_appln_usg_code
1777: AND MR.version_number in (SELECT max(MRM.version_number)

Line 1778: FROM ahl_mr_headers_b MRM

1774: WHERE MR.mr_header_id = A.mr_header_id
1775: AND MR.program_type_code NOT IN ('MO_PROC') -- added in R12
1776: AND MR.application_usg_code = c_appln_usg_code
1777: AND MR.version_number in (SELECT max(MRM.version_number)
1778: FROM ahl_mr_headers_b MRM
1779: WHERE mrm.title = mr.title
1780: AND SYSDATE between trunc(MRM.effective_from)
1781: AND trunc(nvl(MRM.effective_to,SYSDATE+1))
1782: AND mr_status_code='COMPLETE'

Line 1809: AND exists (SELECT /+ PUSH_SUBQ NO_UNNEST / 'x' from ahl_mr_headers_b MR

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
1808: AND nvl(A.inventory_item_id,cii.inventory_item_id) = cii.inventory_item_id
1809: AND exists (SELECT /*+ PUSH_SUBQ NO_UNNEST */ 'x' from ahl_mr_headers_b MR
1810: WHERE MR.mr_header_id = A.mr_header_id
1811: AND MR.program_type_code NOT IN ('MO_PROC') -- added in R12
1812: AND MR.application_usg_code = c_appln_usg_code
1813: AND MR.version_number in (SELECT max(MRM.version_number)

Line 1814: FROM ahl_mr_headers_b MRM

1810: WHERE MR.mr_header_id = A.mr_header_id
1811: AND MR.program_type_code NOT IN ('MO_PROC') -- added in R12
1812: AND MR.application_usg_code = c_appln_usg_code
1813: AND MR.version_number in (SELECT max(MRM.version_number)
1814: FROM ahl_mr_headers_b MRM
1815: WHERE mrm.title = mr.title
1816: AND SYSDATE between trunc(MRM.effective_from)
1817: AND trunc(nvl(MRM.effective_to,SYSDATE+1))
1818: AND mr_status_code='COMPLETE'

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 3190: FROM ahl_mr_headers_b M -- perf bug 6266738

3186: SELECT --count(distinct related_mr_header_id)
3187: count(related_mr_header_id)
3188: FROM ahl_mr_relationships
3189: WHERE EXISTS (SELECT mr_header_id
3190: FROM ahl_mr_headers_b M -- perf bug 6266738
3191: WHERE mr_header_id = related_mr_header_id
3192: AND mr_status_code = 'COMPLETE'
3193: AND SYSDATE between trunc(effective_from) and trunc(nvl(effective_to,SYSDATE+1))
3194: AND (version_number) in (SELECT max(M1.version_number)

Line 3195: from ahl_mr_headers_b M1

3191: WHERE mr_header_id = related_mr_header_id
3192: AND mr_status_code = 'COMPLETE'
3193: AND SYSDATE between trunc(effective_from) and trunc(nvl(effective_to,SYSDATE+1))
3194: AND (version_number) in (SELECT max(M1.version_number)
3195: from ahl_mr_headers_b M1
3196: where M1.title = m.title -- perf bug 6266738
3197: AND mr_status_code = 'COMPLETE'
3198: AND SYSDATE between trunc(effective_from) and trunc(nvl(effective_to,SYSDATE+1))
3199: )

Line 3211: AND exists (select 'x' from ahl_mr_headers_b mr1

3207: SELECT count(amr.related_mr_header_id)
3208: FROM ahl_mr_relationships amr
3209: START WITH amr.mr_header_id = c_mr_header_id
3210: AND amr.relationship_code = 'PARENT'
3211: AND exists (select 'x' from ahl_mr_headers_b mr1
3212: where mr1.mr_header_id = amr.related_mr_header_id
3213: and mr1.version_number = (select max(mr2.version_number)
3214: from ahl_mr_headers_b mr2
3215: where mr2.title = mr1.title

Line 3214: from ahl_mr_headers_b mr2

3210: AND amr.relationship_code = 'PARENT'
3211: AND exists (select 'x' from ahl_mr_headers_b mr1
3212: where mr1.mr_header_id = amr.related_mr_header_id
3213: and mr1.version_number = (select max(mr2.version_number)
3214: from ahl_mr_headers_b mr2
3215: where mr2.title = mr1.title
3216: and mr2.mr_status_code = 'COMPLETE'
3217: and SYSDATE between trunc(mr2.effective_from)
3218: and trunc(nvl(mr2.effective_to,SYSDATE+1))

Line 3223: AND exists (select 'x' from ahl_mr_headers_b mr1

3219: )
3220: )
3221: CONNECT BY amr.mr_header_id = PRIOR amr.related_mr_header_id
3222: AND amr.relationship_code = 'PARENT'
3223: AND exists (select 'x' from ahl_mr_headers_b mr1
3224: where mr1.mr_header_id = amr.related_mr_header_id
3225: and mr1.version_number = (select max(mr2.version_number)
3226: from ahl_mr_headers_b mr2
3227: where mr2.title = mr1.title

Line 3226: from ahl_mr_headers_b mr2

3222: AND amr.relationship_code = 'PARENT'
3223: AND exists (select 'x' from ahl_mr_headers_b mr1
3224: where mr1.mr_header_id = amr.related_mr_header_id
3225: and mr1.version_number = (select max(mr2.version_number)
3226: from ahl_mr_headers_b mr2
3227: where mr2.title = mr1.title
3228: and mr2.mr_status_code = 'COMPLETE'
3229: and SYSDATE between trunc(mr2.effective_from)
3230: and trunc(nvl(mr2.effective_to,SYSDATE+1))

Line 4594: FROM ahl_mr_headers_b --perf bug 6266738. using base tables.

4590: --preceding_mr_header_id,
4591: copy_accomplishment_flag,
4592: implement_status_code,
4593: count_mr_descendents(c_mr_header_id) descendent_count
4594: FROM ahl_mr_headers_b --perf bug 6266738. using base tables.
4595: WHERE mr_header_id = c_mr_header_id;
4596:
4597: l_get_mr_attri get_mr_attri%ROWTYPE;
4598: