DBA Data[Home] [Help]

APPS.AHL_UC_INSTANCE_PVT dependencies on MTL_PARAMETERS

Line 4695: FROM mtl_parameters mp, org_organization_definitions ood

4691: AND upper(M.concatenated_segments) LIKE nvl(c_item_number,'%')
4692: AND upper(C.instance_number) LIKE nvl(c_instance_number,'%')
4693: AND upper(nvl(C.serial_number, '%')) LIKE nvl(c_serial_number,'%')
4694: AND M.organization_id IN (SELECT mp.master_organization_id
4695: FROM mtl_parameters mp, org_organization_definitions ood
4696: WHERE mp.organization_Id = ood.organization_id
4697: -- jaramana on Feb 14, 2008
4698: -- Removed reference to CLIENT_INFO
4699: AND NVL(ood.operating_unit, mo_global.get_current_org_id()) = mo_global.get_current_org_id())

Line 4809: FROM mtl_parameters mp, org_organization_definitions ood

4805: AND upper(M.concatenated_segments) LIKE nvl(c_item_number,'%')
4806: AND upper(C.instance_number) LIKE nvl(c_instance_number,'%')
4807: AND upper(nvl(C.serial_number, '%')) LIKE nvl(c_serial_number,'%')
4808: AND M.organization_id IN (SELECT mp.master_organization_id
4809: FROM mtl_parameters mp, org_organization_definitions ood
4810: WHERE mp.organization_Id = ood.organization_id
4811: -- jaramana on Feb 14, 2008
4812: -- Removed reference to CLIENT_INFO
4813: AND NVL(ood.operating_unit, mo_global.get_current_org_id()) = mo_global.get_current_org_id())

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()