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 ORG_ORGANIZATION_DEFINITIONS

Line 335: FROM org_organization_definitions o,

331:
332: -- SATHAPLI::Bug#4912576 fix::SQL ID 14401150 --
333: /*
334: SELECT o.operating_unit
335: FROM org_organization_definitions o,
336: mtl_system_items_kfv m,
337: csi_item_instances c
338: WHERE c.instance_id = p_instance_id
339: AND c.inventory_item_id = m.inventory_item_id

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