ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223EF493869E053B46B63588994 SELECT inline.BANK_ACCOUNT_NUM BANK_ACCOUNT_NUM , inline.BANK_STMT_NUM BANK_STMT_NUM , inline.BANK_STMT_DATE BANK_STMT_DATE , inline.STATUS STATUS , inline.control_begin_balance BEGIN_BALANCE , inline.control_end_balance CLOSE_BALANCE FROM ( SELECT &lc_uploaded_select_columns , TRUNC(statement_date) BANK_STMT_DATE , &gc_status_current STATUS , control_begin_balance , control_end_balance FROM ce_statement_headers_int uploaded WHERE &lc_uploaded_where_conditions AND uploaded.statement_date = (SELECT MIN(inner_uploaded.statement_date) FROM ce_statement_headers_int inner_uploaded WHERE inner_uploaded.bank_branch_name = :gc_bank_branch_name AND inner_uploaded.bank_account_num = uploaded.bank_account_num GROUP BY inner_uploaded.bank_account_num ) ORDER BY statement_date ) inline UNION ALL SELECT inline.BANK_ACCOUNT_NUM BANK_ACCOUNT_NUM , inline.statement_number BANK_STMT_NUM , inline.statement_date BANK_STMT_DATE , inline.STATUS STATUS , inline.control_begin_balance BEGIN_BALANCE , inline.control_end_balance CLOSE_BALANCE FROM ( SELECT &lc_latest_bank_acc_num BANK_ACCOUNT_NUM , statement_number , statement_date , &gc_status_latest STATUS , control_begin_balance , control_end_balance FROM ce_statement_headers latest &lc_latest_bank_acc_from WHERE statement_date < (SELECT MIN(TRUNC(uploaded.statement_date)) FROM ce_statement_headers_int uploaded WHERE &lc_uploaded_where_conditions AND uploaded.bank_account_num = &lc_latest_bank_acc_num GROUP BY uploaded.bank_account_num ) &lc_latest_bank_acc_where ) inline, ( SELECT &lc_latest_bank_acc_num BANK_ACCOUNT_NUM , MAX(statement_date) statement_date FROM ce_statement_headers latest &lc_latest_bank_acc_from WHERE statement_date < (SELECT MIN(TRUNC(uploaded.statement_date)) FROM ce_statement_headers_int uploaded WHERE &lc_uploaded_where_conditions AND uploaded.bank_account_num = &lc_latest_bank_acc_num GROUP BY uploaded.bank_account_num ) &lc_latest_bank_acc_where GROUP BY &lc_latest_bank_acc_num ) inline1 WHERE inline.statement_date = inline1.statement_date AND inline.BANK_ACCOUNT_NUM = inline1.BANK_ACCOUNT_NUM Y CE CEBNKSTMTIMP AR CE مراجعة استيراد كشف حساب البنك - إسرائيل Application: إدارة النقدية Source: مراجعة استيراد كشف حساب البنك - إسرائيل Short Name: CEBNKSTMTIMP DB package: CE_BNK_STMT_IMP_RPT_PKG D CE Kontoauszugsimport-Validierung - Israel Application: Cash Management Source: Kontoauszugsimport-Validierung - Israel Short Name: CEBNKSTMTIMP DB package: CE_BNK_STMT_IMP_RPT_PKG F CE Validation de l'importation des relevés bancaires - Israël Application: Cash Management Source: Validation de l'importation des relevés bancaires - Israël Short Name: CEBNKSTMTIMP DB package: CE_BNK_STMT_IMP_RPT_PKG US CE Bank Statement Import Validation - Israel Application: Cash Management Source: Bank Statement Import Validation - Israel Short Name: CEBNKSTMTIMP DB package: CE_BNK_STMT_IMP_RPT_PKG ZHS CE 银行对帐单导入验证 - 以色列 Application: 现金管理系统 Source: 银行对帐单导入验证 - 以色列 Short Name: CEBNKSTMTIMP DB package: CE_BNK_STMT_IMP_RPT_PKG BI Publisher &gc_status_current &gc_status_latest &lc_latest_bank_acc_from &lc_latest_bank_acc_num &lc_latest_bank_acc_where &lc_uploaded_select_columns &lc_uploaded_where_conditions :gc_bank_account_num :gc_bank_branch_name :gc_control_totals :gc_from_and_where :gc_status_current :gc_status_latest :gn_total_cr :gn_total_dr :lc_latest_bank_acc_from :lc_latest_bank_acc_num :lc_latest_bank_acc_where :lc_uploaded_group_by :lc_uploaded_select_columns :lc_uploaded_where_conditions :p_bank_account_id :p_bank_branch_id :p_statement_num 1 10 :p_bank_branch_id LOV Oracle CE_BANK_BRANCHES Y select branch_party_id id, bank_branch_name value, bank_name description from ce_bank_branches_v where branch_party_id in (select bank_branch_id from ce_bank_accounts a where a.account_classification='INTERNAL' ) order by bank_branch_name,bank_name Y AR اسم فرع البنك D Zweigstellenbezeichnung F Nom de l'agence bancaire US Bank Branch Name ZHS 分行名称 2 20 :p_bank_account_id LOV Oracle CE_BANK_ACC_NUM Y select bank_account_id id, bank_account_num value, bank_account_name description from ce_bank_accounts_v where bank_branch_id=nvl(:$flex$.ce_bank_branches, bank_branch_id) and account_classification='INTERNAL' order by bank_account_name AR رقم حساب البنك D Bankkontonummer F Numéro de compte bancaire US Bank Account Number ZHS 银行帐号 3 30 :p_statement_num LOV Oracle CE_ABR_ALL_STATEMENT_NUM_FROM Y select statement_number id, statement_number value, null description from ce_all_statements_v where bank_account_id=:$flex$.ce_bank_acc_num order by statement_number AR رقم كشف الحساب D Kontoauszugsnummer F Numéro de relevé US Statement Number ZHS 对帐单编号 :$flex$.ce_bank_acc_num Bank Account Number Statement Number :$flex$.ce_bank_branches Bank Branch Name Bank Account Number