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_UMP_PROCESSUNIT_PVT dependencies on AHL_MR_EFFECTIVITIES

Line 1505: from ahl_mr_effectivities me, ahl_mr_headers_app_v mr

1501: CURSOR csi_pm_instance_csr IS
1502: SELECT min(instance_id), max(instance_id)
1503: FROM csi_item_instances csi,
1504: (select me.inventory_item_id
1505: from ahl_mr_effectivities me, ahl_mr_headers_app_v mr
1506: where mr.mr_header_id = me.mr_header_id
1507: and mr.type_code = 'PROGRAM') mre
1508: WHERE trunc(nvl(active_start_date, sysdate)) <= trunc(sysdate) AND
1509: trunc(sysdate) < trunc(nvl(active_end_date, sysdate+1))

Line 4606: FROM ahl_applicable_mrs mr, ahl_mr_effectivities eff

4602: -- JKJain, NR Analysis and Forecasting
4603: CURSOR ahl_applicable_csr (p_instance_id IN NUMBER,
4604: p_mr_header_id IN NUMBER) IS
4605: SELECT DISTINCT mr.mr_effectivity_id, threshold_date,eff.fleet_header_id
4606: FROM ahl_applicable_mrs mr, ahl_mr_effectivities eff
4607: WHERE mr.mr_effectivity_id = eff.mr_effectivity_id AND
4608: csi_item_instance_id = p_instance_id AND
4609: mr.mr_header_id = p_mr_header_id;
4610:

Line 8375: FROM ahl_mr_effectivities

8371: -- get details of program effectivity.
8372: CURSOR ahl_program_eff_csr (p_mr_effectivity_id IN NUMBER) IS
8373: SELECT mr_effectivity_id, program_duration, program_duration_uom_code,
8374: threshold_date
8375: FROM ahl_mr_effectivities
8376: where mr_effectivity_id = p_mr_effectivity_id;
8377:
8378: -- get all intervals for an effectivity.
8379: CURSOR ahl_mr_interval_csr (p_mr_effectivity_id IN NUMBER) IS

Line 11804: FROM ahl_mr_effectivities_app_v

11800: --get all the MR effectivity definitions for a given MR
11801: CURSOR get_mr_effect(c_mr_header_id NUMBER)
11802: IS
11803: SELECT mr_header_id, mr_effectivity_id, inventory_item_id
11804: FROM ahl_mr_effectivities_app_v
11805: WHERE mr_header_id = c_mr_header_id;
11806:
11807: -- get master org id.
11808: CURSOR get_master_org_id_csr (c_inventory_item_id IN NUMBER)

Line 11834: FROM csi_item_instances cii, ahl_mr_effectivities mre, mtl_system_items_b msi

11830: c_start_inst_id IN NUMBER,
11831: c_end_inst_id IN NUMBER)
11832: IS
11833: SELECT cii.instance_id
11834: FROM csi_item_instances cii, ahl_mr_effectivities mre, mtl_system_items_b msi
11835: WHERE cii.inventory_item_id = msi.inventory_item_id
11836: AND cii.inv_master_organization_id = msi.organization_id
11837: AND cii.inventory_item_id = mre.inventory_item_id
11838: AND mre.mr_header_id = p_mr_header_id

Line 12092: FROM csi_item_instances csi, ahl_mr_effectivities me

12088: cursor csi_inst_count_csr (p_start_inst_id in number,
12089: p_end_inst_id in number,
12090: p_mr_header_id in number) IS
12091: SELECT count(instance_id)
12092: FROM csi_item_instances csi, ahl_mr_effectivities me
12093: WHERE csi.instance_id >= p_start_inst_id and csi.instance_id <= p_end_inst_id
12094: AND csi.inventory_item_id = me.inventory_item_id
12095: AND me.mr_header_id = p_mr_header_id
12096: AND SYSDATE between trunc(nvl(active_start_date,sysdate)) and

Line 12287: FROM csi_item_instances cii, ahl_mr_effectivities mre, mtl_system_items_b msi

12283: c_start_inst_id IN NUMBER,
12284: c_end_inst_id IN NUMBER)
12285: IS
12286: SELECT cii.instance_id
12287: FROM csi_item_instances cii, ahl_mr_effectivities mre, mtl_system_items_b msi
12288: -- repalced mtl_system_items_kfv with mtl_system items_b.
12289: WHERE cii.inventory_item_id = msi.inventory_item_id
12290: AND cii.inv_master_organization_id = msi.organization_id
12291: AND cii.inventory_item_id = mre.inventory_item_id

Line 12303: FROM csi_item_instances cii, ahl_mr_effectivities mre, mtl_system_items_b msi,

12299: CURSOR get_all_inst( c_start_inst_id IN NUMBER,
12300: c_end_inst_id IN NUMBER)
12301: IS
12302: SELECT cii.instance_id
12303: FROM csi_item_instances cii, ahl_mr_effectivities mre, mtl_system_items_b msi,
12304: (select mr_header_id
12305: from ahl_mr_headers_app_v
12306: where type_code = 'PROGRAM') mr
12307: WHERE cii.inventory_item_id = msi.inventory_item_id

Line 12873: FROM csi_item_instances cii, ahl_mr_effectivities mre

12869: trunc(nvl(parent.active_start_date, sysdate)) <= trunc(sysdate) and
12870: trunc(sysdate) < trunc(nvl(parent.active_end_date, sysdate+1))
12871: ) Root_instance_id
12872:
12873: FROM csi_item_instances cii, ahl_mr_effectivities mre
12874: WHERE mre.inventory_item_id = nvl(null, mre.inventory_item_id)
12875: AND mre.mr_header_id = nvl(null,mre.mr_header_id)
12876: -- added nvl conditions above as this seems to force use of index on
12877: -- ahl_mr_headers_b and also brings query cost down.

Line 12952: from ahl_mr_headers_app_v mr, ahl_mr_effectivities me

12948: ) Root_instance_id
12949:
12950: FROM csi_item_instances cii,
12951: (select distinct me.inventory_item_id
12952: from ahl_mr_headers_app_v mr, ahl_mr_effectivities me
12953: where mr.mr_header_id = me.mr_header_id AND
12954: mr.mr_status_code = 'COMPLETE' AND
12955: MR.program_type_code NOT IN ('MO_PROC') AND -- added in R12
12956: trunc(effective_from) <= trunc(sysdate) AND

Line 13016: from ahl_mr_headers_app_v mr, ahl_mr_effectivities me

13012: CURSOR chk_expire_inst_csr IS
13013: SELECT cii.instance_id
13014: FROM csi_item_instances cii,
13015: (select distinct me.inventory_item_id
13016: from ahl_mr_headers_app_v mr, ahl_mr_effectivities me
13017: where mr.mr_header_id = me.mr_header_id AND
13018: mr.mr_status_code = 'COMPLETE' AND
13019: MR.program_type_code NOT IN ('MO_PROC') AND -- added in R12
13020: trunc(effective_from) <= trunc(sysdate) AND