APPS.AHL_UC_INSTANCE_PVT dependencies on INV_ORGANIZATION_INFO_V

Line 344: FROM inv_organization_info_v i, mtl_system_items_kfv m,

340: AND c.inv_master_organization_id = m.organization_id
341: AND m.organization_id = o.organization_id;
342: */
343: SELECT i.operating_unit
344: FROM inv_organization_info_v i, mtl_system_items_kfv m,
345: csi_item_instances c
346: WHERE c.instance_id = p_instance_id AND
347: c.inventory_item_id = m.inventory_item_id AND
348: c.inv_master_organization_id = m.organization_id AND

Line 5477: FROM mtl_parameters mp, inv_organization_info_v io

5473: AND upper(nvl(C.serial_number, '%')) LIKE c_serial_number
5474: AND EXISTS
5475: (
5476: SELECT 'X'
5477: FROM mtl_parameters mp, inv_organization_info_v io
5478: WHERE mp.master_organization_id = M.organization_id AND
5479: mp.organization_Id = io.organization_id AND
5480: NVL(io.operating_unit, mo_global.get_current_org_id()) =
5481: mo_global.get_current_org_id()

Line 5590: FROM mtl_parameters mp, inv_organization_info_v io

5586: AND upper(nvl(C.serial_number, '%')) LIKE c_serial_number
5587: AND EXISTS
5588: (
5589: SELECT 'X'
5590: FROM mtl_parameters mp, inv_organization_info_v io
5591: WHERE mp.master_organization_id = M.organization_id AND
5592: mp.organization_Id = io.organization_id AND
5593: NVL(io.operating_unit, mo_global.get_current_org_id()) =
5594: mo_global.get_current_org_id()