VIEW: APPS.OKL_CNSLD_AR_LINES_V

Source

View Text - Preformatted

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')

View Text - HTML Formatted

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')