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_EXT_AP_LINE_SOURCES_V

Product:	OKL - Lease and Finance Management
Description:
Implementation/DBA Data:	APPS.OKL_EXT_AP_LINE_SOURCES_V

View Text

SELECT PXL.LINE_EXTENSION_ID LINE_EXTENSION_ID
, PXL.HEADER_EXTENSION_ID HEADER_EXTENSION_ID
, PXL.SOURCE_ID SOURCE_ID
, PXL.SOURCE_TABLE SOURCE_TABLE
, PXL.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, PXL.KLE_ID KLE_ID
, PXL.STY_ID STY_ID
, PXL.ASSET_NUMBER ASSET_NUMBER
, PXL.CONTRACT_LINE_NUMBER CONTRACT_LINE_NUMBER
, PXL.ASSET_VENDOR_NAME ASSET_VENDOR_NAME
, PXL.INSTALLED_SITE_ID INSTALLED_SITE_ID
, PXL.FIXED_ASSET_LOCATION_NAME FIXED_ASSET_LOCATION_NAME
, PXL.ACCOUNTING_TEMPLATE_NAME ACCOUNTING_TEMPLATE_NAME
, PXL.FEE_TYPE_CODE FEE_TYPE_CODE
, PXL.MEMO_FLAG MEMO_FLAG
, PXL.CONTRACT_LINE_TYPE CONTRACT_LINE_TYPE
, PXL.LINE_ATTRIBUTE_CATEGORY LINE_ATTRIBUTE_CATEGORY
, PXL.LINE_ATTRIBUTE1 LINE_ATTRIBUTE1
, PXL.LINE_ATTRIBUTE2 LINE_ATTRIBUTE2
, PXL.LINE_ATTRIBUTE3 LINE_ATTRIBUTE3
, PXL.LINE_ATTRIBUTE4 LINE_ATTRIBUTE4
, PXL.LINE_ATTRIBUTE5 LINE_ATTRIBUTE5
, PXL.LINE_ATTRIBUTE6 LINE_ATTRIBUTE6
, PXL.LINE_ATTRIBUTE7 LINE_ATTRIBUTE7
, PXL.LINE_ATTRIBUTE8 LINE_ATTRIBUTE8
, PXL.LINE_ATTRIBUTE9 LINE_ATTRIBUTE9
, PXL.LINE_ATTRIBUTE10 LINE_ATTRIBUTE10
, PXL.LINE_ATTRIBUTE11 LINE_ATTRIBUTE11
, PXL.LINE_ATTRIBUTE12 LINE_ATTRIBUTE12
, PXL.LINE_ATTRIBUTE13 LINE_ATTRIBUTE13
, PXL.LINE_ATTRIBUTE14 LINE_ATTRIBUTE14
, PXL.LINE_ATTRIBUTE15 LINE_ATTRIBUTE15
, PXL.STREAM_TYPE_CODE STREAM_TYPE_CODE
, PXL.STREAM_TYPE_PURPOSE_CODE STREAM_TYPE_PURPOSE_CODE
, PXL.INVENTORY_ORG_CODE INVENTORY_ORG_CODE
, PXLL.LANGUAGE LANGUAGE
, PXLL.INVENTORY_ORG_NAME INVENTORY_ORG_NAME
, PXLL.STREAM_TYPE_NAME STREAM_TYPE_NAME
, PXLL.TRANS_LINE_DESCRIPTION TRANS_LINE_DESCRIPTION
, PXL.CREATED_BY CREATED_BY
, PXL.CREATION_DATE CREATION_DATE
, PXL.LAST_UPDATED_BY LAST_UPDATED_BY
, PXL.LAST_UPDATE_DATE LAST_UPDATE_DATE
, PXL.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, PXL.ASSET_CATEGORY_NAME ASSET_CATEGORY_NAME
, PXL.INVENTORY_ITEM_NAME_CODE INVENTORY_ITEM_NAME_CODE
, PXLL.INVENTORY_ITEM_NAME INVENTORY_ITEM_NAME
, PXL.ASSET_VENDOR_ID ASSET_VENDOR_ID
FROM OKL_EXT_AP_LINE_SOURCES_B PXL
, OKL_EXT_AP_LINE_SOURCES_TL PXLL
WHERE PXL.LINE_EXTENSION_ID = PXLL.LINE_EXTENSION_ID

Columns

Name
LINE_EXTENSION_ID
HEADER_EXTENSION_ID
SOURCE_ID
SOURCE_TABLE
OBJECT_VERSION_NUMBER
KLE_ID
STY_ID
ASSET_NUMBER
CONTRACT_LINE_NUMBER
ASSET_VENDOR_NAME
INSTALLED_SITE_ID
FIXED_ASSET_LOCATION_NAME
ACCOUNTING_TEMPLATE_NAME
FEE_TYPE_CODE
MEMO_FLAG
CONTRACT_LINE_TYPE
LINE_ATTRIBUTE_CATEGORY
LINE_ATTRIBUTE1
LINE_ATTRIBUTE2
LINE_ATTRIBUTE3
LINE_ATTRIBUTE4
LINE_ATTRIBUTE5
LINE_ATTRIBUTE6
LINE_ATTRIBUTE7
LINE_ATTRIBUTE8
LINE_ATTRIBUTE9
LINE_ATTRIBUTE10
LINE_ATTRIBUTE11
LINE_ATTRIBUTE12
LINE_ATTRIBUTE13
LINE_ATTRIBUTE14
LINE_ATTRIBUTE15
STREAM_TYPE_CODE
STREAM_TYPE_PURPOSE_CODE
INVENTORY_ORG_CODE
LANGUAGE
INVENTORY_ORG_NAME
STREAM_TYPE_NAME
TRANS_LINE_DESCRIPTION
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
ASSET_CATEGORY_NAME
INVENTORY_ITEM_NAME_CODE
INVENTORY_ITEM_NAME
ASSET_VENDOR_ID