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.ASO_SERVICE_CONTRACTS_INT_W dependencies on MTL_SYSTEM_ITEMS_VL

Line 304: aso_quote_line_details aqld, mtl_system_items_vl msiv

300: SELECT msiv.concatenated_segments, msiv.description,
301: aql.start_date_active, aqld.service_ref_line_id,
302: aqld.service_duration, aqld.service_period
303: FROM aso_quote_lines_all aql,
304: aso_quote_line_details aqld, mtl_system_items_vl msiv
305: WHERE aqld.quote_line_id = aql.quote_line_id
306: AND aql.inventory_item_id = msiv.inventory_item_id
307: AND aql.organization_id = msiv.organization_id
308: AND msiv.organization_id=p_orgId

Line 315: FROM oe_order_lines_all ol, mtl_system_items_vl msiv

311: -- Cursor to get existing services for order
312: CURSOR c_getExistService_or (p_orgId NUMBER) IS
313: SELECT msiv.concatenated_segments, msiv.description,
314: ol.service_start_date, ol.service_duration, ol.service_period
315: FROM oe_order_lines_all ol, mtl_system_items_vl msiv
316: WHERE ol.service_reference_type_code = 'ORDER'
317: AND ol.inventory_item_id = msiv.inventory_item_id
318: AND msiv.organization_id = p_orgId
319: AND ol.service_reference_line_id=p_source_Id ;