VIEW: APPS.CEBV_BANK_STATEMENTS

Source

View Text - Preformatted

SELECT sh.statement_header_id, sh.statement_number, sh.statement_date, sh.control_begin_balance, sh.control_total_dr, sh.control_total_cr, sh.control_end_balance, sh.control_dr_line_count, sh.control_cr_line_count, sh.currency_code, sh.statement_complete_flag, sh.doc_sequence_value, sh.bank_account_id, sh.org_id, sh.creation_date, sh.created_by, sh.last_update_date, sh.last_updated_by, sh.check_digits FROM ce_statement_headers sh -- ce_bank_acct_balances bal WHERE -- sh.bank_account_id = bal.bank_account_id(+) and -- sh.statement_date = bal.balance_date(+) and '_SEC:sh.org_id' is not null with read only

View Text - HTML Formatted

SELECT SH.STATEMENT_HEADER_ID
, SH.STATEMENT_NUMBER
, SH.STATEMENT_DATE
, SH.CONTROL_BEGIN_BALANCE
, SH.CONTROL_TOTAL_DR
, SH.CONTROL_TOTAL_CR
, SH.CONTROL_END_BALANCE
, SH.CONTROL_DR_LINE_COUNT
, SH.CONTROL_CR_LINE_COUNT
, SH.CURRENCY_CODE
, SH.STATEMENT_COMPLETE_FLAG
, SH.DOC_SEQUENCE_VALUE
, SH.BANK_ACCOUNT_ID
, SH.ORG_ID
, SH.CREATION_DATE
, SH.CREATED_BY
, SH.LAST_UPDATE_DATE
, SH.LAST_UPDATED_BY
, SH.CHECK_DIGITS
FROM CE_STATEMENT_HEADERS SH -- CE_BANK_ACCT_BALANCES BAL
WHERE -- SH.BANK_ACCOUNT_ID = BAL.BANK_ACCOUNT_ID(+)
AND -- SH.STATEMENT_DATE = BAL.BALANCE_DATE(+)
AND '_SEC:SH.ORG_ID' IS NOT NULL WITH READ ONLY