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.

[Home] [Help]

VIEW: OKL.OKL_TXL_EXTENSION_B#

Source

View Text - Preformatted


select LINE_EXTENSION_ID LINE_EXTENSION_ID, SOURCE_ID SOURCE_ID, SOURCE_TABLE SOURCE_TABLE, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, CONTRACT_LINE_NUMBER CONTRACT_LINE_NUMBER, FEE_TYPE_CODE FEE_TYPE_CODE, ASSET_NUMBER ASSET_NUMBER, ASSET_CATEGORY_NAME ASSET_CATEGORY_NAME, ASSET_VENDOR_NAME ASSET_VENDOR_NAME, ASSET_MANUFACTURER_NAME ASSET_MANUFACTURER_NAME, ASSET_YEAR_MANUFACTURED ASSET_YEAR_MANUFACTURED, ASSET_MODEL_NUMBER ASSET_MODEL_NUMBER, ASSET_DELIVERED_DATE ASSET_DELIVERED_DATE, INSTALLED_SITE_ID INSTALLED_SITE_ID, FIXED_ASSET_LOCATION_NAME FIXED_ASSET_LOCATION_NAME, CONTINGENCY_CODE CONTINGENCY_CODE, SUBSIDY_NAME SUBSIDY_NAME, SUBSIDY_PARTY_NAME SUBSIDY_PARTY_NAME, MEMO_FLAG MEMO_FLAG, RECIEVABLES_TRX_TYPE_NAME RECIEVABLES_TRX_TYPE_NAME, AGING_BUCKET_NAME AGING_BUCKET_NAME, CONTRACT_LINE_TYPE CONTRACT_LINE_TYPE, PAY_SUPPLIER_SITE_NAME PAY_SUPPLIER_SITE_NAME, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, TEH_ID TEH_ID, INVENTORY_ITEM_NAME_CODE INVENTORY_ITEM_NAME_CODE, INVENTORY_ORG_CODE INVENTORY_ORG_CODE, VENDOR_SITE_ID VENDOR_SITE_ID, SUBSIDY_VENDOR_ID SUBSIDY_VENDOR_ID, ASSET_VENDOR_ID ASSET_VENDOR_ID from "OKL"."OKL_TXL_EXTENSION_B"

View Text - HTML Formatted

SELECT LINE_EXTENSION_ID LINE_EXTENSION_ID
, SOURCE_ID SOURCE_ID
, SOURCE_TABLE SOURCE_TABLE
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, CONTRACT_LINE_NUMBER CONTRACT_LINE_NUMBER
, FEE_TYPE_CODE FEE_TYPE_CODE
, ASSET_NUMBER ASSET_NUMBER
, ASSET_CATEGORY_NAME ASSET_CATEGORY_NAME
, ASSET_VENDOR_NAME ASSET_VENDOR_NAME
, ASSET_MANUFACTURER_NAME ASSET_MANUFACTURER_NAME
, ASSET_YEAR_MANUFACTURED ASSET_YEAR_MANUFACTURED
, ASSET_MODEL_NUMBER ASSET_MODEL_NUMBER
, ASSET_DELIVERED_DATE ASSET_DELIVERED_DATE
, INSTALLED_SITE_ID INSTALLED_SITE_ID
, FIXED_ASSET_LOCATION_NAME FIXED_ASSET_LOCATION_NAME
, CONTINGENCY_CODE CONTINGENCY_CODE
, SUBSIDY_NAME SUBSIDY_NAME
, SUBSIDY_PARTY_NAME SUBSIDY_PARTY_NAME
, MEMO_FLAG MEMO_FLAG
, RECIEVABLES_TRX_TYPE_NAME RECIEVABLES_TRX_TYPE_NAME
, AGING_BUCKET_NAME AGING_BUCKET_NAME
, CONTRACT_LINE_TYPE CONTRACT_LINE_TYPE
, PAY_SUPPLIER_SITE_NAME PAY_SUPPLIER_SITE_NAME
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, TEH_ID TEH_ID
, INVENTORY_ITEM_NAME_CODE INVENTORY_ITEM_NAME_CODE
, INVENTORY_ORG_CODE INVENTORY_ORG_CODE
, VENDOR_SITE_ID VENDOR_SITE_ID
, SUBSIDY_VENDOR_ID SUBSIDY_VENDOR_ID
, ASSET_VENDOR_ID ASSET_VENDOR_ID
FROM "OKL"."OKL_TXL_EXTENSION_B"