APPS.AHL_UMP_PROCESSUNIT_PVT dependencies on MTL_SYSTEM_ITEMS_B

Line 11811: FROM mtl_system_items_b itm, mtl_parameters mtl

11807: -- get master org id.
11808: CURSOR get_master_org_id_csr (c_inventory_item_id IN NUMBER)
11809: IS
11810: SELECT itm.organization_id
11811: FROM mtl_system_items_b itm, mtl_parameters mtl
11812: WHERE itm.inventory_item_id = c_inventory_item_id
11813: AND itm.organization_id = mtl.organization_id
11814: AND mtl.master_organization_id = mtl.organization_id;
11815:

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

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