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_KFV

Line 101: FROM mtl_system_items_kfv mtl, inv_organization_info_v org, hr_all_organization_units hou

97:
98: SELECT
99: mtl.inventory_item_id,
100: mtl.organization_id inventory_org_id
101: FROM mtl_system_items_kfv mtl, inv_organization_info_v org, hr_all_organization_units hou
102: WHERE hou.name = p_org_name
103: AND mtl.concatenated_segments = p_item_name
104: AND mtl.organization_id = org.organization_id
105: AND hou.organization_id = org.organization_id

Line 592: FROM mtl_system_items_kfv Inv,

588: NULL ,
589: NULL ,
590: NULL ,
591: NULL
592: FROM mtl_system_items_kfv Inv,
593: mtl_system_items_kfv Serv,
594: --Modified by mpothuku on 17-Jan-05 to fix the performance Bug 4919315
595: inv_organization_info_v org
596: WHERE Inv.ORGANIZATION_ID = Serv.ORGANIZATION_ID

Line 593: mtl_system_items_kfv Serv,

589: NULL ,
590: NULL ,
591: NULL
592: FROM mtl_system_items_kfv Inv,
593: mtl_system_items_kfv Serv,
594: --Modified by mpothuku on 17-Jan-05 to fix the performance Bug 4919315
595: inv_organization_info_v org
596: WHERE Inv.ORGANIZATION_ID = Serv.ORGANIZATION_ID
597: AND org.organization_id = Inv.ORGANIZATION_ID