APPS.AHL_UMP_PROCESSUNIT_PVT dependencies on MTL_SYSTEM_ITEMS_B

Line 10202: FROM mtl_system_items_b itm, mtl_parameters mtl

10198: -- get master org id.
10199: CURSOR get_master_org_id_csr (c_inventory_item_id IN NUMBER)
10200: IS
10201: SELECT itm.organization_id
10202: FROM mtl_system_items_b itm, mtl_parameters mtl
10203: WHERE itm.inventory_item_id = c_inventory_item_id
10204: AND itm.organization_id = mtl.organization_id
10205: AND mtl.master_organization_id = mtl.organization_id;
10206:

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 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 10679: -- repalced mtl_system_items_kfv with mtl_system items_b.

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
10683: AND mre.mr_header_id = p_mr_header_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