View: OKL_TXL_EXTENSION_V

Product:	OKL - Lease and Finance Management
Description:	Transaction Line extension view
Implementation/DBA Data:	APPS.OKL_TXL_EXTENSION_V

View Text

SELECT TEL.ROWID ROW_ID
, TEL.LINE_EXTENSION_ID LINE_EXTENSION_ID
, TEL.TEH_ID TEH_ID
, TEL.SOURCE_ID SOURCE_ID
, TEL.SOURCE_TABLE SOURCE_TABLE
, TEL.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, TELL.LANGUAGE LANGUAGE
, TEL.CONTRACT_LINE_NUMBER CONTRACT_LINE_NUMBER
, TEL.FEE_TYPE_CODE FEE_TYPE_CODE
, TEL.ASSET_NUMBER ASSET_NUMBER
, TEL.ASSET_CATEGORY_NAME ASSET_CATEGORY_NAME
, TEL.ASSET_VENDOR_NAME ASSET_VENDOR_NAME
, TEL.ASSET_MANUFACTURER_NAME ASSET_MANUFACTURER_NAME
, TEL.ASSET_YEAR_MANUFACTURED ASSET_YEAR_MANUFACTURED
, TEL.ASSET_MODEL_NUMBER ASSET_MODEL_NUMBER
, TEL.ASSET_DELIVERED_DATE ASSET_DELIVERED_DATE
, TEL.INSTALLED_SITE_ID INSTALLED_SITE_ID
, TEL.FIXED_ASSET_LOCATION_NAME FIXED_ASSET_LOCATION_NAME
, TEL.CONTINGENCY_CODE CONTINGENCY_CODE
, TEL.SUBSIDY_NAME SUBSIDY_NAME
, TEL.SUBSIDY_PARTY_NAME SUBSIDY_PARTY_NAME
, TEL.MEMO_FLAG MEMO_FLAG
, TEL.RECIEVABLES_TRX_TYPE_NAME RECIEVABLES_TRX_TYPE_NAME
, TEL.CONTRACT_LINE_TYPE CONTRACT_LINE_TYPE
, TEL.PAY_SUPPLIER_SITE_NAME PAY_SUPPLIER_SITE_NAME
, TEL.AGING_BUCKET_NAME AGING_BUCKET_NAME
, TEL.CREATED_BY CREATED_BY
, TEL.CREATION_DATE CREATION_DATE
, TEL.LAST_UPDATED_BY LAST_UPDATED_BY
, TEL.LAST_UPDATE_DATE LAST_UPDATE_DATE
, TEL.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, TELL.INVENTORY_ITEM_NAME INVENTORY_ITEM_NAME
, TELL.INVENTORY_ORG_NAME INVENTORY_ORG_NAME
, TEL.INVENTORY_ITEM_NAME_CODE INVENTORY_ITEM_NAME_CODE
, TEL.INVENTORY_ORG_CODE INVENTORY_ORG_CODE
, TEL.VENDOR_SITE_ID VENDOR_SITE_ID
, TEL.SUBSIDY_VENDOR_ID SUBSIDY_VENDOR_ID
, TEL.ASSET_VENDOR_ID ASSET_VENDOR_ID
FROM OKL_TXL_EXTENSION_B TEL
, OKL_TXL_EXTENSION_TL TELL
WHERE TEL.LINE_EXTENSION_ID = TELL.LINE_EXTENSION_ID

Columns