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.

[Home] [Help]

APPS.AHL_OSP_SHIPMENT_PUB dependencies on AHL_INV_SERVICE_ITEM_RELS

Line 2014: from ahl_inv_service_item_rels

2010: where vendor_id =p_vendor_id and vendor_site_id =p_vendor_site_id)
2011: and active_start_date <= sysdate
2012: and (active_end_date is null or active_end_date > sysdate)
2013: and inv_service_item_rel_id in (select inv_service_item_rel_id
2014: from ahl_inv_service_item_rels
2015: where service_item_id in (select service_item_id
2016: from ahl_osp_order_lines
2017: where osp_order_id = p_osp_order_id
2018: and inventory_item_id = p_inventory_item_id