View: OKL_CNSLD_AR_HDRS_V

Product:	OKL - Lease and Finance Management
Description:	Single printed report "bill" for many actual AR invoices
Implementation/DBA Data:	APPS.OKL_CNSLD_AR_HDRS_V

View Text

SELECT CNRB.ROWID
, CNRB.ID
, CNRB.OBJECT_VERSION_NUMBER
, CNRT.SFWT_FLAG
, CNRB.IBT_ID
, CNRB.IXX_ID
, CNRB.CURRENCY_CODE
, CNRB.IRM_ID
, CNRB.INF_ID
, CNRB.SET_OF_BOOKS_ID
, CNRB.CONSOLIDATED_INVOICE_NUMBER
, CNRB.TRX_STATUS_CODE
, CNRB.INVOICE_PULL_YN
, CNRB.DUE_DATE
, CNRB.DATE_CONSOLIDATED
, CNRT.PRIVATE_LABEL_LOGO_URL
, CNRB.AMOUNT
, CNRB.ATTRIBUTE_CATEGORY
, CNRB.ATTRIBUTE1
, CNRB.ATTRIBUTE2
, CNRB.ATTRIBUTE3
, CNRB.ATTRIBUTE4
, CNRB.ATTRIBUTE5
, CNRB.ATTRIBUTE6
, CNRB.ATTRIBUTE7
, CNRB.ATTRIBUTE8
, CNRB.ATTRIBUTE9
, CNRB.ATTRIBUTE10
, CNRB.ATTRIBUTE11
, CNRB.ATTRIBUTE12
, CNRB.ATTRIBUTE13
, CNRB.ATTRIBUTE14
, CNRB.ATTRIBUTE15
, CNRB.REQUEST_ID
, CNRB.PROGRAM_APPLICATION_ID
, CNRB.PROGRAM_ID
, CNRB.PROGRAM_UPDATE_DATE
, CNRB.ORG_ID
, CNRB.CREATED_BY
, CNRB.CREATION_DATE
, CNRB.LAST_UPDATED_BY
, CNRB.LAST_UPDATE_DATE
, CNRB.LAST_UPDATE_LOGIN
, CNRB.LEGAL_ENTITY_ID
FROM OKL_CNSLD_AR_HDRS_B CNRB
, OKL_CNSLD_AR_HDRS_TL CNRT
WHERE CNRB.ID = CNRT.ID
AND CNRT.LANGUAGE = USERENV('LANG')

Columns