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.

VIEW: APPS.OKL_ASSET_EXTRACT_LINE_V

Source

View Text - Preformatted


SELECT TCL.ID TCL_ID ,TEL.ASSET_CATEGORY_NAME TEL_ASSET_CATEGORY_NAME ,TEL.ASSET_DELIVERED_DATE TEL_ASSET_DELIVERED_DATE ,TEL.ASSET_MANUFACTURER_NAME TEL_ASSET_MANUFACTURER_NAME ,TEL.ASSET_MODEL_NUMBER TEL_ASSET_MODEL_NUMBER ,TEL.ASSET_NUMBER TEL_ASSET_NUMBER ,TEL.ASSET_VENDOR_NAME TEL_ASSET_VENDOR_NAME ,TEL.ASSET_YEAR_MANUFACTURED TEL_ASSET_YEAR_MANUFACTURED ,TEL.FIXED_ASSET_LOCATION_NAME TEL_FIXED_ASSET_LOCATION_NAME ,TEL.INSTALLED_SITE_ID TEL_INSTALLED_SITE_ID ,TEL.INVENTORY_ITEM_NAME_CODE TEL_INVENTORY_ITEM_NAME_CODE FROM OKL_TXL_CNTRCT_LNS_ALL TCL,OKL_TXL_EXTENSION_B TEL WHERE TCL.ID = TEL.SOURCE_ID(+) AND TEL.SOURCE_TABLE(+) = 'OKL_TXL_CNTRCT_LNS'

View Text - HTML Formatted

SELECT TCL.ID TCL_ID
, TEL.ASSET_CATEGORY_NAME TEL_ASSET_CATEGORY_NAME
, TEL.ASSET_DELIVERED_DATE TEL_ASSET_DELIVERED_DATE
, TEL.ASSET_MANUFACTURER_NAME TEL_ASSET_MANUFACTURER_NAME
, TEL.ASSET_MODEL_NUMBER TEL_ASSET_MODEL_NUMBER
, TEL.ASSET_NUMBER TEL_ASSET_NUMBER
, TEL.ASSET_VENDOR_NAME TEL_ASSET_VENDOR_NAME
, TEL.ASSET_YEAR_MANUFACTURED TEL_ASSET_YEAR_MANUFACTURED
, TEL.FIXED_ASSET_LOCATION_NAME TEL_FIXED_ASSET_LOCATION_NAME
, TEL.INSTALLED_SITE_ID TEL_INSTALLED_SITE_ID
, TEL.INVENTORY_ITEM_NAME_CODE TEL_INVENTORY_ITEM_NAME_CODE
FROM OKL_TXL_CNTRCT_LNS_ALL TCL
, OKL_TXL_EXTENSION_B TEL
WHERE TCL.ID = TEL.SOURCE_ID(+)
AND TEL.SOURCE_TABLE(+) = 'OKL_TXL_CNTRCT_LNS'