VIEW: APPS.OKL_TXL_EXTENSION_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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