ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 49A8B1A8037108ACE0530100007FEB91 select rtt.name term_name, rtt.description, decode(rtb.partial_discount_flag,'Y','Yes') partial_payment_discount, decode(rtb.prepayment_flag,'Y','Yes') prepayment, decode(rtb.credit_check_flag,'Y','Yes') credit_check, &billing_cycle_column rtb.base_amount, xxen_util.meaning(decode(rtb.calc_discount_on_lines_flag,'Y','L','N','I',rtb.calc_discount_on_lines_flag),'DISCOUNT_BASIS',222) discount_basis, rtb.printing_lead_days, xxen_util.meaning(rtb.first_installment_code,'INSTALLMENT_OPTION',222) installment_options, rtl.relative_amount, rtl.due_days, rtl.due_day_of_month day_of_month, rtl.due_months_forward months_ahead, (select distinct listagg(rtld.discount_percent||'%/'||nvl(rtld.discount_days,nvl(rtld.discount_day_of_month,rtld.discount_months_forward)),', ') within group (order by rtld.discount_days) over (partition by rtld.term_id) from ra_terms_lines_discounts rtld where rtb.term_id=rtld.term_id) cash_discount, xxen_util.user_name(rtb.created_by) created_by, xxen_util.client_time(rtb.creation_date) creation_date, xxen_util.user_name(rtb.last_updated_by) last_updated_by, xxen_util.client_time(rtb.last_update_date) last_update_date from ra_terms_b rtb, ra_terms_tl rtt, &billing_cycle_table ra_terms_lines rtl where 1=1 and rtb.term_id=rtt.term_id and rtt.language=userenv('lang') and &billing_cycle_joins rtb.term_id=rtl.term_id order by rtt.name, rtl.sequence_num Y AR AR Payment Terms تقرير بيانات رئيسي يوضح رموز شروط الدفع مع خيارات الملف الشخصي الخاصة بكل منها. D AR Payment Terms Stammdatenbericht, der die Zahlungsbedingungscodes mit ihren jeweiligen Profiloptionen anzeigt. E AR Payment Terms Informe de datos maestros que muestra los códigos de las condiciones de pago con sus respectivas opciones de perfil. F AR Payment Terms Rapport des données de base indiquant les codes des conditions de paiement avec leurs options de profil respectives. I AR Payment Terms Rapporto dei dati anagrafici che mostra i codici dei termini di pagamento con le loro rispettive opzioni di profilo. JA AR Payment Terms それぞれのプロファイルオプションを持つ支払条件コードを示すマスターデータレポート。 KO AR Payment Terms 각각의 프로필 옵션과 함께 지불 조건 코드를 보여주는 마스터 데이터 보고서. PTB AR Payment Terms Relatório de dados mestre mostrando os códigos de condições de pagamento com suas respectivas opções de perfil. RU AR Payment Terms Отчет об основных данных, показывающий коды платежных условий с соответствующими опциями профиля. S AR Payment Terms Huvuddatarapport som visar betalningsvillkodskoderna med deras respektive profilalternativ. TR AR Payment Terms Ödeme koşulları kodlarını ilgili profil seçenekleriyle birlikte gösteren ana veri raporu. US AR Payment Terms Master data report showing the payment terms codes with their respective profile options. ZHS AR Payment Terms 主数据报告显示付款条件代码及其各自的概况选项。 Enginatics &billing_cycle_column &billing_cycle_joins &billing_cycle_table 1=1 1 -10 &billing_cycle_column acbct.cycle_name billing_cycle, Char 12 select decode(fnd_release.major_version,'11','11','12') from dual US EBS Release Version 2 &billing_cycle_joins rtb.billing_cycle_id=acbct.billing_cycle_id(+) and acbct.language(+)=userenv('lang') and 12 US EBS Release Version 3 &billing_cycle_table ar_cons_bill_cycles_tl acbct, 12 US EBS Release Version