ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 8E2FF36EDE8379D2E0530100007F1FF2 Country Y select ftv.territory_short_name value, ftv.territory_code||': '||ftv.description description from fnd_territories_vl ftv order by ftv.territory_short_name US 8E2FF36EDEA679D2E0530100007F1FF2 Yes Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual US B659AA9741796E47E0530100007FE483 ZX Regime Code Y select zrv.tax_regime_code value, zrv.tax_regime_name||' ('||ftv.territory_short_name||')' description from zx_regimes_vl zrv, fnd_territories_vl ftv where zrv.country_code=ftv.territory_code(+) order by zrv.tax_regime_code US B659AA9741776E47E0530100007FE483 select ftv.territory_short_name country, zrv.tax_regime_code, zrv.tax_regime_name, xxen_util.yes(zrv.allow_recoverability_flag) allow_tax_recovery, xxen_util.yes(zrv.tax_inclusive_override_flag) allow_tax_inclusive_override, xxen_util.yes(zrv.allow_exemptions_flag) allow_tax_exemptions, xxen_util.yes(zrv.allow_exceptions_flag) allow_tax_exceptions, zrv.tax_currency_code tax_currency, zrv.minimum_accountable_unit, xxen_util.meaning(zrv.rounding_rule_code,'ZX_ROUNDING_RULE',0) rounding_rule, zrv.tax_precision, xxen_util.meaning(zrv.def_inclusive_tax_flag,'ZX_INCLUSIVE_TAX',0) allow_tax_inclusion, xxen_util.yes(zrv.has_other_jurisdictions_flag) allow_multiple_jurisdictions, xxen_util.yes(zrv.allow_rounding_override_flag) allow_tax_rounding_override, (select gdct.user_conversion_type from gl_daily_conversion_types gdct where zrv.exchange_rate_type=gdct.conversion_type) exchange_rate_type, xxen_util.meaning(zrv.def_rec_settlement_option_code,'ZX_REC-SETTLEMENT_OPTION',0) default_recovery_settlement, (select hp.party_name from zx_party_tax_profile zptp, hz_parties hp where zrv.coll_tax_authority_id=zptp.party_tax_profile_id and zptp.party_id=hp.party_id) collecting_tax_authority, (select hp.party_name from zx_party_tax_profile zptp, hz_parties hp where zrv.rep_tax_authority_id=zptp.party_tax_profile_id and zptp.party_id=hp.party_id) reporting_tax_authority, xxen_util.yes(zrv.regn_num_same_as_le_flag) use_legal_registration_number, xxen_util.yes(zrv.cross_regime_compounding_flag) allow_cross_regime_compounding, &subscription_columns xxen_util.user_name(zrv.created_by) regime_created_by, xxen_util.client_time(zrv.creation_date) regime_creation_date, xxen_util.user_name(zrv.last_updated_by) regime_last_updated_by, xxen_util.client_time(zrv.last_update_date) regime_last_update_date, zrv.tax_regime_id from zx_regimes_vl zrv, fnd_territories_vl ftv, (select zru.* from zx_regimes_usages zru where '&show_subscriptions'='Y') zru, zx_first_party_orgs_all_v zfpoa, (select zso.* from zx_subscription_options zso where sysdate between zso.effective_from and nvl(zso.effective_to,sysdate) and zso.enabled_flag='Y') zso where 1=1 and sysdate between nvl(zrv.effective_from,sysdate) and nvl(zrv.effective_to,sysdate) and zrv.country_code=ftv.territory_code(+) and zrv.tax_regime_id=zru.tax_regime_id(+) and zru.first_pty_org_id=zfpoa.party_tax_profile_id(+) and zru.regime_usage_id=zso.regime_usage_id(+) order by ftv.territory_short_name, zrv.tax_regime_code &subscription_order_by Y AR ZX Tax Regimes نظام ضرائب الأعمال الإلكترونية وإعداد اشتراك الحزب D ZX Tax Regimes E-Business-Steuerregelung und Einrichtung des Teilnehmerabonnements E ZX Tax Regimes Régimen fiscal del negocio electrónico y configuración de la suscripción de los partidos F ZX Tax Regimes Régime fiscal du commerce électronique et mise en place de l'abonnement au parti I ZX Tax Regimes Regime fiscale dell'E-Business Tax e impostazione dell'abbonamento delle parti JA ZX Tax Regimes 電子事業税の税制とパーティー加入の設定 KO ZX Tax Regimes E-Business Tax 제도 및 당사자 가입 설정 PTB ZX Tax Regimes Regime tributário do E-Business Tax e configuração de assinaturas partidárias RU ZX Tax Regimes Налоговый режим E-Business и настройка партийной подписки S ZX Tax Regimes E-Business skatteregler och partiprenumeration TR ZX Tax Regimes E-İşletme Vergisi vergi rejimi ve parti abonelik kurulumu US ZX Tax Regimes E-Business Tax tax regime and party subscription setup ZHS ZX Tax Regimes 电子营业税税制和党员订阅设置 Enginatics R12 only &show_subscriptions &subscription_columns &subscription_order_by 1=1 1 10 1=1 zrv.tax_regime_code=:regime_code LOV ZX Regime Code B659AA9741796E47E0530100007FE483 Y select zrv.tax_regime_code value, zrv.tax_regime_name||' ('||ftv.territory_short_name||')' description from zx_regimes_vl zrv, fnd_territories_vl ftv where zrv.country_code=ftv.territory_code(+) order by zrv.tax_regime_code US Tax Regime Code 2 30 &show_subscriptions Y LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual Y US Show Regime Subscriptions 3 &subscription_columns xxen_util.meaning(zfpoa.party_type_code,'ZX_PTP_PARTY_TYPE',0) subscription_party_type, zfpoa.party_name subscription_party_name, nvl2(zfpoa.party_name,zfpoa.address_line_1||' '||zfpoa.address_line_2||' '||zfpoa.address_line_3||' '||zfpoa.town_or_city||' '||zfpoa.region_1||' '||zfpoa.region_2||' '||zfpoa.postal_code,null) address, (select ftv.territory_short_name from fnd_territories_vl ftv where zfpoa.country_code=ftv.territory_code) country, xxen_util.meaning(zso.subscription_option_code,'ZX_SUBSCRIPTION_OPTION',0) config_for_taxes_and_rules, xxen_util.meaning(zso.exception_option_code,'ZX_SUBSCRIPTION_OPTION',0) config_for_product_exceptions, zso.effective_from subscription_effective_from, US Show Regime Subscriptions 4 &subscription_order_by ,zfpoa.party_name US Show Regime Subscriptions 5 50 1=1 ftv.territory_short_name=:country LOV Country 8E2FF36EDE8379D2E0530100007F1FF2 Y select ftv.territory_short_name value, ftv.territory_code||': '||ftv.description description from fnd_territories_vl ftv order by ftv.territory_short_name US Country