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_SHIPMENT_PUB dependencies on AHL_INV_SERVICE_ITEM_RELS

Line 2049: from ahl_inv_service_item_rels

2045: where vendor_id =p_vendor_id and vendor_site_id =p_vendor_site_id)
2046: and active_start_date <= sysdate
2047: and (active_end_date is null or active_end_date > sysdate)
2048: and inv_service_item_rel_id in (select inv_service_item_rel_id
2049: from ahl_inv_service_item_rels
2050: where service_item_id in (select service_item_id
2051: from ahl_osp_order_lines
2052: where osp_order_id = p_osp_order_id
2053: and inventory_item_id = p_inventory_item_id