ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 8E2FF36EDEB879D2E0530100007F1FF2 GL Ledger Y select gl.name value, fifsv.id_flex_structure_name||': '||decode(gl.ledger_category_code,'NONE',xxen_util.meaning(gl.object_type_code,'LEDGERS',101),xxen_util.meaning(gl.ledger_category_code,'GL_ASF_LEDGER_CATEGORY',101))||': '||gl.description description from gl_ledgers gl, fnd_id_flex_structures_vl fifsv where (:$flex$.ledger_category is null or gl.ledger_category_code=xxen_util.lookup_code(:$flex$.ledger_category,'GL_ASF_LEDGER_CATEGORY',101,'Y')) and (:$flex$.chart_of_accounts is null or xxen_util.contains(:$flex$.chart_of_accounts,fifsv.id_flex_structure_name)='Y') and gl.ledger_id in (select nvl(glsnav.ledger_id,gasna.ledger_id) from gl_access_set_norm_assign gasna, gl_ledger_set_norm_assign_v glsnav where gasna.access_set_id=fnd_profile.value('GL_ACCESS_SET_ID') and gasna.ledger_id=glsnav.ledger_set_id(+)) and gl.chart_of_accounts_id=fifsv.id_flex_num and fifsv.id_flex_code='GL#' and fifsv.application_id=101 order by fifsv.id_flex_structure_name, decode(gl.ledger_category_code,'PRIMARY',1,'SECONDARY',2,'ALC',3,'NONE',4), gl.name AR دفاتر الأستاذ المقيدة بمجموعة الوصول ، المحددة بواسطة قيمة الملف الشخصي "مجموعة الوصول إلى بيانات GL" لمسؤولية تسجيل الدخول الحالية D Ledger, die durch das Zugriffsset eingeschränkt sind, definiert durch den Profilwert 'GL Data Access Set' der aktuellen Anmeldeverantwortung E Libros restringidos por el conjunto de acceso, definido por el valor del perfil "Conjunto de acceso a datos GL" de la responsabilidad de inicio de sesión actual F Grands livres limités par un ensemble d'accès, défini par la valeur du profil "GL Data Access Set" de la responsabilité de connexion actuelle I Libri mastri limitati dal set di accesso, definito dal valore del profilo 'GL Data Access Set' della responsabilità di login corrente JA 現在のログイン責任者のプロファイル値'GL Data Access Set'によって定義されたアクセスセットによって制限された元帳 KO 현재 로그인 권한의 프로파일 값 'GL 데이터 액세스 세트'로 정의 된 액세스 세트로 제한되는 원장 PTB Ledgers restritos pelo conjunto de acesso, definido pelo valor do perfil 'GL Data Access Set' da atual responsabilidade de login RU Леджеры, ограниченные набором доступа, определяемые значением профиля "GL Data Access Set" текущей ответственности за вход в систему S Ledgers begränsade av åtkomstuppsättning, definierade av profilvärde 'GL Data Access Set' för det aktuella inloggningsansvaret TR Mevcut oturum açma sorumluluğunun profil değeri 'GL Veri Erişim Kümesi' ile tanımlanan erişim kümesiyle kısıtlanmış defterler US Ledgers restricted by access set, defined by profile value 'GL Data Access Set' of the current login responsibility ZHS 由访问集限制的分类账，由当前登录责任的配置文件值 "GL数据访问集 "定义。 8E2FF36EDEA679D2E0530100007F1FF2 Yes Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual US 49A8B1A803A008ACE0530100007FEB91 select distinct gl.name ledger, gl.currency_code ledger_currency, hou.name operating_unit, (select hl.address1 from hz_cust_acct_sites hcasa, hz_party_sites hps, hz_locations hl where hcasa.cust_acct_site_id=:remit_to_address and hcasa.cust_account_id=-1 and hcasa.party_site_id=hps.party_site_id and hps.location_id=hl.location_id ) branch, (select ftv.territory_short_name from hz_cust_acct_sites_all hcasa, hz_party_sites hps, hz_locations hl, fnd_territories_vl ftv where hcasa.cust_acct_site_id=rcta.remit_to_address_id and hcasa.cust_account_id=-1 and hcasa.party_site_id=hps.party_site_id and hps.location_id=hl.location_id and hl.country=ftv.territory_code ) branch_country, (select nvl(zptp.rep_registration_number,zr.registration_number) from xle_etb_profiles xep, zx_party_tax_profile zptp, zx_registrations zr where xep.legal_entity_id = arp_legal_entity_util.get_default_legal_context(hou.organization_id) and xep.main_establishment_flag = 'Y' and xep.party_id = zptp.party_id and zptp.party_type_code = 'LEGAL_ESTABLISHMENT' and zptp.party_tax_profile_id = zr.party_tax_profile_id and trunc(sysdate) between trunc(zr.effective_from) and trunc(nvl(zr.effective_to,sysdate)) and ( (zr.default_registration_flag = 'Y' and not exists (select 1 from zx_registrations zr1, zx_party_tax_profile zptp1, xle_etb_profiles xep1 where xep1.legal_entity_id = arp_legal_entity_util.get_default_legal_context(hou.organization_id) and xep1.main_establishment_flag = 'Y' and xep1.party_id = zptp1.party_id and zptp1.party_type_code = 'LEGAL_ESTABLISHMENT' and zptp1.party_tax_profile_id = zr1.party_tax_profile_id and trunc(sysdate) between trunc(zr1.effective_from) and trunc(nvl(zr1.effective_to,sysdate)) and zr1.registration_id <> zr.registration_id and zr.default_registration_flag = 'Y' ) ) or not exists (select 1 from zx_registrations zr1, zx_party_tax_profile zptp1, xle_etb_profiles xep1 where xep1.legal_entity_id = arp_legal_entity_util.get_default_legal_context(hou.organization_id) and xep1.main_establishment_flag = 'Y' and xep1.party_id = zptp1.party_id and zptp1.party_type_code = 'LEGAL_ESTABLISHMENT' and zptp1.party_tax_profile_id = zr1.party_tax_profile_id and trunc(sysdate) between trunc(zr1.effective_from) and trunc(nvl(zr1.effective_to,sysdate)) and zr1.registration_id <> zr.registration_id ) ) ) trader_tax_registration_num, dense_rank() over (order by nvl2(ftv.alternate_territory_code,'Y',null), ftv.territory_short_name, nvl(zptp.rep_registration_number,zr.registration_number), rcta.invoice_currency_code, decode(:p_rep_type,'D',rctla.customer_trx_line_id)) line_number, nvl2(ftv.alternate_territory_code,'Y',null) eu_flag, ftv.territory_short_name country, ftv.territory_code country_code, nvl(zptp.rep_registration_number,zr.registration_number) tax_registration_num, rcta.invoice_currency_code currency_code, sum(nvl(rctlgda.amount,0)) over (partition by ftv.territory_short_name, ftv.territory_code, nvl(zptp.rep_registration_number,zr.registration_number), rcta.invoice_currency_code, decode(:p_rep_type,'D',rctla.customer_trx_line_id)) amount, sum(nvl(rctlgda.acctd_amount,0)) over (partition by ftv.territory_short_name, ftv.territory_code, nvl(zptp.rep_registration_number,zr.registration_number), rcta.invoice_currency_code, decode(:p_rep_type,'D',rctla.customer_trx_line_id)) acctd_amount from gl_ledgers gl, hr_operating_units hou, ra_customer_trx_all rcta, ra_cust_trx_types_all rctta, ra_customer_trx_lines_all rctla, ra_cust_trx_line_gl_dist_all rctlgda, hz_cust_site_uses_all hcsua, hz_cust_acct_sites_all hcasa, hz_party_sites hps, hz_locations hl, fnd_territories_vl ftv, zx_party_tax_profile zptp, (select zr.* from (select zr.party_tax_profile_id, zr.registration_number, count(zr.registration_number) over (partition by zr.party_tax_profile_id) reg_count from zx_registrations zr where sysdate between zr.effective_from and NVL(zr.effective_to,sysdate+1) ) zr where zr.reg_count = 1 ) zr where 1=1 and rcta.org_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) and gl.ledger_id=hou.set_of_books_id and gl.ledger_id=rcta.set_of_books_id and hou.organization_id=rcta.org_id and rcta.complete_flag='Y' and rcta.org_id=rctta.org_id and rcta.cust_trx_type_id=rctta.cust_trx_type_id and decode(rctta.type,'CM',:remit_to_address,rcta.remit_to_address_id)=:remit_to_address and rcta.customer_trx_id=rctla.customer_trx_id and rctla.line_type!='TAX' and rctla.customer_trx_line_id=rctlgda.customer_trx_line_id and rctlgda.account_class in ('FREIGHT','REV','SUSPENSE','UNEARN','UNBILL') and rctlgda.latest_rec_flag is null and case nvl(:site_use_code,'BILL_TO') when 'BILL_TO' then rcta.bill_to_site_use_id else nvl(rcta.ship_to_site_use_id,rcta.bill_to_site_use_id) end = hcsua.site_use_id and hcsua.cust_acct_site_id=hcasa.cust_acct_site_id and hcasa.party_site_id=hps.party_site_id and hps.location_id=hl.location_id and hl.country=ftv.territory_code and --hl.country != nvl(:country,'?') and hps.party_site_id=zptp.party_id and zptp.party_type_code = 'THIRD_PARTY_SITE' and zptp.party_tax_profile_id = zr.party_tax_profile_id (+) order by line_number Replaced tab characters with spaces Y AR #,##0.00;[Red]-#,##0.00 AR AR European Sales Listing تقرير موجز يسرد المبيعات حسب البلد ورمز العملة ، مع مبلغ / عملة المعاملة والمبلغ / العملة المحسوبة D AR European Sales Listing Application: Debitoren Source: Umsatzliste Europa (XML) Short Name: ARYVTSLD_XML DB package: AR_ARYVTSLD_XMLP_PKG E AR European Sales Listing Informe resumido que enumera las ventas por país y código de moneda, con el importe de la transacción/moneda y el importe contabilizado/moneda F AR European Sales Listing Rapport de synthèse énumérant les ventes par pays et par code devise, avec le montant de la transaction / devise et le montant comptabilisé / devise I AR European Sales Listing Rapporto riassuntivo che elenca le vendite per paese e codice di valuta, con importo della transazione / valuta e importo contabilizzato / valuta JA AR European Sales Listing 国別および通貨コード別の売上高を、取引金額/通貨および会計金額/通貨で一覧表示したサマリーレポート KO AR European Sales Listing 거래 금액 / 통화 및 계정 금액 / 통화와 함께 국가 및 통화 코드 별 판매를 나열하는 요약 보고서 PTB AR European Sales Listing Relatório resumido listando vendas por país e código de moeda, com valor da transação/moeda e valor/moeda contabilizado RU AR European Sales Listing Сводный отчет, в котором перечислены продажи в разбивке по странам и валютным кодам, с указанием суммы сделки / валюты и учетной суммы / валюты. S AR European Sales Listing Sammanfattningsrapport som visar försäljning efter land och valutakod, med transaktionsbelopp / valuta och redovisat belopp / valuta TR AR European Sales Listing Satışları ülkeye ve para birimi koduna göre, işlem tutarı / para birimi ve muhasebeleştirilen tutar / para birimi ile listeleyen özet rapor US AR European Sales Listing Summary report listing sales by country and currency code, with transaction amount / currency and accounted amount/ currency ZHS AR European Sales Listing 按国家和货币代码分列的销售汇总报告，包括交易金额/货币和入账金额/货币。 Enginatics 1=1 :p_rep_type :remit_to_address :site_use_code 1 -10 :country Char select hl.country from hz_cust_acct_sites hcasa, hz_party_sites hps, hz_locations hl where hcasa.cust_acct_site_id=:$flex$.branch_to_which_remitted and hcasa.cust_account_id=-1 and hcasa.party_site_id=hps.party_site_id and hps.location_id=hl.location_id US Remit To Country 2 5 :p_rep_type LOV Oracle AR_REPORT_TYPE Y select lookup_code id, meaning value, null description from ar_lookups where lookup_type='REPORT_TYPE_SD' and enabled_flag='Y' and sysdate between nvl(start_date_active,sysdate) and nvl(end_date_active,sysdate) order by meaning,lookup_code S Y US Detail/Summary 3 10 1=1 gl.name=:ledger LOV GL Ledger 8E2FF36EDEB879D2E0530100007F1FF2 Y select gl.name value, fifsv.id_flex_structure_name||': '||decode(gl.ledger_category_code,'NONE',xxen_util.meaning(gl.object_type_code,'LEDGERS',101),xxen_util.meaning(gl.ledger_category_code,'GL_ASF_LEDGER_CATEGORY',101))||': '||gl.description description from gl_ledgers gl, fnd_id_flex_structures_vl fifsv where (:$flex$.ledger_category is null or gl.ledger_category_code=xxen_util.lookup_code(:$flex$.ledger_category,'GL_ASF_LEDGER_CATEGORY',101,'Y')) and (:$flex$.chart_of_accounts is null or xxen_util.contains(:$flex$.chart_of_accounts,fifsv.id_flex_structure_name)='Y') and gl.ledger_id in (select nvl(glsnav.ledger_id,gasna.ledger_id) from gl_access_set_norm_assign gasna, gl_ledger_set_norm_assign_v glsnav where gasna.access_set_id=fnd_profile.value('GL_ACCESS_SET_ID') and gasna.ledger_id=glsnav.ledger_set_id(+)) and gl.chart_of_accounts_id=fifsv.id_flex_num and fifsv.id_flex_code='GL#' and fifsv.application_id=101 order by fifsv.id_flex_structure_name, decode(gl.ledger_category_code,'PRIMARY',1,'SECONDARY',2,'ALC',3,'NONE',4), gl.name coalesce(xxen_util.previous_parameter_value(:parameter_id),xxen_util.default_ledger) Y D Buchkennung F Grand livre US Ledger 4 20 1=1 rctlgda.gl_date>=:date_from Date add_months(trunc(sysdate,'month'),-1) Y D Von Datum F De la date US From Date 5 30 1=1 rctlgda.gl_date<:date_to+1 Date last_day(:$flex$.from_date) Y D Bis Datum F A ce jour US To Date 6 40 :remit_to_address LOV custom Y select hcasa.cust_acct_site_id value, hl.address1||', '||hl.address2||', '||hl.postal_code||', '||hl.city || ' (' || hou.name || ')' description from hr_operating_units hou, hz_cust_acct_sites hcasa, hz_party_sites hps, hz_locations hl where hcasa.cust_account_id=-1 and hou.organization_id=hcasa.org_id and hcasa.party_site_id=hps.party_site_id and hps.location_id=hl.location_id 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 (:$flex$.operating_unit is null or xxen_util.contains(:$flex$.operating_unit,hou.name) = 'Y') order by hl.address1||', '||hl.address2||', '||hl.postal_code||', '||hl.city Y D (überwiesen an) Zweigstelle US Branch (to which remitted) 7 50 :site_use_code LOV Oracle OE_SITE_USE_CODES Y select lookup_code id, meaning value, null description from ar_lookups where lookup_type='SITE_USE_CODE' and lookup_code in ('BILL_TO','SHIP_TO') order by meaning SHIP_TO Y US Site Reported 8 60 1=1 ftv.alternate_territory_code is not null LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual Y US EU Countries Only :$flex$.branch_to_which_remitted Branch (to which remitted) Remit To Country :$flex$.from_date From Date Y To Date :$flex$.ledger Ledger Branch (to which remitted)