CE_STMT_LINES_INT_V

Details

• Schema: FUSION

• Object owner: CE

• Object type: VIEW

Columns

Name

STATEMENT_LINE_INT_ID STATEMENT_HEADER_INT_ID LINE_NUMBER TRX_CODE ORIG_TRX_CODE DOMAIN FAMILY SUB_FAMILY TRX_TYPE AMOUNT CURRENCY_CODE CREDIT_DEBIT_IND REVERSAL_IND_FLAG SERVICER_STATUS BOOKING_DATE VALUE_DATE ACCNT_SERVICER_REF COMM_WAIVER_IND_FLAG TRX_AMOUNT TRX_CURR_CODE EXCHANGE_RATE EXCHANGE_RATE_DATE EXCHANGE_RATE_TYPE ADDENDA_TXT STRUCTURED_PAYMENT_REFERENCE CONTRACT_IDENTIFICATION ORIG_BANK_ACCOUNT CUSTOMER_REFERENCE LAST_UPDATE_DATE LAST_UPDATED_BY CREATION_DATE CREATED_BY LAST_UPDATE_LOGIN OBJECT_VERSION_NUMBER ATTRIBUTE_CATEGORY ATTRIBUTE1 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTE5 ATTRIBUTE6 ATTRIBUTE7 ATTRIBUTE8 ATTRIBUTE9 ATTRIBUTE10 ATTRIBUTE11 ATTRIBUTE12 ATTRIBUTE13 ATTRIBUTE14 ATTRIBUTE15 GLOBAL_ATTRIBUTE_CATEGORY GLOBAL_ATTRIBUTE1 GLOBAL_ATTRIBUTE2 GLOBAL_ATTRIBUTE3 GLOBAL_ATTRIBUTE4 GLOBAL_ATTRIBUTE5 GLOBAL_ATTRIBUTE6 GLOBAL_ATTRIBUTE7 GLOBAL_ATTRIBUTE8 GLOBAL_ATTRIBUTE9 GLOBAL_ATTRIBUTE10 GLOBAL_ATTRIBUTE11 GLOBAL_ATTRIBUTE12 GLOBAL_ATTRIBUTE13 GLOBAL_ATTRIBUTE14 GLOBAL_ATTRIBUTE15 STMT_LINE_INT_ID STMT_LINE_DETAIL_INT_ID MESSAGE_ID INSTRUCTION_ID END_TO_END_ID TRANSACTION_ID MANDATE_ID CHECK_NUMBER CLEARING_SYSTEM_REF PROP_TYPE PROP_REFERENCE RECON_REFERENCE MESSAGE_IDENTIFIER PAYMENT_INFO_IDENTIFIER

Query

SQL_Statement

SELECT DISTINCT lines.STATEMENT_LINE_INT_ID, lines.STATEMENT_HEADER_INT_ID, lines.LINE_NUMBER, lines.TRX_CODE, lines.ORIG_TRX_CODE, lines.DOMAIN, lines.FAMILY, lines.SUB_FAMILY, lines.TRX_TYPE, lines.AMOUNT, lines.CURRENCY_CODE, lines.CREDIT_DEBIT_IND, lines.REVERSAL_IND_FLAG, lines.SERVICER_STATUS, lines.BOOKING_DATE, lines.VALUE_DATE, lines.ACCNT_SERVICER_REF, lines.COMM_WAIVER_IND_FLAG, lines.TRX_AMOUNT, lines.TRX_CURR_CODE, lines.EXCHANGE_RATE, lines.EXCHANGE_RATE_DATE, lines.EXCHANGE_RATE_TYPE, lines.ADDENDA_TXT, lines.STRUCTURED_PAYMENT_REFERENCE, lines.CONTRACT_IDENTIFICATION, lines.ORIG_BANK_ACCOUNT, lines.CUSTOMER_REFERENCE, lines.LAST_UPDATE_DATE, lines.LAST_UPDATED_BY, lines.CREATION_DATE, lines.CREATED_BY, lines.LAST_UPDATE_LOGIN, lines.OBJECT_VERSION_NUMBER, lines.ATTRIBUTE_CATEGORY, lines.ATTRIBUTE1, lines.ATTRIBUTE2, lines.ATTRIBUTE3, lines.ATTRIBUTE4, lines.ATTRIBUTE5, lines.ATTRIBUTE6, lines.ATTRIBUTE7, lines.ATTRIBUTE8, lines.ATTRIBUTE9, lines.ATTRIBUTE10, lines.ATTRIBUTE11, lines.ATTRIBUTE12, lines.ATTRIBUTE13, lines.ATTRIBUTE14, lines.ATTRIBUTE15, lines.GLOBAL_ATTRIBUTE_CATEGORY, lines.GLOBAL_ATTRIBUTE1, lines.GLOBAL_ATTRIBUTE2, lines.GLOBAL_ATTRIBUTE3, lines.GLOBAL_ATTRIBUTE4, lines.GLOBAL_ATTRIBUTE5, lines.GLOBAL_ATTRIBUTE6, lines.GLOBAL_ATTRIBUTE7, lines.GLOBAL_ATTRIBUTE8, lines.GLOBAL_ATTRIBUTE9, lines.GLOBAL_ATTRIBUTE10, lines.GLOBAL_ATTRIBUTE11, lines.GLOBAL_ATTRIBUTE12, lines.GLOBAL_ATTRIBUTE13, lines.GLOBAL_ATTRIBUTE14, lines.GLOBAL_ATTRIBUTE15, line_details.STMT_LINE_INT_ID, line_details.STMT_LINE_DETAIL_INT_ID, line_details.MESSAGE_ID, lines.INSTRUCTION_ID, lines.END_TO_END_ID, lines.TRANSACTION_ID, line_details.MANDATE_ID, lines.CHECK_NUMBER, lines.CLEARING_SYSTEM_REF, line_details.PROP_TYPE, line_details.PROP_REFERENCE, lines.RECON_REFERENCE, lines.MESSAGE_IDENTIFIER, lines.PAYMENT_INFO_IDENTIFIER FROM ce_statement_lines_int lines, ce_stmt_line_details_int line_details WHERE lines.statement_line_int_id=line_details.stmt_line_int_id(+)