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_VENDOR_CERTIFICATIONS_V

Line 2009: where vendor_certification_id = (select vendor_certification_id from ahl_vendor_certifications_v

2005: CURSOR ahl_max_service_duration_csr(p_vendor_id IN NUMBER, p_vendor_site_id IN NUMBER,
2006: p_osp_order_id IN NUMBER, p_inventory_item_id IN NUMBER, p_inventory_org_id IN NUMBER,
2007: p_serial_number IN VARCHAR2) IS
2008: select max(service_duration) from ahl_item_vendor_rels
2009: where vendor_certification_id = (select vendor_certification_id from ahl_vendor_certifications_v
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