eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ZX_AP_EXTRACT_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 20


PROCEDURE    insert_tax_info;

Line: 30


  c_lines_per_insert      CONSTANT NUMBER :=  1000;

Line: 217


  g_last_updated_by              number(15);

Line: 218


  g_last_update_date             date;

Line: 219


  g_last_update_login            number(15);

Line: 350


|   INSERT_TAX_DATA                                                         |
|                                                                           |
| DESCRIPTION                                                               |
|    This procedure takes the input parameters from ZX_EXTRACT_PKG          |
|    and builds a dynamic SQL statement clauses based on the parameters,    |
|    supplies them as output parameters.                                    |
|                                                                           |
| SCOPE - Public                                                            |
|                                                                           |
| NOTES                                                                     |
|                                                                           |
| MODIFICATION HISTORY                                                      |
|       11-Jan-2005    Srinivasa Rao Korrapati      Created                 |
+===========================================================================*/


PROCEDURE insert_tax_data (
          p_trl_global_variables_rec   IN OUT NOCOPY ZX_EXTRACT_PKG.TRL_GLOBAL_VARIABLES_REC_TYPE
          )
IS

BEGIN
  g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

Line: 376


     FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.INSERT_TAX_DATA.BEGIN',
                                      'ZX_AP_EXTRACT_PKG: INSERT_TAX_DATA(+)');

Line: 423


                   'ZX.TRL.ZX_AP_EXTRACT_PKG.INSERT_TAX_DATA.END',
                   'ZX_AP_EXTRACT_PKG: INSERT_TAX_DATA(-)');

Line: 431


    FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','insert_tax_data- '|| g_error_buffer);

Line: 435


                      'ZX.TRL.ZX_AP_EXTRACT_PKG.insert_tax_data',
                      g_error_buffer);

Line: 440


END insert_tax_data;

Line: 462


  L_SELECT_ACCOUNT_SEG           VARCHAR2(500);

Line: 667


                                      ' OR NOT EXISTS (SELECT ''Non Recoverable''' ||
                                            ' FROM zx_rec_nrec_dist zx_dist1 ' ||
                                           ' WHERE zx_dist1.trx_id = zx_dist.trx_id ' ||
                                             ' AND zx_dist1.application_id = zx_dist.application_id ' ||
                                             ' AND zx_dist1.entity_code = zx_dist.entity_code ' ||
                                             ' AND zx_dist1.event_class_code = zx_dist.event_class_code ' ||
                                             ' AND zx_dist1.recoverable_flag = ''Y'' ' ||
                                             ' AND zx_dist1.tax_rate_id = zx_dist.tax_rate_id ' ||
                                             ' AND zx_dist1.trx_line_id = zx_dist.trx_line_id ' ||
                                             ' AND zx_dist1.trx_line_dist_id = zx_dist.trx_line_dist_id ' ||
                                             ' GROUP BY zx_dist1.trx_line_dist_id '||
                                             ' HAVING sum(zx_dist1.taxable_amt) <> 0 ))';

Line: 680


      L_WHERE_REGISTER_TYPE :=' AND EXISTS (SELECT ''Fully  Recoverable''' ||
                                            ' FROM zx_rec_nrec_dist zx_dist1 ' ||
                                           ' WHERE zx_dist1.trx_id = zx_dist.trx_id ' ||
                                             ' AND zx_dist1.rec_nrec_tax_dist_id = zx_dist.rec_nrec_tax_dist_id ' ||
                                             ' AND zx_dist1.recoverable_flag = ''Y'' '||
                                             ' AND zx_dist1.tax_rate_id = zx_dist.tax_rate_id )';

Line: 690


    L_WHERE_REGISTER_TYPE :=' AND EXISTS (SELECT ''Fully  Recoverable''' ||
                                          ' FROM zx_rec_nrec_dist zx_dist1 ' ||
                                         ' WHERE zx_dist1.trx_id = zx_dist.trx_id ' ||
                                           ' AND zx_dist1.rec_nrec_tax_dist_id = zx_dist.rec_nrec_tax_dist_id ' ||
                                           ' AND zx_dist1.recoverable_flag = ''N'' '||
                                           ' AND zx_dist1.tax_rate_id = zx_dist.tax_rate_id )';

Line: 994


       'SELECT
        zx_det.application_id,
        zx_line.event_class_code ,
        zx_det.internal_organization_id,
        zx_det.doc_event_status,
        zx_det.application_doc_status,
        zx_det.line_class,
        zx_det.doc_seq_id ,
        zx_det.doc_seq_name ,
        zx_det.doc_seq_value,
        zx_det.establishment_id,
        zx_det.batch_source_id,
        zx_det.currency_conversion_date,
        zx_det.currency_conversion_rate,
        zx_det.currency_conversion_type,
        zx_det.minimum_accountable_unit,
        zx_det.precision,
        zx_det.trx_communicated_date ,
        zx_det.trx_currency_code,
        zx_line.trx_id   ,
        zx_det.trx_number ,
        zx_det.trx_date,
        zx_det.trx_description,
        zx_det.trx_type_description,
        zx_rate.description,
        zx_det.trx_due_date,
        to_char(null),--zx_det.trx_line_description,
        to_char(null),--zx_line.trx_line_id,
        to_char(null),--zx_line.trx_line_number,
        to_char(null),--zx_line.trx_line_quantity,
        sum(zx_line.line_amt),
        to_char(NULL),  --zx_det.trx_line_type,
        to_char(NULL), --zx_det.trx_shipping_date,
        to_char(NULL),  --zx_det.uom_code,
        to_char(NULL), --zx_det.related_doc_date,
        to_char(NULL), --zx_det.related_doc_entity_code,
        to_char(NULL), --zx_det.related_doc_event_class_code,
        to_char(NULL), --zx_det.related_doc_number,
        to_number(NULL),   --zx_det.related_doc_trx_id,
        to_number(NULL),   --zx_det.applied_from_application_id,
        to_char(NULL), --zx_line.applied_from_entity_code,
        to_char(NULL), --zx_line.applied_from_event_class_code,
        to_number(NULL),   --zx_det.applied_from_line_id,
        to_number(NULL),   --zx_line.applied_from_trx_id,
        to_char(NULL), --zx_line.applied_from_trx_number,
        to_number(NULL),   --zx_det.applied_to_application_id,
        to_char(NULL), -- zx_line.applied_to_entity_code,
        to_char(NULL), --zx_line.applied_to_event_class_code,
        to_number(NULL),   --zx_line.applied_to_trx_id,
        to_number(NULL),   --zx_det.applied_to_trx_line_id,
        to_char(NULL), --zx_det.applied_to_trx_number,
        to_number(NULL),   --zx_det.adjusted_doc_application_id,
        to_char(NULL), --zx_det.adjusted_doc_date,
        to_char(NULL), --zx_det.adjusted_doc_entity_code,
        to_char(NULL), --zx_det.adjusted_doc_event_class_code,
        to_char(NULL), --ZX_DET.ADJUSTED_DOC_NUMBER,
        --zx_det.country_of_supply,
        zx_det.default_taxation_country,
        TO_CHAR(NULL), --ZX_DET.MERCHANT_PARTY_DOCUMENT_NUMBER,
        TO_CHAR(NULL), --ZX_DET.MERCHANT_PARTY_NAME,
        TO_CHAR(NULL), --ZX_DET.MERCHANT_PARTY_REFERENCE,
        TO_CHAR(NULL), --ZX_DET.MERCHANT_PARTY_TAX_REG_NUMBER,
        TO_CHAR(NULL), --ZX_DET.MERCHANT_PARTY_TAXPAYER_ID,
        to_number(NULL),  --zx_det.ref_doc_application_id,
        to_char(NULL),  --zx_det.ref_doc_entity_code,
        to_char(NULL),  --zx_det.ref_doc_event_class_code,
        to_number(NULL),  --zx_det.ref_doc_line_id,
        to_number(NULL),  --zx_det.ref_doc_line_quantity,
        to_number(NULL),  --zx_det.ref_doc_trx_id,
        zx_det.start_expense_date,
        sum(zx_det.assessable_value),
        zx_det.document_sub_type,
        to_char(NULL),    --zx_det.line_intended_use,
        to_char(NULL),    --zx_det.product_category,
        to_char(NULL),    --zx_det.product_description,
        to_char(NULL),    --zx_det.product_fisc_classification,
        to_number(NULL),    --zx_det.product_id,
        zx_det.supplier_exchange_rate,
        zx_det.supplier_tax_invoice_date,
        zx_det.supplier_tax_invoice_number,
        zx_det.tax_invoice_date,
        zx_det.tax_invoice_number,
        zx_det.trx_business_category,
        zx_det.user_defined_fisc_class,
        CASE WHEN ('''||G_REGISTER_TYPE||''' = ''TAX'' AND '''||G_INCLUDE_FULLY_NR_TAX_FLAG||''' = ''Y'') THEN
                  Decode(zx_dist.recoverable_flag
                         ,''N'',0,
                         sum(NVL(zx_dist.rec_nrec_tax_amt_tax_curr,zx_dist.rec_nrec_tax_amt))
                         )
             ELSE sum(NVL(zx_dist.rec_nrec_tax_amt_tax_curr,zx_dist.rec_nrec_tax_amt))
        END,
        zx_line.OFFSET_TAX_RATE_CODE,
        CASE WHEN ('''||G_REGISTER_TYPE||''' = ''TAX'' AND '''||G_INCLUDE_FULLY_NR_TAX_FLAG||''' = ''Y'') THEN
                  Decode(zx_dist.recoverable_flag
                         ,''N'',0,
                         sum(zx_dist.orig_rec_nrec_tax_amt)
                         )
             ELSE sum(zx_dist.orig_rec_nrec_tax_amt)
        END,
        sum(zx_line.orig_tax_amt),
        sum(zx_line.orig_tax_amt_tax_curr) ,
        sum(zx_line.orig_taxable_amt),
        sum(zx_line.orig_taxable_amt_tax_curr),
        CASE WHEN ('''||G_REGISTER_TYPE||''' = ''TAX'' AND '''||G_INCLUDE_FULLY_NR_TAX_FLAG||''' = ''Y'') THEN
                  Decode(zx_dist.recoverable_flag
                         ,''N'',0,
                         sum(zx_dist.orig_rec_nrec_tax_amt_tax_curr)
                         )
             ELSE sum(zx_dist.orig_rec_nrec_tax_amt_tax_curr)
        END,
        TO_CHAR(NULL), --ZX_DIST.RECOVERY_RATE_CODE,
        TO_CHAR(NULL), --ZX_DIST.RECOVERY_TYPE_CODE,
        zx_line.tax,
        CASE WHEN ('''||G_REGISTER_TYPE||''' = ''TAX'' AND '''||G_INCLUDE_FULLY_NR_TAX_FLAG||''' = ''Y'') THEN
                  Decode(zx_dist.recoverable_flag
                         ,''N'',0,
                         sum(zx_dist.rec_nrec_tax_amt)
                         )
             ELSE sum(zx_dist.rec_nrec_tax_amt)
        END,
        CASE WHEN ('''||G_REGISTER_TYPE||''' = ''TAX'' AND '''||G_INCLUDE_FULLY_NR_TAX_FLAG||''' = ''Y'') THEN
                  Decode(zx_dist.recoverable_flag
                         ,''N'',0,
                         sum(NVL(zx_dist.rec_nrec_tax_amt_funcl_curr,zx_dist.rec_nrec_tax_amt))
                         )
             ELSE sum(NVL(zx_dist.rec_nrec_tax_amt_funcl_curr,zx_dist.rec_nrec_tax_amt))
        END,
        sum(zx_line.tax_amt_tax_curr),
        TO_NUMBER(NULL), --zx_line.tax_apportionment_line_number,
        zx_line.tax_currency_code,
        zx_line.tax_date,
        zx_line.tax_determine_date,
        zx_line.tax_jurisdiction_code,
        TO_NUMBER(NULL), --ZX_LINE.TAX_LINE_ID ,
        TO_NUMBER(NULL),  --ZX_LINE.TAX_LINE_NUMBER ,
        TO_CHAR(NULL), --ZX_LINE.TAX_LINE_USER_ATTRIBUTE1 ,
        TO_CHAR(NULL), --ZX_LINE.TAX_LINE_USER_ATTRIBUTE10,
        TO_CHAR(NULL), --ZX_LINE.TAX_LINE_USER_ATTRIBUTE11,
        TO_CHAR(NULL), --ZX_LINE.TAX_LINE_USER_ATTRIBUTE12,
        TO_CHAR(NULL), --ZX_LINE.TAX_LINE_USER_ATTRIBUTE13,
        TO_CHAR(NULL), --ZX_LINE.TAX_LINE_USER_ATTRIBUTE14,
        TO_CHAR(NULL), --ZX_LINE.TAX_LINE_USER_ATTRIBUTE15,
        TO_CHAR(NULL), --ZX_LINE.TAX_LINE_USER_ATTRIBUTE2,
        TO_CHAR(NULL), --ZX_LINE.TAX_LINE_USER_ATTRIBUTE3,
        TO_CHAR(NULL), --ZX_LINE.TAX_LINE_USER_ATTRIBUTE4,
        TO_CHAR(NULL), --ZX_LINE.TAX_LINE_USER_ATTRIBUTE5,
        TO_CHAR(NULL), --ZX_LINE.TAX_LINE_USER_ATTRIBUTE6,
        TO_CHAR(NULL), --ZX_LINE.TAX_LINE_USER_ATTRIBUTE7,
        TO_CHAR(NULL), --ZX_LINE.TAX_LINE_USER_ATTRIBUTE8,
        TO_CHAR(NULL), --ZX_LINE.TAX_LINE_USER_ATTRIBUTE9,
        TO_CHAR(NULL), --ZX_LINE.TAX_LINE_USER_CATEGORY,
        DECODE(zx_line.LAST_MANUAL_ENTRY,''TAX_RATE'',zx_line.TAX_RATE,zx_rate.percentage_rate),
        zx_line.tax_rate_code,
        zx_line.tax_rate_id,
        TO_NUMBER(NULL),  --ZX_DIST.REC_NREC_RATE,
        zx_line.tax_regime_code,
        zx_line.tax_status_id,
        zx_line.tax_status_code,
        sum(zx_dist.taxable_amt)/Count(zx_dist.trx_id),
        sum(zx_dist.taxable_amt_funcl_curr)/Count(zx_dist.trx_id),
        --   zx_det.billing_trading_partner_name,
        --  zx_det.billing_trading_partner_number,
        zx_det.bill_from_party_tax_prof_id,
        zx_det.bill_from_site_tax_prof_id,
        --    zx_det.billing_tp_taxpayer_id,
        zx_det.ship_to_site_tax_prof_id,
        zx_det.ship_from_site_tax_prof_id,
        TO_NUMBER(NULL), -- zx_det.ship_to_party_tax_prof_id,
        zx_det.ship_from_party_tax_prof_id,
        ZX_DET.SHIP_THIRD_PTY_ACCT_SITE_ID,
        ZX_DET.BILL_THIRD_PTY_ACCT_SITE_ID,
        ZX_DET.SHIP_TO_CUST_ACCT_SITE_USE_ID,
        ZX_DET.BILL_TO_CUST_ACCT_SITE_USE_ID,
        ZX_DET.SHIP_THIRD_PTY_ACCT_ID,
        ZX_DET.BILL_THIRD_PTY_ACCT_ID,
        zx_line.hq_estb_reg_number,
        zx_line.tax_registration_number,
        zx_line.legal_entity_tax_reg_number,
        zx_det.own_hq_site_tax_prof_id,
        zx_det.own_hq_party_tax_prof_id,
        zx_det.port_of_entry_code,
        zx_line.registration_party_type,
        zx_line.cancel_flag,
        zx_line.historical_flag,
        zx_line.mrc_tax_line_flag,
        zx_line.offset_flag,
        zx_line.reporting_only_flag,
        zx_dist.self_assessed_flag,
        zx_line.tax_amt_included_flag,
        zx_line.tax_only_line_flag,
        zx_dist.recoverable_flag,
        zx_dist.posting_flag,
        zx_dist.reverse_flag,
        zx_det.trx_id,
        zx_dist.trx_line_dist_id,
        zx_det.entity_code ,
        zx_det.ledger_id,
        ZX_RATE.VAT_TRANSACTION_TYPE_CODE,
        zx_tax.tax_type_code,
        ZX_RATE.TAX_RATE_NAME,
        zx_det.trx_level_type,
        to_number(NULL),  --zx_det.unit_price ,
        zx_dist.gl_date,
        to_char(NULL)
   FROM zx_lines zx_line,
        zx_lines_det_factors zx_det,
        zx_rec_nrec_dist zx_dist,
        zx_taxes_vl    zx_tax,
        zx_rates_vl    zx_rate
  WHERE zx_det.internal_organization_id = zx_line.internal_organization_id
    AND zx_det.application_id    = zx_line.application_id
    AND zx_det.application_id    = 200
    AND zx_det.tax_reporting_flag = ''Y''
    AND zx_det.entity_code       = zx_line.entity_code
    AND zx_det.event_class_code  = zx_line.event_class_code
    AND zx_det.trx_id            = zx_line.trx_id
    AND zx_det.trx_line_id            = zx_line.trx_line_id
    AND zx_line.tax_line_id      = zx_dist.tax_line_id
    AND zx_line.tax_id            = zx_tax.tax_id
    AND zx_line.application_id    = 200
    AND zx_rate.tax_regime_code = zx_tax.tax_regime_code
    AND zx_rate.tax = zx_tax.tax
    AND zx_line.tax_regime_code = zx_tax.tax_regime_code
    AND zx_line.tax_rate_id     = zx_rate.tax_rate_id '
    || ' AND '''||G_SUMMARY_LEVEL||''' = '''||G_SUMMARY_LEVEL||''' '
    ||L_WHERE_GL_TRX_DATE||' '
    ||L_WHERE_TRX_DATE|| ' '
    ||L_WHERE_REGISTER_TYPE|| ' '
    ||L_WHERE_GL_DATE|| ' '
    ||L_WHERE_TRX_NUM|| ' '
    ||L_WHERE_VAT_TRANSACTION_TYPE|| ' '
    ||L_WHERE_TRX_BUSINESS_CATEGORY|| ' '
    ||L_WHERE_TAX_INVOICE_DATE|| ' '
    ||L_WHERE_TAX_JURISDICTION_CODE|| ' '
    ||L_WHERE_FIRST_PTY_TAX_REG_NUM|| ' '
    ||L_WHERE_TAX_REGIME_CODE|| ' '
    ||L_WHERE_TAX|| ' '
    ||L_WHERE_TAX_STATUS_CODE|| ' '
    ||L_WHERE_TAX_RATE_CODE|| ' '
    ||L_WHERE_TAX_TYPE_CODE|| ' '
    ||L_WHERE_CURRENCY_CODE|| ' '
    ||L_WHERE_PARTY_NAME|| ' '
    ||L_WHERE_TRX_CLASS|| ' '
    ||L_WHERE_LEGAL_ENTITY_ID|| ' '
    ||L_WHERE_LEDGER_ID|| ' '
    ||L_WHERE_REPORT_CONTEXT||' '
    ||L_WHERE_ACCOUNTING_STATUS||' '
    ||L_WHERE_REPORTED_STATUS||' '
    ||L_WHERE_ADJUSTED_DOC_NUM||' '
    || 'GROUP BY
        zx_det.application_id,
        zx_line.event_class_code ,
        zx_det.internal_organization_id,
        zx_det.doc_event_status,
        zx_det.application_doc_status,
        zx_det.line_class,
        zx_det.doc_seq_id,
        zx_det.doc_seq_name ,
        zx_det.doc_seq_value,
        zx_det.establishment_id,
        zx_det.batch_source_id,
        zx_det.currency_conversion_date,
        zx_det.currency_conversion_rate,
        zx_det.currency_conversion_type,
        zx_det.minimum_accountable_unit,
        zx_det.precision,
        zx_det.trx_communicated_date,
        zx_det.trx_currency_code,
        zx_line.trx_id,
        zx_det.trx_number,
        zx_det.trx_date,
        zx_det.trx_description,
        zx_det.trx_type_description,
        zx_rate.description,
        zx_det.trx_due_date,
        to_char(null),--zx_det.trx_line_description,
        to_char(null),--zx_line.trx_line_id,
        to_char(null),--zx_line.trx_line_number,
        to_char(null),--zx_line.trx_line_quantity,
        zx_det.default_taxation_country,
        zx_det.start_expense_date,
        zx_det.document_sub_type,
        zx_det.supplier_exchange_rate,
        zx_det.supplier_tax_invoice_date,
        zx_det.supplier_tax_invoice_number,
        zx_det.tax_invoice_date,
        zx_det.tax_invoice_number,
        zx_det.trx_business_category,
        zx_det.user_defined_fisc_class,
        zx_line.offset_tax_rate_code,
        zx_line.tax,
        zx_line.tax_currency_code,
        zx_line.tax_date,
        zx_line.tax_determine_date,
        zx_line.tax_jurisdiction_code,
        decode(zx_line.last_manual_entry,''TAX_RATE'',zx_line.tax_rate,zx_rate.percentage_rate),
        zx_line.tax_rate_code,
        zx_line.tax_rate_id,
        to_number(null),  --zx_dist.rec_nrec_rate,
        zx_line.tax_regime_code,
        zx_line.tax_status_id,
        zx_line.tax_status_code,
        zx_det.bill_from_party_tax_prof_id,
        zx_det.bill_from_site_tax_prof_id,
        zx_det.ship_to_site_tax_prof_id,
        zx_det.ship_from_site_tax_prof_id,
        zx_det.ship_from_party_tax_prof_id ,
        zx_det.ship_third_pty_acct_site_id,
        zx_det.bill_third_pty_acct_site_id,
        zx_det.ship_to_cust_acct_site_use_id,
        zx_det.bill_to_cust_acct_site_use_id,
        zx_det.ship_third_pty_acct_id,
        zx_det.bill_third_pty_acct_id,
        zx_line.hq_estb_reg_number,
        zx_line.tax_registration_number,
        zx_line.legal_entity_tax_reg_number,
        zx_det.own_hq_site_tax_prof_id,
        zx_det.own_hq_party_tax_prof_id,
        zx_det.port_of_entry_code,
        zx_line.registration_party_type,
        zx_line.cancel_flag,
        zx_line.historical_flag,
        zx_line.mrc_tax_line_flag,
        zx_line.offset_flag,
        zx_line.reporting_only_flag,
        zx_dist.self_assessed_flag,
        zx_line.tax_amt_included_flag,
        zx_line.tax_only_line_flag,
        zx_dist.recoverable_flag,
        zx_dist.posting_flag ,
        zx_dist.reverse_flag,
        zx_det.trx_id,
        zx_dist.trx_line_dist_id,
        zx_det.entity_code,
        zx_det.ledger_id,
        zx_rate.vat_transaction_type_code,
        zx_tax.tax_type_code,
        zx_rate.tax_rate_name,
        zx_det.trx_level_type,
        zx_dist.gl_date';

Line: 1342


       'SELECT
        zx_det.application_id,
        zx_line.event_class_code ,
        zx_det.internal_organization_id,
        zx_det.doc_event_status,
        zx_det.application_doc_status,
        zx_det.line_class,
        zx_det.doc_seq_id ,
        zx_det.doc_seq_name ,
        zx_det.doc_seq_value,
        zx_det.establishment_id,
        zx_det.batch_source_id,
        zx_det.currency_conversion_date,
        zx_det.currency_conversion_rate,
        zx_det.currency_conversion_type,
        zx_det.minimum_accountable_unit,
        zx_det.precision,
        zx_det.trx_communicated_date ,
        zx_det.trx_currency_code,
        zx_line.trx_id   ,
        zx_det.trx_number ,
        zx_det.trx_date,
        zx_det.trx_description,
        zx_det.trx_type_description,
        zx_rate.description,
        zx_det.trx_due_date,
        to_char(null),--zx_det.trx_line_description,
        to_char(null),--zx_line.trx_line_id,
        to_char(null),--zx_line.trx_line_number,
        to_char(null),--zx_line.trx_line_quantity,
        sum(zx_line.line_amt),
        to_char(NULL),  --zx_det.trx_line_type,
        to_char(NULL), --zx_det.trx_shipping_date,
        to_char(NULL),  --zx_det.uom_code,
        to_char(NULL), --zx_det.related_doc_date,
        to_char(NULL), --zx_det.related_doc_entity_code,
        to_char(NULL), --zx_det.related_doc_event_class_code,
        to_char(NULL), --zx_det.related_doc_number,
        to_number(NULL),   --zx_det.related_doc_trx_id,
        to_number(NULL),   --zx_det.applied_from_application_id,
        to_char(NULL), --zx_line.applied_from_entity_code,
        to_char(NULL), --zx_line.applied_from_event_class_code,
        to_number(NULL),   --zx_det.applied_from_line_id,
        to_number(NULL),   --zx_line.applied_from_trx_id,
        to_char(NULL), --zx_line.applied_from_trx_number,
        to_number(NULL),   --zx_det.applied_to_application_id,
        to_char(NULL), -- zx_line.applied_to_entity_code,
        to_char(NULL), --zx_line.applied_to_event_class_code,
        to_number(NULL),   --zx_line.applied_to_trx_id,
        to_number(NULL),   --zx_det.applied_to_trx_line_id,
        to_char(NULL), --zx_det.applied_to_trx_number,
        to_number(NULL),   --zx_det.adjusted_doc_application_id,
        to_char(NULL), --zx_det.adjusted_doc_date,
        to_char(NULL), --zx_det.adjusted_doc_entity_code,
        to_char(NULL), --zx_det.adjusted_doc_event_class_code,
        to_char(NULL), --ZX_DET.ADJUSTED_DOC_NUMBER,
        --zx_det.country_of_supply,
        zx_det.default_taxation_country,
        TO_CHAR(NULL), --ZX_DET.MERCHANT_PARTY_DOCUMENT_NUMBER,
        TO_CHAR(NULL), --ZX_DET.MERCHANT_PARTY_NAME,
        TO_CHAR(NULL), --ZX_DET.MERCHANT_PARTY_REFERENCE,
        TO_CHAR(NULL), --ZX_DET.MERCHANT_PARTY_TAX_REG_NUMBER,
        TO_CHAR(NULL), --ZX_DET.MERCHANT_PARTY_TAXPAYER_ID,
        to_number(NULL),  --zx_det.ref_doc_application_id,
        to_char(NULL),  --zx_det.ref_doc_entity_code,
        to_char(NULL),  --zx_det.ref_doc_event_class_code,
        to_number(NULL),  --zx_det.ref_doc_line_id,
        to_number(NULL),  --zx_det.ref_doc_line_quantity,
        to_number(NULL),  --zx_det.ref_doc_trx_id,
        zx_det.start_expense_date,
        sum(zx_det.assessable_value),
        zx_det.document_sub_type,
        to_char(NULL),    --zx_det.line_intended_use,
        to_char(NULL),    --zx_det.product_category,
        to_char(NULL),    --zx_det.product_description,
        to_char(NULL),    --zx_det.product_fisc_classification,
        to_number(NULL),    --zx_det.product_id,
        zx_det.supplier_exchange_rate,
        zx_det.supplier_tax_invoice_date,
        zx_det.supplier_tax_invoice_number,
        zx_det.tax_invoice_date,
        zx_det.tax_invoice_number,
        zx_det.trx_business_category,
        zx_det.user_defined_fisc_class,
        sum(NVL(zx_dist.rec_nrec_tax_amt_tax_curr,zx_dist.rec_nrec_tax_amt)),
        zx_line.OFFSET_TAX_RATE_CODE,
        sum(zx_dist.orig_rec_nrec_tax_amt),
        sum(zx_line.orig_tax_amt),
        sum(zx_line.orig_tax_amt_tax_curr) ,
        sum(zx_line.orig_taxable_amt),
        sum(zx_line.orig_taxable_amt_tax_curr),
        sum(zx_dist.orig_rec_nrec_tax_amt_tax_curr),
        TO_CHAR(NULL), --ZX_DIST.RECOVERY_RATE_CODE,
        TO_CHAR(NULL), --ZX_DIST.RECOVERY_TYPE_CODE,
        zx_line.tax,
        sum(zx_dist.rec_nrec_tax_amt),
        sum(NVL(zx_dist.rec_nrec_tax_amt_funcl_curr,zx_dist.rec_nrec_tax_amt)),
        sum(zx_line.tax_amt_tax_curr),
        TO_NUMBER(NULL), --zx_line.tax_apportionment_line_number,
        zx_line.tax_currency_code,
        zx_line.tax_date,
        zx_line.tax_determine_date,
        zx_line.tax_jurisdiction_code,
        TO_NUMBER(NULL), --ZX_LINE.TAX_LINE_ID ,
        TO_NUMBER(NULL),  --ZX_LINE.TAX_LINE_NUMBER ,
        TO_CHAR(NULL), --ZX_LINE.TAX_LINE_USER_ATTRIBUTE1 ,
        TO_CHAR(NULL), --ZX_LINE.TAX_LINE_USER_ATTRIBUTE10,
        TO_CHAR(NULL), --ZX_LINE.TAX_LINE_USER_ATTRIBUTE11,
        TO_CHAR(NULL), --ZX_LINE.TAX_LINE_USER_ATTRIBUTE12,
        TO_CHAR(NULL), --ZX_LINE.TAX_LINE_USER_ATTRIBUTE13,
        TO_CHAR(NULL), --ZX_LINE.TAX_LINE_USER_ATTRIBUTE14,
        TO_CHAR(NULL), --ZX_LINE.TAX_LINE_USER_ATTRIBUTE15,
        TO_CHAR(NULL), --ZX_LINE.TAX_LINE_USER_ATTRIBUTE2,
        TO_CHAR(NULL), --ZX_LINE.TAX_LINE_USER_ATTRIBUTE3,
        TO_CHAR(NULL), --ZX_LINE.TAX_LINE_USER_ATTRIBUTE4,
        TO_CHAR(NULL), --ZX_LINE.TAX_LINE_USER_ATTRIBUTE5,
        TO_CHAR(NULL), --ZX_LINE.TAX_LINE_USER_ATTRIBUTE6,
        TO_CHAR(NULL), --ZX_LINE.TAX_LINE_USER_ATTRIBUTE7,
        TO_CHAR(NULL), --ZX_LINE.TAX_LINE_USER_ATTRIBUTE8,
        TO_CHAR(NULL), --ZX_LINE.TAX_LINE_USER_ATTRIBUTE9,
        TO_CHAR(NULL), --ZX_LINE.TAX_LINE_USER_CATEGORY,
        DECODE(zx_line.LAST_MANUAL_ENTRY,''TAX_RATE'',zx_line.TAX_RATE,zx_rate.percentage_rate),
        zx_line.tax_rate_code,
        zx_line.tax_rate_id,
        TO_NUMBER(NULL),  --ZX_DIST.REC_NREC_RATE,
        zx_line.tax_regime_code,
        zx_line.tax_status_id,
        zx_line.tax_status_code,
        sum(zx_dist.taxable_amt),
        sum(zx_dist.taxable_amt_funcl_curr),
        --   zx_det.billing_trading_partner_name,
        --  zx_det.billing_trading_partner_number,
        zx_det.bill_from_party_tax_prof_id,
        zx_det.bill_from_site_tax_prof_id,
        --    zx_det.billing_tp_taxpayer_id,
        zx_det.ship_to_site_tax_prof_id,
        zx_det.ship_from_site_tax_prof_id,
        TO_NUMBER(NULL), -- zx_det.ship_to_party_tax_prof_id,
        zx_det.ship_from_party_tax_prof_id,
        ZX_DET.SHIP_THIRD_PTY_ACCT_SITE_ID,
        ZX_DET.BILL_THIRD_PTY_ACCT_SITE_ID,
        ZX_DET.SHIP_TO_CUST_ACCT_SITE_USE_ID,
        ZX_DET.BILL_TO_CUST_ACCT_SITE_USE_ID,
        ZX_DET.SHIP_THIRD_PTY_ACCT_ID,
        ZX_DET.BILL_THIRD_PTY_ACCT_ID,
        zx_line.hq_estb_reg_number,
        zx_line.tax_registration_number,
        zx_line.legal_entity_tax_reg_number,
        zx_det.own_hq_site_tax_prof_id,
        zx_det.own_hq_party_tax_prof_id,
        zx_det.port_of_entry_code,
        zx_line.registration_party_type,
        zx_line.cancel_flag,
        zx_line.historical_flag,
        zx_line.mrc_tax_line_flag,
        zx_line.offset_flag,
        zx_line.reporting_only_flag,
        zx_dist.self_assessed_flag,
        zx_line.tax_amt_included_flag,
        zx_line.tax_only_line_flag,
        zx_dist.recoverable_flag,
        zx_dist.posting_flag,
        zx_dist.reverse_flag,
        zx_det.trx_id,
        to_number(NULL),
        zx_det.entity_code ,
        zx_det.ledger_id,
        ZX_RATE.VAT_TRANSACTION_TYPE_CODE,
        zx_tax.tax_type_code,
        ZX_RATE.TAX_RATE_NAME,
        zx_det.trx_level_type, -- Bug 5393051
        to_number(NULL),  --zx_det.unit_price ,     -- Bug 5439099
        zx_det.trx_line_gl_date, --Bug 5523095
        to_char(NULL) -- Bug10238948
   FROM zx_lines zx_line,
        zx_lines_det_factors zx_det,
        zx_rec_nrec_dist zx_dist,
        zx_taxes_vl    zx_tax,
        zx_rates_vl    zx_rate
  WHERE zx_det.internal_organization_id = zx_line.internal_organization_id
    AND zx_det.application_id    = zx_line.application_id
    AND zx_det.application_id    = 200
    AND zx_det.tax_reporting_flag = ''Y''
    AND zx_det.entity_code       = zx_line.entity_code
    AND zx_det.event_class_code  = zx_line.event_class_code
    AND zx_det.trx_id            = zx_line.trx_id
    AND zx_det.trx_line_id            = zx_line.trx_line_id
    --    AND zx_det.application_id    = zx_dist.application_id
    --    AND zx_det.entity_code       = zx_dist.entity_code
    --    AND zx_det.event_class_code  = zx_dist.event_class_code
    --    AND zx_det.event_type_code   = zx_dist.event_type_code
    --    AND zx_det.trx_id            = zx_dist.trx_id
    AND zx_line.tax_line_id      = zx_dist.tax_line_id
    AND zx_line.tax_id            = zx_tax.tax_id
    AND zx_line.application_id    = 200
    AND zx_rate.tax_regime_code = zx_tax.tax_regime_code
    AND zx_rate.tax = zx_tax.tax
    AND zx_line.tax_regime_code = zx_tax.tax_regime_code
    AND zx_line.tax_rate_id     = zx_rate.tax_rate_id '
    || ' AND '''||G_SUMMARY_LEVEL||''' = '''||G_SUMMARY_LEVEL||''' '
    ||L_WHERE_GL_TRX_DATE||' '
    ||L_WHERE_TRX_DATE|| ' '
    ||L_WHERE_REGISTER_TYPE|| ' '
    ||L_WHERE_GL_DATE|| ' '
    ||L_WHERE_TRX_NUM|| ' '
    ||L_WHERE_VAT_TRANSACTION_TYPE|| ' '
    ||L_WHERE_TRX_BUSINESS_CATEGORY|| ' '
    ||L_WHERE_TAX_INVOICE_DATE|| ' '
    ||L_WHERE_TAX_JURISDICTION_CODE|| ' '
    ||L_WHERE_FIRST_PTY_TAX_REG_NUM|| ' '
    ||L_WHERE_TAX_REGIME_CODE|| ' '
    ||L_WHERE_TAX|| ' '
    ||L_WHERE_TAX_STATUS_CODE|| ' '
    ||L_WHERE_TAX_RATE_CODE|| ' '
    ||L_WHERE_TAX_TYPE_CODE|| ' '
    ||L_WHERE_CURRENCY_CODE|| ' '
    ||L_WHERE_PARTY_NAME|| ' '
    ||L_WHERE_TRX_CLASS|| ' '
    ||L_WHERE_LEGAL_ENTITY_ID|| ' '
    ||L_WHERE_LEDGER_ID|| ' '
    ||L_WHERE_REPORT_CONTEXT||' '
    ||L_WHERE_ACCOUNTING_STATUS||' '
    ||L_WHERE_REPORTED_STATUS||' '
    ||L_WHERE_ADJUSTED_DOC_NUM||' '
    || 'GROUP BY
        zx_det.application_id,
        zx_line.event_class_code ,
        zx_det.internal_organization_id,
        zx_det.doc_event_status,
        zx_det.application_doc_status,
        zx_det.line_class,
        zx_det.doc_seq_id,
        zx_det.doc_seq_name ,
        zx_det.doc_seq_value,
        zx_det.establishment_id,
        zx_det.batch_source_id,
        zx_det.currency_conversion_date,
        zx_det.currency_conversion_rate,
        zx_det.currency_conversion_type,
        zx_det.minimum_accountable_unit,
        zx_det.precision,
        zx_det.trx_communicated_date,
        zx_det.trx_currency_code,
        zx_line.trx_id,
        zx_det.trx_number,
        zx_det.trx_date,
        zx_det.trx_description,
        zx_det.trx_type_description,
        zx_rate.description,
        zx_det.trx_due_date,
        to_char(null),--zx_det.trx_line_description,
        to_char(null),--zx_line.trx_line_id,
        to_char(null),--zx_line.trx_line_number,
        to_char(null),--zx_line.trx_line_quantity,
        --zx_line.line_amt,
        --zx_det.trx_line_type,
        --zx_det.trx_shipping_date,
        --zx_det.uom_code,
        --zx_det.related_doc_date,
        --zx_det.related_doc_entity_code,
        --zx_det.related_doc_event_class_code,
        --zx_det.related_doc_number,
        --zx_det.related_doc_trx_id,
        --zx_det.applied_from_application_id,
        --zx_line.applied_from_entity_code,
        --zx_line.applied_from_event_class_code,
        --zx_det.applied_from_line_id,
        --zx_line.applied_from_trx_id,
        --zx_line.applied_from_trx_number,
        --zx_det.applied_to_application_id,
        --zx_line.applied_to_entity_code,
        --zx_line.applied_to_event_class_code,
        --zx_line.applied_to_trx_id,
        --zx_det.applied_to_trx_line_id,
        --zx_det.applied_to_trx_number,
        --zx_det.adjusted_doc_application_id,
        --zx_det.adjusted_doc_date,
        --zx_det.adjusted_doc_entity_code,
        --zx_det.adjusted_doc_event_class_code,
        --ZX_DET.ADJUSTED_DOC_NUMBER,
        --zx_det.country_of_supply,
        zx_det.default_taxation_country,
        --zx_det.ref_doc_application_id,
        --zx_det.ref_doc_entity_code,
        --zx_det.ref_doc_event_class_code,
        --zx_det.ref_doc_line_id,
        --zx_det.ref_doc_line_quantity,
        --zx_det.ref_doc_trx_id,
        zx_det.start_expense_date,
        --zx_det.assessable_value,
        zx_det.document_sub_type,
        --zx_det.line_intended_use,
        --zx_det.product_category,
        --zx_det.product_description,
        --zx_det.product_fisc_classification,
        --zx_det.product_id,
        zx_det.supplier_exchange_rate,
        zx_det.supplier_tax_invoice_date,
        zx_det.supplier_tax_invoice_number,
        zx_det.tax_invoice_date,
        zx_det.tax_invoice_number,
        zx_det.trx_business_category,
        zx_det.user_defined_fisc_class,
        zx_line.OFFSET_TAX_RATE_CODE,
        zx_line.tax,
        --zx_line.tax_apportionment_line_number,
        zx_line.tax_currency_code,
        zx_line.tax_date,
        zx_line.tax_determine_date,
        zx_line.tax_jurisdiction_code,
        DECODE(zx_line.LAST_MANUAL_ENTRY,''TAX_RATE'',zx_line.TAX_RATE,zx_rate.percentage_rate),
        zx_line.tax_rate_code,
        zx_line.tax_rate_id,
        to_number(null),  --zx_dist.rec_nrec_rate,
        zx_line.tax_regime_code,
        zx_line.tax_status_id,
        zx_line.tax_status_code,
        -- zx_det.billing_trading_partner_name,
        -- zx_det.billing_trading_partner_number,
        zx_det.bill_from_party_tax_prof_id,
        zx_det.bill_from_site_tax_prof_id,
        -- zx_det.billing_tp_taxpayer_id,
        zx_det.ship_to_site_tax_prof_id,
        zx_det.ship_from_site_tax_prof_id,
        -- zx_det.ship_to_party_tax_prof_id,
        zx_det.ship_from_party_tax_prof_id ,
        ZX_DET.SHIP_THIRD_PTY_ACCT_SITE_ID,
        ZX_DET.BILL_THIRD_PTY_ACCT_SITE_ID,
        ZX_DET.SHIP_TO_CUST_ACCT_SITE_USE_ID,
        ZX_DET.BILL_TO_CUST_ACCT_SITE_USE_ID,
        ZX_DET.SHIP_THIRD_PTY_ACCT_ID,
        ZX_DET.BILL_THIRD_PTY_ACCT_ID,
        zx_line.hq_estb_reg_number,
        zx_line.tax_registration_number,
        zx_line.legal_entity_tax_reg_number,
        zx_det.own_hq_site_tax_prof_id,
        zx_det.own_hq_party_tax_prof_id,
        zx_det.port_of_entry_code,
        zx_line.registration_party_type,
        zx_line.cancel_flag,
        zx_line.historical_flag,
        zx_line.mrc_tax_line_flag,
        zx_line.offset_flag,
        zx_line.reporting_only_flag,
        zx_dist.self_assessed_flag,
        zx_line.tax_amt_included_flag,
        zx_line.tax_only_line_flag,
        zx_dist.recoverable_flag,
        zx_dist.posting_flag ,
        zx_dist.reverse_flag,
        zx_det.trx_id,
        zx_det.entity_code,
        zx_det.ledger_id,
        ZX_RATE.VAT_TRANSACTION_TYPE_CODE,
        --ZX_RATE.RATE_TYPE_CODE,
        zx_tax.tax_type_code,
        ZX_RATE.TAX_RATE_NAME,
        zx_det.trx_level_type,
        --zx_det.unit_price,
        zx_det.trx_line_gl_date';

Line: 1716


      l_sql_statement := 'SELECT /*+ cardinality(ZX_DIST 100) use_nl(zx_line) use_nl(zx_tax.b) */ ';

Line: 1718


      l_sql_statement := 'SELECT ';

Line: 1952


      l_sql_statement_no_tax := 'SELECT /*+ leading(ap_dist) index(ap_dist AP_INVOICE_DISTRIBUTIONS_N4) */ ' ||
        ' DISTINCT zx_det.application_id,
        zx_det.event_class_code,          -- zx_line.event_class_code ,
        zx_det.internal_organization_id,
        zx_det.doc_event_status,
        zx_det.application_doc_status,
        zx_det.line_class,
        zx_det.doc_seq_id ,
        zx_det.doc_seq_name ,
        zx_det.doc_seq_value,
        zx_det.establishment_id,
        zx_det.batch_source_id,
        zx_det.currency_conversion_date,
        zx_det.currency_conversion_rate,
        zx_det.currency_conversion_type,
        zx_det.minimum_accountable_unit,
        zx_det.precision,
        zx_det.trx_communicated_date ,
        zx_det.trx_currency_code,
        zx_det.trx_id,                    -- zx_line.trx_id,
        zx_det.trx_number,
        zx_det.trx_date,
        zx_det.trx_description,
        zx_det.trx_type_description,
        zx_rate.description,
        zx_det.trx_due_date,
        zx_det.trx_line_description,
        zx_det.trx_line_id,               -- zx_line.trx_line_id,
        ap_dist.invoice_line_number,      -- zx_line.trx_line_number,
        to_char(NULL),                    -- zx_line.trx_line_quantity,
        ap_dist.amount,                   -- zx_line.line_amt,
        zx_det.trx_line_type,
        zx_det.trx_shipping_date,
        zx_det.uom_code,
        zx_det.related_doc_date,
        zx_det.related_doc_entity_code,
        zx_det.related_doc_event_class_code,
        zx_det.related_doc_number,
        zx_det.related_doc_trx_id,
        zx_det.applied_from_application_id,
        zx_det.applied_from_entity_code,
        zx_det.applied_from_event_class_code,
        zx_det.applied_from_line_id,
        zx_det.applied_from_trx_id,       -- zx_line.applied_from_trx_id,
        zx_det.applied_from_trx_number,   -- zx_line.applied_from_trx_number,
        zx_det.applied_to_application_id,
        zx_det.applied_to_entity_code,    -- zx_line.applied_to_entity_code,
        zx_det.applied_to_event_class_code,
        zx_det.applied_to_trx_id,
        zx_det.applied_to_trx_line_id,
        zx_det.applied_to_trx_number,
        zx_det.adjusted_doc_application_id,
        zx_det.adjusted_doc_date,
        zx_det.adjusted_doc_entity_code,
        zx_det.adjusted_doc_event_class_code,
        zx_det.adjusted_doc_number,
        zx_det.default_taxation_country,
        zx_det.merchant_party_document_number,
        zx_det.merchant_party_name,
        zx_det.merchant_party_reference,
        zx_det.merchant_party_tax_reg_number,
        zx_det.merchant_party_taxpayer_id,
        zx_det.ref_doc_application_id,
        zx_det.ref_doc_entity_code,
        zx_det.ref_doc_event_class_code,
        zx_det.ref_doc_line_id,
        zx_det.ref_doc_line_quantity,
        zx_det.ref_doc_trx_id,
        zx_det.start_expense_date,
        zx_det.assessable_value,
        zx_det.document_sub_type,
        zx_det.line_intended_use,
        zx_det.product_category,
        zx_det.product_description,
        zx_det.product_fisc_classification,
        zx_det.product_id,
        zx_det.supplier_exchange_rate,
        zx_det.supplier_tax_invoice_date,
        zx_det.supplier_tax_invoice_number,
        zx_det.tax_invoice_date,
        zx_det.tax_invoice_number,
        zx_det.trx_business_category,
        zx_det.user_defined_fisc_class,
        to_number(null), -- zx_dist.rec_nrec_tax_amt_tax_curr,
        to_char(null), -- zx_line.OFFSET_TAX_RATE_CODE,
        to_number(null), -- zx_dist.orig_rec_nrec_tax_amt,
        to_number(null),-- zx_line.orig_tax_amt,
        to_number(null), -- zx_line.orig_tax_amt_tax_curr ,
        to_number(null), -- zx_line.orig_taxable_amt,
        to_number(null), -- zx_line.orig_taxable_amt_tax_curr,
        to_number(null), -- zx_dist.orig_rec_nrec_tax_amt_tax_curr,
        to_char(null), -- zx_dist.recovery_rate_code,
        to_char(null), -- zx_dist.recovery_type_code,
        to_char(null),-- zx_line.tax,
        to_number(null),-- zx_dist.rec_nrec_tax_amt,
        to_number(null),-- zx_dist.rec_nrec_tax_amt_funcl_curr,
        to_number(null),-- zx_line.tax_amt_tax_curr,
        to_number(null), -- zx_line.tax_apportionment_line_number,
        to_char(null), -- zx_line.tax_currency_code,
        to_char(null), --zx_line.tax_date,
        to_char(null), -- zx_line.tax_determine_date,
        to_char(null),-- zx_line.tax_jurisdiction_code,
        to_number(null),-- zx_line.tax_line_id,
        to_number(null),-- zx_line.tax_line_number ,
        TO_CHAR(NULL),  --ZX_LINE.TAX_LINE_USER_ATTRIBUTE1 ,
        TO_CHAR(NULL),  --ZX_LINE.TAX_LINE_USER_ATTRIBUTE10,
        TO_CHAR(NULL),  --ZX_LINE.TAX_LINE_USER_ATTRIBUTE11,
        TO_CHAR(NULL),  --ZX_LINE.TAX_LINE_USER_ATTRIBUTE12,
        TO_CHAR(NULL),  --ZX_LINE.TAX_LINE_USER_ATTRIBUTE13,
        TO_CHAR(NULL),  --ZX_LINE.TAX_LINE_USER_ATTRIBUTE14,
        TO_CHAR(NULL),  --ZX_LINE.TAX_LINE_USER_ATTRIBUTE15,
        TO_CHAR(NULL),  --ZX_LINE.TAX_LINE_USER_ATTRIBUTE2,
        TO_CHAR(NULL),  --ZX_LINE.TAX_LINE_USER_ATTRIBUTE3,
        TO_CHAR(NULL),  --ZX_LINE.TAX_LINE_USER_ATTRIBUTE4,
        TO_CHAR(NULL),  --ZX_LINE.TAX_LINE_USER_ATTRIBUTE5,
        TO_CHAR(NULL),  --ZX_LINE.TAX_LINE_USER_ATTRIBUTE6,
        TO_CHAR(NULL),  --ZX_LINE.TAX_LINE_USER_ATTRIBUTE7,
        TO_CHAR(NULL),  --ZX_LINE.TAX_LINE_USER_ATTRIBUTE8,
        TO_CHAR(NULL),  --ZX_LINE.TAX_LINE_USER_ATTRIBUTE9,
        TO_CHAR(NULL),  --ZX_LINE.TAX_LINE_USER_CATEGORY,
        zx_rate.percentage_rate,
        zx_rate.tax_rate_code,
        ap_dist.tax_code_id, -- zx_line.tax_rate_id,
        to_number(null), --zx_dist.rec_nrec_rate,
        to_char(null), --zx_line.tax_regime_code,
        to_number(null), -- zx_line.tax_status_id,
        to_char(null), -- zx_line.tax_status_code,
        ap_dist.amount, -- zx_dist.taxable_amt,
        nvl(ap_dist.base_amount,ap_dist.amount), --zx_dist.taxable_amt_funcl_curr,
        zx_det.bill_from_party_tax_prof_id,
        zx_det.bill_from_site_tax_prof_id,
        zx_det.ship_to_site_tax_prof_id,
        zx_det.ship_from_site_tax_prof_id,
        zx_det.ship_to_party_tax_prof_id  ,
        zx_det.ship_from_party_tax_prof_id ,
        zx_det.ship_third_pty_acct_site_id,
        zx_det.bill_third_pty_acct_site_id,
        zx_det.ship_to_cust_acct_site_use_id,
        zx_det.bill_to_cust_acct_site_use_id,
        zx_det.ship_third_pty_acct_id,
        zx_det.bill_third_pty_acct_id,
        to_number(null), --zx_line.hq_estb_reg_number,
        to_number(null), --zx_line.tax_registration_number,
        to_number(null), --zx_line.legal_entity_tax_reg_number,
        zx_det.own_hq_site_tax_prof_id,
        zx_det.own_hq_party_tax_prof_id,
        zx_det.port_of_entry_code,
        to_char(null), --zx_line.registration_party_type,
        to_char(null), -- DECODE(zx_dist.REVERSED_TAX_DIST_ID,NULL,''N'',''Y''),
        zx_det.historical_flag, --zx_line.historical_flag,
        to_char(null), --zx_line.mrc_tax_line_flag,
        to_char(null), --zx_line.offset_flag,
        to_char(null), --zx_line.reporting_only_flag,
        to_char(null),--zx_dist.self_assessed_flag,
        to_char(null),--zx_line.tax_amt_included_flag,
        to_char(null),--zx_line.tax_only_line_flag,
        to_char(null),--zx_dist.recoverable_flag,
        nvl(ap_dist.posted_flag,''N''), -- zx_dist.posting_flag,
        nvl(ap_dist.reversal_flag,''N''), -- zx_dist.reverse_flag,
        ap_dist.detail_tax_dist_id, -- zx_dist.rec_nrec_tax_dist_id,
        ap_dist.invoice_distribution_id, -- zx_dist.trx_line_dist_id,
        zx_det.entity_code,
        zx_det.ledger_id,
        ZX_RATE.VAT_TRANSACTION_TYPE_CODE,
        to_char(null), --zx_tax.tax_type_code,
        ZX_RATE.TAX_RATE_NAME,
        zx_det.trx_level_type,
        zx_det.unit_price ,
        nvl(ap_dist.accounting_date,zx_det.trx_line_gl_date),
        to_char(NULL) -- Bug10238948
       FROM zx_lines_det_factors zx_det,
            ap_invoice_distributions_all ap_dist,
            zx_rates_vl    zx_rate
      WHERE zx_det.application_id  = 200
        AND zx_det.entity_code = ''AP_INVOICES''
        AND zx_det.event_class_code in (''STANDARD INVOICES'',
                                        ''EXPENSE REPORTS'',
                                        ''PREPAYMENT INVOICES'')
        AND zx_det.internal_organization_id = ap_dist.org_id
        AND zx_det.trx_id = ap_dist.invoice_id
        AND ap_dist.invoice_line_number = zx_det.trx_line_id
        AND ap_dist.line_type_lookup_code in (''PREPAY'', ''ITEM'')
        AND zx_det.tax_reporting_flag = ''Y''
        AND nvl(ap_dist.posted_flag,''N'') = ''Y''
        AND nvl(zx_rate.source_id,zx_rate.tax_rate_id)= ap_dist.tax_code_id
        AND (zx_rate.tax_class = ''INPUT'' OR zx_rate.tax_class IS NULL)
        AND NOT EXISTS
            (SELECT 1
               FROM ZX_REC_NREC_DIST tax
              WHERE tax.trx_id = zx_det.trx_id
               AND tax.application_id = 200
               AND tax.internal_organization_id = zx_det.internal_organization_id
               AND tax.application_id    = zx_det.application_id
               AND tax.entity_code = zx_det.entity_code
               AND tax.event_class_code = zx_det.event_class_code
               AND tax.trx_line_id = zx_det.trx_line_id
               AND tax.trx_line_dist_id = ap_dist.invoice_distribution_id
               AND tax.trx_level_type  = zx_det.trx_level_type) '
        || ' AND '''||G_SUMMARY_LEVEL||''' = '''||G_SUMMARY_LEVEL||''' '
        ||L_WHERE_ZXXTATAT_SPECIFIC||' '
        ||L_WHERE_GL_TRX_DATE_NO_TAX||' '
        ||L_WHERE_TRX_DATE_NO_TAX|| ' '
        ||L_WHERE_REGISTER_TYPE|| ' '
        ||L_WHERE_GL_DATE_NO_TAX|| ' '
        ||L_WHERE_TRX_NUM|| ' '
        ||L_WHERE_VAT_TRANSACTION_TYPE|| ' '
        ||L_WHERE_TRX_BUSINESS_CATEGORY|| ' '
        ||L_WHERE_TAX_INVOICE_DATE|| ' '
        ||L_WHERE_TAX_JURIS_CODE_NO_TAX|| ' '
        ||L_WHERE_FIRST_PTY_NUM_NO_TAX|| ' '
        ||L_WHERE_TAX_REGIME_CODE_NO_TAX|| ' '
        ||L_WHERE_TAX_NO_TAX|| ' '
        ||L_WHERE_TAX_STATUS_CODE_NO_TAX|| ' '
        ||L_WHERE_TAX_RATE_CODE_NO_TAX|| ' '
        ||L_WHERE_TAX_TYPE_CODE_NO_TAX|| ' '
        ||L_WHERE_CURRENCY_CODE|| ' '
        ||L_WHERE_PARTY_NAME|| ' '
        ||L_WHERE_TRX_CLASS|| ' '
        ||L_WHERE_LEGAL_ENTITY_ID_NO_TAX|| ' '
        ||L_WHERE_LEDGER_ID_NO_TAX|| ' '
        ||L_WHERE_REPORT_CONTEXT||' '
       -- ||L_WHERE_ACCOUNTING_STATUS||' '
       -- ||L_WHERE_REPORTED_STATUS||' '
        ||L_WHERE_ADJUSTED_DOC_NO_TAX||' ';

Line: 2191


      l_sql_statement := 'SELECT /*+ cardinality(ZX_DIST 100) use_nl(zx_line) use_nl(zx_tax.b) */ ';

Line: 2193


      l_sql_statement := 'SELECT ';

Line: 2628


 |    Called from INSERT_TAX_DATA                                            |
 |                                                                           |
 | SCOPE - Private                                                           |
 |                                                                           |
 | NOTES                                                                     |
 |                                                                           |
 | MODIFICATION HISTORY                                                      |
 |       11-Jan-2005    Srinivasa Rao Korrapati     Created                  |
 +===========================================================================*/

PROCEDURE execute_sql_stmt IS

   l_sql1          VARCHAR2(3500);

Line: 2881


    g_last_updated_by   := fnd_global.user_id;

Line: 2882


    g_last_update_login := fnd_global.login_id;

Line: 2883


    g_last_update_date  := sysdate;

Line: 3079


          IF (i >= c_lines_per_insert) THEN
             insert_tax_info;

Line: 3085


                                      'After insert_tax_info Call :' );

Line: 3095


                                      'Before INSERT_TAX_INFO 2 Call :' );

Line: 3101


          insert_tax_info;

Line: 3106


                                      'After INSERT_TAX_INFO 2 :' );

Line: 3160


        gt_extract_rep_line_num.delete;

Line: 3161


        gt_application_id.delete;

Line: 3162


        gt_event_class_code.delete;

Line: 3163


        gt_internal_organization_id.delete;

Line: 3164


        gt_doc_event_status.delete;

Line: 3165


        gt_application_doc_status.delete;

Line: 3166


        gt_line_class.delete;

Line: 3167


        gt_doc_seq_id.delete;

Line: 3168


        gt_doc_seq_name.delete;

Line: 3169


        gt_doc_seq_value.delete;

Line: 3170


        gt_establishment_id.delete;

Line: 3171


        gt_batch_source_id.delete;

Line: 3172


        gt_currency_conversion_date.delete;

Line: 3173


        gt_currency_conversion_rate.delete;

Line: 3174


        gt_currency_conversion_type.delete;

Line: 3175


        gt_minimum_accountable_unit.delete;

Line: 3176


        gt_precision.delete;

Line: 3177


        gt_trx_communicated_date.delete;

Line: 3178


        gt_trx_currency_code.delete;

Line: 3179


        gt_trx_id.delete;

Line: 3180


        gt_trx_number.delete;

Line: 3181


        gt_trx_date.delete;

Line: 3182


        gt_trx_description.delete;

Line: 3183


        gt_trx_type_description.delete;

Line: 3184


        gt_trx_due_date.delete;

Line: 3185


        gt_trx_line_description.delete;

Line: 3186


        gt_trx_line_id.delete;

Line: 3187


        gt_trx_line_number.delete;

Line: 3188


        gt_trx_line_quantity.delete;

Line: 3189


        gt_trx_line_amt.delete;

Line: 3190


        gt_trx_line_type.delete;

Line: 3191


        gt_trx_shipping_date.delete;

Line: 3192


        gt_uom_code.delete;

Line: 3193


        gt_related_doc_date.delete;

Line: 3194


        gt_related_doc_entity_code.delete;

Line: 3195


        gt_related_doc_event_cls_code.delete;

Line: 3196


        gt_related_doc_number.delete;

Line: 3197


        gt_related_doc_trx_id.delete;

Line: 3198


        gt_applied_from_appl_id.delete;

Line: 3199


        gt_applied_from_entity_code.delete;

Line: 3200


        gt_applied_from_event_cls_code.delete;

Line: 3201


        gt_applied_from_line_id.delete;

Line: 3202


        gt_applied_from_trx_id.delete;

Line: 3203


        gt_applied_from_trx_number.delete;

Line: 3204


        gt_applied_to_appl_id.delete;

Line: 3205


        gt_applied_to_entity_code.delete;

Line: 3206


        gt_applied_to_event_cls_code.delete;

Line: 3207


        gt_applied_to_trx_id.delete;

Line: 3208


        gt_applied_to_trx_line_id.delete;

Line: 3209


        gt_applied_to_trx_number.delete;

Line: 3210


        gt_adjusted_doc_appl_id.delete;

Line: 3211


        gt_adjusted_doc_date.delete;

Line: 3212


        gt_adjusted_doc_entity_code.delete;

Line: 3213


        gt_adjusted_doc_event_cls_code.delete;

Line: 3214


        GT_ADJUSTED_DOC_NUMBER.delete;

Line: 3216


        gt_default_taxation_country.delete;

Line: 3217


        gt_merchant_party_doc_num.delete;

Line: 3218


        gt_merchant_party_name.delete;

Line: 3219


        gt_merchant_party_reference.delete;

Line: 3220


        gt_merchant_party_tax_reg_num.delete;

Line: 3221


        gt_merchant_party_taxpayer_id.delete;

Line: 3222


        gt_ref_doc_application_id.delete;

Line: 3223


        gt_ref_doc_entity_code.delete;

Line: 3224


        gt_ref_doc_event_cls_code.delete;

Line: 3225


        gt_ref_doc_line_id.delete;

Line: 3226


        gt_ref_doc_line_quantity.delete;

Line: 3227


        gt_ref_doc_trx_id.delete;

Line: 3228


        gt_start_expense_date.delete;

Line: 3229


        gt_assessable_value.delete;

Line: 3230


        gt_document_sub_type.delete;

Line: 3231


        gt_line_intended_use.delete;

Line: 3232


        gt_product_category.delete;

Line: 3233


        gt_product_description.delete;

Line: 3234


        gt_prod_fisc_classification.delete;

Line: 3235


        gt_product_id.delete;

Line: 3236


        gt_supplier_exchange_rate.delete;

Line: 3237


        gt_supplier_tax_invoice_date.delete;

Line: 3238


        gt_supplier_tax_invoice_num.delete;

Line: 3239


        gt_tax_invoice_date.delete;

Line: 3240


        gt_tax_invoice_number.delete;

Line: 3241


        gt_trx_business_category.delete;

Line: 3242


        gt_user_defined_fisc_class.delete;

Line: 3243


        gt_nrec_tax_amt_tax_curr.delete;

Line: 3244


        gt_offset_tax_rate_code.delete;

Line: 3245


        gt_orig_rec_nrec_tax_amt.delete;

Line: 3246


        gt_orig_tax_amt.delete;

Line: 3247


        gt_orig_tax_amt_tax_curr.delete;

Line: 3248


        gt_orig_taxable_amt.delete;

Line: 3249


        gt_orig_taxable_amt_tax_curr.delete;

Line: 3250


        gt_rec_tax_amt_tax_curr.delete;

Line: 3251


        gt_recovery_rate_code.delete;

Line: 3252


        gt_recovery_type_code.delete;

Line: 3253


        gt_tax.delete;

Line: 3254


        gt_tax_amt.delete;

Line: 3255


        gt_tax_amt_funcl_curr.delete;

Line: 3256


        gt_tax_amt_tax_curr.delete;

Line: 3257


        gt_tax_apportionment_line_num.delete;

Line: 3258


        gt_tax_currency_code.delete;

Line: 3259


        gt_tax_date.delete;

Line: 3260


        gt_tax_determine_date.delete;

Line: 3261


        gt_tax_jurisdiction_code.delete;

Line: 3262


        gt_tax_line_id.delete;

Line: 3263


        gt_tax_line_number.delete;

Line: 3264


        gt_tax_line_user_attribute1.delete;

Line: 3265


        gt_tax_line_user_attribute2.delete;

Line: 3266


        gt_tax_line_user_attribute3.delete;

Line: 3267


        gt_tax_line_user_attribute4.delete;

Line: 3268


        gt_tax_line_user_attribute5.delete;

Line: 3269


        gt_tax_line_user_attribute6.delete;

Line: 3270


        gt_tax_line_user_attribute7.delete;

Line: 3271


        gt_tax_line_user_attribute8.delete;

Line: 3272


        gt_tax_line_user_attribute9.delete;

Line: 3273


        gt_tax_line_user_attribute10.delete;

Line: 3274


        gt_tax_line_user_attribute11.delete;

Line: 3275


        gt_tax_line_user_attribute12.delete;

Line: 3276


        gt_tax_line_user_attribute13.delete;

Line: 3277


        gt_tax_line_user_attribute14.delete;

Line: 3278


        gt_tax_line_user_attribute15.delete;

Line: 3279


        gt_tax_line_user_category.delete;

Line: 3280


        gt_tax_rate.delete;

Line: 3281


        gt_tax_rate_code.delete;

Line: 3282


        gt_tax_rate_id.delete;

Line: 3283


        gt_tax_recovery_rate.delete;

Line: 3284


        gt_tax_regime_code.delete;

Line: 3285


        gt_tax_status_id.delete;

Line: 3286


        gt_tax_status_code.delete;

Line: 3287


        gt_taxable_amt.delete;

Line: 3288


        gt_taxable_amt_funcl_curr.delete;

Line: 3291


        gt_bill_from_pty_tax_prof_id.delete;

Line: 3292


        gt_bill_from_site_tax_prof_id.delete;

Line: 3294


        gt_ship_to_site_tax_prof_id.delete;

Line: 3295


        gt_ship_from_site_tax_prof_id.delete;

Line: 3296


        gt_ship_to_pty_tax_prof_id.delete;

Line: 3297


        gt_ship_from_pty_tax_prof_id.delete;

Line: 3298


    GT_SHIPPING_TP_ADDRESS_ID.delete;

Line: 3299


    GT_BILLING_TP_ADDRESS_ID.delete;

Line: 3300


    GT_SHIPPING_TP_SITE_ID.delete;

Line: 3301


    GT_BILLING_TP_SITE_ID.delete;

Line: 3302


    GT_SHIPPING_TP_ID.delete;

Line: 3303


    GT_BILLING_TRADING_PARTNER_ID.delete;

Line: 3304


        gt_hq_estb_reg_number.delete;

Line: 3305


        gt_tax_line_registration_num.delete;

Line: 3306


        gt_legal_entity_tax_reg_num.delete;

Line: 3307


        gt_own_hq_pty_site_prof_id.delete;

Line: 3308


        gt_own_hq_pty_tax_prof_id.delete;

Line: 3309


        gt_port_of_entry_code.delete;

Line: 3310


        gt_registration_party_type.delete;

Line: 3311


        gt_cancel_flag.delete;

Line: 3312


        gt_historical_flag.delete;

Line: 3313


        gt_mrc_tax_line_flag.delete;

Line: 3314


        gt_offset_flag.delete;

Line: 3315


        gt_reporting_only_flag.delete;

Line: 3316


        gt_self_assessed_flag.delete;

Line: 3317


        gt_tax_amt_included_flag.delete;

Line: 3318


        gt_tax_only_flag.delete;

Line: 3319


        gt_tax_recoverable_flag.delete;

Line: 3320


        gt_posted_flag.delete;

Line: 3321


        gt_reverse_flag.delete;

Line: 3322


        gt_actg_source_id.delete;

Line: 3323


        gt_entity_code.delete;

Line: 3324


        gt_ledger_id.delete;

Line: 3325


        GT_TAXABLE_ITEM_SOURCE_ID.DELETE;

Line: 3326


        GT_TAX_RATE_VAT_TRX_TYPE_CODE.DELETE;

Line: 3327


        GT_TAX_TYPE_CODE.DELETE;

Line: 3328


        GT_TAX_RATE_CODE_NAME.DELETE;

Line: 3329


        gt_tax_rate_code_description.delete;

Line: 3330


        gt_def_rec_settlement_opt_cd.delete;  -- Bug10238948

Line: 3341


 |   insert_tax_info                                                         |
 | DESCRIPTION                                                               |
 |    This procedure inserts payables tax data into ZX_REP_TRX_DETAIL_T table|
 |                                                                           |
 | SCOPE - Private                                                           |
 |                                                                           |
 | NOTES                                                                     |
 |                                                                           |
 | MODIFICATION HISTORY                                                      |
 |       11-Jan-2005    Srinivasa Rao Korrapati      Created                 |
 |                                                                           |
 +===========================================================================*/
PROCEDURE insert_tax_info
IS
    l_count     NUMBER;

Line: 3360


        FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.insert_tax_info.BEGIN',
                                      'ZX_AP_EXTRACT_PKG: insert_tax_info(+)');

Line: 3368


        FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.insert_tax_info',
                                      ' Record Count = ' ||to_char(GT_TRX_ID.COUNT));

Line: 3373


    INSERT INTO ZX_REP_TRX_DETAIL_T(
        DETAIL_TAX_LINE_ID,
        APPLICATION_ID,
        EXTRACT_REPORT_LINE_NUMBER,
        EVENT_CLASS_CODE,
        INTERNAL_ORGANIZATION_ID,
        DOC_EVENT_STATUS,
        APPLICATION_DOC_STATUS,
        TRX_LINE_CLASS,
        DOC_SEQ_ID,
        DOC_SEQ_NAME,
        DOC_SEQ_VALUE,
        ESTABLISHMENT_ID,
        TRX_BATCH_SOURCE_ID,
        CURRENCY_CONVERSION_DATE,
        CURRENCY_CONVERSION_RATE,
        CURRENCY_CONVERSION_TYPE,
        MINIMUM_ACCOUNTABLE_UNIT,
        PRECISION,
        TRX_COMMUNICATED_DATE ,
        TRX_CURRENCY_CODE,
        TRX_ID,
        TRX_NUMBER,
        TRX_DATE,
        TRX_DESCRIPTION,
        TRX_TYPE_DESCRIPTION,
        TRX_TYPE_MNG,
  TAX_RATE_CODE_DESCRIPTION,
        TRX_DUE_DATE,
        TRX_LINE_DESCRIPTION,
        TRX_LINE_ID,
        TRX_LINE_NUMBER,
        TRX_LINE_QUANTITY,
        TRX_LINE_AMT,
        TRX_LINE_TYPE,
        TRX_SHIPPING_DATE,
        UOM_CODE,
        RELATED_DOC_DATE,
        RELATED_DOC_ENTITY_CODE,
        RELATED_DOC_EVENT_CLASS_CODE,
        RELATED_DOC_NUMBER,
        RELATED_DOC_TRX_ID,
        APPLIED_FROM_APPLICATION_ID,
        APPLIED_FROM_ENTITY_CODE,
        APPLIED_FROM_EVENT_CLASS_CODE,
        APPLIED_FROM_LINE_ID,
        APPLIED_FROM_TRX_ID,
        APPLIED_FROM_TRX_NUMBER,
        APPLIED_TO_APPLICATION_ID,
        APPLIED_TO_ENTITY_CODE,
        APPLIED_TO_EVENT_CLASS_CODE,
        APPLIED_TO_TRX_ID,
        APPLIED_TO_TRX_LINE_ID,
        APPLIED_TO_TRX_NUMBER       ,
        ADJUSTED_DOC_APPLICATION_ID,
        ADJUSTED_DOC_DATE,
        ADJUSTED_DOC_ENTITY_CODE,    --ok
        ADJUSTED_DOC_EVENT_CLASS_CODE,
        ADJUSTED_DOC_NUMBER ,
       -- COUNTRY_OF_SUPPLY,
        DEFAULT_TAXATION_COUNTRY,
        MERCHANT_PARTY_DOCUMENT_NUMBER,
        MERCHANT_PARTY_NAME,
        MERCHANT_PARTY_REFERENCE,
        MERCHANT_PARTY_TAX_REG_NUMBER,
        MERCHANT_PARTY_TAXPAYER_ID,
        REF_DOC_APPLICATION_ID,
        REF_DOC_ENTITY_CODE,
        REF_DOC_EVENT_CLASS_CODE,
        REF_DOC_LINE_ID,
        REF_DOC_LINE_QUANTITY,
        REF_DOC_TRX_ID,     --ok
        START_EXPENSE_DATE,
        ASSESSABLE_VALUE,
        DOCUMENT_SUB_TYPE,
        LINE_INTENDED_USE,
        PRODUCT_CATEGORY,
        PRODUCT_DESCRIPTION,
        PRODUCT_FISC_CLASSIFICATION,
        PRODUCT_ID,
        SUPPLIER_EXCHANGE_RATE,
        SUPPLIER_TAX_INVOICE_DATE,
        SUPPLIER_TAX_INVOICE_NUMBER,
        TAX_INVOICE_DATE,
        TAX_INVOICE_NUMBER,
        TRX_BUSINESS_CATEGORY,
        USER_DEFINED_FISC_CLASS,
        NREC_TAX_AMT_TAX_CURR,
        OFFSET_TAX_RATE_CODE,
        ORIG_REC_NREC_TAX_AMT,
        ORIG_TAX_AMT,
        ORIG_TAX_AMT_TAX_CURR ,
        ORIG_TAXABLE_AMT,
        ORIG_TAXABLE_AMT_TAX_CURR,
        REC_TAX_AMT_TAX_CURR,
        RECOVERY_RATE_CODE,
        RECOVERY_TYPE_CODE,   --ok
        TAX,
        TAX_AMT,
        TAX_AMT_FUNCL_CURR,
        TAX_AMT_TAX_CURR ,
        TAX_APPORTIONMENT_LINE_NUMBER,
        TAX_CURRENCY_CODE,
        TAX_DATE,
        TAX_DETERMINE_DATE,
        TAX_JURISDICTION_CODE,
        TAX_LINE_ID,
        TAX_LINE_NUMBER,
        TAX_LINE_USER_ATTRIBUTE1,
        TAX_LINE_USER_ATTRIBUTE2,
        TAX_LINE_USER_ATTRIBUTE3,
        TAX_LINE_USER_ATTRIBUTE4,
        TAX_LINE_USER_ATTRIBUTE5,
        TAX_LINE_USER_ATTRIBUTE6,
        TAX_LINE_USER_ATTRIBUTE7,
        TAX_LINE_USER_ATTRIBUTE8 ,
        TAX_LINE_USER_ATTRIBUTE9 ,
        TAX_LINE_USER_ATTRIBUTE10 ,
        TAX_LINE_USER_ATTRIBUTE11 ,
        TAX_LINE_USER_ATTRIBUTE12 ,
        TAX_LINE_USER_ATTRIBUTE13 ,
        TAX_LINE_USER_ATTRIBUTE14 ,
        TAX_LINE_USER_ATTRIBUTE15 ,
        TAX_LINE_USER_CATEGORY   ,     --ok
        TAX_RATE,
        TAX_RATE_CODE,
        TAX_RATE_ID  ,
        TAX_RECOVERY_RATE,
        TAX_REGIME_CODE,
        TAX_STATUS_ID,
        TAX_STATUS_CODE,
        TAXABLE_AMT,
        TAXABLE_AMT_FUNCL_CURR ,
       -- BILLING_TP_NAME,
       -- BILLING_TP_NUMBER,
        BILL_FROM_PARTY_TAX_PROF_ID,
        BILL_FROM_SITE_TAX_PROF_ID,
        --BILLING_TP_TAXPAYER_ID,
        SHIP_TO_SITE_TAX_PROF_ID  ,
        SHIP_FROM_SITE_TAX_PROF_ID,
        SHIP_TO_PARTY_TAX_PROF_ID  ,
        SHIP_FROM_PARTY_TAX_PROF_ID  ,
        SHIPPING_TP_ADDRESS_ID,    --SHIP_THIRD_PTY_ACCT_SITE_ID
        BILLING_TP_ADDRESS_ID,     --bill_third_pty_acct_site_id
        SHIPPING_TP_SITE_ID,       --ship_to_cust_acct_site_use_id
        BILLING_TP_SITE_ID,        --bill_to_cust_acct_site_use_id
        SHIPPING_TRADING_PARTNER_ID, --ship_third_pty_acct_id
        BILLING_TRADING_PARTNER_ID,  -- bill_third_pty_acct_id
        HQ_ESTB_REG_NUMBER ,
        TAX_LINE_REGISTRATION_NUMBER,
        LEGAL_ENTITY_TAX_REG_NUMBER,
        OWN_HQ_PARTY_SITE_PROF_ID,
        OWN_HQ_PARTY_TAX_PROF_ID,
        PORT_OF_ENTRY_CODE,
        REGISTRATION_PARTY_TYPE,
        CANCEL_FLAG,
        HISTORICAL_FLAG,
        MRC_TAX_LINE_FLAG,
        OFFSET_FLAG,
        REPORTING_ONLY_FLAG,
        SELF_ASSESSED_FLAG,
        TAX_AMT_INCLUDED_FLAG,
        TAX_ONLY_FLAG,
        TAX_RECOVERABLE_FLAG,
        CREATED_BY ,
        CREATION_DATE ,
        LAST_UPDATED_BY,
        LAST_UPDATE_DATE,
        LAST_UPDATE_LOGIN,
        REQUEST_ID,
        EXTRACT_SOURCE_LEDGER,
        POSTED_FLAG,
        REVERSE_FLAG,
        ACTG_SOURCE_ID,
        TAXABLE_ITEM_SOURCE_ID,
  ENTITY_CODE,
        LEDGER_ID,
        TAX_RATE_VAT_TRX_TYPE_CODE,
        TAX_TYPE_CODE,
        TAX_RATE_CODE_NAME,
        trx_level_type, --Bug 5393051
        unit_price,
        gl_date,  --Bug 5523095
        def_rec_settlement_option_code )  -- Bug10238948
    VALUES(
        ZX_REP_TRX_DETAIL_T_S.NEXTVAL,
        gt_application_id(i),
        gt_extract_rep_line_num(i),
        gt_event_class_code(i),
        gt_internal_organization_id(i),
        gt_doc_event_status(i),
        gt_application_doc_status(i),
        gt_line_class(i),
        gt_doc_seq_id(i),
        gt_doc_seq_name(i),
        gt_doc_seq_value(i),
        gt_establishment_id(i),
        gt_batch_source_id(i),
        gt_currency_conversion_date(i),
        gt_currency_conversion_rate(i),
        gt_currency_conversion_type(i),
        gt_minimum_accountable_unit(i),
        gt_precision(i),
        gt_trx_communicated_date(i),
        gt_trx_currency_code(i),
        gt_trx_id(i),
        gt_trx_number(i),
        gt_trx_date(i),
        gt_trx_description(i),
        gt_trx_type_description(i),
        gt_trx_type_description(i),
  gt_tax_rate_code_description(i),
        gt_trx_due_date(i),
        gt_trx_line_description(i),
        gt_trx_line_id(i),
        gt_trx_line_number(i),
        gt_trx_line_quantity(i),
        gt_trx_line_amt(i),
        gt_trx_line_type(i),
        gt_trx_shipping_date(i),
        gt_uom_code(i),
        gt_related_doc_date(i),
        gt_related_doc_entity_code(i),
        gt_related_doc_event_cls_code(i),
        gt_related_doc_number(i),
        gt_related_doc_trx_id(i),
        gt_applied_from_appl_id(i),
        gt_applied_from_entity_code(i),
        gt_applied_from_event_cls_code(i),
        gt_applied_from_line_id(i),
        gt_applied_from_trx_id(i),
        gt_applied_from_trx_number(i),
        gt_applied_to_appl_id(i),
        gt_applied_to_entity_code(i),
        gt_applied_to_event_cls_code(i),
        gt_applied_to_trx_id(i),
        gt_applied_to_trx_line_id(i),
        gt_applied_to_trx_number(i),
        gt_adjusted_doc_appl_id(i),
        gt_adjusted_doc_date(i),
        gt_adjusted_doc_entity_code(i),
        gt_adjusted_doc_event_cls_code(i),
        GT_ADJUSTED_DOC_NUMBER(i),
      --  gt_country_of_supply(i),
        gt_default_taxation_country(i),
        gt_merchant_party_doc_num(i),
        gt_merchant_party_name(i),
        gt_merchant_party_reference(i),
        gt_merchant_party_tax_reg_num(i),
        gt_merchant_party_taxpayer_id(i),
        gt_ref_doc_application_id(i),
        gt_ref_doc_entity_code(i),
        gt_ref_doc_event_cls_code(i),
        gt_ref_doc_line_id(i),
        gt_ref_doc_line_quantity(i),
        gt_ref_doc_trx_id(i),
        gt_start_expense_date(i),
        gt_assessable_value(i),
        gt_document_sub_type(i),
        gt_line_intended_use(i),
        gt_product_category(i),
        gt_product_description(i),
        gt_prod_fisc_classification(i),
        gt_product_id(i),
        gt_supplier_exchange_rate(i),
        gt_supplier_tax_invoice_date(i),
        gt_supplier_tax_invoice_num(i),
        gt_tax_invoice_date(i),
        gt_tax_invoice_number(i),
        gt_trx_business_category(i),
        gt_user_defined_fisc_class(i),
        gt_nrec_tax_amt_tax_curr(i),
        gt_offset_tax_rate_code(i),
        gt_orig_rec_nrec_tax_amt(i),
        gt_orig_tax_amt(i),
        gt_orig_tax_amt_tax_curr(i),
        gt_orig_taxable_amt(i),
        gt_orig_taxable_amt_tax_curr(i),
        gt_rec_tax_amt_tax_curr(i),
        gt_recovery_rate_code(i),
        gt_recovery_type_code(i),
        gt_tax(i),
        gt_tax_amt(i),
        gt_tax_amt_funcl_curr(i),
        gt_tax_amt_tax_curr(i),
        gt_tax_apportionment_line_num(i),
        gt_tax_currency_code(i),
        gt_tax_date(i),
        gt_tax_determine_date(i),
        gt_tax_jurisdiction_code(i),
        gt_tax_line_id(i),
        gt_tax_line_number(i),
        gt_tax_line_user_attribute1(i),
        gt_tax_line_user_attribute2(i),
        gt_tax_line_user_attribute3(i),
        gt_tax_line_user_attribute4(i),
        gt_tax_line_user_attribute5(i),
        gt_tax_line_user_attribute6(i),
        gt_tax_line_user_attribute7(i),
        gt_tax_line_user_attribute8(i),
        gt_tax_line_user_attribute9(i),
        gt_tax_line_user_attribute10(i),
        gt_tax_line_user_attribute11(i),
        gt_tax_line_user_attribute12(i),
        gt_tax_line_user_attribute13(i),
        gt_tax_line_user_attribute14(i),
        gt_tax_line_user_attribute15(i),
        gt_tax_line_user_category(i),
        gt_tax_rate(i),
        gt_tax_rate_code(i),
        gt_tax_rate_id(i),
        gt_tax_recovery_rate(i),
        gt_tax_regime_code(i),
        gt_tax_status_id(i),
        gt_tax_status_code(i),
        gt_taxable_amt(i),
        gt_taxable_amt_funcl_curr(i),
       -- gt_billing_tp_name(i),
       -- gt_billing_tp_number(i),
        gt_bill_from_pty_tax_prof_id(i),
        gt_bill_from_site_tax_prof_id(i),
       -- gt_billing_tp_taxpayer_id(i),
        gt_ship_to_site_tax_prof_id(i) ,
        gt_ship_from_site_tax_prof_id(i),
        gt_ship_to_pty_tax_prof_id(i),
        gt_ship_from_pty_tax_prof_id(i),
        GT_SHIPPING_TP_ADDRESS_ID(i),
        GT_BILLING_TP_ADDRESS_ID(i),
        GT_SHIPPING_TP_SITE_ID(i),
        GT_BILLING_TP_SITE_ID(i),
        GT_SHIPPING_TP_ID(i),
        GT_BILLING_TRADING_PARTNER_ID(i),
        gt_hq_estb_reg_number(i),
        gt_tax_line_registration_num(i),
        gt_legal_entity_tax_reg_num(i),
        gt_own_hq_pty_site_prof_id(i),
        gt_own_hq_pty_tax_prof_id(i),
        gt_port_of_entry_code(i),
        gt_registration_party_type(i),
        gt_cancel_flag(i),
        gt_historical_flag(i),
        gt_mrc_tax_line_flag(i),
        gt_offset_flag(i),
        gt_reporting_only_flag(i),
        gt_self_assessed_flag(i),
        gt_tax_amt_included_flag(i),
        gt_tax_only_flag(i),
        gt_tax_recoverable_flag(i),
        g_created_by ,
        g_creation_date ,
        g_last_updated_by,
        g_last_update_date,
        g_last_update_login,
        g_request_id,
        'AP',
        gt_posted_flag(i),
        gt_reverse_flag(i),
        gt_actg_source_id(i),
        gt_taxable_item_source_id(i),
  gt_entity_code(i),
        gt_ledger_id(i),
        GT_TAX_RATE_VAT_TRX_TYPE_CODE(i),
        GT_TAX_TYPE_CODE(i),
        GT_TAX_RATE_CODE_NAME(i),
        gt_trx_level_type(i),  --Bug 5393051
        gt_unit_price_tbl(i),   -- Bug 5439099
        gt_gl_date(i),
        gt_def_rec_settlement_opt_cd(i) -- Bug10238948
  )
        RETURNING detail_tax_line_id bulk collect into GT_DETAIL_TAX_LINE_ID ;

Line: 3745


         FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.insert_tax_info',
                      'Number of Tax Lines successfully inserted = '||TO_CHAR(l_count));

Line: 3748


        FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.INSERT_TAX_INFO.END',
                                      'ZX_AP_EXTRACT_PKG: INIT_GT_VARIABLES(-)');

Line: 3760


                          'ZX.TRL.ZX_AP_EXTRACT_PKG.INSERT_TAX_INFO',
                           g_error_buffer);

Line: 3766


END insert_tax_info;

Line: 3931


  SELECT SUM(TRX_line_amt),
    SUM(assessable_value),
    SUM(nrec_tax_amt_tax_curr),
    SUM(orig_rec_nrec_tax_amt),
    SUM(orig_tax_amt),
    SUM(orig_tax_amt_tax_curr) ,
    SUM(orig_taxable_amt),
    SUM(orig_taxable_amt_tax_curr),
    SUM(rec_tax_amt_tax_curr),
    SUM(tax_amt),
    SUM(tax_amt_funcl_curr),
    SUM(tax_amt_tax_curr),
    SUM(taxable_amt),
    SUM(taxable_amt_funcl_curr),
    MIN(detail_tax_line_id)
  FROM ZX_REP_TRX_DETAIL_T
  WHERE request_id          = g_request_id
  AND application_id        = 200
  AND entity_code           = 'AP_INVOICES'
  AND EXTRACT_SOURCE_LEDGER = 'AP'
  GROUP BY application_id,
    event_class_code ,
    internal_organization_id,
    doc_event_status,
    application_doc_status,
    trx_line_class,
    doc_seq_id,
    doc_seq_name ,
    doc_seq_value,
    establishment_id,
    trx_batch_source_id,
    currency_conversion_date,
    currency_conversion_rate,
    currency_conversion_type,
    minimum_accountable_unit,
    PRECISION,
    trx_communicated_date,
    trx_currency_code,
    trx_id,
    trx_number,
    trx_date,
    trx_description,
    trx_type_description,
    tax_rate_code_description,
    trx_due_date,
    default_taxation_country,
    start_expense_date,
    document_sub_type,
    supplier_exchange_rate,
    supplier_tax_invoice_date,
    supplier_tax_invoice_number,
    tax_invoice_date,
    tax_invoice_number,
    trx_business_category,
    user_defined_fisc_class,
    offset_tax_rate_code,
    tax,
    tax_currency_code,
    tax_date,
    tax_determine_date,
    tax_jurisdiction_code,
    tax_rate,
    tax_rate_code,
    tax_rate_id,
    to_number(NULL),
    tax_regime_code,
    tax_status_id,
    tax_status_code,
    bill_from_party_tax_prof_id,
    bill_from_site_tax_prof_id,
    ship_to_site_tax_prof_id ,
    ship_from_site_tax_prof_id,
    ship_to_party_tax_prof_id ,
    ship_from_party_tax_prof_id ,
    shipping_tp_address_id,
    billing_tp_address_id,
    shipping_tp_site_id,
    billing_tp_site_id,
    shipping_trading_partner_id,
    billing_trading_partner_id,
    hq_estb_reg_number,
    tax_line_registration_number,
    legal_entity_tax_reg_number,
    own_hq_party_site_prof_id,
    own_hq_party_tax_prof_id,
    port_of_entry_code,
    registration_party_type,
    cancel_flag,
    historical_flag,
    mrc_tax_line_flag,
    offset_flag,
    reporting_only_flag,
    self_assessed_flag,
    tax_amt_included_flag,
    tax_only_flag,
    tax_recoverable_flag,
    posted_flag ,
    reverse_flag,
    trx_id,
    entity_code,
    ledger_id,
    tax_rate_vat_trx_type_code,
    tax_type_code,
    tax_rate_code_name,
    TRX_LEVEL_TYPE,
    gl_date;

Line: 4063


    UPDATE ZX_REP_TRX_DETAIL_T
    SET trx_line_amt            = gt_trx_line_amt(i),
      assessable_value          = gt_assessable_value(i),
      nrec_tax_amt_tax_curr     = gt_nrec_tax_amt_tax_curr(i),
      orig_rec_nrec_tax_amt     = gt_orig_rec_nrec_tax_amt(i),
      orig_tax_amt              = gt_orig_tax_amt(i),
      orig_tax_amt_tax_curr     = gt_orig_tax_amt_tax_curr(i),
      orig_taxable_amt          = gt_orig_taxable_amt(i),
      orig_taxable_amt_tax_curr = gt_orig_taxable_amt_tax_curr(i),
      rec_tax_amt_tax_curr      = gt_rec_tax_amt_tax_curr(i),
      tax_amt                   = gt_tax_amt(i),
      tax_amt_funcl_curr        = gt_tax_amt_funcl_curr(i),
      tax_amt_tax_curr          = gt_tax_amt_tax_curr(i),
      taxable_amt               = gt_taxable_amt(i),
      taxable_amt_funcl_curr    = gt_taxable_amt_funcl_curr(i),
      taxable_item_source_id    = NULL
    WHERE detail_tax_line_id    = gt_detail_tax_line_id(i);

Line: 4085


  DELETE
  FROM ZX_REP_TRX_DETAIL_T
  WHERE request_id            = g_request_id
  AND application_id          = 200
  AND entity_code             = 'AP_INVOICES'
  AND taxable_item_source_id IS NOT NULL;

Line: 4115


|    This procedure deletes unwanted records from AP tax data extract.      |
|                                                                           |
| SCOPE - Private                                                           |
|                                                                           |
| NOTES                                                                     |
|                                                                           |
| MODIFICATION HISTORY                                                      |
|   11-Jan-2005  Srinivasa Rao Korrapati      Created                       |
+===========================================================================*/


PROCEDURE FILTER_VALIDATED IS

BEGIN

    IF (g_level_procedure >= g_current_runtime_level ) THEN
       FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AP_EXTRACT_PKG.FILTER_VALIDATED.BEGIN',
                                        'ZX_AP_EXTRACT_PKG: FILTER_VALIDATED(+)');

Line: 4143


      DELETE
      FROM ZX_REP_TRX_DETAIL_T DTL
      WHERE REQUEST_ID = g_request_id
      AND DTL.EXTRACT_SOURCE_LEDGER = 'AP'
      AND EXISTS
          (SELECT /*+ no_unnest */ 1
           FROM AP_INVOICES_ALL AI
           WHERE AI.INVOICE_ID = DTL.TRX_ID
           AND DECODE(AP_INVOICES_PKG.GET_APPROVAL_STATUS(AI.INVOICE_ID,AI.INVOICE_AMOUNT,AI.PAYMENT_STATUS_FLAG,AI.INVOICE_TYPE_LOOKUP_CODE),
                      'NEVER APPROVED','Y',
                      'UNAPPROVED','Y',
                      'NEEDS REAPPROVAL', DECODE((SELECT COUNT(*)
                                                  FROM  DUAL
                                                  WHERE NOT EXISTS (SELECT 1
                                                                    FROM  AP_HOLDS AH
                                                                    WHERE AI.INVOICE_ID = AH.INVOICE_ID)
                                                  OR EXISTS (SELECT 1
                                                              FROM  AP_HOLDS AH1, AP_HOLD_CODES AHC
                                                              WHERE AH1.RELEASE_LOOKUP_CODE IS NULL
                                                              AND   AI.INVOICE_ID = AH1.INVOICE_ID
                                                              AND   AH1.HOLD_LOOKUP_CODE = AHC.HOLD_LOOKUP_CODE
                                                              AND   NVL(AHC.POSTABLE_FLAG,'N') = 'N')
                                                  ), 0,'N','Y'
                                                 ),
                      'N') = 'Y'
            )
      AND EXISTS (SELECT /*+ FIRST_ROWS(1) */ 1
                  FROM AP_INVOICE_DISTRIBUTIONS_ALL DIST
                  WHERE DIST.INVOICE_ID = DTL.TRX_ID
                  AND NVL(DIST.POSTED_FLAG,'N')='N'
                  AND ROWNUM = 1
                 );

Line: 4179


                      ' Deleted Count : Filter_Validated : '||to_char(sql%ROWCOUNT) ); --Bug 5347188