eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AHL_UC_INSTANCE_PVT dependencies on MTL_PARAMETERS

Line 4720: FROM mtl_parameters mp, org_organization_definitions ood

4716: -- SATHAPLI::Bug 9817209, 02-Jul-2010, changed the view ORG_ORGANIZATION_DEFINITIONS usage to
4717: -- view INV_ORGANIZATION_INFO_V instead
4718: /*
4719: AND M.organization_id IN (SELECT mp.master_organization_id
4720: FROM mtl_parameters mp, org_organization_definitions ood
4721: WHERE mp.organization_Id = ood.organization_id
4722: -- jaramana on Feb 14, 2008
4723: -- Removed reference to CLIENT_INFO
4724: AND NVL(ood.operating_unit, mo_global.get_current_org_id()) = mo_global.get_current_org_id())

Line 4728: FROM mtl_parameters mp, inv_organization_info_v io

4724: AND NVL(ood.operating_unit, mo_global.get_current_org_id()) = mo_global.get_current_org_id())
4725: */
4726: AND EXISTS (
4727: SELECT 'X'
4728: FROM mtl_parameters mp, inv_organization_info_v io
4729: WHERE mp.master_organization_id = M.organization_id AND
4730: mp.organization_Id = io.organization_id AND
4731: NVL(io.operating_unit, mo_global.get_current_org_id()) =
4732: mo_global.get_current_org_id()

Line 4859: FROM mtl_parameters mp, org_organization_definitions ood

4855: -- SATHAPLI::Bug 9817209, 02-Jul-2010, changed the view ORG_ORGANIZATION_DEFINITIONS usage to
4856: -- view INV_ORGANIZATION_INFO_V instead
4857: /*
4858: AND M.organization_id IN (SELECT mp.master_organization_id
4859: FROM mtl_parameters mp, org_organization_definitions ood
4860: WHERE mp.organization_Id = ood.organization_id
4861: -- jaramana on Feb 14, 2008
4862: -- Removed reference to CLIENT_INFO
4863: AND NVL(ood.operating_unit, mo_global.get_current_org_id()) = mo_global.get_current_org_id())

Line 4867: FROM mtl_parameters mp, inv_organization_info_v io

4863: AND NVL(ood.operating_unit, mo_global.get_current_org_id()) = mo_global.get_current_org_id())
4864: */
4865: AND EXISTS (
4866: SELECT 'X'
4867: FROM mtl_parameters mp, inv_organization_info_v io
4868: WHERE mp.master_organization_id = M.organization_id AND
4869: mp.organization_Id = io.organization_id AND
4870: NVL(io.operating_unit, mo_global.get_current_org_id()) =
4871: mo_global.get_current_org_id()

Line 5582: FROM mtl_parameters mp, inv_organization_info_v io

5578: AND upper(nvl(C.serial_number, '%')) LIKE c_serial_number
5579: AND EXISTS
5580: (
5581: SELECT 'X'
5582: FROM mtl_parameters mp, inv_organization_info_v io
5583: WHERE mp.master_organization_id = M.organization_id AND
5584: mp.organization_Id = io.organization_id AND
5585: NVL(io.operating_unit, mo_global.get_current_org_id()) =
5586: mo_global.get_current_org_id()

Line 5697: FROM mtl_parameters mp, inv_organization_info_v io

5693: AND upper(nvl(C.serial_number, '%')) LIKE c_serial_number
5694: AND EXISTS
5695: (
5696: SELECT 'X'
5697: FROM mtl_parameters mp, inv_organization_info_v io
5698: WHERE mp.master_organization_id = M.organization_id AND
5699: mp.organization_Id = io.organization_id AND
5700: NVL(io.operating_unit, mo_global.get_current_org_id()) =
5701: mo_global.get_current_org_id()

Line 6781: FROM mtl_parameters mp, inv_organization_info_v io

6777: -- Filter by serial number if provided
6778: AND upper(nvl(CII.serial_number, '%')) LIKE c_serial_number
6779: -- Instance's Item is defined in at least one Inv Org in User's OU
6780: AND (EXISTS (SELECT 'X'
6781: FROM mtl_parameters mp, inv_organization_info_v io
6782: WHERE mp.master_organization_id = MSIK.organization_id
6783: AND mp.organization_Id = io.organization_id
6784: AND NVL(io.operating_unit, mo_global.get_current_org_id()) = mo_global.get_current_org_id())
6785: )

Line 6847: FROM mtl_parameters mp,

6843: -- Filter by serial number if provided
6844: AND upper(nvl(CII.serial_number, '%')) LIKE c_serial_number
6845: -- Instance's Item is defined in at least one Inv Org in User's OU
6846: AND (EXISTS (SELECT 'X'
6847: FROM mtl_parameters mp,
6848: inv_organization_info_v io
6849: WHERE mp.master_organization_id = MSIK.organization_id
6850: AND mp.organization_Id = io.organization_id
6851: AND NVL(io.operating_unit, mo_global.get_current_org_id()) = mo_global.get_current_org_id())

Line 7144: FROM mtl_parameters mp, inv_organization_info_v io

7140: AND trunc(nvl(AUCH.active_end_date, SYSDATE+1)) > trunc(SYSDATE))
7141: )
7142: -- Instance's Item is defined in at least one Inv Org in User's OU
7143: AND (EXISTS (SELECT 'X'
7144: FROM mtl_parameters mp, inv_organization_info_v io
7145: WHERE mp.master_organization_id = MSIK.organization_id
7146: AND mp.organization_Id = io.organization_id
7147: AND NVL(io.operating_unit, mo_global.get_current_org_id()) = mo_global.get_current_org_id())
7148: )

Line 7194: FROM mtl_parameters mp,

7190: AND trunc(nvl(MR.active_end_date, SYSDATE+1)) > trunc(SYSDATE))
7191: )
7192: -- Instance's Item is defined in at least one Inv Org in User's OU
7193: AND (EXISTS (SELECT 'X'
7194: FROM mtl_parameters mp,
7195: inv_organization_info_v io
7196: WHERE mp.master_organization_id = MSIK.organization_id
7197: AND mp.organization_Id = io.organization_id
7198: AND NVL(io.operating_unit, mo_global.get_current_org_id()) = mo_global.get_current_org_id())