FND Design Data [Home] [Help]

View: OKL_XTD_SELL_INVS_V

Product: OKL - Lease and Finance Management
Description: Accounting distributions for the transaction
Implementation/DBA Data: ViewAPPS.OKL_XTD_SELL_INVS_V
View Text

SELECT ESDB.ROWID ROW_ID
, ESDB.ID ID
, ESDB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, ESDT.SFWT_FLAG SFWT_FLAG
, ESDB.XLS_ID XLS_ID
, ESDB.ILD_ID ILD_ID
, ESDB.ACCOUNT_CLASS ACCOUNT_CLASS
, ESDB.CODE_COMBINATION_ID CODE_COMBINATION_ID
, ESDB.AMOUNT AMOUNT
, ESDB.PERCENT PERCENT
, ESDB.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, ESDB.ATTRIBUTE1 ATTRIBUTE1
, ESDB.ATTRIBUTE2 ATTRIBUTE2
, ESDB.ATTRIBUTE3 ATTRIBUTE3
, ESDB.ATTRIBUTE4 ATTRIBUTE4
, ESDB.ATTRIBUTE5 ATTRIBUTE5
, ESDB.ATTRIBUTE6 ATTRIBUTE6
, ESDB.ATTRIBUTE7 ATTRIBUTE7
, ESDB.ATTRIBUTE8 ATTRIBUTE8
, ESDB.ATTRIBUTE9 ATTRIBUTE9
, ESDB.ATTRIBUTE10 ATTRIBUTE10
, ESDB.ATTRIBUTE11 ATTRIBUTE11
, ESDB.ATTRIBUTE12 ATTRIBUTE12
, ESDB.ATTRIBUTE13 ATTRIBUTE13
, ESDB.ATTRIBUTE14 ATTRIBUTE14
, ESDB.ATTRIBUTE15 ATTRIBUTE15
, ESDB.REQUEST_ID REQUEST_ID
, ESDB.PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, ESDB.PROGRAM_ID PROGRAM_ID
, ESDB.PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, ESDB.ORG_ID ORG_ID
, ESDB.CREATED_BY CREATED_BY
, ESDB.CREATION_DATE CREATION_DATE
, ESDB.LAST_UPDATED_BY LAST_UPDATED_BY
, ESDB.LAST_UPDATE_DATE LAST_UPDATE_DATE
, ESDB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM OKL_XTD_SELL_INVS_B ESDB
, OKL_XTD_SELL_INVS_TL ESDT
WHERE ESDB.ID = ESDT.ID
AND ESDT.LANGUAGE = USERENV('LANG')

Columns

Name
ROW_ID
ID
OBJECT_VERSION_NUMBER
SFWT_FLAG
XLS_ID
ILD_ID
ACCOUNT_CLASS
CODE_COMBINATION_ID
AMOUNT
PERCENT
ATTRIBUTE_CATEGORY
ATTRIBUTE1
ATTRIBUTE2
ATTRIBUTE3
ATTRIBUTE4
ATTRIBUTE5
ATTRIBUTE6
ATTRIBUTE7
ATTRIBUTE8
ATTRIBUTE9
ATTRIBUTE10
ATTRIBUTE11
ATTRIBUTE12
ATTRIBUTE13
ATTRIBUTE14
ATTRIBUTE15
REQUEST_ID
PROGRAM_APPLICATION_ID
PROGRAM_ID
PROGRAM_UPDATE_DATE
ORG_ID
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN