ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 8E2FF36EDEB979D2E0530100007F1FF2 HR Operating Unit Y select hou.name value, null description from hr_operating_units hou where sysdate between hou.date_from and nvl(hou.date_to,sysdate) and (:$flex$.ledger is null or hou.set_of_books_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y')) and hou.organization_id in (select mgoat.organization_id from mo_glob_org_access_tmp mgoat union select fnd_global.org_id from dual where fnd_release.major_version=11) order by hou.name Fixed where clause duplication AR وحدة التشغيل مقيدة بالتحكم في الوصول متعدد المنظمات (MOAC) D Bedieneinheit eingeschränkt durch Multi Org Access Control (MOAC) E Unidad operativa restringida por el control de acceso multiorgánico (MOAC) F Unité opérationnelle restreinte par un contrôle d'accès multi-organismes (MOAC) I Unità operativa limitata dal controllo di accesso multiorgano (MOAC) JA 多機関アクセス制御(MOAC)で制限された操作ユニット KO 다중 조직 액세스 제어 (MOAC)에 의해 제한되는 운영 단위 PTB Unidade operacional restrita por controle de acesso multi org (MOAC) RU Операционное устройство, ограниченное мультиорганизованным контролем доступа (MOAC) S Styrenhet begränsad av multi-org access control (MOAC) TR Çoklu kuruluş erişim kontrolü (MOAC) tarafından kısıtlanan işletim birimi US Operating unit restricted by multi org access control (MOAC) ZHS 受多机构访问控制（MOAC）限制的操作单元。 EEE75CEB4A9F6AD8E05362FB09051F8B select x.* from ( SELECT * from (SELECT CONTRACT_NUMBER, GL_ACCOUNT, GL_ACCT_DESCRIPTION, ENTERED_DR, ENTERED_CR, STREAM_CODE, decode(deal_type,'LOAN-REVOLVING',decode(stream_type_purpose,'PRINCIPAL_CATCHUP',0, (select sum(amount) from okl_trx_ap_invs_all_b where khr_id =ocs.contract_id and trx_status_code in('PROCESSED','APPROVED') and ocs.stream_type_purpose='PRINCIPAL_BALANCE')), 'LOAN', decode(stream_type_purpose,'PRINCIPAL_CATCHUP',0,stream_full_value), stream_full_value) STREAM_FULL_VALUE, subledger_balance, spec_id ecc_spec_id, contract_status, stream_type_purpose, decode(stream_type_purpose,'FUNDING',decode(fundable_amount,0,0,stream_balance), stream_balance) stream_balance, (flv.meaning) account_group_code, abs_subledger_balance, org_id, ledger_name, ledger_currency, conversion_rate_date, conversion_type, conversion_rate, decode(stream_type_purpose,'FUNDING',decode(fundable_amount,0,0,(stream_balance * nvl(conversion_rate,1))), (stream_balance*nvl(conversion_rate,1)))acctd_stream_balance, -- bug 30719664 (stream_full_value * nvl(conversion_rate,1)) acctd_stream_full_value, (subledger_balance * nvl(conversion_rate,1)) acctd_subledger_balance, flv.language language_code, fundable_amount, funded_amount, fundable_remaining, fundable_remaining * nvl(conversion_rate,1) acctd_fundable_amount, ocs.account_group_code account_code, decode(account_group_code,'UNBILLED_RECEIVABLES',(nvl(stream_balance,0)-nvl(subledger_balance,0)) ,'RESIDUAL',abs(nvl(stream_balance,0)-nvl(subledger_balance,0)) ,'UNEARNED_REVENUE',((nvl(stream_balance,0)-nvl(subledger_balance,0))) ,'FUNDABLE_ASSET',abs((nvl(stream_balance,0)-nvl(subledger_balance,0))) ,'LOAN_PRINCIPAL',((nvl(stream_balance,0)-nvl(subledger_balance,0))) ,'REV_LOAN_PRINCIPAL',((nvl(stream_balance,0)-nvl(subledger_balance,0))) ,nvl(stream_balance,0)) unbilled_receivable_bar, decode(account_group_code,'UNBILLED_RECEIVABLES',(nvl(stream_balance,0)-nvl(subledger_balance,0)) ,'RESIDUAL',abs(nvl(stream_balance,0)-nvl(subledger_balance,0)) ,'UNEARNED_REVENUE',((nvl(stream_balance,0)-nvl(subledger_balance,0))) ,'FUNDABLE_ASSET',abs((nvl(stream_balance,0)-nvl(subledger_balance,0))) ,'LOAN_PRINCIPAL',((nvl(stream_balance,0)-nvl(subledger_balance,0))) ,'REV_LOAN_PRINCIPAL',((nvl(stream_balance,0)-nvl(subledger_balance,0))) ,nvl(stream_balance,0))* nvl(conversion_rate,1) acctd_recv_bar, currency_code, nvl(subledger_balance,0)-nvl(stream_balance,0) reconciliation_balance, (select max(actual_principal_balance_date) from OKL_CNTRCT_BALANCES_ALL where khr_id= ocs.contract_id) principal_update_date, interest_calculation_method, revenue_recognition_method, bc.meaning book_classification, deal_type, principal_basis_code, pbc.meaning principal_basis, receipt_amt_applied from OKL_ECC_ARCON_CONTRACT_SUMM ocs, fnd_lookup_values flv, fnd_lookup_values bc, fnd_lookup_values pbc where 1 =1 and flv.lookup_code = ocs.account_group_code and flv.lookup_type = 'OKL_REPORT_ACCNT_GROUP' and deal_type= bc.lookup_code and bc.lookup_type='OKL_BOOK_CLASS' and bc.language= flv.language and nvl(pbc.lookup_type,'OKL_PRINCIPAL_BASIS_CODE')='OKL_PRINCIPAL_BASIS_CODE' and pbc.lookup_code(+) = principal_basis_code and nvl(pbc.language,flv.language)= flv.language --included nvl BUG 31665696 and deal_type in('LOAN','LEASEDF','LOAN-REVOLVING') and flv.language in('US') ) PIVOT (MAX(account_group_code) AS ACCOUNT_GROUP_CODE, MAX(book_classification) AS BOOK_CLASSIFICATION, MAX(principal_basis) AS principal_basis -- MAX(stream_description) AS stream_description, for language_code in ('US' "US")) ) x where 2=2 Y AR ECC عقود الإيجار, ملخص أرصدة حساب العقد Imported from Enterprise Command Center Description: ملخص أرصدة حساب عقد الإيجار Dataset Key: okl_arcon_cont_summ Query Procedure: okl_ecc_arcon_pkg.ecc_acct_recon_data_load Security Procedure: okl_ecc_datasecurity_pkg_pub.GetFilterAttributeValues D ECC Leasingverträge, Vertrag - Kontensalden - Übersicht Imported from Enterprise Command Center Description: Leasingvertrag - Kontensalden - Übersicht Dataset Key: okl_arcon_cont_summ Query Procedure: okl_ecc_arcon_pkg.ecc_acct_recon_data_load Security Procedure: okl_ecc_datasecurity_pkg_pub.GetFilterAttributeValues E ECC Lease Contracts, Resumen de Saldos de Cuenta de Contrato Imported from Enterprise Command Center Description: Resumen de Saldos de Cuenta de Contrato de Leasing Dataset Key: okl_arcon_cont_summ Query Procedure: okl_ecc_arcon_pkg.ecc_acct_recon_data_load Security Procedure: okl_ecc_datasecurity_pkg_pub.GetFilterAttributeValues F ECC Contrats Lease, Synthèse des soldes comptables de contrat Imported from Enterprise Command Center Description: Synthèse soldes comptables de contrat de crédit-bail Dataset Key: okl_arcon_cont_summ Query Procedure: okl_ecc_arcon_pkg.ecc_acct_recon_data_load Security Procedure: okl_ecc_datasecurity_pkg_pub.GetFilterAttributeValues I ECC Contratti leasing, Sintetico saldi conto contratto Imported from Enterprise Command Center Description: Lease: sintetico saldi conto contratto Dataset Key: okl_arcon_cont_summ Query Procedure: okl_ecc_arcon_pkg.ecc_acct_recon_data_load Security Procedure: okl_ecc_datasecurity_pkg_pub.GetFilterAttributeValues JA ECC リース契約, 契約勘定科目残高要約 Imported from Enterprise Command Center Description: リース契約勘定科目残高要約 Dataset Key: okl_arcon_cont_summ Query Procedure: okl_ecc_arcon_pkg.ecc_acct_recon_data_load Security Procedure: okl_ecc_datasecurity_pkg_pub.GetFilterAttributeValues KO ECC 리스 계약, 계약 계정 잔액 요약 Imported from Enterprise Command Center Description: 리스 계약 계정 잔액 요약 Dataset Key: okl_arcon_cont_summ Query Procedure: okl_ecc_arcon_pkg.ecc_acct_recon_data_load Security Procedure: okl_ecc_datasecurity_pkg_pub.GetFilterAttributeValues RU ECC Контракты на лизинг, Сводка сальдо счетов контракта Imported from Enterprise Command Center Description: Лизинг: сводка сальдо счетов контракта Dataset Key: okl_arcon_cont_summ Query Procedure: okl_ecc_arcon_pkg.ecc_acct_recon_data_load Security Procedure: okl_ecc_datasecurity_pkg_pub.GetFilterAttributeValues S ECC Hyresavtal: Kontrakt, Översikt över kontosaldon för kontrakt Imported from Enterprise Command Center Description: Hyresavtal: Översikt över kontosaldon för kontrakt Dataset Key: okl_arcon_cont_summ Query Procedure: okl_ecc_arcon_pkg.ecc_acct_recon_data_load Security Procedure: okl_ecc_datasecurity_pkg_pub.GetFilterAttributeValues TR ECC Kiralama Sözleşmeleri, Sözleşme Hesap Bakiyeleri Özeti Imported from Enterprise Command Center Description: Kiralama Sözleşmesi Hesap Bakiyeleri Özeti Dataset Key: okl_arcon_cont_summ Query Procedure: okl_ecc_arcon_pkg.ecc_acct_recon_data_load Security Procedure: okl_ecc_datasecurity_pkg_pub.GetFilterAttributeValues US ECC Lease Contracts, Contract Account Balances Summary Imported from Enterprise Command Center Description: Lease Contract Account Balances Summary Dataset Key: okl_arcon_cont_summ Query Procedure: okl_ecc_arcon_pkg.ecc_acct_recon_data_load Security Procedure: okl_ecc_datasecurity_pkg_pub.GetFilterAttributeValues ZHS ECC Lease Contracts, 合同账户余额汇总 Imported from Enterprise Command Center Description: 租赁合同账户余额汇总 Dataset Key: okl_arcon_cont_summ Query Procedure: okl_ecc_arcon_pkg.ecc_acct_recon_data_load Security Procedure: okl_ecc_datasecurity_pkg_pub.GetFilterAttributeValues Enterprise Command Center 1 10 2=2 x.org_id in (select haouv.organization_id from hr_all_organization_units_vl haouv where haouv.name=:operating_unit) LOV HR Operating Unit 8E2FF36EDEB979D2E0530100007F1FF2 Y select hou.name value, null description from hr_operating_units hou where sysdate between hou.date_from and nvl(hou.date_to,sysdate) and (:$flex$.ledger is null or hou.set_of_books_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y')) and hou.organization_id in (select mgoat.organization_id from mo_glob_org_access_tmp mgoat union select fnd_global.org_id from dual where fnd_release.major_version=11) order by hou.name select haouv.name from hr_all_organization_units_vl haouv where haouv.organization_id=nvl((select mgoat.organization_id from mo_glob_org_access_tmp mgoat where mgoat.organization_id=nvl(fnd_profile.value('DEFAULT_ORG_ID'),mgoat.organization_id) and rownum=1),fnd_global.org_id) US Operating Unit