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 ASO_QUOTE_LINES_ALL

Line 280: FROM aso_quote_lines_all

276:
277: -- for the Quote
278: CURSOR c_getInvOrgId_qe IS
279: SELECT inventory_item_id, organization_id
280: FROM aso_quote_lines_all
281: WHERE quote_line_id=p_source_id;
282:
283: -- for the Order
284: --Query to get inventory item id:

Line 303: FROM aso_quote_lines_all aql,

299: CURSOR c_getExistService_qe(p_orgId NUMBER) IS
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