Product: | OKL - Lease and Finance Management |
---|---|
Description: | Line of consolidated invoice |
Implementation/DBA Data: | APPS.OKL_CNSLD_AR_LINES_V |
SELECT LLNB.ROWID
, LLNB.ID
, LLNB.OBJECT_VERSION_NUMBER
, LLNT.SFWT_FLAG
, LLNB.KHR_ID
, LLNB.CNR_ID
, LLNB.KLE_ID
, LLNB.LLN_ID_PARENT
, LLNB.ILT_ID
, LLNB.SEQUENCE_NUMBER
, LLNB.AMOUNT
, LLNB.TAX_AMOUNT
, LLNB.ATTRIBUTE_CATEGORY
, LLNB.ATTRIBUTE1
, LLNB.ATTRIBUTE2
, LLNB.ATTRIBUTE3
, LLNB.ATTRIBUTE4
, LLNB.ATTRIBUTE5
, LLNB.ATTRIBUTE6
, LLNB.ATTRIBUTE7
, LLNB.ATTRIBUTE8
, LLNB.ATTRIBUTE9
, LLNB.ATTRIBUTE10
, LLNB.ATTRIBUTE11
, LLNB.ATTRIBUTE12
, LLNB.ATTRIBUTE13
, LLNB.ATTRIBUTE14
, LLNB.ATTRIBUTE15
, LLNB.LINE_TYPE
, LLNB.REQUEST_ID
, LLNB.PROGRAM_APPLICATION_ID
, LLNB.PROGRAM_ID
, LLNB.PROGRAM_UPDATE_DATE
, LLNB.ORG_ID
, LLNB.CREATED_BY
, LLNB.CREATION_DATE
, LLNB.LAST_UPDATED_BY
, LLNB.LAST_UPDATE_DATE
, LLNB.LAST_UPDATE_LOGIN
FROM OKL_CNSLD_AR_LINES_B LLNB
, OKL_CNSLD_AR_LINES_TL LLNT
WHERE LLNB.ID = LLNT.ID
AND LLNT.LANGUAGE = USERENV('LANG')