View: OKL_EXT_SELL_INVS_V

Product:	OKL - Lease and Finance Management
Description:	External Transactions Header for Billing records
Implementation/DBA Data:	APPS.OKL_EXT_SELL_INVS_V

View Text

SELECT XSIB.ROWID ROW_ID
, XSIB.ID ID
, XSIB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, XSIT.SFWT_FLAG SFWT_FLAG
, XSIB.TRX_STATUS_CODE TRX_STATUS_CODE
, XSIB.ISI_ID ISI_ID
, XSIB.TRX_NUMBER TRX_NUMBER
, XSIB.TRX_DATE TRX_DATE
, XSIB.CUSTOMER_ID CUSTOMER_ID
, XSIB.RECEIPT_METHOD_ID RECEIPT_METHOD_ID
, XSIB.TERM_ID TERM_ID
, XSIB.CURRENCY_CODE CURRENCY_CODE
, XSIB.CURRENCY_CONVERSION_TYPE CURRENCY_CONVERSION_TYPE
, XSIB.CURRENCY_CONVERSION_RATE CURRENCY_CONVERSION_RATE
, XSIB.CURRENCY_CONVERSION_DATE CURRENCY_CONVERSION_DATE
, XSIB.CUSTOMER_ADDRESS_ID CUSTOMER_ADDRESS_ID
, XSIB.INF_ID INF_ID
, XSIB.SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, XSIB.RECEIVABLES_INVOICE_ID RECEIVABLES_INVOICE_ID
, XSIB.CUST_TRX_TYPE_ID CUST_TRX_TYPE_ID
, XSIB.CUSTOMER_BANK_ACCOUNT_ID CUSTOMER_BANK_ACCOUNT_ID
, XSIB.REFERENCE_LINE_ID REFERENCE_LINE_ID
, XSIT.INVOICE_MESSAGE INVOICE_MESSAGE
, XSIT.DESCRIPTION DESCRIPTION
, XSIB.TAX_EXEMPT_FLAG TAX_EXEMPT_FLAG
, XSIB.TAX_EXEMPT_REASON_CODE TAX_EXEMPT_REASON_CODE
, XSIT.XTRX_CONS_INVOICE_NUMBER XTRX_CONS_INVOICE_NUMBER
, XSIT.XTRX_FORMAT_TYPE XTRX_FORMAT_TYPE
, XSIB.XTRX_INVOICE_PULL_YN XTRX_INVOICE_PULL_YN
, XSIT.XTRX_PRIVATE_LABEL XTRX_PRIVATE_LABEL
, XSIB.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, XSIB.ATTRIBUTE1 ATTRIBUTE1
, XSIB.ATTRIBUTE2 ATTRIBUTE2
, XSIB.ATTRIBUTE3 ATTRIBUTE3
, XSIB.ATTRIBUTE4 ATTRIBUTE4
, XSIB.ATTRIBUTE5 ATTRIBUTE5
, XSIB.ATTRIBUTE6 ATTRIBUTE6
, XSIB.ATTRIBUTE7 ATTRIBUTE7
, XSIB.ATTRIBUTE8 ATTRIBUTE8
, XSIB.ATTRIBUTE9 ATTRIBUTE9
, XSIB.ATTRIBUTE10 ATTRIBUTE10
, XSIB.ATTRIBUTE11 ATTRIBUTE11
, XSIB.ATTRIBUTE12 ATTRIBUTE12
, XSIB.ATTRIBUTE13 ATTRIBUTE13
, XSIB.ATTRIBUTE14 ATTRIBUTE14
, XSIB.ATTRIBUTE15 ATTRIBUTE15
, XSIB.REQUEST_ID REQUEST_ID
, XSIB.PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, XSIB.PROGRAM_ID PROGRAM_ID
, XSIB.PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, XSIB.ORG_ID ORG_ID
, XSIB.CREATED_BY CREATED_BY
, XSIB.CREATION_DATE CREATION_DATE
, XSIB.LAST_UPDATED_BY LAST_UPDATED_BY
, XSIB.LAST_UPDATE_DATE LAST_UPDATE_DATE
, XSIB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, XSIB.LEGAL_ENTITY_ID LEGAL_ENTITY_ID
FROM OKL_EXT_SELL_INVS_B XSIB
, OKL_EXT_SELL_INVS_TL XSIT
WHERE XSIB.ID = XSIT.ID
AND XSIT.LANGUAGE = USERENV('LANG')

Columns