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_OSP_SERV_ITEM_RELS_PVT dependencies on MTL_SYSTEM_ITEMS_B

Line 134: FROM mtl_system_items_b mtl, inv_organization_info_v org

130: --Changed by mpothuku for fixing the Performance Bug# 4919315
131: SELECT
132: mtl.inventory_item_id,
133: mtl.organization_id inventory_org_id
134: FROM mtl_system_items_b mtl, inv_organization_info_v org
135: WHERE mtl.organization_id = p_org_id
136: AND mtl.inventory_item_id = p_item_id
137: AND mtl.organization_id = org.organization_id
138: AND NVL (org.operating_unit, mo_global.get_current_org_id ()) = mo_global.get_current_org_id()

Line 189: mtl_system_items_b mtl

185: isirv.rank
186: /* Removed the OU filtering here, as the view ahl_inv_service_item_rels_v itself is OU filtered with the Bug
187: fix 5350882, mpothuku 26-Jul-06 */
188: FROM ahl_inv_service_item_rels_v isirv,
189: mtl_system_items_b mtl
190: /*
191: inv_organization_info_v org
192: */
193: WHERE isirv.inv_item_id = p_inv_item_id