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 OE_ORDER_LINES_ALL

Line 287: FROM oe_order_lines_all

283: -- for the Order
284: --Query to get inventory item id:
285: CURSOR c_getInventoryId IS
286: SELECT inventory_item_id
287: FROM oe_order_lines_all
288: WHERE line_id =p_source_id;
289:
290: --Query to get inventory organization id:
291: CURSOR c_getOrgId IS

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 ;