View: OKL_XTL_SELL_INVS_V

Product:	OKL - Lease and Finance Management
Description:	The transaction table for "bill" type transactions, where cash receipts are expected
Implementation/DBA Data:	APPS.OKL_XTL_SELL_INVS_V

View Text

SELECT XLSB.ROWID ROW_ID
, XLSB.ID ID
, XLSB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, XLST.SFWT_FLAG SFWT_FLAG
, XLSB.TLD_ID TLD_ID
, XLSB.LSM_ID LSM_ID
, XLSB.TIL_ID TIL_ID
, XLSB.ISL_ID
, XLSB.ILL_ID ILL_ID
, XLSB.XSI_ID_DETAILS XSI_ID_DETAILS
, XLSB.LINE_TYPE LINE_TYPE
, XLST.DESCRIPTION DESCRIPTION
, XLSB.AMOUNT AMOUNT
, XLSB.QUANTITY QUANTITY
, XLSB.XTRX_CONS_LINE_NUMBER XTRX_CONS_LINE_NUMBER
, XLST.XTRX_CONTRACT XTRX_CONTRACT
, XLST.XTRX_ASSET XTRX_ASSET
, XLST.XTRX_STREAM_GROUP XTRX_STREAM_GROUP
, XLST.XTRX_STREAM_TYPE XTRX_STREAM_TYPE
, XLSB.XTRX_CONS_STREAM_ID XTRX_CONS_STREAM_ID
, XLSB.INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, XLSB.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, XLSB.ATTRIBUTE1 ATTRIBUTE1
, XLSB.ATTRIBUTE2 ATTRIBUTE2
, XLSB.ATTRIBUTE3 ATTRIBUTE3
, XLSB.ATTRIBUTE4 ATTRIBUTE4
, XLSB.ATTRIBUTE5 ATTRIBUTE5
, XLSB.ATTRIBUTE6 ATTRIBUTE6
, XLSB.ATTRIBUTE7 ATTRIBUTE7
, XLSB.ATTRIBUTE8 ATTRIBUTE8
, XLSB.ATTRIBUTE9 ATTRIBUTE9
, XLSB.ATTRIBUTE10 ATTRIBUTE10
, XLSB.ATTRIBUTE11 ATTRIBUTE11
, XLSB.ATTRIBUTE12 ATTRIBUTE12
, XLSB.ATTRIBUTE13 ATTRIBUTE13
, XLSB.ATTRIBUTE14 ATTRIBUTE14
, XLSB.ATTRIBUTE15 ATTRIBUTE15
, XLSB.REQUEST_ID REQUEST_ID
, XLSB.PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, XLSB.PROGRAM_ID PROGRAM_ID
, XLSB.PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, XLSB.ORG_ID ORG_ID
, XLSB.INVENTORY_ORG_ID INVENTORY_ORG_ID
, XLSB.CREATED_BY CREATED_BY
, XLSB.CREATION_DATE CREATION_DATE
, XLSB.LAST_UPDATED_BY LAST_UPDATED_BY
, XLSB.LAST_UPDATE_DATE LAST_UPDATE_DATE
, XLSB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, XLSB.SEL_ID SEL_ID
FROM OKL_XTL_SELL_INVS_B XLSB
, OKL_XTL_SELL_INVS_TL XLST
WHERE XLSB.ID = XLST.ID
AND XLST.LANGUAGE = USERENV('LANG')

Columns