DBA Data[Home] [Help]

APPS.AHL_UC_INSTANCE_PVT dependencies on MO_GLOBAL

Line 4699: AND NVL(ood.operating_unit, mo_global.get_current_org_id()) = mo_global.get_current_org_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())
4700: AND C.inv_locator_id IN (
4701: SELECT
4702: ILOC.inventory_location_id
4703: FROM

Line 4813: AND NVL(ood.operating_unit, mo_global.get_current_org_id()) = mo_global.get_current_org_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())
4814: AND C.inv_locator_id IN (
4815: SELECT
4816: ILOC.inventory_location_id
4817: FROM

Line 5480: NVL(io.operating_unit, mo_global.get_current_org_id()) =

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()
5482: )
5483: --Plus those units could be installed
5484: UNION ALL

Line 5481: mo_global.get_current_org_id()

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()
5482: )
5483: --Plus those units could be installed
5484: UNION ALL
5485: SELECT

Line 5593: NVL(io.operating_unit, mo_global.get_current_org_id()) =

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()
5595: )
5596: AND ahl_util_uc_pkg.IS_UNIT_QUARANTINED(U.uc_header_id , null) =
5597: FND_API.G_FALSE

Line 5594: mo_global.get_current_org_id()

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()
5595: )
5596: AND ahl_util_uc_pkg.IS_UNIT_QUARANTINED(U.uc_header_id , null) =
5597: FND_API.G_FALSE
5598: ORDER BY 2;