VIEW: APPS.CE_STAT_LINES_INF_V

Source

View Text - Preformatted

SELECT SLI.ROWID ROW_ID, SLI.BANK_ACCOUNT_NUM, SLI.STATEMENT_NUMBER, SLI.LINE_NUMBER, SLI.TRX_DATE, SLI.TRX_CODE, SLI.EFFECTIVE_DATE, SLI.TRX_TEXT, SLI.INVOICE_TEXT, SLI.BANK_ACCOUNT_TEXT, SLI.AMOUNT, SLI.CHARGES_AMOUNT, SLI.CURRENCY_CODE, SLI.USER_EXCHANGE_RATE_TYPE, SLI.EXCHANGE_RATE_DATE, SLI.ORIGINAL_AMOUNT, SLI.EXCHANGE_RATE, SLI.BANK_TRX_NUMBER, SLI.CUSTOMER_TEXT, SLI.CREATED_BY, SLI.CREATION_DATE, SLI.LAST_UPDATED_BY, SLI.LAST_UPDATE_DATE, SLI.ATTRIBUTE_CATEGORY, SLI.ATTRIBUTE1, SLI.ATTRIBUTE10, SLI.ATTRIBUTE11, SLI.ATTRIBUTE12, SLI.ATTRIBUTE13, SLI.ATTRIBUTE14, SLI.ATTRIBUTE15, SLI.ATTRIBUTE2, SLI.ATTRIBUTE3, SLI.ATTRIBUTE4, SLI.ATTRIBUTE5, SLI.ATTRIBUTE6, SLI.ATTRIBUTE7, SLI.ATTRIBUTE8, SLI.ATTRIBUTE9 FROM CE_STATEMENT_LINES_INTERFACE SLI

View Text - HTML Formatted

SELECT SLI.ROWID ROW_ID
, SLI.BANK_ACCOUNT_NUM
, SLI.STATEMENT_NUMBER
, SLI.LINE_NUMBER
, SLI.TRX_DATE
, SLI.TRX_CODE
, SLI.EFFECTIVE_DATE
, SLI.TRX_TEXT
, SLI.INVOICE_TEXT
, SLI.BANK_ACCOUNT_TEXT
, SLI.AMOUNT
, SLI.CHARGES_AMOUNT
, SLI.CURRENCY_CODE
, SLI.USER_EXCHANGE_RATE_TYPE
, SLI.EXCHANGE_RATE_DATE
, SLI.ORIGINAL_AMOUNT
, SLI.EXCHANGE_RATE
, SLI.BANK_TRX_NUMBER
, SLI.CUSTOMER_TEXT
, SLI.CREATED_BY
, SLI.CREATION_DATE
, SLI.LAST_UPDATED_BY
, SLI.LAST_UPDATE_DATE
, SLI.ATTRIBUTE_CATEGORY
, SLI.ATTRIBUTE1
, SLI.ATTRIBUTE10
, SLI.ATTRIBUTE11
, SLI.ATTRIBUTE12
, SLI.ATTRIBUTE13
, SLI.ATTRIBUTE14
, SLI.ATTRIBUTE15
, SLI.ATTRIBUTE2
, SLI.ATTRIBUTE3
, SLI.ATTRIBUTE4
, SLI.ATTRIBUTE5
, SLI.ATTRIBUTE6
, SLI.ATTRIBUTE7
, SLI.ATTRIBUTE8
, SLI.ATTRIBUTE9
FROM CE_STATEMENT_LINES_INTERFACE SLI