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 97: FROM ahl_mr_effectivities_app_v

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
96: SELECT mr_header_id, mr_effectivity_id, inventory_item_id,relationship_id, pc_node_id
97: FROM ahl_mr_effectivities_app_v
98: WHERE mr_effectivity_id = NVL(c_mr_effectivity_id,mr_effectivity_id)
99: AND mr_header_id = c_mr_header_id;
100: l_mr_effect check_mr_effect%ROWTYPE;
101:

Line 108: FROM ahl_mr_effectivities_app_v

104: --all the mr_effectivity_id's for the given MR).
105: CURSOR get_mr_effect(c_mr_header_id NUMBER, c_mr_effectivity_id NUMBER)
106: IS
107: SELECT mr_header_id, mr_effectivity_id, inventory_item_id,relationship_id, pc_node_id
108: FROM ahl_mr_effectivities_app_v
109: WHERE mr_header_id = c_mr_header_id
110: AND mr_effectivity_id = NVL(c_mr_effectivity_id, mr_effectivity_id);
111: --get distinct item instances from the global temporary table
112: CURSOR get_dist_inst

Line 1199: FROM ahl_mr_effectivities A,

1195: --- Performance Changes bug - 6138653
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,

Line 1280: ahl_mr_effectivities A

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'
1284: AND MR.program_type_code NOT IN ('MO_PROC') -- added in R12

Line 1305: cir, ahl_mr_effectivities A

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
1308: AND MR.mr_status_code = 'COMPLETE'
1309: AND MR.program_type_code NOT IN ('MO_PROC') -- added in R12

Line 1352: ahl_mr_effectivities A

1348: AND relationship_type_code = 'COMPONENT-OF'
1349: AND SYSDATE between trunc(nvl(active_start_date,sysdate))
1350: AND trunc(NVL(active_end_date,sysdate+1))
1351: ) cir, csi_item_instances ii,
1352: ahl_mr_effectivities A
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

Line 1383: ahl_mr_effectivities A

1379: AND ciea1.attribute_level = 'GLOBAL') mfg_date,
1380: ii.serial_number --,
1381: --(SELECT 'Y' from ahl_mr_effectivity_dtls where mr_effectivity_id = a.mr_effectivity_id and ROWNUM < 2) eff_dtls_flag
1382: FROM csi_item_instances ii,
1383: ahl_mr_effectivities A
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

Line 1414: ahl_mr_effectivities A

1410: AND ciea1.attribute_level = 'GLOBAL') mfg_date,
1411: cii.serial_number --,
1412: --(SELECT 'Y' from ahl_mr_effectivity_dtls where mr_effectivity_id = a.mr_effectivity_id and ROWNUM < 2) eff_dtls_flag
1413: FROM ahl_applicable_instances aai,csi_item_instances cii,
1414: ahl_mr_effectivities A
1415: WHERE A.mr_header_id = NVL(c_mr_header_id, A.mr_header_id)
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

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 1491: ahl_mr_effectivities A

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
1495: AND MR.mr_status_code = 'COMPLETE'

Line 1517: cir, ahl_mr_effectivities A

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
1520: AND vis.mr_visit_type_code = c_visit_type_code
1521: AND MR.mr_status_code = 'COMPLETE'

Line 1565: ahl_mr_effectivities A

1561: AND relationship_type_code = 'COMPONENT-OF'
1562: AND SYSDATE between trunc(nvl(active_start_date,sysdate))
1563: AND trunc(NVL(active_end_date,sysdate+1))
1564: ) cir, csi_item_instances cii, ahl_mr_visit_types vis,
1565: ahl_mr_effectivities A
1566: WHERE A.mr_header_id = vis.mr_header_id
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

Line 1597: ahl_mr_effectivities A

1593: AND ciea1.attribute_level(+) = 'GLOBAL') mfg_date,
1594: cii.serial_number --,
1595: --(SELECT 'Y' from ahl_mr_effectivity_dtls where mr_effectivity_id = a.mr_effectivity_id and ROWNUM < 2) eff_dtls_flag
1596: FROM csi_item_instances cii,ahl_mr_visit_types vis,
1597: ahl_mr_effectivities A
1598: WHERE A.mr_header_id = vis.mr_header_id
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

Line 1628: ahl_mr_effectivities A

1624: AND ciea1.attribute_level = 'GLOBAL') mfg_date,
1625: cii.serial_number --,
1626: --(SELECT 'Y' from ahl_mr_effectivity_dtls where mr_effectivity_id = a.mr_effectivity_id and ROWNUM < 2) eff_dtls_flag
1627: FROM ahl_applicable_instances aai,csi_item_instances cii,ahl_mr_visit_types vis,
1628: ahl_mr_effectivities A
1629: WHERE A.mr_header_id = vis.mr_header_id
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

Line 1653: from ahl_mr_effectivities mre

1649: -- check for path position based effectivities.
1650: CURSOR relationship_csr IS
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

Line 1673: from ahl_mr_effectivities mre, ahl_mr_visit_types vis

1669: -- check for path position based effectivities for visit type
1670: CURSOR relationship_vtype_csr(p_visit_type_code IN VARCHAR2) IS
1671: SELECT 'x' from dual
1672: WHERE exists (select 'x'
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

Line 1694: from ahl_mr_effectivities

1690: -- check for path position based effectivities for MR
1691: CURSOR relationship_mr_csr(p_mr_header_id IN NUMBER) IS
1692: SELECT 'x' from dual
1693: WHERE exists (select 'x'
1694: from ahl_mr_effectivities
1695: where mr_header_id = p_mr_header_id
1696: and relationship_id is not null);
1697:
1698:

Line 1743: FROM ahl_mr_effectivities

1739:
1740: /* not used
1741: CURSOR is_position_check_req(c_mr_effectivity_id NUMBER) IS
1742: SELECT 'X'
1743: FROM ahl_mr_effectivities
1744: WHERE mr_effectivity_id = c_mr_effectivity_id
1745: AND inventory_item_id IS NOT NULL;
1746: */
1747:

Line 2988: FROM ahl_mr_effectivities_app_v

2984: l_unique_mr_headers_tbl unique_mr_headers_tbl_type;
2985: */
2986: CURSOR get_applicable_mrs(c_inventory_item_id NUMBER) IS
2987: SELECT mr_header_id, mr_effectivity_id
2988: FROM ahl_mr_effectivities_app_v
2989: WHERE inventory_item_id = c_inventory_item_id
2990: ORDER BY mr_header_id, mr_effectivity_id;
2991:
2992: /*