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_AP_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, KLE_ID KLE_ID, STY_ID STY_ID, ASSET_NUMBER ASSET_NUMBER, CONTRACT_LINE_NUMBER CONTRACT_LINE_NUMBER, ASSET_VENDOR_NAME ASSET_VENDOR_NAME, INSTALLED_SITE_ID INSTALLED_SITE_ID, FIXED_ASSET_LOCATION_NAME FIXED_ASSET_LOCATION_NAME, ACCOUNTING_TEMPLATE_NAME ACCOUNTING_TEMPLATE_NAME, FEE_TYPE_CODE FEE_TYPE_CODE, MEMO_FLAG MEMO_FLAG, CONTRACT_LINE_TYPE CONTRACT_LINE_TYPE, 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, STREAM_TYPE_CODE STREAM_TYPE_CODE, STREAM_TYPE_PURPOSE_CODE STREAM_TYPE_PURPOSE_CODE, INVENTORY_ORG_CODE INVENTORY_ORG_CODE, 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, ASSET_CATEGORY_NAME ASSET_CATEGORY_NAME, INVENTORY_ITEM_NAME_CODE INVENTORY_ITEM_NAME_CODE, ASSET_VENDOR_ID ASSET_VENDOR_ID from "OKL"."OKL_EXT_AP_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
, KLE_ID KLE_ID
, STY_ID STY_ID
, ASSET_NUMBER ASSET_NUMBER
, CONTRACT_LINE_NUMBER CONTRACT_LINE_NUMBER
, ASSET_VENDOR_NAME ASSET_VENDOR_NAME
, INSTALLED_SITE_ID INSTALLED_SITE_ID
, FIXED_ASSET_LOCATION_NAME FIXED_ASSET_LOCATION_NAME
, ACCOUNTING_TEMPLATE_NAME ACCOUNTING_TEMPLATE_NAME
, FEE_TYPE_CODE FEE_TYPE_CODE
, MEMO_FLAG MEMO_FLAG
, CONTRACT_LINE_TYPE CONTRACT_LINE_TYPE
, 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
, STREAM_TYPE_CODE STREAM_TYPE_CODE
, STREAM_TYPE_PURPOSE_CODE STREAM_TYPE_PURPOSE_CODE
, INVENTORY_ORG_CODE INVENTORY_ORG_CODE
, 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
, ASSET_CATEGORY_NAME ASSET_CATEGORY_NAME
, INVENTORY_ITEM_NAME_CODE INVENTORY_ITEM_NAME_CODE
, ASSET_VENDOR_ID ASSET_VENDOR_ID
FROM "OKL"."OKL_EXT_AP_LINE_SOURCES_B"