VIEW: APPS.CEFV_BANK_STATEMENTS

Source

View Text - Preformatted

SELECT sh.statement_header_id, ba.bank_account_num, ba.bank_account_name, 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, ba.currency_code, sh.statement_complete_flag, sh.doc_sequence_value, og.name, ba.bank_account_id, og.organization_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,*/ ce_bank_accounts ba, hr_all_organization_units og WHERE ba.bank_account_id = sh.bank_account_id /*and sh.bank_account_id = bal.bank_account_id(+)*/ /*and sh.statement_date = bal.balance_date(+)*/ and og.organization_id (+) = sh.org_id and '_SEC:sh.org_id' is not null with read only

View Text - HTML Formatted

SELECT SH.STATEMENT_HEADER_ID
, BA.BANK_ACCOUNT_NUM
, BA.BANK_ACCOUNT_NAME
, 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
, BA.CURRENCY_CODE
, SH.STATEMENT_COMPLETE_FLAG
, SH.DOC_SEQUENCE_VALUE
, OG.NAME
, BA.BANK_ACCOUNT_ID
, OG.ORGANIZATION_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
, */ CE_BANK_ACCOUNTS BA
, HR_ALL_ORGANIZATION_UNITS OG
WHERE BA.BANK_ACCOUNT_ID = SH.BANK_ACCOUNT_ID /*AND SH.BANK_ACCOUNT_ID = BAL.BANK_ACCOUNT_ID(+)*/ /*AND SH.STATEMENT_DATE = BAL.BALANCE_DATE(+)*/
AND OG.ORGANIZATION_ID (+) = SH.ORG_ID
AND '_SEC:SH.ORG_ID' IS NOT NULL WITH READ ONLY