APPS.AHL_UMP_PROCESSUNIT_PVT dependencies on AHL_MR_EFFECTIVITIES

Line 1316: from ahl_mr_effectivities me, ahl_mr_headers_app_v mr

1312: CURSOR csi_pm_instance_csr IS
1313: SELECT min(instance_id), max(instance_id)
1314: FROM csi_item_instances csi,
1315: (select me.inventory_item_id
1316: from ahl_mr_effectivities me, ahl_mr_headers_app_v mr
1317: where mr.mr_header_id = me.mr_header_id
1318: and mr.type_code = 'PROGRAM') mre
1319: WHERE trunc(nvl(active_start_date, sysdate)) <= trunc(sysdate) AND
1320: trunc(sysdate) < trunc(nvl(active_end_date, sysdate+1))

Line 3590: FROM ahl_applicable_mrs mr, ahl_mr_effectivities eff

3586: -- Read all effectivities for the mr and item instance.
3587: CURSOR ahl_applicable_csr (p_instance_id IN NUMBER,
3588: p_mr_header_id IN NUMBER) IS
3589: SELECT DISTINCT mr.mr_effectivity_id, threshold_date
3590: FROM ahl_applicable_mrs mr, ahl_mr_effectivities eff
3591: WHERE mr.mr_effectivity_id = eff.mr_effectivity_id AND
3592: csi_item_instance_id = p_instance_id AND
3593: mr.mr_header_id = p_mr_header_id;
3594:

Line 6905: FROM ahl_mr_effectivities

6901: -- get details of program effectivity.
6902: CURSOR ahl_program_eff_csr (p_mr_effectivity_id IN NUMBER) IS
6903: SELECT mr_effectivity_id, program_duration, program_duration_uom_code,
6904: threshold_date
6905: FROM ahl_mr_effectivities
6906: where mr_effectivity_id = p_mr_effectivity_id;
6907:
6908: -- get all intervals for an effectivity.
6909: CURSOR ahl_mr_interval_csr (p_mr_effectivity_id IN NUMBER) IS

Line 10195: FROM ahl_mr_effectivities_app_v

10191: --get all the MR effectivity definitions for a given MR
10192: CURSOR get_mr_effect(c_mr_header_id NUMBER)
10193: IS
10194: SELECT mr_header_id, mr_effectivity_id, inventory_item_id
10195: FROM ahl_mr_effectivities_app_v
10196: WHERE mr_header_id = c_mr_header_id;
10197:
10198: -- get master org id.
10199: CURSOR get_master_org_id_csr (c_inventory_item_id IN NUMBER)

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

10221: c_start_inst_id IN NUMBER,
10222: c_end_inst_id IN NUMBER)
10223: IS
10224: SELECT cii.instance_id
10225: FROM csi_item_instances cii, ahl_mr_effectivities mre, mtl_system_items_b msi
10226: WHERE cii.inventory_item_id = msi.inventory_item_id
10227: AND cii.inv_master_organization_id = msi.organization_id
10228: AND cii.inventory_item_id = mre.inventory_item_id
10229: AND mre.mr_header_id = p_mr_header_id

Line 10483: FROM csi_item_instances csi, ahl_mr_effectivities me

10479: cursor csi_inst_count_csr (p_start_inst_id in number,
10480: p_end_inst_id in number,
10481: p_mr_header_id in number) IS
10482: SELECT count(instance_id)
10483: FROM csi_item_instances csi, ahl_mr_effectivities me
10484: WHERE csi.instance_id >= p_start_inst_id and csi.instance_id <= p_end_inst_id
10485: AND csi.inventory_item_id = me.inventory_item_id
10486: AND me.mr_header_id = p_mr_header_id
10487: AND SYSDATE between trunc(nvl(active_start_date,sysdate)) and

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

10674: c_start_inst_id IN NUMBER,
10675: c_end_inst_id IN NUMBER)
10676: IS
10677: SELECT cii.instance_id
10678: FROM csi_item_instances cii, ahl_mr_effectivities mre, mtl_system_items_b msi
10679: -- repalced mtl_system_items_kfv with mtl_system items_b.
10680: WHERE cii.inventory_item_id = msi.inventory_item_id
10681: AND cii.inv_master_organization_id = msi.organization_id
10682: AND cii.inventory_item_id = mre.inventory_item_id

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

10690: CURSOR get_all_inst( c_start_inst_id IN NUMBER,
10691: c_end_inst_id IN NUMBER)
10692: IS
10693: SELECT cii.instance_id
10694: FROM csi_item_instances cii, ahl_mr_effectivities mre, mtl_system_items_b msi,
10695: (select mr_header_id
10696: from ahl_mr_headers_app_v
10697: where type_code = 'PROGRAM') mr
10698: WHERE cii.inventory_item_id = msi.inventory_item_id

Line 11186: FROM csi_item_instances cii, ahl_mr_effectivities mre

11182: trunc(nvl(parent.active_start_date, sysdate)) <= trunc(sysdate) and
11183: trunc(sysdate) < trunc(nvl(parent.active_end_date, sysdate+1))
11184: ) Root_instance_id
11185:
11186: FROM csi_item_instances cii, ahl_mr_effectivities mre
11187: WHERE mre.inventory_item_id = nvl(null, mre.inventory_item_id)
11188: AND mre.mr_header_id = nvl(null,mre.mr_header_id)
11189: -- added nvl conditions above as this seems to force use of index on
11190: -- ahl_mr_headers_b and also brings query cost down.

Line 11265: from ahl_mr_headers_app_v mr, ahl_mr_effectivities me

11261: ) Root_instance_id
11262:
11263: FROM csi_item_instances cii,
11264: (select distinct me.inventory_item_id
11265: from ahl_mr_headers_app_v mr, ahl_mr_effectivities me
11266: where mr.mr_header_id = me.mr_header_id AND
11267: mr.mr_status_code = 'COMPLETE' AND
11268: MR.program_type_code NOT IN ('MO_PROC') AND -- added in R12
11269: trunc(effective_from) <= trunc(sysdate) AND