Product: | OKL - Lease and Finance Management |
---|---|
Description: | Line extract object with asset related information. |
Implementation/DBA Data: | APPS.OKL_ASSET_EXTRACT_LINE_V |
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'