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_APP_V

Line 91: FROM ahl_mr_headers_app_v

87: --check whether the given mr exists
88: CURSOR check_mr_exists(c_mr_header_id number)
89: IS
90: SELECT mr_header_id
91: FROM ahl_mr_headers_app_v
92: WHERE mr_header_id = c_mr_header_id;
93: --check whether the given mr_effecitivity_id exists
94: CURSOR check_mr_effect(c_mr_effectivity_id number ,c_mr_header_id number)
95: IS

Line 1200: ahl_mr_headers_app_v MR,

1196: CURSOR get_mr_details_csr(c_instance_id NUMBER, c_mr_header_id NUMBER, c_components_flag VARCHAR2) IS
1197: SELECT A.mr_header_id, A.mr_effectivity_id, A.relationship_id, A.pc_node_id, A.inventory_item_id,
1198: cir.object_id, cir.subject_id, cir.position_reference
1199: FROM ahl_mr_effectivities A,
1200: ahl_mr_headers_app_v MR,
1201: (select cir2.object_id,
1202: cii2.instance_id subject_id,
1203: nvl(uc.master_config_id, cir2.position_reference) position_reference,
1204: 0 depth

Line 1230: 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)

1226: AND cir.subject_id = cii.instance_id
1227: AND MR.mr_status_code = 'COMPLETE'
1228: AND MR.program_type_code NOT IN ('MO_PROC') -- added in R12
1229: AND SYSDATE between trunc(MR.effective_from) and trunc(nvl(MR.effective_to,SYSDATE+1))
1230: 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)
1231: AND (A.inventory_item_id = cii.inventory_item_id OR
1232: (A.inventory_item_id IS NULL AND A.relationship_id IS NOT NULL AND
1233: AHL_FMP_PVT.Instance_Matches_Path_Pos(cii.instance_id,A.relationship_id) = 'T'))
1234: ORDER BY cir.depth, cir.subject_id; -- depth, subject_id

Line 1279: FROM ahl_mr_headers_app_v MR, cir,

1275: -- cir.object_id,
1276: cir.subject_id,
1277: --cir.position_reference ,
1278: cir.depth
1279: FROM ahl_mr_headers_app_v MR, cir,
1280: ahl_mr_effectivities A
1281: WHERE A.mr_header_id = NVL(c_mr_header_id, A.mr_header_id)
1282: AND MR.mr_header_id = A.mr_header_id
1283: AND MR.mr_status_code = 'COMPLETE'

Line 1287: from ahl_mr_headers_app_v MRM

1283: AND MR.mr_status_code = 'COMPLETE'
1284: AND MR.program_type_code NOT IN ('MO_PROC') -- added in R12
1285: AND SYSDATE between trunc(MR.effective_from) and trunc(nvl(MR.effective_to,SYSDATE+1))
1286: AND MR.version_number in (SELECT max(MRM.version_number)
1287: from ahl_mr_headers_app_v MRM
1288: where SYSDATE between trunc(MR.effective_from)
1289: and trunc(nvl(MR.effective_to,SYSDATE+1))
1290: and title=mr.title and mr_status_code='COMPLETE'
1291: group by MRM.title)

Line 1303: FROM ahl_mr_headers_app_v MR, ahl_mc_path_positions mcp,

1299: --cir.object_id,
1300: cir.subject_id,
1301: --cir.position_reference,
1302: cir.depth
1303: FROM ahl_mr_headers_app_v MR, ahl_mc_path_positions mcp,
1304: --ahl_mc_headers_b hdr, ahl_mc_relationships rel,
1305: cir, ahl_mr_effectivities A
1306: WHERE A.mr_header_id = NVL(c_mr_header_id, A.mr_header_id)
1307: AND MR.mr_header_id = A.mr_header_id

Line 1313: from ahl_mr_headers_app_v MRM

1309: AND MR.program_type_code NOT IN ('MO_PROC') -- added in R12
1310: AND SYSDATE between trunc(MR.effective_from)
1311: AND trunc(nvl(MR.effective_to,SYSDATE+1))
1312: AND MR.version_number in (SELECT max(MRM.version_number)
1313: from ahl_mr_headers_app_v MRM
1314: where SYSDATE between trunc(MR.effective_from)
1315: and trunc(nvl(MR.effective_to,SYSDATE+1))
1316: and title=mr.title and mr_status_code='COMPLETE'
1317: group by MRM.title)

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

1353: WHERE A.mr_header_id = NVL(c_mr_header_id, A.mr_header_id)
1354: AND ii.instance_id = cir.subject_id
1355: AND A.inventory_item_id = ii.inventory_item_id
1356: AND A.relationship_id is null
1357: AND exists (SELECT 'x' from ahl_mr_headers_app_v MR
1358: WHERE MR.mr_header_id = A.mr_header_id
1359: AND MR.program_type_code NOT IN ('MO_PROC') -- added in R12
1360: AND MR.version_number in (SELECT max(MRM.version_number)
1361: FROM ahl_mr_headers_app_v MRM

Line 1361: FROM ahl_mr_headers_app_v MRM

1357: AND exists (SELECT 'x' from ahl_mr_headers_app_v MR
1358: WHERE MR.mr_header_id = A.mr_header_id
1359: AND MR.program_type_code NOT IN ('MO_PROC') -- added in R12
1360: AND MR.version_number in (SELECT max(MRM.version_number)
1361: FROM ahl_mr_headers_app_v MRM
1362: WHERE mrm.title = mr.title
1363: AND SYSDATE between trunc(MR.effective_from)
1364: AND trunc(nvl(MR.effective_to,SYSDATE+1))
1365: AND mr_status_code='COMPLETE'

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

1384: WHERE ii.instance_id = c_instance_id
1385: AND A.mr_header_id = NVL(c_mr_header_id, A.mr_header_id)
1386: AND A.inventory_item_id = ii.inventory_item_id
1387: AND A.relationship_id is null
1388: AND exists (SELECT 'x' from ahl_mr_headers_app_v MR
1389: WHERE MR.mr_header_id = A.mr_header_id
1390: AND MR.program_type_code NOT IN ('MO_PROC') -- added in R12
1391: AND MR.version_number in (SELECT max(MRM.version_number)
1392: FROM ahl_mr_headers_app_v MRM

Line 1392: FROM ahl_mr_headers_app_v MRM

1388: AND exists (SELECT 'x' from ahl_mr_headers_app_v MR
1389: WHERE MR.mr_header_id = A.mr_header_id
1390: AND MR.program_type_code NOT IN ('MO_PROC') -- added in R12
1391: AND MR.version_number in (SELECT max(MRM.version_number)
1392: FROM ahl_mr_headers_app_v MRM
1393: WHERE mrm.title = mr.title
1394: AND SYSDATE between trunc(MR.effective_from)
1395: AND trunc(nvl(MR.effective_to,SYSDATE+1))
1396: AND mr_status_code='COMPLETE'

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

1416: AND A.relationship_id IS NOT NULL
1417: AND aai.position_id = A.relationship_id
1418: AND aai.csi_item_instance_id = cii.instance_id
1419: AND nvl(A.inventory_item_id,cii.inventory_item_id) = cii.inventory_item_id
1420: AND exists (SELECT 'x' from ahl_mr_headers_app_v MR
1421: WHERE MR.mr_header_id = A.mr_header_id
1422: AND MR.program_type_code NOT IN ('MO_PROC') -- added in R12
1423: AND MR.version_number in (SELECT max(MRM.version_number)
1424: FROM ahl_mr_headers_app_v MRM

Line 1424: FROM ahl_mr_headers_app_v MRM

1420: AND exists (SELECT 'x' from ahl_mr_headers_app_v MR
1421: WHERE MR.mr_header_id = A.mr_header_id
1422: AND MR.program_type_code NOT IN ('MO_PROC') -- added in R12
1423: AND MR.version_number in (SELECT max(MRM.version_number)
1424: FROM ahl_mr_headers_app_v MRM
1425: WHERE mrm.title = mr.title
1426: AND SYSDATE between trunc(MR.effective_from)
1427: AND trunc(nvl(MR.effective_to,SYSDATE+1))
1428: AND mr_status_code='COMPLETE'

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

1435: /* 12 Jul 08: Modified for performance.
1436: CURSOR get_visit_mr_details_csr(c_instance_id NUMBER, c_visit_type_code VARCHAR2) IS
1437: SELECT A.mr_header_id, A.mr_effectivity_id, A.relationship_id, A.pc_node_id, A.inventory_item_id,
1438: cir.object_id, cir.subject_id, cir.position_reference
1439: FROM ahl_mr_effectivities A, ahl_mr_headers_app_v MR, ahl_mr_visit_types vis,
1440: (select cir2.object_id,
1441: cii2.instance_id subject_id,
1442: nvl(uc.master_config_id, cir2.position_reference) position_reference,
1443: 0 depth

Line 1459: 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)

1455: AND cir.subject_id = cii.instance_id
1456: AND MR.mr_status_code = 'COMPLETE'
1457: AND MR.program_type_code NOT IN ('MO_PROC') -- added in R12
1458: AND SYSDATE between trunc(MR.effective_from) and trunc(nvl(MR.effective_to,SYSDATE+1))
1459: 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)
1460: AND (A.inventory_item_id = cii.inventory_item_id OR
1461: (A.inventory_item_id IS NULL AND A.relationship_id IS NOT NULL AND
1462: AHL_FMP_PVT.Instance_Matches_Path_Pos(cii.instance_id,A.relationship_id) = 'T'))
1463: ORDER BY cir.depth, cir.subject_id; -- depth, subject_id

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

1486: --cir.object_id,
1487: cir.subject_id,
1488: --cir.position_reference ,
1489: cir.depth
1490: FROM ahl_mr_headers_app_v MR, ahl_mr_visit_types vis, cir,
1491: ahl_mr_effectivities A
1492: WHERE MR.mr_header_id = A.mr_header_id
1493: AND A.mr_header_id = vis.mr_header_id
1494: AND vis.mr_visit_type_code = c_visit_type_code

Line 1499: from ahl_mr_headers_app_v MRM

1495: AND MR.mr_status_code = 'COMPLETE'
1496: AND MR.program_type_code NOT IN ('MO_PROC') -- added in R12
1497: AND SYSDATE between trunc(MR.effective_from) and trunc(nvl(MR.effective_to,SYSDATE+1))
1498: AND MR.version_number in (SELECT max(MRM.version_number)
1499: from ahl_mr_headers_app_v MRM
1500: where SYSDATE between trunc(MR.effective_from)
1501: and trunc(nvl(MR.effective_to,SYSDATE+1))
1502: and title=mr.title and mr_status_code='COMPLETE'
1503: group by MRM.title)

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

1511: --cir.object_id,
1512: cir.subject_id,
1513: --cir.position_reference,
1514: cir.depth
1515: FROM ahl_mr_headers_app_v MR, ahl_mr_visit_types vis, ahl_mc_path_positions mcp,
1516: --ahl_mc_headers_b hdr, ahl_mc_relationships rel,
1517: cir, ahl_mr_effectivities A
1518: WHERE MR.mr_header_id = A.mr_header_id
1519: AND A.mr_header_id = vis.mr_header_id

Line 1526: from ahl_mr_headers_app_v MRM

1522: AND MR.program_type_code NOT IN ('MO_PROC') -- added in R12
1523: AND SYSDATE between trunc(MR.effective_from)
1524: AND trunc(nvl(MR.effective_to,SYSDATE+1))
1525: AND MR.version_number in (SELECT max(MRM.version_number)
1526: from ahl_mr_headers_app_v MRM
1527: where SYSDATE between trunc(MR.effective_from)
1528: and trunc(nvl(MR.effective_to,SYSDATE+1))
1529: and title=mr.title and mr_status_code='COMPLETE'
1530: group by MRM.title)

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

1567: AND vis.mr_visit_type_code = c_visit_type_code
1568: AND cir.subject_id = cii.instance_id
1569: AND A.inventory_item_id = cii.inventory_item_id
1570: AND A.relationship_id is null
1571: AND exists (SELECT 'x' from ahl_mr_headers_app_v MR
1572: WHERE MR.mr_header_id = A.mr_header_id
1573: AND MR.program_type_code NOT IN ('MO_PROC') -- added in R12
1574: AND MR.version_number in (SELECT max(MRM.version_number)
1575: FROM ahl_mr_headers_app_v MRM

Line 1575: FROM ahl_mr_headers_app_v MRM

1571: AND exists (SELECT 'x' from ahl_mr_headers_app_v MR
1572: WHERE MR.mr_header_id = A.mr_header_id
1573: AND MR.program_type_code NOT IN ('MO_PROC') -- added in R12
1574: AND MR.version_number in (SELECT max(MRM.version_number)
1575: FROM ahl_mr_headers_app_v MRM
1576: WHERE mrm.title = mr.title
1577: AND SYSDATE between trunc(MR.effective_from)
1578: AND trunc(nvl(MR.effective_to,SYSDATE+1))
1579: AND mr_status_code='COMPLETE'

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

1599: AND vis.mr_visit_type_code = c_visit_type_code
1600: AND cii.instance_id = c_instance_id
1601: AND A.inventory_item_id = cii.inventory_item_id
1602: AND A.relationship_id is null
1603: AND exists (SELECT 'x' from ahl_mr_headers_app_v MR
1604: WHERE MR.mr_header_id = A.mr_header_id
1605: AND MR.program_type_code NOT IN ('MO_PROC') -- added in R12
1606: AND MR.version_number in (SELECT max(MRM.version_number)
1607: FROM ahl_mr_headers_app_v MRM

Line 1607: FROM ahl_mr_headers_app_v MRM

1603: AND exists (SELECT 'x' from ahl_mr_headers_app_v MR
1604: WHERE MR.mr_header_id = A.mr_header_id
1605: AND MR.program_type_code NOT IN ('MO_PROC') -- added in R12
1606: AND MR.version_number in (SELECT max(MRM.version_number)
1607: FROM ahl_mr_headers_app_v MRM
1608: WHERE mrm.title = mr.title
1609: AND SYSDATE between trunc(MR.effective_from)
1610: AND trunc(nvl(MR.effective_to,SYSDATE+1))
1611: AND mr_status_code='COMPLETE'

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

1630: AND vis.mr_visit_type_code = c_visit_type_code
1631: AND A.relationship_id IS NOT NULL
1632: AND aai.position_id = A.relationship_id
1633: AND nvl(A.inventory_item_id, cii.inventory_item_id) = cii.inventory_item_id
1634: AND exists (SELECT 'x' from ahl_mr_headers_app_v MR
1635: WHERE MR.mr_header_id = A.mr_header_id
1636: AND MR.program_type_code NOT IN ('MO_PROC') -- added in R12
1637: AND MR.version_number in (SELECT max(MRM.version_number)
1638: FROM ahl_mr_headers_app_v MRM

Line 1638: FROM ahl_mr_headers_app_v MRM

1634: AND exists (SELECT 'x' from ahl_mr_headers_app_v MR
1635: WHERE MR.mr_header_id = A.mr_header_id
1636: AND MR.program_type_code NOT IN ('MO_PROC') -- added in R12
1637: AND MR.version_number in (SELECT max(MRM.version_number)
1638: FROM ahl_mr_headers_app_v MRM
1639: WHERE mrm.title = mr.title
1640: AND SYSDATE between trunc(MR.effective_from)
1641: AND trunc(nvl(MR.effective_to,SYSDATE+1))
1642: AND mr_status_code='COMPLETE'

Line 1655: and exists (SELECT 'x' from ahl_mr_headers_app_v MR

1651: SELECT 'x' from dual
1652: WHERE exists (select 'x'
1653: from ahl_mr_effectivities mre
1654: where mre.relationship_id is not null
1655: and exists (SELECT 'x' from ahl_mr_headers_app_v MR
1656: WHERE MR.mr_header_id = mre.mr_header_id
1657: AND MR.program_type_code NOT IN ('MO_PROC') -- added in R12
1658: AND MR.version_number in (SELECT max(MRM.version_number)
1659: FROM ahl_mr_headers_app_v MRM

Line 1659: FROM ahl_mr_headers_app_v MRM

1655: and exists (SELECT 'x' from ahl_mr_headers_app_v MR
1656: WHERE MR.mr_header_id = mre.mr_header_id
1657: AND MR.program_type_code NOT IN ('MO_PROC') -- added in R12
1658: AND MR.version_number in (SELECT max(MRM.version_number)
1659: FROM ahl_mr_headers_app_v MRM
1660: WHERE mrm.title = mr.title
1661: AND SYSDATE between trunc(MR.effective_from)
1662: AND trunc(nvl(MR.effective_to,SYSDATE+1))
1663: AND mr_status_code='COMPLETE'

Line 1677: and exists (SELECT 'x' from ahl_mr_headers_app_v MR

1673: from ahl_mr_effectivities mre, ahl_mr_visit_types vis
1674: where vis.mr_visit_type_code = p_visit_type_code
1675: and mre.mr_header_id = vis.mr_header_id
1676: and mre.relationship_id is not null
1677: and exists (SELECT 'x' from ahl_mr_headers_app_v MR
1678: WHERE MR.mr_header_id = vis.mr_header_id
1679: AND MR.program_type_code NOT IN ('MO_PROC') -- added in R12
1680: AND MR.version_number in (SELECT max(MRM.version_number)
1681: FROM ahl_mr_headers_app_v MRM

Line 1681: FROM ahl_mr_headers_app_v MRM

1677: and exists (SELECT 'x' from ahl_mr_headers_app_v MR
1678: WHERE MR.mr_header_id = vis.mr_header_id
1679: AND MR.program_type_code NOT IN ('MO_PROC') -- added in R12
1680: AND MR.version_number in (SELECT max(MRM.version_number)
1681: FROM ahl_mr_headers_app_v MRM
1682: WHERE mrm.title = mr.title
1683: AND SYSDATE between trunc(MR.effective_from)
1684: AND trunc(nvl(MR.effective_to,SYSDATE+1))
1685: AND mr_status_code='COMPLETE'

Line 3005: FROM ahl_mr_headers_app_v

3001: SELECT repetitive_flag,
3002: show_repetitive_code,
3003: whichever_first_code,
3004: implement_status_code
3005: FROM ahl_mr_headers_app_v
3006: WHERE mr_header_id = c_mr_header_id;
3007: l_get_mr_attri get_mr_attri%ROWTYPE;
3008: l_debug VARCHAR2(1) :=AHL_DEBUG_PUB.is_log_enabled;
3009: BEGIN