ZX Financial Tax Register

select
zrev.gdf_ra_addresses_ship_att9         gdf_ra_addresses_ship_att9,
zrev.country_of_supply                  country_of_supply,
zrev.start_expense_date                 start_expense_date,
zrev.tax_exemption_id                   tax_exemption_id,
zrev.tax_exception_id                   tax_exception_id,
zrev.exempt_certificate_number          exempt_certificate_number,
zrev.exempt_reason_code                 exempt_reason_code,
zrev.tax_exempt_reason_mng              tax_exempt_reason_mng,
zrev.tax_exception_reason_code          tax_exception_reason_code,
zrev.tax_exception_reason_mng           tax_exception_reason_mng,
zrev.tax_line_user_category             tax_line_user_category,
zrev.tax_line_user_attribute1           tax_line_user_attribute1,
zrev.tax_line_user_attribute2           tax_line_user_attribute2,
zrev.tax_line_user_attribute3           tax_line_user_attribute3,
zrev.tax_line_user_attribute4           tax_line_user_attribute4,
zrev.tax_line_user_attribute5           tax_line_user_attribute5,
zrev.tax_line_user_attribute6           tax_line_user_attribute6,
zrev.tax_line_user_attribute7           tax_line_user_attribute7,
zrev.tax_line_user_attribute8           tax_line_user_attribute8,
zrev.tax_line_user_attribute9           tax_line_user_attribute9,
zrev.tax_line_user_attribute10          tax_line_user_attribute10,
zrev.tax_line_user_attribute11          tax_line_user_attribute11,
zrev.tax_line_user_attribute12          tax_line_user_attribute12,
zrev.tax_line_user_attribute13          tax_line_user_attribute13,
zrev.tax_line_user_attribute14          tax_line_user_attribute14,
zrev.tax_line_user_attribute15          tax_line_user_attribute15,
zrev.tax_amt                            tax_amount,
zrev.tax_amt_funcl_curr                 tax_accounted_amount,
zrev.tax_line_number                    tax_line_number,
zrev.taxable_amt                        taxable_amount,
zrev.taxable_amt_funcl_curr             taxable_accounted_amount,
zrev.total_entered_amount               total_entered_amount,
zrev.total_accounted_amount             total_accounted_amount,
zrev.taxable_disc_amt                   taxable_discount_amount,
zrev.taxable_disc_amt_funcl_curr        taxable_discount_acctd_amount,
zrev.tax_disc_amt                       tax_discount_amount,
zrev.tax_disc_amt_funcl_curr            tax_discount_accounted_amount,
zrev.trx_line_number                    trx_line_number,
zrev.taxable_line_source_table          taxable_line_source_table,
zrev.trx_line_description               trx_line_description,
zrev.product_id                         product_id,
zrev.taxable_line_item_flexfield        taxable_line_item_flexfield,
zrev.product_description                product_description,
zrev.trx_line_quantity                  trx_line_quantity,
zrev.uom_code                           uom_code,
zrev.trx_quantity_uom_mng               trx_quantity_uom_mng,
zrev.trx_line_type                      trx_line_type,
zrev.actg_event_id                      actg_event_id,
zrev.actg_event_type_code               actg_event_type_code,
zrev.actg_event_type_mng                actg_event_type_mng,
zrev.actg_event_number                  actg_event_number,
zrev.actg_event_status_flag             actg_event_status_flag,
zrev.actg_event_status_mng              actg_event_status_mng,
zrev.actg_source_table                  actg_source_table,
zrev.actg_source_id                     actg_source_id,
zrev.actg_header_id                     actg_header_id,
zrev.actg_category_code                 actg_category_code,
zrev.actg_category_mng                  actg_category_mng,
zrev.period_name                        period_name,
zrev.gl_transfer_flag                   gl_transfer_flag,
zrev.gl_transfer_run_id                 gl_transfer_run_id,
zrev.actg_header_description            actg_header_description,
zrev.actg_line_num                      actg_line_num,
zrev.actg_line_type_code                actg_line_type_code,
zrev.actg_line_type_mng                 actg_line_type_mng,
zrev.actg_line_ccid                     actg_line_ccid,
zrev.account_flexfield                  account_flexfield,
zrev.account_description                account_description,
zrev.actg_line_description              actg_line_description,
zrev.actg_stat_amt                      actg_stat_amount,
zrev.actg_error_code                    actg_error_code,
zrev.gl_transfer_code                   gl_transfer_code,
zrev.actg_doc_sequence_id               actg_doc_sequence_id,
zrev.actg_doc_sequence_name             actg_doc_sequence_name,
zrev.actg_doc_sequence_value            actg_doc_sequence_value,
zrev.actg_party_id                      actg_party_id,
zrev.actg_party_site_id                 actg_party_site_id,
zrev.trx_arap_balancing_segment         trx_arap_balancing_segment,
zrev.trx_arap_natural_account           trx_arap_natural_account,
zrev.trx_taxable_balancing_segment      trx_taxable_balancing_segment,
zrev.trx_taxable_natural_account        trx_taxable_natural_account,
zrev.trx_tax_balancing_segment          trx_tax_balancing_segment,
zrev.trx_tax_natural_account            trx_tax_natural_account,
zrev.trx_taxable_account                trx_taxable_account,
zrev.trx_taxable_account_desc           trx_taxable_account_desc,
zrev.trx_taxable_balseg_desc            trx_taxable_balseg_desc,
zrev.trx_taxable_natacct_seg_desc       trx_taxable_natacct_seg_desc,
zrev.numeric1                           numeric1,
zrev.numeric2                           numeric2,
zrev.numeric3                           numeric3,
zrev.numeric4                           numeric4,
zrev.numeric5                           numeric5,
zrev.numeric6                           numeric6,
zrev.numeric7                           numeric7,
zrev.numeric8                           numeric8,
zrev.numeric9                           numeric9,
zrev.numeric10                          numeric10,
zrev.numeric11                          numeric11,
zrev.numeric12                          numeric12,
zrev.numeric13                          numeric13,
zrev.numeric14                          numeric14,
zrev.numeric15                          numeric15,
zrev.numeric16                          numeric16,
zrev.attribute1                         attribute1,
zrev.attribute2                         attribute2,
zrev.attribute3                         attribute3,
zrev.attribute4                         attribute4,
zrev.attribute5                         attribute5,
zrev.attribute6                         attribute6,
zrev.attribute7                         attribute7,
zrev.attribute8                         attribute8,
zrev.attribute9                         attribute9,
zrev.attribute10                        attribute10,
zrev.attribute11                        attribute11,
zrev.attribute12                        attribute12,
zrev.attribute13                        attribute13,
zrev.attribute14                        attribute14,
zrev.attribute15                        attribute15,
zrev.attribute16                        attribute16,
zrev.attribute17                        attribute17,
zrev.attribute18                        attribute18,
zrev.business_loc_address               business_loc_address,
zrev.document_sub_type_mng              document_sub_type_mng,
zrev.tax_status_mng                     tax_status_mng,
zrev.trx_business_category_mng          trx_business_category_mng,
zrev.gdf_ap_invoices_att2               gdf_ap_invoices_att2,
zrev.gdf_ap_invoices_att3               gdf_ap_invoices_att3,
zrev.gdf_ap_invoices_att4               gdf_ap_invoices_att4,
zrev.gdf_ap_invoices_att11              gdf_ap_invoices_att11,
zrev.gdf_ap_invoices_att12              gdf_ap_invoices_att12,
zrev.gdf_ap_invoices_att13              gdf_ap_invoices_att13,
zrev.gdf_ap_invoice_dist_att1           gdf_ap_invoice_dist_att1,
zrev.gdf_po_vendor_sites_att17          gdf_po_vendor_sites_att17,
zrev.gdf_ra_cust_bill_att10             gdf_ra_cust_bill_att10,
zrev.gdf_ra_cust_bill_att12             gdf_ra_cust_bill_att12,
zrev.gdf_party_sites_bill_att8          gdf_party_sites_bill_att8,
zrev.gdf_party_sites_bill_att9          gdf_party_sites_bill_att9,
zrev.gdf_ra_cust_trx_att3               gdf_ra_cust_trx_att3,
zrev.gdf_ra_cust_trx_att4               gdf_ra_cust_trx_att4,
zrev.gdf_ra_cust_trx_att5               gdf_ra_cust_trx_att5,
zrev.gdf_ra_cust_trx_att6               gdf_ra_cust_trx_att6,
zrev.gdf_ra_cust_trx_att7               gdf_ra_cust_trx_att7,
zrev.gdf_ra_cust_trx_att8               gdf_ra_cust_trx_att8,
zrev.gdf_ra_cust_trx_att9               gdf_ra_cust_trx_att9,
zrev.gdf_ra_cust_trx_att19              gdf_ra_cust_trx_att19,
zrev.gdf_ra_cust_trx_lines_att1         gdf_ra_cust_trx_lines_att1,
zrev.gdf_ra_cust_trx_lines_att2         gdf_ra_cust_trx_lines_att2,
zrev.gdf_ra_cust_trx_types_att5         gdf_ra_cust_trx_types_att5,
zrev.gdf_ra_cust_trx_types_att6         gdf_ra_cust_trx_types_att6,
zrev.gdf_ra_cust_trx_types_att7         gdf_ra_cust_trx_types_att7,
zrev.gdf_ra_batch_sources_att1          gdf_ra_batch_sources_att1,
zrev.gdf_ra_batch_sources_att2          gdf_ra_batch_sources_att2,
zrev.gdf_ra_batch_sources_att3          gdf_ra_batch_sources_att3,
zrev.gdf_ra_batch_sources_att4          gdf_ra_batch_sources_att4,
zrev.ledger_id                          ledger_id,
zrev.chart_of_accounts_id               chart_of_accounts_id,
zrev.detail_tax_line_id                 detail_tax_line_id,
zrev.extract_source_ledger              extract_source_ledger,
zrev.extract_report_line_number         extract_report_line_number,
zrev.rep_entity_id                      rep_entity_id,
zrev.legal_entity_tax_reg_number        legal_entity_tax_reg_number,
zrev.org_information2                   org_information2,
zrev.rep_context_lvl_code               rep_context_lvl_code,
zrev.rep_context_lvl_mng                rep_context_lvl_mng,
zrev.taxpayer_id                        taxpayer_id,
zrev.rep_context_entity_name            rep_context_entity_name,
zrev.rep_context_entity_location_id     rep_context_entity_location_id,
zrev.rep_context_entity_city            rep_context_entity_city,
zrev.rep_context_entity_county          rep_context_entity_county,
zrev.rep_context_entity_state           rep_context_entity_state,
zrev.rep_context_entity_province        rep_context_entity_province,
zrev.rep_context_entity_address1        rep_context_entity_address1,
zrev.rep_context_entity_address2        rep_context_entity_address2,
zrev.rep_context_entity_address3        rep_context_entity_address3,
zrev.rep_context_entity_country         rep_context_entity_country,
zrev.rep_context_entity_postal_code     rep_context_entity_postal_code,
zrev.rep_context_entity_tel_number      rep_context_entity_tel_number,
zrev.ledger_name                        ledger_name,
zrev.functional_currency_code           functional_currency,
zrev.trx_id                             trx_id,
zrev.trx_number                         trx_number,
zrev.trx_description                    trx_description,
zrev.doc_seq_id                         doc_seq_id,
zrev.doc_seq_name                       doc_seq_name,
zrev.doc_seq_value                      doc_seq_value,
zrev.trx_date                           trx_date,
zrev.trx_line_class                     tax_class,
zrev.trx_line_class                     trx_line_class,
zrev.trx_class_mng                      trx_class,
zrev.trx_type_id                        trx_type_id,
zrev.trx_type_mng                       trx_type,
zrev.applied_from_entity_code           applied_from_entity_code,
zrev.applied_from_trx_id                applied_from_trx_id,
zrev.applied_from_event_class_code      applied_from_event_class_code,
zrev.trx_applied_from_class_mng         trx_applied_from_class_mng,
zrev.applied_from_trx_number            applied_from_trx_number,
zrev.adjusted_doc_entity_code           adjusted_doc_entity_code,
zrev.adjusted_doc_trx_id                adjusted_doc_trx_id,
zrev.adjusted_doc_event_class_code      adjusted_doc_event_class_code,
zrev.adjusted_doc_number                adjusted_doc_number,
zrev.adjusted_doc_date                  adjusted_doc_date,
zrev.trx_applied_to_class_mng           related_transaction_class,
zrev.applied_to_trx_number              related_transaction,
zrev.trx_type_description               trx_type_description,
zrev.trx_due_date                       trx_due_date,
zrev.trx_shipping_date                  trx_shipping_date,
zrev.trx_communicated_date              trx_communicated_date,
zrev.trx_currency_code                  trx_currency_code,
zrev.currency_conversion_type           currency_conversion_type,
zrev.currency_conversion_date           currency_conversion_date,
zrev.currency_conversion_rate           currency_conversion_rate,
zrev.reconciliation_flag                reconciliation_flag,
zrev.trx_tax_balancing_segment          balancing_segment_value,
zrev.trx_tax_balancing_segment          company,
zrev.trx_control_account_flexfield      trx_control_account_flexfield,
zrev.billing_trading_partner_id         billing_trading_partner_id,
zrev.billing_tp_site_id                 billing_tp_site_id,
zrev.billing_tp_number                  billing_tp_number,
zrev.billing_tp_tax_reg_num             billing_tp_tax_reg_num,
zrev.billing_tp_taxpayer_id             billing_tp_taxpayer_id,
zrev.billing_tp_site_name               billing_tp_site_name,
zrev.billing_tp_site_name_alt           billing_tp_site_name_alt,
zrev.billing_tp_site_tax_reg_num        billing_tp_site_tax_reg_num,
zrev.billing_tp_tax_reporting_flag      billing_tp_tax_reporting_flag,
zrev.billing_tp_name                    billing_tp_name,
zrev.billing_tp_name_alt                billing_tp_name_alt,
zrev.billing_tp_sic_code                billing_tp_sic_code,
zrev.billing_tp_address_id              billing_tp_address_id,
zrev.billing_tp_city                    billing_tp_city,
zrev.billing_tp_county                  billing_tp_county,
zrev.billing_tp_state                   billing_tp_state,
zrev.billing_tp_province                billing_tp_province,
zrev.billing_tp_address1                billing_tp_address1,
zrev.billing_tp_address2                billing_tp_address2,
zrev.billing_tp_address3                billing_tp_address3,
zrev.billing_tp_address_lines_alt       billing_tp_address_lines_alt,
zrev.billing_tp_country                 billing_tp_country,
zrev.billing_tp_postal_code             billing_tp_postal_code,
zrev.shipping_trading_partner_id        shipping_trading_partner_id,
zrev.shipping_tp_site_id                shipping_tp_site_id,
zrev.shipping_tp_number                 shipping_tp_number,
zrev.shipping_tp_tax_reg_num            shipping_tp_tax_reg_num,
zrev.shipping_tp_taxpayer_id            shipping_tp_taxpayer_id,
zrev.shipping_tp_site_name              shipping_tp_site_name,
zrev.shipping_tp_site_tax_reg_num       shipping_tp_site_tax_reg_num,
zrev.shipping_tp_name                   shipping_tp_name,
zrev.shipping_tp_name_alt               shipping_tp_name_alt,
zrev.shipping_tp_sic_code               shipping_tp_sic_code,
zrev.shipping_tp_address_id             shipping_tp_address_id,
zrev.shipping_tp_city                   shipping_tp_city,
zrev.shipping_tp_county                 shipping_tp_county,
zrev.shipping_tp_state                  shipping_tp_state,
zrev.shipping_tp_province               shipping_tp_province,
zrev.shipping_tp_address1               shipping_tp_address1,
zrev.gdf_ra_batch_sources_att7          gdf_ra_batch_sources_att7,
zrev.gdf_ra_addresses_bill_att9         gdf_ra_addresses_bill_att9,
zrev.shipping_tp_address2               shipping_tp_address2,
zrev.shipping_tp_address3               shipping_tp_address3,
zrev.shipping_tp_address_lines_alt      shipping_tp_address_lines_alt,
zrev.shipping_tp_country                shipping_tp_country,
zrev.shipping_tp_postal_code            shipping_tp_postal_code,
zrev.banking_tp_name                    banking_tp_name,
zrev.banking_tp_taxpayer_id             banking_tp_taxpayer_id,
zrev.trx_batch_source_name              trx_batch_source_name,
zrev.trx_sic_code                       trx_sic_code,
zrev.fob_point                          fob_point,
zrev.trx_waybill_number                 trx_waybill_number,
zrev.posted_flag                        posted_flag,
zrev.tax_rate_id                        tax_rate_id,
zrev.tax_rate_code                      tax_rate_code,
zrev.tax_rate                           tax_rate,
zrev.tax_rate_vat_trx_type_code         tax_rate_vat_trx_type_code,
zrev.tax_rate_code_vat_trx_type_mng     tax_rate_code_vat_trx_type_mng,
zrev.tax_rate_vat_trx_type_desc         tax_rate_vat_trx_type_desc,
zrev.tax_rate_register_type_code        tax_rate_register_type_code,
zrev.tax_rate_code_reg_type_meaning     tax_rate_code_reg_type_meaning,
zrev.tax                                tax,
zrev.tax_regime_code                    tax_regime_code,
zrev.tax_status_code                    tax_status_code,
zrev.tax_type_code                      tax_type_code,
zrev.tax_type_mng                       tax_type_mng,
zrev.tax_rate_code_name                 tax_rate_code_name,
zrev.tax_rate_code_description          tax_rate_code_description,
zrev.tax_recoverable_flag               tax_recoverable_flag,
zrev.tax_recovery_rate                  tax_recovery_rate,
zrev.merchant_party_document_number     merchant_party_document_number,
zrev.merchant_party_name                merchant_party_name,
zrev.merchant_party_reference           merchant_party_reference,
zrev.merchant_party_tax_reg_number      merchant_party_tax_reg_number,
zrev.merchant_party_taxpayer_id         merchant_party_taxpayer_id,
zrev.gl_date                            gl_date,
--
to_number(to_char(zrev.trx_date,'YYYY'))  trx_date_year,
to_number(to_char(zrev.trx_date,'MM'))  trx_date_month,
to_number(to_char(zrev.gl_date,'YYYY'))   gl_date_year,
to_number(to_char(zrev.gl_date,'MM'))   gl_date_month
from
zx_rep_extract_v zrev
where
request_id=fnd_global.conc_request_id
order by
zrev.tax_disc_amt_funcl_curr

select zrev.gdf_ra_addresses_ship_att9 gdf_ra_addresses_ship_att9, zrev.country_of_supply country_of_supply, zrev.start_expense_date start_expense_date, zrev.tax_exemption_id tax_exemption_id, zrev.tax_exception_id tax_exception_id, zrev.exempt_certificate_number exempt_certificate_number, zrev.exempt_reason_code exempt_reason_code, zrev.tax_exempt_reason_mng tax_exempt_reason_mng, zrev.tax_exception_reason_code tax_exception_reason_code, zrev.tax_exception_reason_mng tax_exception_reason_mng, zrev.tax_line_user_category tax_line_user_category, zrev.tax_line_user_attribute1 tax_line_user_attribute1, zrev.tax_line_user_attribute2 tax_line_user_attribute2, zrev.tax_line_user_attribute3 tax_line_user_attribute3, zrev.tax_line_user_attribute4 tax_line_user_attribute4, zrev.tax_line_user_attribute5 tax_line_user_attribute5, zrev.tax_line_user_attribute6 tax_line_user_attribute6, zrev.tax_line_user_attribute7 tax_line_user_attribute7, zrev.tax_line_user_attribute8 tax_line_user_attribute8, zrev.tax_line_user_attribute9 tax_line_user_attribute9, zrev.tax_line_user_attribute10 tax_line_user_attribute10, zrev.tax_line_user_attribute11 tax_line_user_attribute11, zrev.tax_line_user_attribute12 tax_line_user_attribute12, zrev.tax_line_user_attribute13 tax_line_user_attribute13, zrev.tax_line_user_attribute14 tax_line_user_attribute14, zrev.tax_line_user_attribute15 tax_line_user_attribute15, zrev.tax_amt tax_amount, zrev.tax_amt_funcl_curr tax_accounted_amount, zrev.tax_line_number tax_line_number, zrev.taxable_amt taxable_amount, zrev.taxable_amt_funcl_curr taxable_accounted_amount, zrev.total_entered_amount total_entered_amount, zrev.total_accounted_amount total_accounted_amount, zrev.taxable_disc_amt taxable_discount_amount, zrev.taxable_disc_amt_funcl_curr taxable_discount_acctd_amount, zrev.tax_disc_amt tax_discount_amount, zrev.tax_disc_amt_funcl_curr tax_discount_accounted_amount, zrev.trx_line_number trx_line_number, zrev.taxable_line_source_table taxable_line_source_table, zrev.trx_line_description trx_line_description, zrev.product_id product_id, zrev.taxable_line_item_flexfield taxable_line_item_flexfield, zrev.product_description product_description, zrev.trx_line_quantity trx_line_quantity, zrev.uom_code uom_code, zrev.trx_quantity_uom_mng trx_quantity_uom_mng, zrev.trx_line_type trx_line_type, zrev.actg_event_id actg_event_id, zrev.actg_event_type_code actg_event_type_code, zrev.actg_event_type_mng actg_event_type_mng, zrev.actg_event_number actg_event_number, zrev.actg_event_status_flag actg_event_status_flag, zrev.actg_event_status_mng actg_event_status_mng, zrev.actg_source_table actg_source_table, zrev.actg_source_id actg_source_id, zrev.actg_header_id actg_header_id, zrev.actg_category_code actg_category_code, zrev.actg_category_mng actg_category_mng, zrev.period_name period_name, zrev.gl_transfer_flag gl_transfer_flag, zrev.gl_transfer_run_id gl_transfer_run_id, zrev.actg_header_description actg_header_description, zrev.actg_line_num actg_line_num, zrev.actg_line_type_code actg_line_type_code, zrev.actg_line_type_mng actg_line_type_mng, zrev.actg_line_ccid actg_line_ccid, zrev.account_flexfield account_flexfield, zrev.account_description account_description, zrev.actg_line_description actg_line_description, zrev.actg_stat_amt actg_stat_amount, zrev.actg_error_code actg_error_code, zrev.gl_transfer_code gl_transfer_code, zrev.actg_doc_sequence_id actg_doc_sequence_id, zrev.actg_doc_sequence_name actg_doc_sequence_name, zrev.actg_doc_sequence_value actg_doc_sequence_value, zrev.actg_party_id actg_party_id, zrev.actg_party_site_id actg_party_site_id, zrev.trx_arap_balancing_segment trx_arap_balancing_segment, zrev.trx_arap_natural_account trx_arap_natural_account, zrev.trx_taxable_balancing_segment trx_taxable_balancing_segment, zrev.trx_taxable_natural_account trx_taxable_natural_account, zrev.trx_tax_balancing_segment trx_tax_balancing_segment, zrev.trx_tax_natural_account trx_tax_natural_account, zrev.trx_taxable_account trx_taxable_account, zrev.trx_taxable_account_desc trx_taxable_account_desc, zrev.trx_taxable_balseg_desc trx_taxable_balseg_desc, zrev.trx_taxable_natacct_seg_desc trx_taxable_natacct_seg_desc, zrev.numeric1 numeric1, zrev.numeric2 numeric2, zrev.numeric3 numeric3, zrev.numeric4 numeric4, zrev.numeric5 numeric5, zrev.numeric6 numeric6, zrev.numeric7 numeric7, zrev.numeric8 numeric8, zrev.numeric9 numeric9, zrev.numeric10 numeric10, zrev.numeric11 numeric11, zrev.numeric12 numeric12, zrev.numeric13 numeric13, zrev.numeric14 numeric14, zrev.numeric15 numeric15, zrev.numeric16 numeric16, zrev.attribute1 attribute1, zrev.attribute2 attribute2, zrev.attribute3 attribute3, zrev.attribute4 attribute4, zrev.attribute5 attribute5, zrev.attribute6 attribute6, zrev.attribute7 attribute7, zrev.attribute8 attribute8, zrev.attribute9 attribute9, zrev.attribute10 attribute10, zrev.attribute11 attribute11, zrev.attribute12 attribute12, zrev.attribute13 attribute13, zrev.attribute14 attribute14, zrev.attribute15 attribute15, zrev.attribute16 attribute16, zrev.attribute17 attribute17, zrev.attribute18 attribute18, zrev.business_loc_address business_loc_address, zrev.document_sub_type_mng document_sub_type_mng, zrev.tax_status_mng tax_status_mng, zrev.trx_business_category_mng trx_business_category_mng, zrev.gdf_ap_invoices_att2 gdf_ap_invoices_att2, zrev.gdf_ap_invoices_att3 gdf_ap_invoices_att3, zrev.gdf_ap_invoices_att4 gdf_ap_invoices_att4, zrev.gdf_ap_invoices_att11 gdf_ap_invoices_att11, zrev.gdf_ap_invoices_att12 gdf_ap_invoices_att12, zrev.gdf_ap_invoices_att13 gdf_ap_invoices_att13, zrev.gdf_ap_invoice_dist_att1 gdf_ap_invoice_dist_att1, zrev.gdf_po_vendor_sites_att17 gdf_po_vendor_sites_att17, zrev.gdf_ra_cust_bill_att10 gdf_ra_cust_bill_att10, zrev.gdf_ra_cust_bill_att12 gdf_ra_cust_bill_att12, zrev.gdf_party_sites_bill_att8 gdf_party_sites_bill_att8, zrev.gdf_party_sites_bill_att9 gdf_party_sites_bill_att9, zrev.gdf_ra_cust_trx_att3 gdf_ra_cust_trx_att3, zrev.gdf_ra_cust_trx_att4 gdf_ra_cust_trx_att4, zrev.gdf_ra_cust_trx_att5 gdf_ra_cust_trx_att5, zrev.gdf_ra_cust_trx_att6 gdf_ra_cust_trx_att6, zrev.gdf_ra_cust_trx_att7 gdf_ra_cust_trx_att7, zrev.gdf_ra_cust_trx_att8 gdf_ra_cust_trx_att8, zrev.gdf_ra_cust_trx_att9 gdf_ra_cust_trx_att9, zrev.gdf_ra_cust_trx_att19 gdf_ra_cust_trx_att19, zrev.gdf_ra_cust_trx_lines_att1 gdf_ra_cust_trx_lines_att1, zrev.gdf_ra_cust_trx_lines_att2 gdf_ra_cust_trx_lines_att2, zrev.gdf_ra_cust_trx_types_att5 gdf_ra_cust_trx_types_att5, zrev.gdf_ra_cust_trx_types_att6 gdf_ra_cust_trx_types_att6, zrev.gdf_ra_cust_trx_types_att7 gdf_ra_cust_trx_types_att7, zrev.gdf_ra_batch_sources_att1 gdf_ra_batch_sources_att1, zrev.gdf_ra_batch_sources_att2 gdf_ra_batch_sources_att2, zrev.gdf_ra_batch_sources_att3 gdf_ra_batch_sources_att3, zrev.gdf_ra_batch_sources_att4 gdf_ra_batch_sources_att4, zrev.ledger_id ledger_id, zrev.chart_of_accounts_id chart_of_accounts_id, zrev.detail_tax_line_id detail_tax_line_id, zrev.extract_source_ledger extract_source_ledger, zrev.extract_report_line_number extract_report_line_number, zrev.rep_entity_id rep_entity_id, zrev.legal_entity_tax_reg_number legal_entity_tax_reg_number, zrev.org_information2 org_information2, zrev.rep_context_lvl_code rep_context_lvl_code, zrev.rep_context_lvl_mng rep_context_lvl_mng, zrev.taxpayer_id taxpayer_id, zrev.rep_context_entity_name rep_context_entity_name, zrev.rep_context_entity_location_id rep_context_entity_location_id, zrev.rep_context_entity_city rep_context_entity_city, zrev.rep_context_entity_county rep_context_entity_county, zrev.rep_context_entity_state rep_context_entity_state, zrev.rep_context_entity_province rep_context_entity_province, zrev.rep_context_entity_address1 rep_context_entity_address1, zrev.rep_context_entity_address2 rep_context_entity_address2, zrev.rep_context_entity_address3 rep_context_entity_address3, zrev.rep_context_entity_country rep_context_entity_country, zrev.rep_context_entity_postal_code rep_context_entity_postal_code, zrev.rep_context_entity_tel_number rep_context_entity_tel_number, zrev.ledger_name ledger_name, zrev.functional_currency_code functional_currency, zrev.trx_id trx_id, zrev.trx_number trx_number, zrev.trx_description trx_description, zrev.doc_seq_id doc_seq_id, zrev.doc_seq_name doc_seq_name, zrev.doc_seq_value doc_seq_value, zrev.trx_date trx_date, zrev.trx_line_class tax_class, zrev.trx_line_class trx_line_class, zrev.trx_class_mng trx_class, zrev.trx_type_id trx_type_id, zrev.trx_type_mng trx_type, zrev.applied_from_entity_code applied_from_entity_code, zrev.applied_from_trx_id applied_from_trx_id, zrev.applied_from_event_class_code applied_from_event_class_code, zrev.trx_applied_from_class_mng trx_applied_from_class_mng, zrev.applied_from_trx_number applied_from_trx_number, zrev.adjusted_doc_entity_code adjusted_doc_entity_code, zrev.adjusted_doc_trx_id adjusted_doc_trx_id, zrev.adjusted_doc_event_class_code adjusted_doc_event_class_code, zrev.adjusted_doc_number adjusted_doc_number, zrev.adjusted_doc_date adjusted_doc_date, zrev.trx_applied_to_class_mng related_transaction_class, zrev.applied_to_trx_number related_transaction, zrev.trx_type_description trx_type_description, zrev.trx_due_date trx_due_date, zrev.trx_shipping_date trx_shipping_date, zrev.trx_communicated_date trx_communicated_date, zrev.trx_currency_code trx_currency_code, zrev.currency_conversion_type currency_conversion_type, zrev.currency_conversion_date currency_conversion_date, zrev.currency_conversion_rate currency_conversion_rate, zrev.reconciliation_flag reconciliation_flag, zrev.trx_tax_balancing_segment balancing_segment_value, zrev.trx_tax_balancing_segment company, zrev.trx_control_account_flexfield trx_control_account_flexfield, zrev.billing_trading_partner_id billing_trading_partner_id, zrev.billing_tp_site_id billing_tp_site_id, zrev.billing_tp_number billing_tp_number, zrev.billing_tp_tax_reg_num billing_tp_tax_reg_num, zrev.billing_tp_taxpayer_id billing_tp_taxpayer_id, zrev.billing_tp_site_name billing_tp_site_name, zrev.billing_tp_site_name_alt billing_tp_site_name_alt, zrev.billing_tp_site_tax_reg_num billing_tp_site_tax_reg_num, zrev.billing_tp_tax_reporting_flag billing_tp_tax_reporting_flag, zrev.billing_tp_name billing_tp_name, zrev.billing_tp_name_alt billing_tp_name_alt, zrev.billing_tp_sic_code billing_tp_sic_code, zrev.billing_tp_address_id billing_tp_address_id, zrev.billing_tp_city billing_tp_city, zrev.billing_tp_county billing_tp_county, zrev.billing_tp_state billing_tp_state, zrev.billing_tp_province billing_tp_province, zrev.billing_tp_address1 billing_tp_address1, zrev.billing_tp_address2 billing_tp_address2, zrev.billing_tp_address3 billing_tp_address3, zrev.billing_tp_address_lines_alt billing_tp_address_lines_alt, zrev.billing_tp_country billing_tp_country, zrev.billing_tp_postal_code billing_tp_postal_code, zrev.shipping_trading_partner_id shipping_trading_partner_id, zrev.shipping_tp_site_id shipping_tp_site_id, zrev.shipping_tp_number shipping_tp_number, zrev.shipping_tp_tax_reg_num shipping_tp_tax_reg_num, zrev.shipping_tp_taxpayer_id shipping_tp_taxpayer_id, zrev.shipping_tp_site_name shipping_tp_site_name, zrev.shipping_tp_site_tax_reg_num shipping_tp_site_tax_reg_num, zrev.shipping_tp_name shipping_tp_name, zrev.shipping_tp_name_alt shipping_tp_name_alt, zrev.shipping_tp_sic_code shipping_tp_sic_code, zrev.shipping_tp_address_id shipping_tp_address_id, zrev.shipping_tp_city shipping_tp_city, zrev.shipping_tp_county shipping_tp_county, zrev.shipping_tp_state shipping_tp_state, zrev.shipping_tp_province shipping_tp_province, zrev.shipping_tp_address1 shipping_tp_address1, zrev.gdf_ra_batch_sources_att7 gdf_ra_batch_sources_att7, zrev.gdf_ra_addresses_bill_att9 gdf_ra_addresses_bill_att9, zrev.shipping_tp_address2 shipping_tp_address2, zrev.shipping_tp_address3 shipping_tp_address3, zrev.shipping_tp_address_lines_alt shipping_tp_address_lines_alt, zrev.shipping_tp_country shipping_tp_country, zrev.shipping_tp_postal_code shipping_tp_postal_code, zrev.banking_tp_name banking_tp_name, zrev.banking_tp_taxpayer_id banking_tp_taxpayer_id, zrev.trx_batch_source_name trx_batch_source_name, zrev.trx_sic_code trx_sic_code, zrev.fob_point fob_point, zrev.trx_waybill_number trx_waybill_number, zrev.posted_flag posted_flag, zrev.tax_rate_id tax_rate_id, zrev.tax_rate_code tax_rate_code, zrev.tax_rate tax_rate, zrev.tax_rate_vat_trx_type_code tax_rate_vat_trx_type_code, zrev.tax_rate_code_vat_trx_type_mng tax_rate_code_vat_trx_type_mng, zrev.tax_rate_vat_trx_type_desc tax_rate_vat_trx_type_desc, zrev.tax_rate_register_type_code tax_rate_register_type_code, zrev.tax_rate_code_reg_type_meaning tax_rate_code_reg_type_meaning, zrev.tax tax, zrev.tax_regime_code tax_regime_code, zrev.tax_status_code tax_status_code, zrev.tax_type_code tax_type_code, zrev.tax_type_mng tax_type_mng, zrev.tax_rate_code_name tax_rate_code_name, zrev.tax_rate_code_description tax_rate_code_description, zrev.tax_recoverable_flag tax_recoverable_flag, zrev.tax_recovery_rate tax_recovery_rate, zrev.merchant_party_document_number merchant_party_document_number, zrev.merchant_party_name merchant_party_name, zrev.merchant_party_reference merchant_party_reference, zrev.merchant_party_tax_reg_number merchant_party_tax_reg_number, zrev.merchant_party_taxpayer_id merchant_party_taxpayer_id, zrev.gl_date gl_date, -- to_number(to_char(zrev.trx_date,'YYYY')) trx_date_year, to_number(to_char(zrev.trx_date,'MM')) trx_date_month, to_number(to_char(zrev.gl_date,'YYYY')) gl_date_year, to_number(to_char(zrev.gl_date,'MM')) gl_date_month from zx_rep_extract_v zrev where request_id=fnd_global.conc_request_id order by zrev.tax_disc_amt_funcl_curr