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_EXT_FA_LINE_SOURCES_B#

Source

View Text - Preformatted


select LINE_EXTENSION_ID LINE_EXTENSION_ID, HEADER_EXTENSION_ID HEADER_EXTENSION_ID, SOURCE_ID SOURCE_ID, SOURCE_TABLE SOURCE_TABLE, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, FA_TRANSACTION_ID FA_TRANSACTION_ID, ASSET_ID ASSET_ID, KLE_ID KLE_ID, ASSET_NUMBER ASSET_NUMBER, CONTRACT_LINE_NUMBER CONTRACT_LINE_NUMBER, ASSET_BOOK_TYPE_NAME ASSET_BOOK_TYPE_NAME, ASSET_VENDOR_NAME ASSET_VENDOR_NAME, INSTALLED_SITE_ID INSTALLED_SITE_ID, LINE_ATTRIBUTE_CATEGORY LINE_ATTRIBUTE_CATEGORY, LINE_ATTRIBUTE1 LINE_ATTRIBUTE1, LINE_ATTRIBUTE2 LINE_ATTRIBUTE2, LINE_ATTRIBUTE3 LINE_ATTRIBUTE3, LINE_ATTRIBUTE4 LINE_ATTRIBUTE4, LINE_ATTRIBUTE5 LINE_ATTRIBUTE5, LINE_ATTRIBUTE6 LINE_ATTRIBUTE6, LINE_ATTRIBUTE7 LINE_ATTRIBUTE7, LINE_ATTRIBUTE8 LINE_ATTRIBUTE8, LINE_ATTRIBUTE9 LINE_ATTRIBUTE9, LINE_ATTRIBUTE10 LINE_ATTRIBUTE10, LINE_ATTRIBUTE11 LINE_ATTRIBUTE11, LINE_ATTRIBUTE12 LINE_ATTRIBUTE12, LINE_ATTRIBUTE13 LINE_ATTRIBUTE13, LINE_ATTRIBUTE14 LINE_ATTRIBUTE14, LINE_ATTRIBUTE15 LINE_ATTRIBUTE15, 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, INVENTORY_ORG_CODE INVENTORY_ORG_CODE, ASSET_BOOK_TYPE_CODE ASSET_BOOK_TYPE_CODE, PERIOD_COUNTER PERIOD_COUNTER, INVENTORY_ITEM_NAME_CODE INVENTORY_ITEM_NAME_CODE, ASSET_VENDOR_ID ASSET_VENDOR_ID from "OKL"."OKL_EXT_FA_LINE_SOURCES_B"

View Text - HTML Formatted

SELECT LINE_EXTENSION_ID LINE_EXTENSION_ID
, HEADER_EXTENSION_ID HEADER_EXTENSION_ID
, SOURCE_ID SOURCE_ID
, SOURCE_TABLE SOURCE_TABLE
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, FA_TRANSACTION_ID FA_TRANSACTION_ID
, ASSET_ID ASSET_ID
, KLE_ID KLE_ID
, ASSET_NUMBER ASSET_NUMBER
, CONTRACT_LINE_NUMBER CONTRACT_LINE_NUMBER
, ASSET_BOOK_TYPE_NAME ASSET_BOOK_TYPE_NAME
, ASSET_VENDOR_NAME ASSET_VENDOR_NAME
, INSTALLED_SITE_ID INSTALLED_SITE_ID
, LINE_ATTRIBUTE_CATEGORY LINE_ATTRIBUTE_CATEGORY
, LINE_ATTRIBUTE1 LINE_ATTRIBUTE1
, LINE_ATTRIBUTE2 LINE_ATTRIBUTE2
, LINE_ATTRIBUTE3 LINE_ATTRIBUTE3
, LINE_ATTRIBUTE4 LINE_ATTRIBUTE4
, LINE_ATTRIBUTE5 LINE_ATTRIBUTE5
, LINE_ATTRIBUTE6 LINE_ATTRIBUTE6
, LINE_ATTRIBUTE7 LINE_ATTRIBUTE7
, LINE_ATTRIBUTE8 LINE_ATTRIBUTE8
, LINE_ATTRIBUTE9 LINE_ATTRIBUTE9
, LINE_ATTRIBUTE10 LINE_ATTRIBUTE10
, LINE_ATTRIBUTE11 LINE_ATTRIBUTE11
, LINE_ATTRIBUTE12 LINE_ATTRIBUTE12
, LINE_ATTRIBUTE13 LINE_ATTRIBUTE13
, LINE_ATTRIBUTE14 LINE_ATTRIBUTE14
, LINE_ATTRIBUTE15 LINE_ATTRIBUTE15
, 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
, INVENTORY_ORG_CODE INVENTORY_ORG_CODE
, ASSET_BOOK_TYPE_CODE ASSET_BOOK_TYPE_CODE
, PERIOD_COUNTER PERIOD_COUNTER
, INVENTORY_ITEM_NAME_CODE INVENTORY_ITEM_NAME_CODE
, ASSET_VENDOR_ID ASSET_VENDOR_ID
FROM "OKL"."OKL_EXT_FA_LINE_SOURCES_B"