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: 18


PROCEDURE    insert_tax_info;

Line: 28


c_lines_per_insert   CONSTANT NUMBER :=  1000;

Line: 213


    g_last_updated_by                   number(15);

Line: 214


    g_last_update_date                  date;

Line: 215


    g_last_update_login                 number(15);

Line: 348


|   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: 374


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

Line: 412


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

Line: 420


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

Line: 424


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

Line: 430


END insert_tax_data;

Line: 452


L_SELECT_ACCOUNT_SEG           VARCHAR2(500);

Line: 629


          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: 641


       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: 875


			  	p_mode => 'SELECT',
			   	p_qualifier => 'GL_BALANCING');

Line: 882


			          	p_mode => 'SELECT',
			           	p_qualifier => 'GL_ACCOUNT');

Line: 915


      '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,
        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,
        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,
        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,
        sum(zx_dist.rec_nrec_tax_amt_tax_curr),
        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(zx_dist.rec_nrec_tax_amt_funcl_curr),
        sum(zx_line.tax_amt_tax_curr),
        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,
        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,
        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
	zx_det.unit_price ,     -- Bug 5439099
	zx_det.trx_line_gl_date --Bug 5523095
   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.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_det.tax_reporting_flag = ''Y''
    AND zx_line.tax_id        = zx_tax.tax_id
    AND zx_line.tax_rate_id     =  zx_rate.tax_rate_id '
    ||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_dist.rec_nrec_tax_amt_tax_curr,
        zx_line.OFFSET_TAX_RATE_CODE,
        --zx_dist.orig_rec_nrec_tax_amt,
        --zx_line.orig_tax_amt,
        --zx_line.orig_tax_amt_tax_curr,
        --zx_line.orig_taxable_amt,
        --zx_line.orig_taxable_amt_tax_curr,
        --zx_dist.orig_rec_nrec_tax_amt_tax_curr,
        zx_line.tax,
        --zx_dist.rec_nrec_tax_amt,
        --zx_dist.rec_nrec_tax_amt_funcl_curr,
        --zx_line.tax_amt_tax_curr,
        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,
        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_line.taxable_amt,
        --zx_line.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,
        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: 1292


    '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,
        zx_det.trx_line_description,
        zx_line.trx_line_id,
        zx_line.trx_line_number,
        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.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,
        zx_dist.rec_nrec_tax_amt_tax_curr,
        zx_line.OFFSET_TAX_RATE_CODE,
        zx_dist.orig_rec_nrec_tax_amt,
        zx_line.orig_tax_amt,
        zx_line.orig_tax_amt_tax_curr ,
        zx_line.orig_taxable_amt,
        zx_line.orig_taxable_amt_tax_curr,
        zx_dist.orig_rec_nrec_tax_amt_tax_curr,
        zx_dist.recovery_rate_code,
        zx_dist.recovery_type_code,
        zx_line.tax,
        zx_dist.rec_nrec_tax_amt,
        zx_dist.rec_nrec_tax_amt_funcl_curr,
        zx_line.tax_amt_tax_curr,
        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,
        zx_line.tax_line_id,
        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_line.tax_rate_code,
        zx_line.tax_rate_id,
        zx_dist.rec_nrec_rate,
        zx_line.tax_regime_code,
        zx_line.tax_status_id,
        zx_line.tax_status_code,
        zx_dist.taxable_amt,     --zx_line.taxable_amt,
        zx_dist.taxable_amt_funcl_curr, --zx_line.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,
        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,
        decode(zx_dist.REVERSED_TAX_DIST_ID,NULL,''N'',''Y''), -- 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_dist.rec_nrec_tax_dist_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,--Bug 5393051
	zx_det.unit_price ,    -- Bug 5439099
	nvl(zx_dist.gl_date,zx_det.trx_line_gl_date) --Bug 5523095
   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.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 --Bug 5443504
--    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_det.tax_reporting_flag = ''Y''
    AND zx_line.tax_id          = zx_tax.tax_id
    AND zx_line.tax_rate_id     =  zx_rate.tax_rate_id'
    ||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_ACCOUNTING_STATUS||' '
    ||L_WHERE_REPORTED_STATUS||' '
    ||L_WHERE_ADJUSTED_DOC_NUM||' ';

Line: 1521


     '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,
        zx_det.trx_line_description,
        zx_line.trx_line_id,
        zx_line.trx_line_number,
        zx_line.trx_line_quantity,
        sum(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.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,
        sum(zx_dist.rec_nrec_tax_amt_tax_curr),
        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),
        zx_dist.recovery_rate_code,
        zx_dist.recovery_type_code,
        zx_line.tax,
        sum(zx_dist.rec_nrec_tax_amt),
        sum(zx_dist.rec_nrec_tax_amt_funcl_curr),
        sum(zx_line.tax_amt_tax_curr),
        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_char(null),--zx_line.tax_line_id ,
        to_char(null),--zx_line.tax_line_number ,
        zx_line.attribute1 ,
        zx_line.attribute2 ,
        zx_line.attribute3 ,
        zx_line.attribute4 ,
        zx_line.attribute5 ,
        zx_line.attribute6 ,
        zx_line.attribute7 ,
        zx_line.attribute8 ,
        zx_line.attribute9 ,
        zx_line.attribute10,
        zx_line.attribute11,
        zx_line.attribute12,
        zx_line.attribute13,
        zx_line.attribute14,
        zx_line.attribute15,
        zx_line.attribute_category ,
        zx_rate.percentage_rate,
        zx_line.tax_rate_code,
        zx_line.tax_rate_id,
        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,
        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_line.trx_line_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
	zx_det.unit_price ,     -- Bug 5439099
	zx_det.trx_line_gl_date --Bug 5523095
   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.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 --Bug 5443504
--    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.tax_rate_id     =  zx_rate.tax_rate_id
    AND zx_det.tax_reporting_flag = ''Y'' '
    ||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_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,
        zx_det.trx_line_description,
        zx_line.trx_line_id,
        zx_line.trx_line_number,
        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.default_taxation_country, --Bug 5374021
        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,
        --zx_dist.rec_nrec_tax_amt_tax_curr,
        zx_line.OFFSET_TAX_RATE_CODE,
        --zx_dist.orig_rec_nrec_tax_amt,
        --zx_line.orig_tax_amt,
        --zx_line.orig_tax_amt_tax_curr ,
        --zx_line.orig_taxable_amt,
        --zx_line.orig_taxable_amt_tax_curr,
        --zx_dist.orig_rec_nrec_tax_amt_tax_curr,
        zx_dist.recovery_rate_code,
        zx_dist.recovery_type_code,
        zx_line.tax,
        --zx_dist.rec_nrec_tax_amt,
        --zx_dist.rec_nrec_tax_amt_funcl_curr,
        --zx_line.tax_amt_tax_curr,
        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_char(null),--zx_line.tax_line_id ,
        to_char(null),--zx_line.tax_line_number ,
        zx_line.attribute1 ,
        zx_line.attribute2 ,
        zx_line.attribute3 ,
        zx_line.attribute4 ,
        zx_line.attribute5 ,
        zx_line.attribute6 ,
        zx_line.attribute7 ,
        zx_line.attribute8 ,
        zx_line.attribute9 ,
        zx_line.attribute10,
        zx_line.attribute11,
        zx_line.attribute12,
        zx_line.attribute13,
        zx_line.attribute14,
        zx_line.attribute15,
        zx_line.attribute_category ,
        zx_rate.percentage_rate,
        zx_line.tax_rate_code,
        zx_line.tax_rate_id,
        zx_dist.rec_nrec_rate,
        zx_line.tax_regime_code,
        zx_line.tax_status_id,
        zx_line.tax_status_code,
        --zx_line.taxable_amt,
        --zx_line.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,
        zx_det.ship_to_party_tax_prof_id,
        zx_det.ship_from_party_tax_prof_id,
        ZX_DET.SHIP_THIRD_PTY_ACCT_SITE_ID, --Bug 5374021
        ZX_DET.BILL_THIRD_PTY_ACCT_SITE_ID, --Bug 5374021
        ZX_DET.SHIP_TO_CUST_ACCT_SITE_USE_ID, --Bug 5374021
        ZX_DET.BILL_TO_CUST_ACCT_SITE_USE_ID, --Bug 5374021
        ZX_DET.SHIP_THIRD_PTY_ACCT_ID, --Bug 5374021
        ZX_DET.BILL_THIRD_PTY_ACCT_ID,--Bug 5374021
        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_line.trx_line_id , --Bug 5374021
	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: 1946


 |    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: 2164


    g_last_updated_by   := fnd_global.user_id;

Line: 2165


    g_last_update_login := fnd_global.login_id;

Line: 2166


    g_last_update_date  := sysdate;

Line: 2347


                                      'Before insert Call  :' ||to_char(GT_TRX_ID.count));

Line: 2361


          IF (i >= c_lines_per_insert) THEN
             insert_tax_info;

Line: 2367


                                      'After insert_tax_info Call :' );

Line: 2377


                                      'Before INSERT_TAX_INFO 2 Call :' );

Line: 2383


          insert_tax_info;

Line: 2388


                                      'After INSERT_TAX_INFO 2 :' );

Line: 2442


        gt_extract_rep_line_num.delete;

Line: 2443


        gt_application_id.delete;

Line: 2444


        gt_event_class_code.delete;

Line: 2445


        gt_internal_organization_id.delete;

Line: 2446


        gt_doc_event_status.delete;

Line: 2447


        gt_application_doc_status.delete;

Line: 2448


        gt_line_class.delete;

Line: 2449


        gt_doc_seq_id.delete;

Line: 2450


        gt_doc_seq_name.delete;

Line: 2451


        gt_doc_seq_value.delete;

Line: 2452


        gt_establishment_id.delete;

Line: 2453


        gt_batch_source_id.delete;

Line: 2454


        gt_currency_conversion_date.delete;

Line: 2455


        gt_currency_conversion_rate.delete;

Line: 2456


        gt_currency_conversion_type.delete;

Line: 2457


        gt_minimum_accountable_unit.delete;

Line: 2458


        gt_precision.delete;

Line: 2459


        gt_trx_communicated_date.delete;

Line: 2460


        gt_trx_currency_code.delete;

Line: 2461


        gt_trx_id.delete;

Line: 2462


        gt_trx_number.delete;

Line: 2463


        gt_trx_date.delete;

Line: 2464


        gt_trx_description.delete;

Line: 2465


        gt_trx_type_description.delete;

Line: 2466


        gt_trx_due_date.delete;

Line: 2467


        gt_trx_line_description.delete;

Line: 2468


        gt_trx_line_id.delete;

Line: 2469


        gt_trx_line_number.delete;

Line: 2470


        gt_trx_line_quantity.delete;

Line: 2471


        gt_trx_line_amt.delete;

Line: 2472


        gt_trx_line_type.delete;

Line: 2473


        gt_trx_shipping_date.delete;

Line: 2474


        gt_uom_code.delete;

Line: 2475


        gt_related_doc_date.delete;

Line: 2476


        gt_related_doc_entity_code.delete;

Line: 2477


        gt_related_doc_event_cls_code.delete;

Line: 2478


        gt_related_doc_number.delete;

Line: 2479


        gt_related_doc_trx_id.delete;

Line: 2480


        gt_applied_from_appl_id.delete;

Line: 2481


        gt_applied_from_entity_code.delete;

Line: 2482


        gt_applied_from_event_cls_code.delete;

Line: 2483


        gt_applied_from_line_id.delete;

Line: 2484


        gt_applied_from_trx_id.delete;

Line: 2485


        gt_applied_from_trx_number.delete;

Line: 2486


        gt_applied_to_appl_id.delete;

Line: 2487


        gt_applied_to_entity_code.delete;

Line: 2488


        gt_applied_to_event_cls_code.delete;

Line: 2489


        gt_applied_to_trx_id.delete;

Line: 2490


        gt_applied_to_trx_line_id.delete;

Line: 2491


        gt_applied_to_trx_number.delete;

Line: 2492


        gt_adjusted_doc_appl_id.delete;

Line: 2493


        gt_adjusted_doc_date.delete;

Line: 2494


        gt_adjusted_doc_entity_code.delete;

Line: 2495


        gt_adjusted_doc_event_cls_code.delete;

Line: 2496


        GT_ADJUSTED_DOC_NUMBER.delete;

Line: 2498


        gt_default_taxation_country.delete;

Line: 2499


        gt_merchant_party_doc_num.delete;

Line: 2500


        gt_merchant_party_name.delete;

Line: 2501


        gt_merchant_party_reference.delete;

Line: 2502


        gt_merchant_party_tax_reg_num.delete;

Line: 2503


        gt_merchant_party_taxpayer_id.delete;

Line: 2504


        gt_ref_doc_application_id.delete;

Line: 2505


        gt_ref_doc_entity_code.delete;

Line: 2506


        gt_ref_doc_event_cls_code.delete;

Line: 2507


        gt_ref_doc_line_id.delete;

Line: 2508


        gt_ref_doc_line_quantity.delete;

Line: 2509


        gt_ref_doc_trx_id.delete;

Line: 2510


        gt_start_expense_date.delete;

Line: 2511


        gt_assessable_value.delete;

Line: 2512


        gt_document_sub_type.delete;

Line: 2513


        gt_line_intended_use.delete;

Line: 2514


        gt_product_category.delete;

Line: 2515


        gt_product_description.delete;

Line: 2516


        gt_prod_fisc_classification.delete;

Line: 2517


        gt_product_id.delete;

Line: 2518


        gt_supplier_exchange_rate.delete;

Line: 2519


        gt_supplier_tax_invoice_date.delete;

Line: 2520


        gt_supplier_tax_invoice_num.delete;

Line: 2521


        gt_tax_invoice_date.delete;

Line: 2522


        gt_tax_invoice_number.delete;

Line: 2523


        gt_trx_business_category.delete;

Line: 2524


        gt_user_defined_fisc_class.delete;

Line: 2525


        gt_nrec_tax_amt_tax_curr.delete;

Line: 2526


        gt_offset_tax_rate_code.delete;

Line: 2527


        gt_orig_rec_nrec_tax_amt.delete;

Line: 2528


        gt_orig_tax_amt.delete;

Line: 2529


        gt_orig_tax_amt_tax_curr.delete;

Line: 2530


        gt_orig_taxable_amt.delete;

Line: 2531


        gt_orig_taxable_amt_tax_curr.delete;

Line: 2532


        gt_rec_tax_amt_tax_curr.delete;

Line: 2533


        gt_recovery_rate_code.delete;

Line: 2534


        gt_recovery_type_code.delete;

Line: 2535


        gt_tax.delete;

Line: 2536


        gt_tax_amt.delete;

Line: 2537


        gt_tax_amt_funcl_curr.delete;

Line: 2538


        gt_tax_amt_tax_curr.delete;

Line: 2539


        gt_tax_apportionment_line_num.delete;

Line: 2540


        gt_tax_currency_code.delete;

Line: 2541


        gt_tax_date.delete;

Line: 2542


        gt_tax_determine_date.delete;

Line: 2543


        gt_tax_jurisdiction_code.delete;

Line: 2544


        gt_tax_line_id.delete;

Line: 2545


        gt_tax_line_number.delete;

Line: 2546


        gt_tax_line_user_attribute1.delete;

Line: 2547


        gt_tax_line_user_attribute2.delete;

Line: 2548


        gt_tax_line_user_attribute3.delete;

Line: 2549


        gt_tax_line_user_attribute4.delete;

Line: 2550


        gt_tax_line_user_attribute5.delete;

Line: 2551


        gt_tax_line_user_attribute6.delete;

Line: 2552


        gt_tax_line_user_attribute7.delete;

Line: 2553


        gt_tax_line_user_attribute8.delete;

Line: 2554


        gt_tax_line_user_attribute9.delete;

Line: 2555


        gt_tax_line_user_attribute10.delete;

Line: 2556


        gt_tax_line_user_attribute11.delete;

Line: 2557


        gt_tax_line_user_attribute12.delete;

Line: 2558


        gt_tax_line_user_attribute13.delete;

Line: 2559


        gt_tax_line_user_attribute14.delete;

Line: 2560


        gt_tax_line_user_attribute15.delete;

Line: 2561


        gt_tax_line_user_category.delete;

Line: 2562


        gt_tax_rate.delete;

Line: 2563


        gt_tax_rate_code.delete;

Line: 2564


        gt_tax_rate_id.delete;

Line: 2565


        gt_tax_recovery_rate.delete;

Line: 2566


        gt_tax_regime_code.delete;

Line: 2567


        gt_tax_status_id.delete;

Line: 2568


        gt_tax_status_code.delete;

Line: 2569


        gt_taxable_amt.delete;

Line: 2570


        gt_taxable_amt_funcl_curr.delete;

Line: 2573


        gt_bill_from_pty_tax_prof_id.delete;

Line: 2574


        gt_bill_from_site_tax_prof_id.delete;

Line: 2576


        gt_ship_to_site_tax_prof_id.delete;

Line: 2577


        gt_ship_from_site_tax_prof_id.delete;

Line: 2578


        gt_ship_to_pty_tax_prof_id.delete;

Line: 2579


        gt_ship_from_pty_tax_prof_id.delete;

Line: 2580


    GT_SHIPPING_TP_ADDRESS_ID.delete;

Line: 2581


    GT_BILLING_TP_ADDRESS_ID.delete;

Line: 2582


    GT_SHIPPING_TP_SITE_ID.delete;

Line: 2583


    GT_BILLING_TP_SITE_ID.delete;

Line: 2584


    GT_SHIPPING_TP_ID.delete;

Line: 2585


    GT_BILLING_TRADING_PARTNER_ID.delete;

Line: 2586


        gt_hq_estb_reg_number.delete;

Line: 2587


        gt_tax_line_registration_num.delete;

Line: 2588


        gt_legal_entity_tax_reg_num.delete;

Line: 2589


        gt_own_hq_pty_site_prof_id.delete;

Line: 2590


        gt_own_hq_pty_tax_prof_id.delete;

Line: 2591


        gt_port_of_entry_code.delete;

Line: 2592


        gt_registration_party_type.delete;

Line: 2593


        gt_cancel_flag.delete;

Line: 2594


        gt_historical_flag.delete;

Line: 2595


        gt_mrc_tax_line_flag.delete;

Line: 2596


        gt_offset_flag.delete;

Line: 2597


        gt_reporting_only_flag.delete;

Line: 2598


        gt_self_assessed_flag.delete;

Line: 2599


        gt_tax_amt_included_flag.delete;

Line: 2600


        gt_tax_only_flag.delete;

Line: 2601


        gt_tax_recoverable_flag.delete;

Line: 2602


        gt_posted_flag.delete;

Line: 2603


        gt_reverse_flag.delete;

Line: 2604


        gt_actg_source_id.delete;

Line: 2605


        gt_entity_code.delete;

Line: 2606


        gt_ledger_id.delete;

Line: 2607


        GT_TAXABLE_ITEM_SOURCE_ID.DELETE;

Line: 2608


        GT_TAX_RATE_VAT_TRX_TYPE_CODE.DELETE;

Line: 2609


        GT_TAX_TYPE_CODE.DELETE;

Line: 2610


        GT_TAX_RATE_CODE_NAME.DELETE;

Line: 2611


	gt_tax_rate_code_description.delete;

Line: 2623


 |   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: 2642


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

Line: 2650


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

Line: 2655


    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
    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) --Bug 5523095
	)
        RETURNING detail_tax_line_id bulk collect into GT_DETAIL_TAX_LINE_ID ;

Line: 3025


         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: 3028


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

Line: 3040


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

Line: 3046


END insert_tax_info;

Line: 3197


|    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: 3225


      DELETE
      FROM ZX_REP_TRX_DETAIL_T DTL
      WHERE REQUEST_ID = g_request_id
      AND DTL.EXTRACT_SOURCE_LEDGER = 'AP'
      AND EXISTS
          (SELECT 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');

Line: 3256


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