ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C8A7FD7AC920667BE0530100007F4469 CE Internal Bank Account Name (Secured) Y with ce_sec_v as (select /*+ materialize */ cbaua.bank_account_id, cspv.organization_type from ce_bank_acct_uses_all cbaua, ce_security_profiles_v cspv where ((cbaua.org_id = cspv.organization_id and cspv.organization_type = 'OPERATING_UNIT') or (cbaua.legal_entity_id = cspv.organization_id and cspv.organization_type = 'LEGAL_ENTITY') or (cbaua.org_id = cspv.organization_id and cspv.organization_type = 'BUSINESS_GROUP') ) and trunc(nvl(cbaua.end_date,sysdate)) >= trunc(sysdate) ) select cba.bank_account_name value, hpb.party_name||' ('||cba.currency_code||') Account#: ' || cba.masked_account_num description from ce_bank_accounts cba, hz_parties hpb, hz_parties hpbb where cba.account_classification = 'INTERNAL' and nvl(cba.netting_acct_flag,'N') = 'N' and hpb.party_id = cba.bank_id and hpbb.party_id = cba.bank_branch_id and (:$flex$.legal_entity is null or cba.account_owner_org_id in (select xep.legal_entity_id from xle_entity_profiles xep where xxen_util.contains(:$flex$.legal_entity,xep.name) = 'Y') ) and hpb.party_name = nvl(:$flex$.bank_name,hpb.party_name) and hpbb.party_name = nvl(:$flex$.bank_branch,hpbb.party_name) and ( ((cba.ap_use_allowed_flag = 'Y' or cba.ar_use_allowed_flag ='Y') and exists (select null from ce_sec_v where ce_sec_v.bank_account_id = cba.bank_account_id and ce_sec_v.organization_type = 'OPERATING_UNIT') ) or (cba.xtr_use_allowed_flag ='Y' and exists (select null from ce_sec_v where ce_sec_v.bank_account_id = cba.bank_account_id and ce_sec_v.organization_type = 'LEGAL_ENTITY') ) or (cba.pay_use_allowed_flag ='Y' and exists (select null from ce_sec_v where ce_sec_v.bank_account_id = cba.bank_account_id and ce_sec_v.organization_type = 'BUSINESS_GROUP') ) ) order by cba.bank_account_name US CE Internal Bank Account Names secured by CE Security Profile F82893FE27E8AB4BE0530100007FB42A CE Internal Bank Account Number (secured) Y with ce_sec_v as (select /*+ materialize */ cbaua.bank_account_id, cspv.organization_type from ce_bank_acct_uses_all cbaua, ce_security_profiles_v cspv where ((cbaua.org_id = cspv.organization_id and cspv.organization_type = 'OPERATING_UNIT') or (cbaua.legal_entity_id = cspv.organization_id and cspv.organization_type = 'LEGAL_ENTITY') or (cbaua.org_id = cspv.organization_id and cspv.organization_type = 'BUSINESS_GROUP') ) and trunc(nvl(cbaua.end_date,sysdate)) >= trunc(sysdate) ) select cba.bank_account_num value, hpb.party_name||' ('||cba.currency_code||') Account:' || cba.bank_account_name description from ce_bank_accounts cba, hz_parties hpb, hz_parties hpbb where cba.account_classification = 'INTERNAL' and nvl(cba.netting_acct_flag,'N') = 'N' and hpb.party_id = cba.bank_id and hpbb.party_id = cba.bank_branch_id and (:$flex$.legal_entity is null or cba.account_owner_org_id in (select xep.legal_entity_id from xle_entity_profiles xep where xxen_util.contains(:$flex$.legal_entity,xep.name) = 'Y') ) and hpb.party_name = nvl(:$flex$.bank_name,hpb.party_name) and hpbb.party_name = nvl(:$flex$.bank_branch,hpbb.party_name) and ( ((cba.ap_use_allowed_flag = 'Y' or cba.ar_use_allowed_flag ='Y') and exists (select null from ce_sec_v where ce_sec_v.bank_account_id = cba.bank_account_id and ce_sec_v.organization_type = 'OPERATING_UNIT') ) or (cba.xtr_use_allowed_flag ='Y' and exists (select null from ce_sec_v where ce_sec_v.bank_account_id = cba.bank_account_id and ce_sec_v.organization_type = 'LEGAL_ENTITY') ) or (cba.pay_use_allowed_flag ='Y' and exists (select null from ce_sec_v where ce_sec_v.bank_account_id = cba.bank_account_id and ce_sec_v.organization_type = 'BUSINESS_GROUP') ) ) order by cba.masked_account_num US CE Internal Bank Account Numbers secured by CE Security Profile CB5B97B15AC6A126E05362FB09055DE0 CE Internal Bank Branch Names Y select cbbv.bank_branch_name value, cbbv.bank_name description from ce_bank_branches_v cbbv where cbbv.branch_party_id in (select cba.bank_branch_id from ce_bank_accounts cba where cba.account_classification='INTERNAL' and nvl(cba.netting_acct_flag,'N') = 'N' ) and cbbv.bank_name = nvl(:$flex$.Bank_name,cbbv.bank_name) order by cbbv.bank_branch_name, cbbv.bank_name US CE Internal Bank Branch Names CB5B97B15AC5A126E05362FB09055DE0 CE Internal Bank Names Y select distinct cbbv.bank_name value, null description from ce_bank_branches_v cbbv where cbbv.branch_party_id in (select cba.bank_branch_id from ce_bank_accounts cba where cba.account_classification='INTERNAL' and nvl(cba.netting_acct_flag,'N') = 'N' ) order by cbbv.bank_name US CE Internal Bank Names D88803FCA7F06FCDE05362FB09056217 select ctcv.bank_name bank_name, ctcv.bank_branch_name bank_branch_name, ctcv.bank_account_name account_name, ctcv.bank_account_num account_number, ctcv.bank_account_currency_code currency, ctcv.type_dsp type, ctcv.trx_code code, ctcv.description description, ctcv.domain_code domain, ctcv.family_code family, ctcv.sub_family_code sub_family, ctcv.start_date start_date, ctcv.end_date end_date, ctcv.reconcile_flag_dsp transaction_source, ctcv.reconciliation_sequence reconciliation_sequence, ctcv.payroll_payment_format_dsp payroll_payment_format, ctcv.payroll_matching_order, cl2.meaning matching_against, cl1.meaning correction_method, ctcv.create_misc_trx_flag_dsp create_misc_trx_flag, ctcv.receivables_activity receivables_activity, ctcv.payment_method payment_method, ctcv.request_id request_id from ce_internal_bank_accounts_v cibav, ce_transaction_codes_v ctcv, ce_lookups cl1, ce_lookups cl2 where 1=1 and ctcv.bank_account_id = cibav.bank_account_id and cl1.lookup_code(+) = ctcv.correction_method and cl1.lookup_type(+) = 'CORRECTION_METHOD' and cl2.lookup_code(+) = ctcv.matching_against and cl2.lookup_type(+) = 'CORRECTION_MATCHING' order by ctcv.bank_name, ctcv.bank_branch_name, ctcv.bank_account_name, ctcv.bank_account_num, ctcv.bank_account_currency_code, ctcv.reconciliation_sequence, ctcv.type_dsp, ctcv.trx_code Y CE CEXTRXCD_XML AR CE قائمة رموز حركات البنك (بتنسيق XML) - غير مدعم: محجوز للاستخدام الآجل Imported from BI Publisher Description: أخرى - رموز الحركات Application: إدارة النقدية Source: قائمة رموز حركات البنك (بتنسيق XML) - غير مدعم: محجوز للاستخدام الآجل Short Name: CEXTRXCD_XML DB package: CE_CEXTRXCD_XMLP_PKG D CE Banktransaktionsschlüssel- Nicht unterstützt: Reserviert für zukünftige Verwendung Imported from BI Publisher Description: Sonstiges - Transaktionsschlüssel Application: Cash Management Source: Banktransaktionsschlüssel (XML) - Nicht unterstützt: Reserviert für zukünftige Verwendung Short Name: CEXTRXCD_XML DB package: CE_CEXTRXCD_XMLP_PKG E CE Listado de Códigos de Transacciones Bancarias: No Admitido, Reservado para Uso Futuro Imported from BI Publisher Description: Otros: Códigos de Transacciones Application: Cash Management Source: Listado de Códigos de Transacciones Bancarias (XML): No Admitido, Reservado para Uso Futuro Short Name: CEXTRXCD_XML DB package: CE_CEXTRXCD_XMLP_PKG F CE Liste des codes de mouvements bancaires- Non pris en charge : réservé pour une utilisation future Imported from BI Publisher Description: Autres - Codes mouvement Application: Cash Management Source: Liste des codes de mouvements bancaires (XML) - Non pris en charge : réservé pour une utilisation future Short Name: CEXTRXCD_XML DB package: CE_CEXTRXCD_XMLP_PKG I CE Elenco codici transazioni bancarie- non supportato: riservato per usi futuri Imported from BI Publisher Description: Altri: codici transazioni Application: Cash Management Source: Elenco codici transazioni bancarie (XML) - non supportato: riservato per usi futuri Short Name: CEXTRXCD_XML DB package: CE_CEXTRXCD_XMLP_PKG JA CE 銀行取引コード・リスト- 未サポート: 将来の使用のために予約 Imported from BI Publisher Description: その他 - 取引コード Application: Cash Management Source: 銀行取引コード・リスト(XML) - 未サポート: 将来の使用のために予約 Short Name: CEXTRXCD_XML DB package: CE_CEXTRXCD_XMLP_PKG KO CE 은행 거래 코드 목록- 지원되지 않음: 추후 사용을 위해 예약됨 Imported from BI Publisher Description: 기타 - 거래 코드 Application: Cash Management Source: 은행 거래 코드 목록(XML) - 지원되지 않음: 추후 사용을 위해 예약됨 Short Name: CEXTRXCD_XML DB package: CE_CEXTRXCD_XMLP_PKG PTB CE Lista de Códigos de Transação Bancária- Não Suportada: Reservada para Uso Futuro Imported from BI Publisher Description: Outros - Códigos de Transação Application: Cash Management Source: Lista de Códigos de Transação Bancária (XML) - Não Suportada: Reservada para Uso Futuro Short Name: CEXTRXCD_XML DB package: CE_CEXTRXCD_XMLP_PKG RU CE Список кодов банковских транзакций- не поддерживается: зарезервировано для будущего использования Imported from BI Publisher Description: Другое - коды транзакций Application: Движение денежных средств Source: Список кодов банковских транзакций (XML) - не поддерживается: зарезервировано для будущего использования Short Name: CEXTRXCD_XML DB package: CE_CEXTRXCD_XMLP_PKG S CE Lista över banktransaktionskoder- stöds inte: Reserverad för framtida bruk Imported from BI Publisher Description: Övrigt - Transaktionskoder Application: Cash Management Source: Lista över banktransaktionskoder (XML) - stöds inte: Reserverad för framtida bruk Short Name: CEXTRXCD_XML DB package: CE_CEXTRXCD_XMLP_PKG TR CE Banka İşlem Kodları Listesi- Desteklenmez: Gelecekte Kullanım İçin Ayrılmıştır Imported from BI Publisher Description: Diğer - İşlem Kodları Application: Nakit Yönetimi Source: Banka İşlem Kodları Listesi (XML) - Desteklenmez: Gelecekte Kullanım İçin Ayrılmıştır Short Name: CEXTRXCD_XML DB package: CE_CEXTRXCD_XMLP_PKG US CE Bank Transaction Codes Listing Imported from BI Publisher Description: Bank Transaction Codes Application: Cash Management Source: Bank Transaction Codes Listing Short Name: CEXTRXCD DB package: CE_CEXTRXCD_XMLP_PKG ZHS CE 银行事务处理代码列表- 不支持：已保留供将来使用 Imported from BI Publisher Description: 其它 - 事务处理代码 Application: 现金管理系统 Source: 银行事务处理代码列表 (XML) - 不支持：已保留供将来使用 Short Name: CEXTRXCD_XML DB package: CE_CEXTRXCD_XMLP_PKG Enginatics R12 only 1=1 :c_bank_account_name :c_bank_account_num :c_bank_branch_name :c_bank_currency_code :c_bank_name :c_company_name_header :c_the_end :p_bank_account_id :p_conc_request_id :p_debug_mode :p_sql_trace 1 10 1=1 ctcv.bank_name=:p_bank_name LOV CE Internal Bank Names CB5B97B15AC5A126E05362FB09055DE0 Y select distinct cbbv.bank_name value, null description from ce_bank_branches_v cbbv where cbbv.branch_party_id in (select cba.bank_branch_id from ce_bank_accounts cba where cba.account_classification='INTERNAL' and nvl(cba.netting_acct_flag,'N') = 'N' ) order by cbbv.bank_name F Nom de la banque US Bank Name 2 20 1=1 ctcv.bank_branch_name=:p_bank_branch_name LOV CE Internal Bank Branch Names CB5B97B15AC6A126E05362FB09055DE0 Y select cbbv.bank_branch_name value, cbbv.bank_name description from ce_bank_branches_v cbbv where cbbv.branch_party_id in (select cba.bank_branch_id from ce_bank_accounts cba where cba.account_classification='INTERNAL' and nvl(cba.netting_acct_flag,'N') = 'N' ) and cbbv.bank_name = nvl(:$flex$.Bank_name,cbbv.bank_name) order by cbbv.bank_branch_name, cbbv.bank_name F Nom de la succursale bancaire US Bank Branch Name 3 30 1=1 ctcv.bank_account_name=:p_bank_account_name LOV CE Internal Bank Account Name (Secured) C8A7FD7AC920667BE0530100007F4469 Y with ce_sec_v as (select /*+ materialize */ cbaua.bank_account_id, cspv.organization_type from ce_bank_acct_uses_all cbaua, ce_security_profiles_v cspv where ((cbaua.org_id = cspv.organization_id and cspv.organization_type = 'OPERATING_UNIT') or (cbaua.legal_entity_id = cspv.organization_id and cspv.organization_type = 'LEGAL_ENTITY') or (cbaua.org_id = cspv.organization_id and cspv.organization_type = 'BUSINESS_GROUP') ) and trunc(nvl(cbaua.end_date,sysdate)) >= trunc(sysdate) ) select cba.bank_account_name value, hpb.party_name||' ('||cba.currency_code||') Account#: ' || cba.masked_account_num description from ce_bank_accounts cba, hz_parties hpb, hz_parties hpbb where cba.account_classification = 'INTERNAL' and nvl(cba.netting_acct_flag,'N') = 'N' and hpb.party_id = cba.bank_id and hpbb.party_id = cba.bank_branch_id and (:$flex$.legal_entity is null or cba.account_owner_org_id in (select xep.legal_entity_id from xle_entity_profiles xep where xxen_util.contains(:$flex$.legal_entity,xep.name) = 'Y') ) and hpb.party_name = nvl(:$flex$.bank_name,hpb.party_name) and hpbb.party_name = nvl(:$flex$.bank_branch,hpbb.party_name) and ( ((cba.ap_use_allowed_flag = 'Y' or cba.ar_use_allowed_flag ='Y') and exists (select null from ce_sec_v where ce_sec_v.bank_account_id = cba.bank_account_id and ce_sec_v.organization_type = 'OPERATING_UNIT') ) or (cba.xtr_use_allowed_flag ='Y' and exists (select null from ce_sec_v where ce_sec_v.bank_account_id = cba.bank_account_id and ce_sec_v.organization_type = 'LEGAL_ENTITY') ) or (cba.pay_use_allowed_flag ='Y' and exists (select null from ce_sec_v where ce_sec_v.bank_account_id = cba.bank_account_id and ce_sec_v.organization_type = 'BUSINESS_GROUP') ) ) order by cba.bank_account_name F Nom du compte bancaire US Bank Account Name 4 40 1=1 ctcv.bank_account_num=:p_bank_account_num LOV CE Internal Bank Account Number (secured) F82893FE27E8AB4BE0530100007FB42A Y with ce_sec_v as (select /*+ materialize */ cbaua.bank_account_id, cspv.organization_type from ce_bank_acct_uses_all cbaua, ce_security_profiles_v cspv where ((cbaua.org_id = cspv.organization_id and cspv.organization_type = 'OPERATING_UNIT') or (cbaua.legal_entity_id = cspv.organization_id and cspv.organization_type = 'LEGAL_ENTITY') or (cbaua.org_id = cspv.organization_id and cspv.organization_type = 'BUSINESS_GROUP') ) and trunc(nvl(cbaua.end_date,sysdate)) >= trunc(sysdate) ) select cba.bank_account_num value, hpb.party_name||' ('||cba.currency_code||') Account:' || cba.bank_account_name description from ce_bank_accounts cba, hz_parties hpb, hz_parties hpbb where cba.account_classification = 'INTERNAL' and nvl(cba.netting_acct_flag,'N') = 'N' and hpb.party_id = cba.bank_id and hpbb.party_id = cba.bank_branch_id and (:$flex$.legal_entity is null or cba.account_owner_org_id in (select xep.legal_entity_id from xle_entity_profiles xep where xxen_util.contains(:$flex$.legal_entity,xep.name) = 'Y') ) and hpb.party_name = nvl(:$flex$.bank_name,hpb.party_name) and hpbb.party_name = nvl(:$flex$.bank_branch,hpbb.party_name) and ( ((cba.ap_use_allowed_flag = 'Y' or cba.ar_use_allowed_flag ='Y') and exists (select null from ce_sec_v where ce_sec_v.bank_account_id = cba.bank_account_id and ce_sec_v.organization_type = 'OPERATING_UNIT') ) or (cba.xtr_use_allowed_flag ='Y' and exists (select null from ce_sec_v where ce_sec_v.bank_account_id = cba.bank_account_id and ce_sec_v.organization_type = 'LEGAL_ENTITY') ) or (cba.pay_use_allowed_flag ='Y' and exists (select null from ce_sec_v where ce_sec_v.bank_account_id = cba.bank_account_id and ce_sec_v.organization_type = 'BUSINESS_GROUP') ) ) order by cba.masked_account_num AR رقم حساب البنك رقم حساب البنك D Kontonummer Kontonummer E Número de Cuenta Bancaria Número de Cuenta Bancaria F Numéro de compte bancaire Numéro de compte bancaire I Numero conto bancario Numero conto bancario JA 銀行口座番号 銀行口座番号 KO 은행 계정 번호 은행 계좌 번호 PTB Número da Conta Bancária Número da Conta Bancária RU № банковского счета № банковского счета S Bankkontonummer Bankkontonummer TR Banka Hesap Numarası Banka Hesap Numarası US Bank Account Number Bank Account Number ZHS 银行帐号 银行帐号 :$flex$.Bank_name Bank Name Bank Branch Name :$flex$.bank_name Bank Name Bank Account Name :$flex$.bank_name Bank Name Bank Account Number