ZX_IMPORT_TAX_LINES_INPUT_V

Details

• Schema: FUSION

• Object owner: FND

• Object type: VIEW

Columns

Name
DOCUMENT_TYPE_ID TRANSACTION_ID TRANSACTION_LINE_ID TRANSACTION_LEVEL_TYPE COUNTRY_CODE TAX SITUS TAX_JURISDICTION TAX_CURRENCY_CODE TAX_AMOUNT TAX_CURR_TAX_AMOUNT TAX_RATE_PERCENTAGE TAXABLE_AMOUNT EXEMPT_RATE_MODIFIER EXEMPT_REASON TAX_ONLY_LINE_FLAG INCLUSIVE_TAX_LINE_FLAG USE_TAX_FLAG USER_OVERRIDE_FLAG LAST_MANUAL_ENTRY MANUALLY_ENTERED_FLAG FIRST_PARTY_TAX_REG_NUMBER

Query

SQL_Statement

SELECT /*+ leading (ztppo) index (zdtl ZX_DETAIL_TAX_LINES_GT_U1) */ ztppo.evnt_cls_mapping_id document_type_id, zdtl.trx_id transaction_id, zdtl.trx_line_id transaction_line_id, zdtl.trx_level_type transaction_level_type, zdtl.tax_regime_code country_code, zdtl.tax tax, zdtl.place_of_supply_type_code situs, zdtl.tax_jurisdiction_code tax_jurisdiction, zdtl.tax_currency_code tax_currency_code, zdtl.tax_amt tax_amount, zdtl.tax_amt_tax_curr tax_curr_tax_amount, zdtl.tax_rate tax_rate_percentage, zdtl.taxable_amt taxable_amount, zdtl.exempt_rate_modifier exempt_rate_modifier, zdtl.exempt_reason exempt_reason, zdtl.tax_only_line_flag tax_only_line_flag, zdtl.tax_amt_included_flag inclusive_tax_line_flag, zdtl.self_assessed_flag use_tax_flag, zdtl.overridden_flag user_override_flag, zdtl.last_manual_entry last_manual_entry, zdtl.manually_entered_flag manually_entered_flag, zdtl.tax_registration_number first_party_tax_reg_number FROM ZX_DETAIL_TAX_LINES_GT zdtl, ZX_TRX_PRE_PROC_OPTIONS_GT ztppo WHERE zdtl.application_id = ztppo.application_id AND zdtl.entity_code = ztppo.entity_code AND zdtl.event_class_code = ztppo.event_class_code AND zdtl.trx_id = ztppo.trx_id AND zdtl.tax_regime_code = ztppo.tax_regime_code AND zdtl.tax_provider_id = ztppo.tax_provider_id AND ztppo.record_for_partners_flag = 'Y' AND ztppo.quote_flag = 'N'