APPS.ZX_AR_EXTRACT_PKG SQL Statements

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

Line: 17

PROCEDURE insert_ar_trx_info;

Line: 57

  C_LINES_PER_INSERT             CONSTANT NUMBER :=  5000;

Line: 303

  G_LAST_UPDATED_BY                NUMBER(15);

Line: 304

  G_LAST_UPDATE_DATE               DATE;

Line: 305

  G_LAST_UPDATE_LOGIN              NUMBER(15);

Line: 463

 |   insert_tax_data                                                         |
 |                                                                           |
 | DESCRIPTION                                                               |
 |    This procedure takes the input parameters from ZX_EXTRACT_PKG          |
 |    and builds  dynamic SQL statement clauses based on the parameters,     |
 |    supplies them as output parameters.                                    |
 |                                                                           |
 | SCOPE - Public                                                            |
 |                                                                           |
 | NOTES                                                                     |
 |                                                                           |
 | MODIFICATION HISTORY                                                      |
 |   04-Mar-04  Ling Zhang   Created                                         |
 |                                                                           |
 +===========================================================================*/

PROCEDURE insert_tax_data (
  P_MRC_SOB_TYPE             IN            VARCHAR2,
  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: 489

    FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.insert_tax_data.BEGIN',
                                      'ZX_AR_EXTRACT_PKG: insert_tax_data(+)');

Line: 510

    FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.insert_tax_data.END',
                                      'ZX_AR_EXTRACT_PKG: insert_tax_data(-)');

Line: 519

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

Line: 523

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

Line: 529

END insert_tax_data;

Line: 559

 |                           the fetch and insert procedures.                |
 +===========================================================================*/

PROCEDURE build_sql(
    P_MRC_SOB_TYPE                  IN VARCHAR2
) IS


  L_WHERE_REPORTING_CONTEXT_TRXH  VARCHAR2(2500);

Line: 1725

    SELECT CHART_OF_ACCOUNTS_ID
      INTO   L_CHART_OF_ACCOUNTS_ID
      FROM   GL_SETS_OF_BOOKS
      WHERE  SET_OF_BOOKS_ID = FND_PROFILE.VALUE('GL_SET_OF_BKS_ID');

Line: 1752

      'SELECT count(*) '||
      ' FROM AR_VAT_TAX_ALL_B VAT '||
      ' WHERE VAT.INTERIM_TAX_CCID IS NOT NULL  '||
      ' AND ROWNUM = :1 '
      || L_WHERE_TAX_CLASS
      || L_WHERE_TAX_CODE
      || L_WHERE_TAX_CODE_VAT_TRX_TYPE
      || L_WHERE_TAX_CODE_TYPE
      || L_WHERE_GDF_AR_TAX_CODES_ATT1
      || L_WHERE_REPORTING_CONTEXT_VAT;

Line: 1828

  'SELECT '|| get_hint_ar_inv ||
  'ZX_DET.LEDGER_ID,
   ZX_DET.TRX_ID    ,
   ZX_DET.DOC_SEQ_ID ,
   ZX_DET.DOC_SEQ_NAME ,
   ZX_DET.RECEIVABLES_TRX_TYPE_ID,
   ZX_DET.LINE_CLASS,
   ZX_DET.EVENT_CLASS_CODE ,
   TO_CHAR(NULL) ,'|| --APPLIED_FROM_ENTITY_CODE
   'TO_NUMBER(NULL)  ,'||--APPLIED_FROM_TRX_ID
   'TO_CHAR(NULL)  ,'||--APPLIED_FROM_EVENT_CLASS_CODE
   'TO_CHAR(NULL)  ,'||  -- ADJUSTED_DOC_ENTITY_CODE --APPLIED_TO_ENTITY_CODE
   'TO_NUMBER(NULL) ,'|| --ADJSUTED_DOC_ID --APPLIED_TO_TRX_ID
   'TO_CHAR(NULL)  ,'||  --ADJUSTED_DOC_EVENT_CLASS_CODE  --APPLIED_TO_EVENT_CLASS_CODE
   'ZX_DET.ADJUSTED_DOC_NUMBER  ,'|| --ADJUSTED_DOC_NUMBER  --APPLIED_TO_TRX_NUMBER
   'ZX_DET.BATCH_SOURCE_ID,
   ZX_LINE.TAX_RATE_ID ,
   DECODE(ZX_ACCOUNTS.INTERIM_TAX_CCID,NULL,''TAX'',''INTERIM''),
   TO_NUMBER(NULL) ,'|| -- ZX_DET.PRODUCT_ID
   'TO_CHAR(NULL) ,'|| -- ZX_DET.PRODUCT_DESCRIPTION
   'TO_CHAR(NULL),'||  --TAXABLE_LINE_SOURCE_TABLE
   'TO_NUMBER(NULL),'|| --TAXABLE_ITEM_SOURCE_ID
   'ZX_LINE.TAX_EXEMPTION_ID,
   ZX_LINE.TAX_EXCEPTION_ID,
   TO_NUMBER(NULL),'||     --TAXABLE_LINE_TOTAL_AMOUNT
   'TO_NUMBER(NULL),'|| --ZX_LINE.TAX_LINE_ID
   'SUM(ZX_LINE.TAX_AMT),
   sum(NVL(ZX_LINE.TAX_AMT_FUNCL_CURR,ZX_LINE.TAX_AMT))  ,
   TO_NUMBER(NULL),'|| --ZX_LINE.TAX_LINE_NUMBER
   'sum(ZX_LINE.TAXABLE_AMT),
   sum(NVL(ZX_LINE.TAXABLE_AMT_FUNCL_CURR,ZX_LINE.TAXABLE_AMT)) ,
   TO_NUMBER(NULL),'|| --ZX_LINE.TRX_LINE_ID
   'TO_NUMBER(NULL),'|| --ZX_LINE.TRX_LINE_QUANTITY
   'ZX_DET.EXEMPT_CERTIFICATE_NUMBER,
   ZX_LINE.EXEMPT_REASON_CODE   ,
   TO_CHAR(NULL), --exception_reason_code
   TO_CHAR(NULL),'|| --ZX_DET.UOM_CODE
   'TO_CHAR(NULL),'||--RECONCILIATION_FLAG
   'ZX_DET.INTERNAL_ORGANIZATION_ID ,'||--ORG_ID
   'TO_NUMBER(NULL),'||--BR_REF_CUSTOMER_TRX_ID
  -- 'TO_CHAR(NULL),  --reverse_date
   'TO_NUMBER(NULL),'||  --AMOUNT_APPLIED
   'TO_NUMBER(NULL),'||  --TAX_APPLIED
   'CASE WHEN (ZX_LINE.LAST_MANUAL_ENTRY=''TAX_RATE'' AND ZX_LINE.OVERRIDDEN_FLAG = ''Y'') OR ZX_LINE.TAX_PROVIDER_ID IS NOT NULL THEN ZX_LINE.TAX_RATE ELSE ZX_RATE.PERCENTAGE_RATE END,
   ZX_LINE.TAX_RATE_CODE,
   ZX_RATE.VAT_TRANSACTION_TYPE_CODE,
   ZX_TAX.TAX_TYPE_CODE,
   ZX_RATE.TAX_RATE_NAME,
   ZX_DET.TRX_NUMBER,
   ZX_DET.TRX_DESCRIPTION,
   ZX_DET.DOC_SEQ_VALUE,
   ZX_DET.TRX_DATE,
   TO_DATE(NULL),   --Deposit Date
   ZX_DET.TRX_DUE_DATE ,
   ZX_DET.TRX_SHIPPING_DATE ,
   ZX_DET.TRX_COMMUNICATED_DATE ,
   ZX_DET.TRX_CURRENCY_CODE,
   ZX_DET.CURRENCY_CONVERSION_TYPE,
   ZX_DET.CURRENCY_CONVERSION_DATE,
   ZX_DET.CURRENCY_CONVERSION_RATE,
   ZX_DET.TRX_SIC_CODE,
   ZX_DET.FOB_POINT,
   ZX_DET.TRX_WAYBILL_NUMBER,
   ZX_DET.BATCH_SOURCE_NAME,
   ZX_DET.TRX_TYPE_DESCRIPTION,
   ZX_RATE.DESCRIPTION,'||
   'to_char(NULL),'||  --ZX_DET.TRX_LINE_DESCRIPTION,
   'TO_NUMBER(NULL),'|| --ZX_LINE.TRX_LINE_NUMBER,
   'TO_CHAR(NULL),'|| --ZX_DET.TRX_LINE_TYPE,
   'TO_CHAR(NULL),
   TO_CHAR(NULL),
   TO_CHAR(NULL),
   TO_CHAR(NULL),
   TO_CHAR(NULL),
   TO_CHAR(NULL),
   TO_CHAR(NULL),
   TO_CHAR(NULL),
   TO_CHAR(NULL),
   TO_CHAR(NULL),
   TO_CHAR(NULL),
   TO_CHAR(NULL),
   TO_CHAR(NULL),
   TO_CHAR(NULL),
   TO_CHAR(NULL),
   TO_CHAR(NULL),
   ZX_DET.APPLICATION_ID,
   ZX_DET.DOC_EVENT_STATUS,
   ZX_DET.APPLICATION_DOC_STATUS,
   ZX_DET.ESTABLISHMENT_ID,
   ''AR'','||           --EXTRACT_SOURCE_LEDGER
   '--ZX_DET.FUNCTIONAL_CURRECNY_CODE,
   --ZX_DET.LEDGER_NAME,
   ZX_DET.MINIMUM_ACCOUNTABLE_UNIT,
   ZX_DET.PRECISION,
   TO_NUMBER(NULL),'|| --RECEIPT_CLASS_ID
   'ZX_DET.APPLIED_TO_APPLICATION_ID,
   ZX_DET.APPLIED_TO_TRX_LINE_ID,
   ZX_DET.APPLIED_TO_ENTITY_CODE,
   ZX_DET.APPLIED_TO_TRX_ID,
   ZX_DET.APPLIED_TO_EVENT_CLASS_CODE,
   ZX_DET.APPLIED_TO_TRX_NUMBER,
   ZX_DET.RELATED_DOC_APPLICATION_ID,
   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.ADJUSTED_DOC_APPLICATION_ID,
   ZX_DET.ADJUSTED_DOC_DATE,
   --ZX_DET.BANKING_TP_TAXPAYER_ID,
   ZX_DET.REF_DOC_APPLICATION_ID,
   ZX_DET.REF_DOC_ENTITY_CODE,
   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,
   'ZX_DET.REF_DOC_TRX_ID,
   ZX_RATE.DEF_REC_SETTLEMENT_OPTION_CODE,
   ZX_DET.DEFAULT_TAXATION_COUNTRY,
   ZX_DET.DOCUMENT_SUB_TYPE,
   sum(ZX_DET.ASSESSABLE_VALUE),
   ZX_DET.TRX_BUSINESS_CATEGORY,
   ZX_DET.LINE_INTENDED_USE,
   ZX_DET.PRODUCT_CATEGORY,
   ZX_DET.PRODUCT_FISC_CLASSIFICATION,
   ZX_DET.SUPPLIER_EXCHANGE_RATE,
   ZX_DET.SUPPLIER_TAX_INVOICE_DATE,
   ZX_DET.SUPPLIER_TAX_INVOICE_NUMBER,
   ZX_DET.USER_DEFINED_FISC_CLASS,
   ZX_LINE.EXCEPTION_RATE,
   ZX_LINE.EXEMPT_RATE_MODIFIER,
   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),
   TO_CHAR(NULL),'|| -- RECOVERY_RATE_CODE,
   '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_DET.TAX_INVOICE_DATE,
   ZX_DET.TAX_INVOICE_NUMBER,
   ZX_LINE.TAX_JURISDICTION_CODE,
   ZX_LINE.TAX_REGIME_CODE,
   ZX_LINE.TAX_STATUS_CODE,
   ZX_LINE.TAX_STATUS_ID,
   ZX_LINE.TAX,
   ZX_DET.SHIP_FROM_PARTY_TAX_PROF_ID  ,
   ZX_DET.SHIP_FROM_SITE_TAX_PROF_ID,
   ZX_DET.SHIP_TO_PARTY_TAX_PROF_ID  ,
   ZX_DET.SHIP_TO_SITE_TAX_PROF_ID  ,
   ZX_DET.BILL_TO_PARTY_TAX_PROF_ID,
   ZX_DET.BILL_TO_SITE_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.HISTORICAL_FLAG,
   ZX_LINE.MRC_TAX_LINE_FLAG,
   To_CHAR(NULL) POSTED_FLAG,
   ZX_LINE.REPORTING_ONLY_FLAG,
   ZX_LINE.TAX_AMT_INCLUDED_FLAG,
   ZX_LINE.TAX_ONLY_LINE_FLAG,
   ZX_DET.EVENT_CLASS_MAPPING_ID,
   ZX_DET.TRX_LEVEL_TYPE,
   ZX_LINE.PLACE_OF_SUPPLY_TYPE_CODE,
   ZX_DET.POA_LOCATION_ID,
   ZX_DET.POO_LOCATION_ID,
   ZX_TAX.DEF_PLACE_OF_SUPPLY_TYPE_CODE,
   sum(ZX_DET.LINE_AMT),
   ZX_LINE.TAX_PROVIDER_ID,
   TO_DATE(NULL),
   TO_CHAR(NULL),
   TO_NUMBER(NULL),
   TO_NUMBER(NULL),
   TO_CHAR(NULL),
   TO_CHAR(NULL),
   TO_CHAR(NULL),
   ZX_DET.TRX_ID ,
   ZX_DET.ENTITY_CODE,
   TO_DATE(NULL),
   ZX_DET.TRX_LINE_GL_DATE,
   to_number(NULL), --ZX_DET.UNIT_PRICE,
   TO_NUMBER(NULL),
   ZX_LINE.OFFSET_TAX_RATE_CODE,
   ZX_LINE.OFFSET_FLAG';

Line: 2217

  'SELECT '|| get_hint_ar_inv ||
  'ZX_DET.LEDGER_ID,
   ZX_DET.TRX_ID    ,
   ZX_DET.DOC_SEQ_ID ,
   ZX_DET.DOC_SEQ_NAME ,
   ZX_DET.RECEIVABLES_TRX_TYPE_ID,
   ZX_DET.LINE_CLASS,
   ZX_DET.EVENT_CLASS_CODE ,
   TO_CHAR(NULL) ,'|| --APPLIED_FROM_ENTITY_CODE
   'TO_NUMBER(NULL)  ,'||--APPLIED_FROM_TRX_ID
   'TO_CHAR(NULL)  ,'||--APPLIED_FROM_EVENT_CLASS_CODE
   'TO_CHAR(NULL)  ,'||  -- ADJUSTED_DOC_ENTITY_CODE --APPLIED_TO_ENTITY_CODE
   'TO_NUMBER(NULL) ,'|| --ADJSUTED_DOC_ID --APPLIED_TO_TRX_ID
   'TO_CHAR(NULL)  ,'||  --ADJUSTED_DOC_EVENT_CLASS_CODE  --APPLIED_TO_EVENT_CLASS_CODE
   'ZX_DET.ADJUSTED_DOC_NUMBER  ,'|| --ADJUSTED_DOC_NUMBER  --APPLIED_TO_TRX_NUMBER
   'ZX_DET.BATCH_SOURCE_ID,
   ZX_LINE.TAX_RATE_ID ,
   DECODE(ZX_ACCOUNTS.INTERIM_TAX_CCID,NULL,''TAX'',''INTERIM''),
   TO_NUMBER(NULL), '|| -- ZX_DET.PRODUCT_ID
   'TO_CHAR(NULL), '|| -- ZX_DET.PRODUCT_DESCRIPTION
   'TO_CHAR(NULL),'||  --TAXABLE_LINE_SOURCE_TABLE
   'TO_NUMBER(NULL),'|| --TAXABLE_ITEM_SOURCE_ID
   'ZX_LINE.TAX_EXEMPTION_ID,
   ZX_LINE.TAX_EXCEPTION_ID,
   TO_NUMBER(NULL),'||     --TAXABLE_LINE_TOTAL_AMOUNT
   'TO_NUMBER(NULL),'|| --ZX_LINE.TAX_LINE_ID
   'SUM(DIST.AMOUNT),
   sum(DIST.ACCTD_AMOUNT)  ,
   TO_NUMBER(NULL),'|| --ZX_LINE.TAX_LINE_NUMBER
   'SUM(DECODE(ZX_LINE.MANUALLY_ENTERED_FLAG,
         ''Y'',DECODE(ZX_LINE.TAX_AMT_INCLUDED_FLAG,''N'', ZX_LINE.LINE_AMT,
                                                           ZX_LINE.TAXABLE_AMT)
              ,ZX_LINE.TAXABLE_AMT)*(DIST.PERCENT)/100),
   SUM(NVL(ZX_LINE.TAXABLE_AMT_FUNCL_CURR,ZX_LINE.TAXABLE_AMT) *(DIST.PERCENT)/100) ,
   TO_NUMBER(NULL),'|| --ZX_LINE.TRX_LINE_ID
   'TO_NUMBER(NULL),'|| --ZX_LINE.TRX_LINE_QUANTITY
   'ZX_DET.EXEMPT_CERTIFICATE_NUMBER,
   ZX_LINE.EXEMPT_REASON_CODE   ,
   TO_CHAR(NULL), --exception_reason_code
   TO_CHAR(NULL),'|| --ZX_DET.UOM_CODE
   'TO_CHAR(NULL),'||--RECONCILIATION_FLAG
   'ZX_DET.INTERNAL_ORGANIZATION_ID ,'||--ORG_ID
   'TO_NUMBER(NULL),'||--BR_REF_CUSTOMER_TRX_ID
  -- 'TO_CHAR(NULL),  --reverse_date
   'TO_NUMBER(NULL),'||  --AMOUNT_APPLIED
   'TO_NUMBER(NULL),'||  --TAX_APPLIED
   'CASE WHEN (ZX_LINE.LAST_MANUAL_ENTRY=''TAX_RATE'' AND ZX_LINE.OVERRIDDEN_FLAG = ''Y'') OR ZX_LINE.TAX_PROVIDER_ID IS NOT NULL THEN ZX_LINE.TAX_RATE ELSE ZX_RATE.PERCENTAGE_RATE END,
   ZX_LINE.TAX_RATE_CODE,
   ZX_RATE.VAT_TRANSACTION_TYPE_CODE,
   ZX_TAX.TAX_TYPE_CODE,
   ZX_RATE.TAX_RATE_NAME,
   ZX_DET.TRX_NUMBER,
   ZX_DET.TRX_DESCRIPTION,
   ZX_DET.DOC_SEQ_VALUE,
   ZX_DET.TRX_DATE,
   TO_DATE(NULL),   --Deposit Date
   ZX_DET.TRX_DUE_DATE ,
   ZX_DET.TRX_SHIPPING_DATE ,
   ZX_DET.TRX_COMMUNICATED_DATE ,
   ZX_DET.TRX_CURRENCY_CODE,
   ZX_DET.CURRENCY_CONVERSION_TYPE,
   ZX_DET.CURRENCY_CONVERSION_DATE,
   ZX_DET.CURRENCY_CONVERSION_RATE,
   ZX_DET.TRX_SIC_CODE,
   ZX_DET.FOB_POINT,
   ZX_DET.TRX_WAYBILL_NUMBER,
   ZX_DET.BATCH_SOURCE_NAME,
   ZX_DET.TRX_TYPE_DESCRIPTION,
   ZX_RATE.DESCRIPTION,
   TO_CHAR(NULL),'||   --ZX_DET.TRX_LINE_DESCRIPTION,
   'TO_NUMBER(NULL),'|| --ZX_LINE.TRX_LINE_NUMBER,
   'TO_CHAR(NULL),'|| --ZX_DET.TRX_LINE_TYPE,
   'TO_CHAR(NULL),
   TO_CHAR(NULL),
   TO_CHAR(NULL),
   TO_CHAR(NULL),
   TO_CHAR(NULL),
   TO_CHAR(NULL),
   TO_CHAR(NULL),
   TO_CHAR(NULL),
   TO_CHAR(NULL),
   TO_CHAR(NULL),
   TO_CHAR(NULL),
   TO_CHAR(NULL),
   TO_CHAR(NULL),
   TO_CHAR(NULL),
   TO_CHAR(NULL),
   TO_CHAR(NULL),
   ZX_DET.APPLICATION_ID,
   ZX_DET.DOC_EVENT_STATUS,
   ZX_DET.APPLICATION_DOC_STATUS,
   ZX_DET.ESTABLISHMENT_ID,
   ''AR'','||           --EXTRACT_SOURCE_LEDGER
   '--ZX_DET.FUNCTIONAL_CURRECNY_CODE,
   --ZX_DET.LEDGER_NAME,
   ZX_DET.MINIMUM_ACCOUNTABLE_UNIT,
   ZX_DET.PRECISION,
   TO_NUMBER(NULL),'|| --RECEIPT_CLASS_ID
   'ZX_DET.APPLIED_TO_APPLICATION_ID,
   ZX_DET.APPLIED_TO_TRX_LINE_ID,
   ZX_DET.APPLIED_TO_ENTITY_CODE,
   ZX_DET.APPLIED_TO_TRX_ID,
   ZX_DET.APPLIED_TO_EVENT_CLASS_CODE,
   ZX_DET.APPLIED_TO_TRX_NUMBER,
   ZX_DET.RELATED_DOC_APPLICATION_ID,
   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.ADJUSTED_DOC_APPLICATION_ID,
   ZX_DET.ADJUSTED_DOC_DATE,
   --ZX_DET.BANKING_TP_TAXPAYER_ID,
   ZX_DET.REF_DOC_APPLICATION_ID,
   ZX_DET.REF_DOC_ENTITY_CODE,
   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,
   'ZX_DET.REF_DOC_TRX_ID,
   ZX_RATE.DEF_REC_SETTLEMENT_OPTION_CODE,
   ZX_DET.DEFAULT_TAXATION_COUNTRY,
   ZX_DET.DOCUMENT_SUB_TYPE,
   SUM(ZX_DET.ASSESSABLE_VALUE),
   ZX_DET.TRX_BUSINESS_CATEGORY,
   ZX_DET.LINE_INTENDED_USE,
   ZX_DET.PRODUCT_CATEGORY,
   ZX_DET.PRODUCT_FISC_CLASSIFICATION,
   ZX_DET.SUPPLIER_EXCHANGE_RATE,
   ZX_DET.SUPPLIER_TAX_INVOICE_DATE,
   ZX_DET.SUPPLIER_TAX_INVOICE_NUMBER,
   ZX_DET.USER_DEFINED_FISC_CLASS,
   ZX_LINE.EXCEPTION_RATE,
   ZX_LINE.EXEMPT_RATE_MODIFIER,
   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),
   TO_CHAR(NULL),'|| -- RECOVERY_RATE_CODE,
   '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_DET.TAX_INVOICE_DATE,
   ZX_DET.TAX_INVOICE_NUMBER,
   ZX_LINE.TAX_JURISDICTION_CODE,
   ZX_LINE.TAX_REGIME_CODE,
   ZX_LINE.TAX_STATUS_CODE,
   ZX_LINE.TAX_STATUS_ID,
   ZX_LINE.TAX,
   ZX_DET.SHIP_FROM_PARTY_TAX_PROF_ID  ,
   ZX_DET.SHIP_FROM_SITE_TAX_PROF_ID,
   ZX_DET.SHIP_TO_PARTY_TAX_PROF_ID  ,
   ZX_DET.SHIP_TO_SITE_TAX_PROF_ID  ,
   ZX_DET.BILL_TO_PARTY_TAX_PROF_ID,
   ZX_DET.BILL_TO_SITE_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.HISTORICAL_FLAG,
   ZX_LINE.MRC_TAX_LINE_FLAG,
   DECODE(DIST.GL_POSTED_DATE, NULL, ''N'', ''Y'') POSTED_FLAG,
   ZX_LINE.REPORTING_ONLY_FLAG,
   ZX_LINE.TAX_AMT_INCLUDED_FLAG,
   ZX_LINE.TAX_ONLY_LINE_FLAG,
   ZX_DET.EVENT_CLASS_MAPPING_ID,
   ZX_DET.TRX_LEVEL_TYPE,
   ZX_LINE.PLACE_OF_SUPPLY_TYPE_CODE,
   ZX_DET.POA_LOCATION_ID,
   ZX_DET.POO_LOCATION_ID,
   ZX_TAX.DEF_PLACE_OF_SUPPLY_TYPE_CODE,
   SUM(ZX_DET.LINE_AMT),
   ZX_LINE.TAX_PROVIDER_ID,
   TO_DATE(NULL),
   TO_CHAR(NULL),
   TO_NUMBER(NULL),
   TO_NUMBER(NULL),
   TO_CHAR(NULL),
   DIST.ACCOUNT_CLASS,
   TO_CHAR(NULL),
   ZX_DET.TRX_ID ,
   ZX_DET.ENTITY_CODE,
   DIST.GL_POSTED_DATE,
   DIST.GL_DATE,
   to_number(NULL),     --ZX_DET.UNIT_PRICE,
   TO_NUMBER(NULL),
   ZX_LINE.OFFSET_TAX_RATE_CODE,
   ZX_LINE.OFFSET_FLAG';

Line: 2620

  'SELECT '|| get_hint_ar_inv ||
  ' ZX_DET.LEDGER_ID,
   ZX_DET.TRX_ID    ,
   ZX_DET.DOC_SEQ_ID ,
   ZX_DET.DOC_SEQ_NAME ,
   ZX_DET.RECEIVABLES_TRX_TYPE_ID,
   ZX_DET.LINE_CLASS,
   ZX_DET.EVENT_CLASS_CODE ,
   TO_CHAR(NULL) ,'|| --APPLIED_FROM_ENTITY_CODE
  'TO_NUMBER(NULL)  ,'||--APPLIED_FROM_TRX_ID
  'TO_CHAR(NULL)  ,'||--APPLIED_FROM_EVENT_CLASS_CODE
  'TO_CHAR(NULL)  ,'||  -- ADJUSTED_DOC_ENTITY_CODE --APPLIED_TO_ENTITY_CODE
  'ZX_DET.ADJUSTED_DOC_TRX_ID,'|| --ADJSUTED_DOC_ID --APPLIED_TO_TRX_ID
  --'TO_CHAR(NULL)  ,'||  --ADJUSTED_DOC_EVENT_CLASS_CODE  --APPLIED_TO_EVENT_CLASS_CODE
  'ZX_DET.ADJUSTED_DOC_EVENT_CLASS_CODE ,'|| --ADJUSTED_DOC_EVENT_CLASS_CODE Bug 9031051
  'ZX_DET.ADJUSTED_DOC_NUMBER  ,'|| --ADJUSTED_DOC_NUMBER  --APPLIED_TO_TRX_NUMBER
  'ZX_DET.BATCH_SOURCE_ID,
   ZX_LINE.TAX_RATE_ID ,
   DECODE(ZX_ACCOUNTS.INTERIM_TAX_CCID,NULL,''TAX'',''INTERIM''),
   ZX_DET.PRODUCT_ID,
   ZX_DET.PRODUCT_DESCRIPTION,
   TO_CHAR(NULL), --TAXABLE_LINE_SOURCE_TABLE,
   TO_NUMBER(NULL), --TAXABLE_ITEM_SOURCE_ID,
   ZX_LINE.TAX_EXEMPTION_ID ,
   ZX_LINE.TAX_EXCEPTION_ID  ,
   TO_NUMBER(NULL),  --TAXABLE_LINE_TOTAL_AMOUNT  ,
   ZX_LINE.TAX_LINE_ID,
   ZX_LINE.TAX_AMT,
   NVL(ZX_LINE.TAX_AMT_FUNCL_CURR,ZX_LINE.TAX_AMT)  ,
   ZX_LINE.TAX_LINE_NUMBER,
   DECODE(ZX_LINE.MANUALLY_ENTERED_FLAG,
          ''Y'',DECODE(ZX_LINE.TAX_AMT_INCLUDED_FLAG,''N'', ZX_LINE.LINE_AMT,ZX_LINE.TAXABLE_AMT),
          ZX_LINE.TAXABLE_AMT),
   NVL(ZX_LINE.TAXABLE_AMT_FUNCL_CURR,ZX_LINE.TAXABLE_AMT) ,
   ZX_LINE.TRX_LINE_ID,
   ZX_LINE.TRX_LINE_QUANTITY  ,
   ZX_DET.EXEMPT_CERTIFICATE_NUMBER,
   ZX_LINE.EXEMPT_REASON_CODE   ,
   TO_CHAR(NULL), --exception_reason_code
   ZX_DET.UOM_CODE,
   TO_CHAR(NULL)  ,'||--RECONCILIATION_FLAG
  'ZX_DET.INTERNAL_ORGANIZATION_ID ,'||--ORG_ID
  'TO_NUMBER(NULL),'||--BR_REF_CUSTOMER_TRX_ID
 -- 'TO_CHAR(NULL),  --reverse_date
  'TO_NUMBER(NULL)   ,'||--AMOUNT_APPLIED
  'TO_NUMBER(NULL),'||  --TAX_APPLIED
  'CASE WHEN (ZX_LINE.LAST_MANUAL_ENTRY=''TAX_RATE'' AND ZX_LINE.OVERRIDDEN_FLAG = ''Y'') OR ZX_LINE.TAX_PROVIDER_ID IS NOT NULL THEN ZX_LINE.TAX_RATE ELSE ZX_RATE.PERCENTAGE_RATE END,
   ZX_LINE.TAX_RATE_CODE,
   ZX_RATE.VAT_TRANSACTION_TYPE_CODE,
   -- ZX_RATE.RATE_TYPE_CODE,
   ZX_TAX.TAX_TYPE_CODE,
   ZX_RATE.TAX_RATE_NAME,
   ZX_DET.TRX_NUMBER,
   ZX_DET.TRX_DESCRIPTION,
   ZX_DET.DOC_SEQ_VALUE,
   ZX_DET.TRX_DATE,
   TO_DATE(NULL),   -- Deposit Date
   ZX_DET.TRX_DUE_DATE ,
   ZX_DET.TRX_SHIPPING_DATE ,
   ZX_DET.TRX_COMMUNICATED_DATE ,
   ZX_DET.TRX_CURRENCY_CODE,
   ZX_DET.CURRENCY_CONVERSION_TYPE,
   ZX_DET.CURRENCY_CONVERSION_DATE,
   ZX_DET.CURRENCY_CONVERSION_RATE,
   ZX_DET.TRX_SIC_CODE,
   ZX_DET.FOB_POINT,
   ZX_DET.TRX_WAYBILL_NUMBER,
   ZX_DET.BATCH_SOURCE_NAME,
   ZX_DET.TRX_TYPE_DESCRIPTION,
   ZX_RATE.DESCRIPTION,
   ZX_DET.TRX_LINE_DESCRIPTION,
   ZX_LINE.TRX_LINE_NUMBER,
   ZX_DET.TRX_LINE_TYPE,
   ZX_LINE.ATTRIBUTE_CATEGORY,
   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_DET.APPLICATION_ID,
   ZX_DET.DOC_EVENT_STATUS,
   ZX_DET.APPLICATION_DOC_STATUS,
   ZX_DET.ESTABLISHMENT_ID,
   ''AR'', '|| --EXTRACT_SOURCE_LEDGER
  '--ZX_DET.FUNCTIONAL_CURRECNY_CODE,
   --ZX_DET.LEDGER_NAME,
   ZX_DET.MINIMUM_ACCOUNTABLE_UNIT,
   ZX_DET.PRECISION,
   TO_NUMBER(NULL),'|| --RECEIPT_CLASS_ID
  'ZX_DET.APPLIED_TO_APPLICATION_ID,
   ZX_DET.APPLIED_TO_TRX_LINE_ID,
   ZX_DET.APPLIED_TO_ENTITY_CODE,
   ZX_DET.APPLIED_TO_TRX_ID,
   ZX_DET.APPLIED_TO_EVENT_CLASS_CODE,
   ZX_DET.APPLIED_TO_TRX_NUMBER,
   ZX_DET.RELATED_DOC_APPLICATION_ID,
   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.ADJUSTED_DOC_APPLICATION_ID,
   ZX_DET.ADJUSTED_DOC_DATE,
   --ZX_DET.BANKING_TP_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_RATE.DEF_REC_SETTLEMENT_OPTION_CODE,
   ZX_DET.DEFAULT_TAXATION_COUNTRY,
   ZX_DET.DOCUMENT_SUB_TYPE,
   ZX_DET.ASSESSABLE_VALUE,
   ZX_DET.TRX_BUSINESS_CATEGORY,
   ZX_DET.LINE_INTENDED_USE,
   ZX_DET.PRODUCT_CATEGORY,
   ZX_DET.PRODUCT_FISC_CLASSIFICATION,
   ZX_DET.SUPPLIER_EXCHANGE_RATE,
   ZX_DET.SUPPLIER_TAX_INVOICE_DATE,
   ZX_DET.SUPPLIER_TAX_INVOICE_NUMBER,
   ZX_DET.USER_DEFINED_FISC_CLASS,
   ZX_LINE.EXCEPTION_RATE,
   ZX_LINE.EXEMPT_RATE_MODIFIER,
   ZX_LINE.ORIG_TAX_AMT,
   ZX_LINE.ORIG_TAX_AMT_TAX_CURR ,
   ZX_LINE.ORIG_TAXABLE_AMT,
   ZX_LINE.ORIG_TAXABLE_AMT_TAX_CURR,
   TO_CHAR(NULL),'|| -- RECOVERY_RATE_CODE,
  '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_DET.TAX_INVOICE_DATE,
   ZX_DET.TAX_INVOICE_NUMBER,
   ZX_LINE.TAX_JURISDICTION_CODE,
   ZX_LINE.TAX_REGIME_CODE,
   ZX_LINE.TAX_STATUS_CODE,
   ZX_LINE.TAX_STATUS_ID,
   ZX_LINE.TAX,
   ZX_DET.SHIP_FROM_PARTY_TAX_PROF_ID  ,
   ZX_DET.SHIP_FROM_SITE_TAX_PROF_ID,
   ZX_DET.SHIP_TO_PARTY_TAX_PROF_ID  ,
   ZX_DET.SHIP_TO_SITE_TAX_PROF_ID  ,
   ZX_DET.BILL_TO_PARTY_TAX_PROF_ID,
   ZX_DET.BILL_TO_SITE_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.HISTORICAL_FLAG,
   ZX_LINE.MRC_TAX_LINE_FLAG,
   TO_CHAR(NULL)POSTED_FLAG,
   ZX_LINE.REPORTING_ONLY_FLAG,
   ZX_LINE.TAX_AMT_INCLUDED_FLAG,
   ZX_LINE.TAX_ONLY_LINE_FLAG,
   ZX_DET.EVENT_CLASS_MAPPING_ID,
   ZX_DET.TRX_LEVEL_TYPE,
   ZX_LINE.PLACE_OF_SUPPLY_TYPE_CODE,
   ZX_DET.POA_LOCATION_ID,
   ZX_DET.POO_LOCATION_ID,
   ZX_TAX.DEF_PLACE_OF_SUPPLY_TYPE_CODE,
   ZX_DET.LINE_AMT,
   ZX_LINE.TAX_PROVIDER_ID,
   TO_DATE(NULL),
   TO_CHAR(NULL),
   TO_NUMBER(NULL),
   TO_NUMBER(NULL),
   TO_CHAR(NULL),
   TO_CHAR(NULL),
   TO_CHAR(NULL),
   TO_CHAR(NULL),
   ZX_DET.ENTITY_CODE,
   TO_DATE(NULL),
   ZX_DET.TRX_LINE_GL_DATE,
   ZX_DET.UNIT_PRICE,
   TO_NUMBER(NULL),
   ZX_LINE.OFFSET_TAX_RATE_CODE,
   ZX_LINE.OFFSET_FLAG';

Line: 2866

   'SELECT '|| get_hint_ar_inv ||
   ' ZX_DET.LEDGER_ID,
    ZX_DET.TRX_ID    ,
    ZX_DET.DOC_SEQ_ID ,
    ZX_DET.DOC_SEQ_NAME ,
    ZX_DET.RECEIVABLES_TRX_TYPE_ID,
    ZX_DET.LINE_CLASS,
    ZX_DET.EVENT_CLASS_CODE ,
    TO_CHAR(NULL) ,'|| --APPLIED_FROM_ENTITY_CODE
   'TO_NUMBER(NULL)  ,'||--APPLIED_FROM_TRX_ID
   'TO_CHAR(NULL)  ,'||--APPLIED_FROM_EVENT_CLASS_CODE
   'ZX_DET.ADJUSTED_DOC_ENTITY_CODE ,'||  --APPLIED_TO_ENTITY_CODE --TO_CHAR(NULL)
   'ZX_DET.ADJUSTED_DOC_TRX_ID ,'|| --TO_NUMBER(NULL) --APPLIED_TO_TRX_ID
   'ZX_DET.ADJUSTED_DOC_EVENT_CLASS_CODE  ,'||  --TO_CHAR(NULL)  --APPLIED_TO_EVENT_CLASS_CODE
   'ZX_DET.ADJUSTED_DOC_NUMBER  ,'|| --ADJUSTED_DOC_NUMBER  --APPLIED_TO_TRX_NUMBER
   'ZX_DET.BATCH_SOURCE_ID,
    ZX_LINE.TAX_RATE_ID ,
    DECODE(ZX_ACCOUNTS.INTERIM_TAX_CCID,NULL,''TAX'',''INTERIM''),
    ZX_DET.PRODUCT_ID,
    ZX_DET.PRODUCT_DESCRIPTION,
    TO_CHAR(NULL), --TAXABLE_LINE_SOURCE_TABLE,
    TO_NUMBER(NULL), --TAXABLE_ITEM_SOURCE_ID,
    ZX_LINE.TAX_EXEMPTION_ID ,
    ZX_LINE.TAX_EXCEPTION_ID  ,
    TO_NUMBER(NULL),  --TAXABLE_LINE_TOTAL_AMOUNT  ,
    ZX_LINE.TAX_LINE_ID,
    ZX_LINE.TAX_AMT,
    NVL(ZX_LINE.TAX_AMT_FUNCL_CURR,ZX_LINE.TAX_AMT)  ,
    ZX_LINE.TAX_LINE_NUMBER,
    DECODE(ZX_LINE.MANUALLY_ENTERED_FLAG,
           ''Y'',DECODE(ZX_LINE.TAX_AMT_INCLUDED_FLAG,''N'', ZX_LINE.LINE_AMT,ZX_LINE.TAXABLE_AMT),
           ZX_LINE.TAXABLE_AMT),
    NVL(ZX_LINE.TAXABLE_AMT_FUNCL_CURR,ZX_LINE.TAXABLE_AMT) ,
    ZX_LINE.TRX_LINE_ID,
    ZX_LINE.TRX_LINE_QUANTITY  ,
    ZX_DET.EXEMPT_CERTIFICATE_NUMBER,
    ZX_LINE.EXEMPT_REASON_CODE   ,
    TO_CHAR(NULL), --exception_reason_code
    ZX_DET.UOM_CODE,
    TO_CHAR(NULL)  ,'||--RECONCILIATION_FLAG
   'ZX_DET.INTERNAL_ORGANIZATION_ID ,'||--ORG_ID
   'TO_NUMBER(NULL),'||--BR_REF_CUSTOMER_TRX_ID
  -- 'TO_CHAR(NULL),  --reverse_date
   'TO_NUMBER(NULL)   ,'||--AMOUNT_APPLIED
   'TO_NUMBER(NULL),'||  --TAX_APPLIED
   'CASE WHEN (ZX_LINE.LAST_MANUAL_ENTRY=''TAX_RATE'' AND ZX_LINE.OVERRIDDEN_FLAG = ''Y'') OR ZX_LINE.TAX_PROVIDER_ID IS NOT NULL THEN ZX_LINE.TAX_RATE ELSE ZX_RATE.PERCENTAGE_RATE END,
    ZX_LINE.TAX_RATE_CODE,
    ZX_RATE.VAT_TRANSACTION_TYPE_CODE,
   --ZX_RATE.RATE_TYPE_CODE,
    ZX_TAX.TAX_TYPE_CODE,
    ZX_RATE.TAX_RATE_NAME,
    ZX_DET.TRX_NUMBER,
    ZX_DET.TRX_DESCRIPTION,
    ZX_DET.DOC_SEQ_VALUE,
    ZX_DET.TRX_DATE,
    TO_DATE(NULL),   --Deposit Date
    ZX_DET.TRX_DUE_DATE ,
    ZX_DET.TRX_SHIPPING_DATE ,
    ZX_DET.TRX_COMMUNICATED_DATE ,
    ZX_DET.TRX_CURRENCY_CODE,
    ZX_DET.CURRENCY_CONVERSION_TYPE,
    ZX_DET.CURRENCY_CONVERSION_DATE,
    ZX_DET.CURRENCY_CONVERSION_RATE,
    ZX_DET.TRX_SIC_CODE,
    ZX_DET.FOB_POINT,
    ZX_DET.TRX_WAYBILL_NUMBER,
    ZX_DET.BATCH_SOURCE_NAME,
    ZX_DET.TRX_TYPE_DESCRIPTION,
    ZX_RATE.DESCRIPTION,
    ZX_DET.TRX_LINE_DESCRIPTION,
    ZX_LINE.TRX_LINE_NUMBER,
    ZX_DET.TRX_LINE_TYPE,
    ZX_LINE.ATTRIBUTE_CATEGORY,
    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_DET.APPLICATION_ID,
    ZX_DET.DOC_EVENT_STATUS,
    ZX_DET.APPLICATION_DOC_STATUS,
    ZX_DET.ESTABLISHMENT_ID,
    ''AR'','|| --EXTRACT_SOURCE_LEDGER
   '--ZX_DET.FUNCTIONAL_CURRECNY_CODE,
    --ZX_DET.LEDGER_NAME,
    ZX_DET.MINIMUM_ACCOUNTABLE_UNIT,
    ZX_DET.PRECISION,
    TO_NUMBER(NULL),'|| --RECEIPT_CLASS_ID
   'ZX_DET.APPLIED_TO_APPLICATION_ID,
    ZX_DET.APPLIED_TO_TRX_LINE_ID,
    ZX_DET.APPLIED_TO_ENTITY_CODE,
    ZX_DET.APPLIED_TO_TRX_ID,
    ZX_DET.APPLIED_TO_EVENT_CLASS_CODE,
    ZX_DET.APPLIED_TO_TRX_NUMBER,
    ZX_DET.RELATED_DOC_APPLICATION_ID,
    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.ADJUSTED_DOC_APPLICATION_ID,
    ZX_DET.ADJUSTED_DOC_DATE,
    --ZX_DET.BANKING_TP_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_RATE.DEF_REC_SETTLEMENT_OPTION_CODE,
    ZX_DET.DEFAULT_TAXATION_COUNTRY,
    ZX_DET.DOCUMENT_SUB_TYPE,
    ZX_DET.ASSESSABLE_VALUE,
    ZX_DET.TRX_BUSINESS_CATEGORY,
    ZX_DET.LINE_INTENDED_USE,
    ZX_DET.PRODUCT_CATEGORY,
    ZX_DET.PRODUCT_FISC_CLASSIFICATION,
    ZX_DET.SUPPLIER_EXCHANGE_RATE,
    ZX_DET.SUPPLIER_TAX_INVOICE_DATE,
    ZX_DET.SUPPLIER_TAX_INVOICE_NUMBER,
    ZX_DET.USER_DEFINED_FISC_CLASS,
    ZX_LINE.EXCEPTION_RATE,
    ZX_LINE.EXEMPT_RATE_MODIFIER,
    ZX_LINE.ORIG_TAX_AMT,
    ZX_LINE.ORIG_TAX_AMT_TAX_CURR ,
    ZX_LINE.ORIG_TAXABLE_AMT,
    ZX_LINE.ORIG_TAXABLE_AMT_TAX_CURR,
    TO_CHAR(NULL),'|| -- RECOVERY_RATE_CODE,
   '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_DET.TAX_INVOICE_DATE,
    ZX_DET.TAX_INVOICE_NUMBER,
    ZX_LINE.TAX_JURISDICTION_CODE,
    ZX_LINE.TAX_REGIME_CODE,
    ZX_LINE.TAX_STATUS_CODE,
    ZX_LINE.TAX_STATUS_ID,
    ZX_LINE.TAX,
    ZX_DET.SHIP_FROM_PARTY_TAX_PROF_ID  ,
    ZX_DET.SHIP_FROM_SITE_TAX_PROF_ID,
    ZX_DET.SHIP_TO_PARTY_TAX_PROF_ID  ,
    ZX_DET.SHIP_TO_SITE_TAX_PROF_ID  ,
    ZX_DET.BILL_TO_PARTY_TAX_PROF_ID,
    ZX_DET.BILL_TO_SITE_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.HISTORICAL_FLAG,
    ZX_LINE.MRC_TAX_LINE_FLAG,
    DECODE(DIST.GL_POSTED_DATE, NULL, ''N'', ''Y'') POSTED_FLAG,
    ZX_LINE.REPORTING_ONLY_FLAG,
    ZX_LINE.TAX_AMT_INCLUDED_FLAG,
    ZX_LINE.TAX_ONLY_LINE_FLAG,
    ZX_DET.EVENT_CLASS_MAPPING_ID,
    ZX_DET.TRX_LEVEL_TYPE,
    ZX_LINE.PLACE_OF_SUPPLY_TYPE_CODE,
    ZX_DET.POA_LOCATION_ID,
    ZX_DET.POO_LOCATION_ID,
    ZX_TAX.DEF_PLACE_OF_SUPPLY_TYPE_CODE,
    ZX_DET.LINE_AMT,
    ZX_LINE.TAX_PROVIDER_ID,
    TO_DATE(NULL),
    TO_CHAR(NULL),
    TO_NUMBER(NULL),
    TO_NUMBER(NULL),
    TO_CHAR(NULL),
    DIST.ACCOUNT_CLASS,
    TO_CHAR(NULL),
    TO_CHAR(NULL) ,
    ZX_DET.ENTITY_CODE,
    DIST.GL_POSTED_DATE,
    DIST.GL_DATE,
    ZX_DET.UNIT_PRICE,
    TO_NUMBER(NULL),
    ZX_LINE.OFFSET_TAX_RATE_CODE,
    ZX_LINE.OFFSET_FLAG';

Line: 3111

   'SELECT '|| get_hint_ar_inv ||
   'DISTINCT ZX_DET.LEDGER_ID,
    ZX_DET.TRX_ID    ,
    ZX_DET.DOC_SEQ_ID ,
    ZX_DET.DOC_SEQ_NAME ,
    ZX_DET.RECEIVABLES_TRX_TYPE_ID,
    ZX_DET.LINE_CLASS,
    ZX_DET.EVENT_CLASS_CODE ,
    TO_CHAR(NULL) ,'|| --APPLIED_FROM_ENTITY_CODE
   'TO_NUMBER(NULL)  ,'||--APPLIED_FROM_TRX_ID
   'TO_CHAR(NULL)  ,'||--APPLIED_FROM_EVENT_CLASS_CODE
   'TO_CHAR(NULL)  ,'||  -- ADJUSTED_DOC_ENTITY_CODE --APPLIED_TO_ENTITY_CODE
   'TO_NUMBER(NULL) ,'|| --ADJSUTED_DOC_ID --APPLIED_TO_TRX_ID
   'TO_CHAR(NULL)  ,'||  --ADJUSTED_DOC_EVENT_CLASS_CODE  --APPLIED_TO_EVENT_CLASS_CODE
   'ZX_DET.ADJUSTED_DOC_NUMBER  ,'|| --ADJUSTED_DOC_NUMBER  --APPLIED_TO_TRX_NUMBER
   'ZX_DET.BATCH_SOURCE_ID,
    ZX_LINE.TAX_RATE_ID ,
    DECODE(ZX_ACCOUNTS.INTERIM_TAX_CCID,NULL,''TAX'',''INTERIM''),
    ZX_DET.PRODUCT_ID,
    ZX_DET.PRODUCT_DESCRIPTION,
    TO_CHAR(NULL),   --TAXABLE_LINE_SOURCE_TABLE,
    TO_NUMBER(NULL),   --TAXABLE_ITEM_SOURCE_ID,
    ZX_LINE.TAX_EXEMPTION_ID ,
    ZX_LINE.TAX_EXCEPTION_ID  ,
    TO_NUMBER(NULL),   --TAXABLE_LINE_TOTAL_AMOUNT  ,
    ZX_LINE.TAX_LINE_ID,
    DIST.AMOUNT,     -- ZX_LINE.TAX_AMT,
    DIST.ACCTD_AMOUNT,    --NVL(ZX_LINE.TAX_AMT_FUNCL_CURR,ZX_LINE.TAX_AMT)  ,
    ZX_LINE.TAX_LINE_NUMBER,
    DECODE(ZX_LINE.MANUALLY_ENTERED_FLAG,
           ''Y'',DECODE(ZX_LINE.TAX_AMT_INCLUDED_FLAG,''N'', ZX_LINE.LINE_AMT,
                                                             ZX_LINE.TAXABLE_AMT)
                ,ZX_LINE.TAXABLE_AMT)*(DIST.PERCENT)/100,
    --NVL(ZX_LINE.TAXABLE_AMT_FUNCL_CURR,ZX_LINE.TAXABLE_AMT) *(DIST.PERCENT)/100,
    DECODE(ZX_LINE.MANUALLY_ENTERED_FLAG,
           ''Y'', DECODE(ZX_LINE.TAX_AMT_INCLUDED_FLAG, ''N'', ZX_LINE.LINE_AMT,
                                                          NVL(ZX_LINE.TAXABLE_AMT_FUNCL_CURR,ZX_LINE.TAXABLE_AMT))
           ,NVL(ZX_LINE.TAXABLE_AMT_FUNCL_CURR,ZX_LINE.TAXABLE_AMT)) *(DIST.PERCENT)/100, --13045488
    ZX_LINE.TRX_LINE_ID,
    ZX_LINE.TRX_LINE_QUANTITY  ,
    ZX_DET.EXEMPT_CERTIFICATE_NUMBER,
    ZX_LINE.EXEMPT_REASON_CODE   ,
    TO_CHAR(NULL), --exception_reason_code
    ZX_DET.UOM_CODE,
    TO_CHAR(NULL)  ,'||--RECONCILIATION_FLAG
   'ZX_DET.INTERNAL_ORGANIZATION_ID ,'||--ORG_ID
   'TO_NUMBER(NULL),'||--BR_REF_CUSTOMER_TRX_ID
   --'TO_CHAR(NULL),  --reverse_date
   'TO_NUMBER(NULL)   ,'||--AMOUNT_APPLIED
   'TO_NUMBER(NULL),'||  --TAX_APPLIED
   'CASE WHEN (ZX_LINE.LAST_MANUAL_ENTRY=''TAX_RATE'' AND ZX_LINE.OVERRIDDEN_FLAG = ''Y'') OR ZX_LINE.TAX_PROVIDER_ID IS NOT NULL THEN ZX_LINE.TAX_RATE ELSE ZX_RATE.PERCENTAGE_RATE END,
    ZX_LINE.TAX_RATE_CODE,
    ZX_RATE.VAT_TRANSACTION_TYPE_CODE,
   --ZX_RATE.RATE_TYPE_CODE,
    ZX_TAX.TAX_TYPE_CODE,
    ZX_RATE.TAX_RATE_NAME,
    ZX_DET.TRX_NUMBER,
    ZX_DET.TRX_DESCRIPTION,
    ZX_DET.DOC_SEQ_VALUE,
    ZX_DET.TRX_DATE,
    TO_DATE(NULL),   --Deposit Date
    ZX_DET.TRX_DUE_DATE ,
    ZX_DET.TRX_SHIPPING_DATE ,
    ZX_DET.TRX_COMMUNICATED_DATE ,
    ZX_DET.TRX_CURRENCY_CODE,
    ZX_DET.CURRENCY_CONVERSION_TYPE,
    ZX_DET.CURRENCY_CONVERSION_DATE,
    ZX_DET.CURRENCY_CONVERSION_RATE,
    ZX_DET.TRX_SIC_CODE,
    ZX_DET.FOB_POINT,
    ZX_DET.TRX_WAYBILL_NUMBER,
    ZX_DET.BATCH_SOURCE_NAME,
    ZX_DET.TRX_TYPE_DESCRIPTION,
    ZX_RATE.DESCRIPTION,
    ZX_DET.TRX_LINE_DESCRIPTION,
    ZX_LINE.TRX_LINE_NUMBER,
    ZX_DET.TRX_LINE_TYPE,
    ZX_LINE.ATTRIBUTE_CATEGORY,
    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_DET.APPLICATION_ID,
    ZX_DET.DOC_EVENT_STATUS,
    ZX_DET.APPLICATION_DOC_STATUS,
    ZX_DET.ESTABLISHMENT_ID,
    ''AR'','|| --EXTRACT_SOURCE_LEDGER
   '--ZX_DET.FUNCTIONAL_CURRECNY_CODE,
    --ZX_DET.LEDGER_NAME,
    ZX_DET.MINIMUM_ACCOUNTABLE_UNIT,
    ZX_DET.PRECISION,
    TO_NUMBER(NULL)  ,'|| --RECEIPT_CLASS_ID
   'ZX_DET.APPLIED_TO_APPLICATION_ID,
    ZX_DET.APPLIED_TO_TRX_LINE_ID,
    ZX_DET.APPLIED_TO_ENTITY_CODE,
    ZX_DET.APPLIED_TO_TRX_ID,
    ZX_DET.APPLIED_TO_EVENT_CLASS_CODE,
    ZX_DET.APPLIED_TO_TRX_NUMBER,
    ZX_DET.RELATED_DOC_APPLICATION_ID,
    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.ADJUSTED_DOC_APPLICATION_ID,
    ZX_DET.ADJUSTED_DOC_DATE,
    --ZX_DET.BANKING_TP_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_RATE.DEF_REC_SETTLEMENT_OPTION_CODE,
    ZX_DET.DEFAULT_TAXATION_COUNTRY,
    ZX_DET.DOCUMENT_SUB_TYPE,
    ZX_DET.ASSESSABLE_VALUE,
    ZX_DET.TRX_BUSINESS_CATEGORY,
    ZX_DET.LINE_INTENDED_USE,
    ZX_DET.PRODUCT_CATEGORY,
    ZX_DET.PRODUCT_FISC_CLASSIFICATION,
    ZX_DET.SUPPLIER_EXCHANGE_RATE,
    ZX_DET.SUPPLIER_TAX_INVOICE_DATE,
    ZX_DET.SUPPLIER_TAX_INVOICE_NUMBER,
    ZX_DET.USER_DEFINED_FISC_CLASS,
    ZX_LINE.EXCEPTION_RATE,
    ZX_LINE.EXEMPT_RATE_MODIFIER,
    ZX_LINE.ORIG_TAX_AMT,
    ZX_LINE.ORIG_TAX_AMT_TAX_CURR ,
    ZX_LINE.ORIG_TAXABLE_AMT,
    ZX_LINE.ORIG_TAXABLE_AMT_TAX_CURR,
    TO_CHAR(NULL)  ,'|| -- RECOVERY_RATE_CODE,
   '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_DET.TAX_INVOICE_DATE,
    ZX_DET.TAX_INVOICE_NUMBER,
    ZX_LINE.TAX_JURISDICTION_CODE,
    ZX_LINE.TAX_REGIME_CODE,
    ZX_LINE.TAX_STATUS_CODE,
    ZX_LINE.TAX_STATUS_ID,
    ZX_LINE.TAX,
    ZX_DET.SHIP_FROM_PARTY_TAX_PROF_ID  ,
    ZX_DET.SHIP_FROM_SITE_TAX_PROF_ID,
    ZX_DET.SHIP_TO_PARTY_TAX_PROF_ID  ,
    ZX_DET.SHIP_TO_SITE_TAX_PROF_ID  ,
    ZX_DET.BILL_TO_PARTY_TAX_PROF_ID,
    ZX_DET.BILL_TO_SITE_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.HISTORICAL_FLAG,
    ZX_LINE.MRC_TAX_LINE_FLAG,
    DECODE(DIST.GL_POSTED_DATE, NULL, ''N'', ''Y'') POSTED_FLAG,
    ZX_LINE.REPORTING_ONLY_FLAG,
    ZX_LINE.TAX_AMT_INCLUDED_FLAG,
    ZX_LINE.TAX_ONLY_LINE_FLAG,
    ZX_DET.EVENT_CLASS_MAPPING_ID,
    ZX_DET.TRX_LEVEL_TYPE,
    ZX_LINE.PLACE_OF_SUPPLY_TYPE_CODE,
    ZX_DET.POA_LOCATION_ID,
    ZX_DET.POO_LOCATION_ID,
    ZX_TAX.DEF_PLACE_OF_SUPPLY_TYPE_CODE,
    ZX_DET.LINE_AMT,
    ZX_LINE.TAX_PROVIDER_ID,
    TO_DATE(NULL),
    TO_CHAR(NULL),
    TO_NUMBER(NULL),
    TO_NUMBER(NULL),
    TO_CHAR(NULL),
    DIST.ACCOUNT_CLASS,
    DIST.LATEST_REC_FLAG,
    DIST.CUST_TRX_LINE_GL_DIST_ID ,
    ZX_DET.ENTITY_CODE,
    DIST.GL_POSTED_DATE,
    DIST.GL_DATE,
    ZX_DET.UNIT_PRICE,
    TO_NUMBER(NULL),
    ZX_LINE.OFFSET_TAX_RATE_CODE,
    ZX_LINE.OFFSET_FLAG';

Line: 3386

      'SELECT '||
        'ARCS.SET_OF_BOOKS_ID,
         ARCS.CASH_RECEIPT_ID, '||
        'ARCS.DOC_SEQUENCE_ID,
         SEQ.NAME,
         TO_NUMBER(NULL), '||
        'DECODE(ARD.SOURCE_TYPE,''EDISC'',''EDISC'',''UNEDISC'',
                 ''UNEDISC'',''REC'',''APP''), '||
        'DECODE(ARD.SOURCE_TYPE,''EDISC'',''EDISC'',''UNEDISC'',
                 ''UNEDISC'',''REC'',''APP''), '||
        ' ''APP'',
         APP.RECEIVABLE_APPLICATION_ID, '||
        '''APP'','||
        'TO_CHAR(NULL),'||  --ZX_DET.ADJUSTED_DOC_ENTITY_CODE,   --INV
        'ZX_DET.CUSTOMER_TRX_ID ,'|| --ZX_DET.ADJUSTED_DOC_TRX_ID--Applied_to_trx_id--adjusted_doc_id in eTax
        'TO_CHAR(NULL),'||   --ZX_DET.ADJUSTED_DOC_EVENT_CLASS_CODE  -- INV
        'ZX_DET.TRX_NUMBER,'||   --ZX_DET.ADJUSTED_DOC_NUMBER --Applied_doc_number
        'ZX_DET.BATCH_SOURCE_ID,'||
        'ARDTAX.TAX_CODE_ID,'||
        'DECODE(ARDTAX.SOURCE_TYPE,''TAX'',''TAX'',''DEFERRED_TAX'',''INTERIM'',
            ''UNEDISC_NON_REC_TAX'',''NON-RECOVERABLE'',
            ''EDISC_NON_REC_TAX'',''NON-RECOVERABLE'',NULL), ' || -- REG. TYPE CODE
        'TO_NUMBER(NULL),
         TO_CHAR(NULL),
         ARD.SOURCE_TABLE,
         ARD.SOURCE_ID,
         TO_NUMBER(NULL),'||
        'TO_NUMBER(NULL),'||
        'sum(nvl(ARDTAX.TAXABLE_ENTERED_CR,0)-nvl(ARDTAX.TAXABLE_ENTERED_DR,0)),'||-- Total Amount
        'TO_NUMBER(NULL), ' || -- tax_line_id
        'sum(nvl(ARDTAX.AMOUNT_CR,0)-nvl(ARDTAX.AMOUNT_DR,0)),'||
        'sum(nvl(ARDTAX.ACCTD_AMOUNT_CR,0) - nvl(ARDTAX.ACCTD_AMOUNT_DR,0)) ,'||
        'ARDTAX.TAX_LINK_ID, '||  -- Tax Line number populating with tax_link_id
        'sum(nvl(ARDTAX.TAXABLE_ENTERED_CR,0) - nvl(ARDTAX.TAXABLE_ENTERED_DR,0)) ,'||
        'sum(nvl(ARDTAX.TAXABLE_ACCOUNTED_CR,0) - nvl(ARDTAX.TAXABLE_ACCOUNTED_DR,0)),'|| -- ar matrix ++ 17
        'ARD.LINE_ID,
         TO_NUMBER(NULL),
         TO_CHAR(NULL),
         TO_CHAR(NULL),
         TO_CHAR(NULL),
         TO_CHAR(NULL), '||
        'DECODE(ARDTAX.SOURCE_TYPE_SECONDARY,''RECONCILE'',''Y'','||
        ' ''ASSIGNMENT_RECONCILE'', ''Y'',''N''), ' ||
        'ZX_DET.ORG_ID,
         TO_NUMBER(NULL), ' ||
        --    'ARCS.REVERSAL_DATE,     --Check this column
        ' APP.AMOUNT_APPLIED,
         APP.TAX_APPLIED,
         ZX_RATE.PERCENTAGE_RATE,
         ZX_RATE.TAX_RATE_CODE,
         ZX_RATE.VAT_TRANSACTION_TYPE_CODE,
         -- ZX_RATE.RATE_TYPE_CODE,
         ZX_TAX.TAX_TYPE_CODE,
         ZX_RATE.TAX_RATE_NAME,
         ARCS.RECEIPT_NUMBER,
         TO_CHAR(NULL),  --ZX_DET.TRX_DESCRIPTION,
         ARCS.DOC_SEQUENCE_VALUE,
         ARCS.RECEIPT_DATE,
         ARCS.DEPOSIT_DATE,
         TO_DATE(NULL),    --ZX_DET.TRX_DUE_DATE,
         TO_DATE(NULL),    --ZX_DET.TRX_SHIPPING_DATE,
         TO_DATE(NULL),    --ZX_DET.TRX_COMMUNICATED_DATE,
         ARCS.CURRENCY_CODE,
         ARCS.EXCHANGE_RATE_TYPE,
         ARCS.EXCHANGE_DATE,
         ZX_DET.EXCHANGE_RATE,
         TO_CHAR(NULL),
         ZX_DET.FOB_POINT,
         ZX_DET.WAYBILL_NUMBER,
         TO_CHAR(NULL),'|| --ZX_DET.BATCH_SOURCE_NAME,
        'TO_CHAR(NULL),'|| -- TRX_TYPE_DESCRIPTION
         -- 'ZX_RATE.RATE_TYPE_CODE,
        'ZX_RATE.DESCRIPTION,
         TO_CHAR(NULL),
         TO_NUMBER(NULL),
         TO_CHAR(NULL),
         TO_CHAR(NULL),
         TO_CHAR(NULL),
         TO_CHAR(NULL),
         TO_CHAR(NULL),
         TO_CHAR(NULL),
         TO_CHAR(NULL),
         TO_CHAR(NULL),
         TO_CHAR(NULL),
         TO_CHAR(NULL),
         TO_CHAR(NULL),
         TO_CHAR(NULL),
         TO_CHAR(NULL),
         TO_CHAR(NULL),
         TO_CHAR(NULL),
         TO_CHAR(NULL),
         TO_CHAR(NULL),
         NVL(ZX_DET.APPLICATION_ID,222),
         TO_CHAR(NULL),    --ZX_DET.DOC_EVENT_STATUS,
         TO_CHAR(NULL),    --ZX_DET.APPLICATION_DOC_STATUS,
         TO_NUMBER(NULL),    --ZX_DET.ESTABLISHMENT_ID,
         ''AR'', --EXTRACT_SOURCE_LEDGER,
         --ZX_DET.FUNCTIONAL_CURRECNY_CODE,
         --ZX_DET.LEDGER_NAME,
         TO_NUMBER(NULL),    --ZX_DET.MINIMUM_ACCOUNTABLE_UNIT,
         TO_NUMBER(NULL),    --ZX_DET.PRECISION,
         TO_NUMBER(NULL),   --RECEIPT_CLASS_ID,
         TO_NUMBER(NULL),    --ZX_DET.APPLIED_TO_APPLICATION_ID,
         ARD.REF_CUSTOMER_TRX_LINE_ID,    --ZX_DET.APPLIED_TO_TRX_LINE_ID,
         TO_CHAR(NULL),    --ZX_DET.APPLIED_TO_ENTITY_CODE,
         TO_NUMBER(NULL),    --ZX_DET.APPLIED_TO_TRX_ID,
         TO_CHAR(NULL),    --ZX_DET.APPLIED_TO_EVENT_CLASS_CODE,
         TO_CHAR(NULL),    --ZX_DET.APPLIED_TO_TRX_NUMBER,
         TO_NUMBER(NULL),    --ZX_DET.RELATED_DOC_APPLICATION_ID,
         TO_DATE(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.ADJUSTED_DOC_APPLICATION_ID,
        ' ZX_DET.TRX_DATE, '||  --ZX_DET.ADJUSTED_DOC_DATE,
         -- ZX_DET.BANKING_TP_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,
         TO_CHAR(NULL),    --ZX_RATE.DEF_REC_SETTLEMENT_OPTION_CODE,
         TO_CHAR(NULL),    --ZX_DET.DEFAULT_TAXATION_COUNTRY,
         TO_CHAR(NULL),    --ZX_DET.DOCUMENT_SUB_TYPE,
         TO_NUMBER(NULL),    --ZX_DET.ASSESSABLE_VALUE,
         TO_CHAR(NULL),    --ZX_DET.TRX_BUSINESS_CATEGORY,
         TO_CHAR(NULL),    --ZX_DET.LINE_INTENDED_USE,
         TO_CHAR(NULL),    --ZX_DET.PRODUCT_CATEGORY,
         TO_CHAR(NULL),    --ZX_DET.PRODUCT_FISC_CLASSIFICATION,
         TO_NUMBER(NULL),    --ZX_DET.SUPPLIER_EXCHANGE_RATE,
         TO_DATE(NULL),    --ZX_DET.SUPPLIER_TAX_INVOICE_DATE,
         TO_CHAR(NULL),    --ZX_DET.SUPPLIER_TAX_INVOICE_NUMBER,
         TO_CHAR(NULL),    --ZX_DET.USER_DEFINED_FISC_CLASS,
         TO_NUMBER(NULL),    --ZX_LINE.EXCEPTION_RATE,
         TO_NUMBER(NULL),    --ZX_LINE.EXEMPT_RATE_MODIFIER,
         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_CHAR(NULL),    --ZX_RATE.RECOVERY_RATE_CODE,
         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_DATE(NULL),    --ZX_LINE.TAX_DATE,
         TO_DATE(NULL),    --ZX_LINE.TAX_DETERMINE_DATE,
         TO_DATE(NULL),    --ZX_DET.TAX_INVOICE_DATE,
         TO_NUMBER(NULL),    --ZX_DET.TAX_INVOICE_NUMBER,
         ZX_RATE.TAX_JURISDICTION_CODE,
         ZX_RATE.TAX_REGIME_CODE,
         ZX_RATE.TAX_STATUS_CODE,
         TO_NUMBER(NULL),  --ZX_LINE.TAX_STATUS_ID,
         ZX_RATE.TAX,
         TO_NUMBER(NULL),    --ZX_DET.SHIP_FROM_PARTY_TAX_PROF_ID,
         TO_NUMBER(NULL),    --ZX_DET.SHIP_FROM_SITE_TAX_PROF_ID,
         TO_NUMBER(NULL),    --ZX_DET.SHIP_TO_PARTY_TAX_PROF_ID,
         TO_NUMBER(NULL),    --ZX_DET.SHIP_TO_SITE_TAX_PROF_ID,
         TO_NUMBER(NULL),    --ZX_DET.BILL_TO_PARTY_TAX_PROF_ID,
         TO_NUMBER(NULL),    --ZX_DET.BILL_TO_SITE_TAX_PROF_ID,
         TO_NUMBER(NULL),    --ZX_DET.SHIP_THIRD_PTY_ACCT_SITE_ID,
         TO_NUMBER(NULL),    --ZX_DET.BILL_THIRD_PTY_ACCT_SITE_ID,
         ZX_DET.SHIP_TO_SITE_USE_ID,  --ZX_DET.SHIP_TO_CUST_ACCT_SITE_USE_ID,
         ZX_DET.BILL_TO_SITE_USE_ID,   --ZX_DET.BILL_TO_CUST_ACCT_SITE_USE_ID,
         ZX_DET.SHIP_TO_CUSTOMER_ID,    --ZX_DET.SHIP_THIRD_PTY_ACCT_ID,
         ZX_DET.BILL_TO_CUSTOMER_ID,   --ZX_DET.BILL_THIRD_PTY_ACCT_ID,
         TO_CHAR(NULL),'||  --ZX_LINE.HQ_ESTB_REG_NUMBER
        'TO_CHAR(NULL),'||  --zx_line.tax_registration_number
        'TO_CHAR(NULL),'||     --ZX_LINE.LEGAL_ENTITY_TAX_REG_NUMBER
        'TO_CHAR(NULL),  --ZX_DET.OWN_HQ_SITE_TAX_PROF_ID,
         TO_NUMBER(NULL),    --ZX_DET.OWN_HQ_PARTY_TAX_PROF_ID,
         TO_CHAR(NULL),    --ZX_DET.PORT_OF_ENTRY_CODE,
         TO_CHAR(NULL),'||     --ZX_LINE.REGISTRATION_PARTY_TYPE
        'TO_CHAR(NULL),'||     --ZX_LINE.HISTORICAL_FLAG
        'TO_CHAR(NULL),'||     --ZX_LINE.MRC_TAX_LINE_FLAG
        'DECODE(APP.GL_POSTED_DATE, NULL, ''N'', ''Y'') POSTED_FLAG,'||     -- POSTED_FLAG
        'TO_CHAR(NULL),'||     --ZX_LINE.REPORTING_ONLY_FLAG
        'TO_CHAR(NULL),'||     --ZX_LINE.TAX_AMT_INCLUDED_FLAG
        'TO_CHAR(NULL),'||     --ZX_LINE.TAX_ONLY_LINE_FLAG
        'TO_NUMBER(NULL),    -- ZX_DET.EVENT_CLASS_MAPPING_ID,
         TO_CHAR(NULL),    --ZX_DET.TRX_LEVEL_TYPE,
         TO_CHAR(NULL),       -- Place of supply type code
         TO_NUMBER(NULL),    --ZX_DET.POA_LOCATION_ID,
         TO_NUMBER(NULL),    --ZX_DET.POO_LOCATION_ID,
         TO_CHAR(NULL), '||      -- Default Place of supply type code
        '(nvl(ARD.AMOUNT_CR,0) - nvl(ARD.AMOUNT_DR,0)),'|| --ZX_DET.LINE_AMT
        'TO_NUMBER(NULL),
         ARCS.REVERSAL_DATE,
         ARCS.STATUS,
         sum(ARDTAX.ACCTD_AMOUNT_CR),
         sum(ARDTAX.ACCTD_AMOUNT_DR),
         APP.STATUS,
         TO_CHAR(NULL),
         TO_CHAR(NULL),
         ARD.LINE_ID ,
         TO_CHAR(NULL), --ZX_DET.ENTITY_CODE,
         APP.GL_POSTED_DATE,
         APP.GL_DATE,
         TO_NUMBER(NULL),
         TO_NUMBER(NULL),
         TO_CHAR(NULL),
         TO_CHAR(NULL)';

Line: 3747

      'SELECT '||
           'ARCS.SET_OF_BOOKS_ID,
             ARCS.CASH_RECEIPT_ID, '||
            'ARCS.DOC_SEQUENCE_ID,
             SEQ.NAME,
             TO_NUMBER(NULL), '||
             'DECODE(ARD.SOURCE_TYPE,''EDISC'',''EDISC'',''UNEDISC'',
                    ''UNEDISC'',''REC'',''APP''), '||
             'DECODE(ARD.SOURCE_TYPE,''EDISC'',''EDISC'',''UNEDISC'',
                    ''UNEDISC'',''REC'',''APP''), '||
            ' ''APP'',
             APP.RECEIVABLE_APPLICATION_ID, '||
            '''APP'','||
             'ZX_DET.ADJUSTED_DOC_ENTITY_CODE,'||    --INV
             'ZX_DET.ADJUSTED_DOC_TRX_ID,'|| -- Applied_to_trx_id -- adjusted_doc_id in eTax
            'ZX_DET.ADJUSTED_DOC_EVENT_CLASS_CODE,'||   -- INV
            'ZX_DET.ADJUSTED_DOC_NUMBER, --Applied_doc_number
             ZX_DET.BATCH_SOURCE_ID,'||
            'ARDTAX.TAX_CODE_ID,'||
            'DECODE(ARDTAX.SOURCE_TYPE,''TAX'',''TAX'',''DEFERRED_TAX'',''INTERIM'',
                ''UNEDISC_NON_REC_TAX'',''NON-RECOVERABLE'',
                ''EDISC_NON_REC_TAX'',''NON-RECOVERABLE'',NULL), ' || -- REG. TYPE CODE
            'TO_NUMBER(NULL),
             TO_CHAR(NULL),
             ARD.SOURCE_TABLE,
             ARD.SOURCE_ID,
             TO_NUMBER(NULL),'||
            'TO_NUMBER(NULL),'||
            'sum(nvl(ARDTAX.TAXABLE_ENTERED_CR,0)-nvl(ARDTAX.TAXABLE_ENTERED_DR,0)),'||-- Total Amount
            'TO_NUMBER(NULL), ' || -- tax_line_id
            'sum(nvl(ARDTAX.AMOUNT_CR,0)-nvl(ARDTAX.AMOUNT_DR,0)),'||
            'sum(nvl(ARDTAX.ACCTD_AMOUNT_CR,0) - nvl(ARDTAX.ACCTD_AMOUNT_DR,0)) ,'||
            'TO_NUMBER(NULL), '||
            'sum(nvl(ARDTAX.TAXABLE_ENTERED_CR,0) - nvl(ARDTAX.TAXABLE_ENTERED_DR,0)) ,'||
            'sum(nvl(ARDTAX.TAXABLE_ACCOUNTED_CR,0) - nvl(ARDTAX.TAXABLE_ACCOUNTED_DR,0)),'|| -- ar matrix ++ 17
             'TO_NUMBER(NULL),
             TO_NUMBER(NULL),
             TO_CHAR(NULL),
             TO_CHAR(NULL),
             TO_CHAR(NULL),
             TO_CHAR(NULL), '||
             'DECODE(ARDTAX.SOURCE_TYPE_SECONDARY,''RECONCILE'',''Y'','||
            ' ''ASSIGNMENT_RECONCILE'', ''Y'',''N''), ' ||
            'ZX_DET.INTERNAL_ORGANIZATION_ID,
            TO_NUMBER(NULL), ' ||
        --    'ARCS.REVERSAL_DATE,     --Check this column
            ' APP.AMOUNT_APPLIED,
             APP.TAX_APPLIED,
             ZX_RATE.PERCENTAGE_RATE,
             ZX_RATE.TAX_RATE_CODE,
             ZX_RATE.VAT_TRANSACTION_TYPE_CODE,
       --      ZX_RATE.RATE_TYPE_CODE,
       ZX_TAX.TAX_TYPE_CODE,
             ZX_RATE.TAX_RATE_NAME,
             ARCS.RECEIPT_NUMBER,
             ZX_DET.TRX_DESCRIPTION,
             ARCS.DOC_SEQUENCE_VALUE,
             ARCS.RECEIPT_DATE,
             ARCS.DEPOSIT_DATE,
             ZX_DET.TRX_DUE_DATE,
             ZX_DET.TRX_SHIPPING_DATE,
             ZX_DET.TRX_COMMUNICATED_DATE,
             ARCS.CURRENCY_CODE,
             ARCS.EXCHANGE_RATE_TYPE,
             ARCS.EXCHANGE_DATE,
             ARCS.EXCHANGE_RATE,
             TO_CHAR(NULL),
             ZX_DET.FOB_POINT,
             ZX_DET.TRX_WAYBILL_NUMBER,
             ZX_DET.BATCH_SOURCE_NAME,'||
            'TO_CHAR(NULL),'|| -- TRX_TYPE_DESCRIPTION
            -- 'ZX_RATE.RATE_TYPE_CODE,
      'ZX_RATE.DESCRIPTION,
            TO_CHAR(NULL),
            TO_NUMBER(NULL),
             TO_CHAR(NULL),
             TO_CHAR(NULL),
             TO_CHAR(NULL),
             TO_CHAR(NULL),
             TO_CHAR(NULL),
             TO_CHAR(NULL),
             TO_CHAR(NULL),
             TO_CHAR(NULL),
             TO_CHAR(NULL),
             TO_CHAR(NULL),
             TO_CHAR(NULL),
             TO_CHAR(NULL),
             TO_CHAR(NULL),
             TO_CHAR(NULL),
             TO_CHAR(NULL),
             TO_CHAR(NULL),
             TO_CHAR(NULL),
             ZX_DET.APPLICATION_ID,
              ZX_DET.DOC_EVENT_STATUS,
         ZX_DET.APPLICATION_DOC_STATUS,
              ZX_DET.ESTABLISHMENT_ID,
              ''AR'', --EXTRACT_SOURCE_LEDGER,
              --ZX_DET.FUNCTIONAL_CURRECNY_CODE,
              --ZX_DET.LEDGER_NAME,
              ZX_DET.MINIMUM_ACCOUNTABLE_UNIT,
              ZX_DET.PRECISION,
              to_number(NULL),      --RECEIPT_CLASS_ID,
              ZX_DET.APPLIED_TO_APPLICATION_ID,
              ZX_DET.APPLIED_TO_TRX_LINE_ID,
              ZX_DET.APPLIED_TO_ENTITY_CODE,
              ZX_DET.APPLIED_TO_TRX_ID,
              ZX_DET.APPLIED_TO_EVENT_CLASS_CODE,
              ZX_DET.APPLIED_TO_TRX_NUMBER,
              ZX_DET.RELATED_DOC_APPLICATION_ID,
              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.ADJUSTED_DOC_APPLICATION_ID,
              ZX_DET.ADJUSTED_DOC_DATE,
              --ZX_DET.BANKING_TP_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_RATE.DEF_REC_SETTLEMENT_OPTION_CODE,
              ZX_DET.DEFAULT_TAXATION_COUNTRY,
              ZX_DET.DOCUMENT_SUB_TYPE,
         ZX_DET.ASSESSABLE_VALUE,
              ZX_DET.TRX_BUSINESS_CATEGORY,
              ZX_DET.LINE_INTENDED_USE,
              ZX_DET.PRODUCT_CATEGORY,
              ZX_DET.PRODUCT_FISC_CLASSIFICATION,
              ZX_DET.SUPPLIER_EXCHANGE_RATE,
              ZX_DET.SUPPLIER_TAX_INVOICE_DATE,
              ZX_DET.SUPPLIER_TAX_INVOICE_NUMBER,
              ZX_DET.USER_DEFINED_FISC_CLASS,
              TO_NUMBER(NULL),    --ZX_LINE.EXCEPTION_RATE,
              TO_NUMBER(NULL),    --ZX_LINE.EXEMPT_RATE_MODIFIER,
              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_CHAR(NULL),    --ZX_RATE.RECOVERY_RATE_CODE,
              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_DATE(NULL),    --ZX_LINE.TAX_DATE,
              TO_DATE(NULL),    --ZX_LINE.TAX_DETERMINE_DATE,
              TO_DATE(NULL),    --ZX_DET.TAX_INVOICE_DATE,
              TO_NUMBER(NULL),    --ZX_DET.TAX_INVOICE_NUMBER,
              ZX_RATE.TAX_JURISDICTION_CODE,
              ZX_RATE.TAX_REGIME_CODE,
              ZX_RATE.TAX_STATUS_CODE,
              TO_NUMBER(NULL),  --ZX_LINE.TAX_STATUS_ID,
              ZX_RATE.TAX,
              ZX_DET.SHIP_FROM_PARTY_TAX_PROF_ID,
              ZX_DET.SHIP_FROM_SITE_TAX_PROF_ID,
              ZX_DET.SHIP_TO_PARTY_TAX_PROF_ID,
              ZX_DET.SHIP_TO_SITE_TAX_PROF_ID,
              ZX_DET.BILL_TO_PARTY_TAX_PROF_ID,
              ZX_DET.BILL_TO_SITE_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_CHAR(NULL),'||  --ZX_LINE.HQ_ESTB_REG_NUMBER
              'TO_CHAR(NULL),'||  --zx_line.tax_registration_number
              'TO_CHAR(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),'||     --ZX_LINE.HISTORICAL_FLAG
              'TO_CHAR(NULL),'||     --ZX_LINE.MRC_TAX_LINE_FLAG
            'DECODE(APP.GL_POSTED_DATE, NULL, ''N'', ''Y'') POSTED_FLAG,'||     -- POSTED_FLAG
              'TO_CHAR(NULL),'||     --ZX_LINE.REPORTING_ONLY_FLAG
              'TO_CHAR(NULL),'||     --ZX_LINE.TAX_AMT_INCLUDED_FLAG
              'TO_CHAR(NULL),'||     --ZX_LINE.TAX_ONLY_LINE_FLAG
         'ZX_DET.EVENT_CLASS_MAPPING_ID,
         ZX_DET.TRX_LEVEL_TYPE,
         TO_CHAR(NULL),       -- Place of supply type code
         ZX_DET.POA_LOCATION_ID,
         ZX_DET.POO_LOCATION_ID,
         TO_CHAR(NULL),       -- Default Place of supply type code
         ZX_DET.LINE_AMT,
         TO_NUMBER(NULL),
         ARCS.REVERSAL_DATE,
         ARCS.STATUS,
         sum(ARDTAX.ACCTD_AMOUNT_CR),
         sum(ARDTAX.ACCTD_AMOUNT_DR),
         APP.STATUS,
         TO_CHAR(NULL),
         TO_CHAR(NULL),
         ARD.LINE_ID ,
         ZX_DET.ENTITY_CODE,
   APP.GL_POSTED_DATE,
         APP.GL_DATE,
         TO_NUMBER(NULL),
         TO_NUMBER(NULL),
   TO_CHAR(NULL),
   TO_CHAR(NULL)';

Line: 4183

      'SELECT DISTINCT '||
            'ARCS.SET_OF_BOOKS_ID,
             ARCS.CASH_RECEIPT_ID, '||
            'ARCS.DOC_SEQUENCE_ID,
             SEQ.NAME,
             TO_NUMBER(NULL), '||
             'DECODE(ARD.SOURCE_TYPE,''EDISC'',''EDISC'',''UNEDISC'',
                    ''UNEDISC'',''REC'',''APP''), '||
       'DECODE(ARD.SOURCE_TYPE,''EDISC'',''EDISC'',''UNEDISC'',
                    ''UNEDISC'',''REC'',''APP''), '||
            ' ''APP'',
             APP.RECEIVABLE_APPLICATION_ID, '||
            ' ''APP'','||
             'TO_CHAR(NULL),'||  --ZX_DET.ADJUSTED_DOC_ENTITY_CODE,   --INV
             'TO_NUMBER(NULL) ,'|| --ZX_DET.ADJUSTED_DOC_TRX_ID--Applied_to_trx_id--adjusted_doc_id in eTax
            'TO_CHAR(NULL),'||   --ZX_DET.ADJUSTED_DOC_EVENT_CLASS_CODE  -- INV
            'ARCS.RECEIPT_NUMBER,'||   --ZX_DET.ADJUSTED_DOC_NUMBER --Applied_doc_number
            'ZX_DET.BATCH_SOURCE_ID,'||
            'ARDTAX.TAX_CODE_ID,'||
            'DECODE(ARDTAX.SOURCE_TYPE,''TAX'',''TAX'',''DEFERRED_TAX'',''INTERIM'',
                ''UNEDISC_NON_REC_TAX'',''NON-RECOVERABLE'',
                ''EDISC_NON_REC_TAX'',''NON-RECOVERABLE'',NULL), ' || -- REG. TYPE CODE
            'TO_NUMBER(NULL),
             TO_CHAR(NULL),
             ARD.SOURCE_TABLE,
             ARD.SOURCE_ID,
             TO_NUMBER(NULL) ,'||
            'TO_NUMBER(NULL), ' ||
            '(nvl(ARDTAX.TAXABLE_ENTERED_CR,0) - nvl(ARDTAX.TAXABLE_ENTERED_DR,0)),'|| -- Total Amount
            'TO_NUMBER(NULL),
            (nvl(ARDTAX.AMOUNT_CR,0)-nvl(ARDTAX.AMOUNT_DR,0)),'||
            '(nvl(ARDTAX.ACCTD_AMOUNT_CR,0) - nvl(ARDTAX.ACCTD_AMOUNT_DR,0)),
             ARDTAX.TAX_LINK_ID, '||
            '(nvl(ARDTAX.TAXABLE_ENTERED_CR,0) - nvl(ARDTAX.TAXABLE_ENTERED_DR,0)),'||
            '(nvl(ARDTAX.TAXABLE_ACCOUNTED_CR,0) - nvl(ARDTAX.TAXABLE_ACCOUNTED_DR,0)),'|| -- ar matrix ++ 20
            'ARD.LINE_ID,
            TO_NUMBER(NULL),
            TO_CHAR(NULL),
            TO_CHAR(NULL),
             TO_CHAR(NULL),
             TO_CHAR(NULL), '||
            'DECODE(ARDTAX.SOURCE_TYPE_SECONDARY,''RECONCILE'',''Y'','||
            ' ''ASSIGNMENT_RECONCILE'',''Y'',''N''),'  ||
            'ZX_DET.ORG_ID,
            TO_NUMBER(NULL), ' ||
           -- 'ARCS.REVERSAL_DATE,
             'APP.AMOUNT_APPLIED,
             APP.TAX_APPLIED,
             TO_NUMBER(NULL),       --ZX_RATE.PERCENTAGE_RATE,
             TO_CHAR(NULL),          --ZX_RATE.TAX_RATE_CODE,
             TO_CHAR(NULL),          --ZX_RATE.VAT_TRANSACTION_TYPE_CODE,
       --      ZX_RATE.RATE_TYPE_CODE,
             TO_CHAR(NULL),          --ZX_TAX.TAX_TYPE_CODE,
             TO_CHAR(NULL),          --ZX_RATE.TAX_RATE_NAME,
             ZX_DET.TRX_NUMBER,
              TO_CHAR(NULL),   --ZX_DET.TRX_DESCRIPTION,
              ARCS.DOC_SEQUENCE_VALUE,
              ARCS.RECEIPT_DATE,
              ARCS.DEPOSIT_DATE,
              TO_DATE(NULL),    --ZX_DET.TRX_DUE_DATE,
              TO_DATE(NULL),    --ZX_DET.TRX_SHIPPING_DATE,
              TO_DATE(NULL),    --ZX_DET.TRX_COMMUNICATED_DATE,
              ARCS.CURRENCY_CODE,
              ARCS.EXCHANGE_RATE_TYPE,
              ARCS.EXCHANGE_DATE,
              ZX_DET.EXCHANGE_RATE,    --ARCS.EXCHANGE_RATE,
              TO_CHAR(NULL),
              ZX_DET.FOB_POINT,
              ZX_DET.WAYBILL_NUMBER,
              BAT.NAME,
              TO_CHAR(NULL),
             -- ZX_RATE.RATE_TYPE_CODE,
        TO_CHAR(NULL),
              TO_CHAR(NULL),
               TO_NUMBER(NULL),
               TO_CHAR(NULL),
              TO_CHAR(NULL),
              TO_CHAR(NULL),
              TO_CHAR(NULL),
              TO_CHAR(NULL),
              TO_CHAR(NULL),
              TO_CHAR(NULL),
              TO_CHAR(NULL),
              TO_CHAR(NULL),
              TO_CHAR(NULL),
              TO_CHAR(NULL),
              TO_CHAR(NULL),
              TO_CHAR(NULL),
              TO_CHAR(NULL),
              TO_CHAR(NULL),
              TO_CHAR(NULL),
              TO_CHAR(NULL),
              NVL(ZX_DET.APPLICATION_ID,222),
              TO_CHAR(NULL),    --ZX_DET.DOC_EVENT_STATUS,
              TO_CHAR(NULL),    --ZX_DET.APPLICATION_DOC_STATUS,
              TO_NUMBER(NULL),    --ZX_DET.ESTABLISHMENT_ID,
              ''AR'', --EXTRACT_SOURCE_LEDGER,
              --ZX_DET.FUNCTIONAL_CURRECNY_CODE,
              --ZX_DET.LEDGER_NAME,
              TO_NUMBER(NULL),    --ZX_DET.MINIMUM_ACCOUNTABLE_UNIT,
              TO_NUMBER(NULL),    --ZX_DET.PRECISION,
              TO_NUMBER(NULL),   --RECEIPT_CLASS_ID,
              TO_NUMBER(NULL),    --ZX_DET.APPLIED_TO_APPLICATION_ID,
              TO_NUMBER(NULL),    --ZX_DET.APPLIED_TO_TRX_LINE_ID,
              TO_CHAR(NULL),    --ZX_DET.APPLIED_TO_ENTITY_CODE,
              TO_NUMBER(NULL),    --ZX_DET.APPLIED_TO_TRX_ID,
              TO_CHAR(NULL),    --ZX_DET.APPLIED_TO_EVENT_CLASS_CODE,
              TO_CHAR(NULL),    --ZX_DET.APPLIED_TO_TRX_NUMBER,
              TO_NUMBER(NULL),    --ZX_DET.RELATED_DOC_APPLICATION_ID,
              TO_DATE(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.ADJUSTED_DOC_APPLICATION_ID,
              TO_DATE(NULL),    --ZX_DET.ADJUSTED_DOC_DATE,
              --ZX_DET.BANKING_TP_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,
              TO_CHAR(NULL),    --ZX_RATE.DEF_REC_SETTLEMENT_OPTION_CODE,
              TO_CHAR(NULL),    --ZX_DET.DEFAULT_TAXATION_COUNTRY,
              TO_CHAR(NULL),    --ZX_DET.DOCUMENT_SUB_TYPE,
         TO_NUMBER(NULL),    --ZX_DET.ASSESSABLE_VALUE,
              TO_CHAR(NULL),    --ZX_DET.TRX_BUSINESS_CATEGORY,
              TO_CHAR(NULL),    --ZX_DET.LINE_INTENDED_USE,
              TO_CHAR(NULL),    --ZX_DET.PRODUCT_CATEGORY,
              TO_CHAR(NULL),    --ZX_DET.PRODUCT_FISC_CLASSIFICATION,
              TO_NUMBER(NULL),    --ZX_DET.SUPPLIER_EXCHANGE_RATE,
              TO_DATE(NULL),    --ZX_DET.SUPPLIER_TAX_INVOICE_DATE,
              TO_CHAR(NULL),    --ZX_DET.SUPPLIER_TAX_INVOICE_NUMBER,
              TO_CHAR(NULL),    --ZX_DET.USER_DEFINED_FISC_CLASS,
              TO_NUMBER(NULL),    --ZZX_LINE.EXCEPTION_RATE,
              TO_NUMBER(NULL),    --ZX_LINE.EXEMPT_RATE_MODIFIER,
              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_CHAR(NULL),    --ZX_RATE.RECOVERY_RATE_CODE,
              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_DATE(NULL),   --ZX_LINE.TAX_DATE,
              TO_DATE(NULL),   --ZX_LINE.TAX_DETERMINE_DATE,
              TO_DATE(NULL),   --ZX_DET.TAX_INVOICE_DATE,
              TO_CHAR(NULL),    --ZX_DET.TAX_INVOICE_NUMBER,
              TO_CHAR(NULL),    --ZX_RATE.TAX_JURISDICTION_CODE,
              TO_CHAR(NULL),    --ZX_RATE.TAX_REGIME_CODE,
              TO_CHAR(NULL),    --ZX_RATE.TAX_STATUS_CODE,
              TO_NUMBER(NULL),  --ZX_LINE.TAX_STATUS_ID,
              TO_CHAR(NULL),    --ZX_RATE.TAX,
              TO_NUMBER(NULL),    --ZX_DET.SHIP_FROM_PARTY_TAX_PROF_ID,
              TO_NUMBER(NULL),    --ZX_DET.SHIP_FROM_SITE_TAX_PROF_ID,
              TO_NUMBER(NULL),    --ZX_DET.SHIP_TO_PARTY_TAX_PROF_ID,
              TO_NUMBER(NULL),    --ZX_DET.SHIP_TO_SITE_TAX_PROF_ID,
              TO_NUMBER(NULL),    --ZX_DET.BILL_TO_PARTY_TAX_PROF_ID,
              TO_NUMBER(NULL),    --ZX_DET.BILL_TO_SITE_TAX_PROF_ID,
         TO_NUMBER(NULL),    --ZX_DET.SHIP_THIRD_PTY_ACCT_SITE_ID,
         TO_NUMBER(NULL),    --ZX_DET.BILL_THIRD_PTY_ACCT_SITE_ID,
         ZX_DET.SHIP_TO_SITE_USE_ID,  --ZX_DET.SHIP_TO_CUST_ACCT_SITE_USE_ID,
         ZX_DET.BILL_TO_SITE_USE_ID,   --ZX_DET.BILL_TO_CUST_ACCT_SITE_USE_ID,
         ZX_DET.SHIP_TO_CUSTOMER_ID,    --ZX_DET.SHIP_THIRD_PTY_ACCT_ID,
         ZX_DET.BILL_TO_CUSTOMER_ID,   --ZX_DET.BILL_THIRD_PTY_ACCT_ID,
              TO_CHAR(NULL),'||  --ZX_LINE.HQ_ESTB_REG_NUMBER,
              'TO_CHAR(NULL),'||  --zx_line.tax_registration_number
              'TO_CHAR(NULL),'||     --ZX_LINE.LEGAL_ENTITY_TAX_REG_NUMBER,
              'TO_NUMBER(NULL),    -- ZX_DET.OWN_HQ_SITE_TAX_PROF_ID,
              TO_NUMBER(NULL),    --ZX_DET.OWN_HQ_PARTY_TAX_PROF_ID,
              TO_CHAR(NULL),    --ZX_DET.PORT_OF_ENTRY_CODE,
              TO_CHAR(NULL),'||     --ZX_LINE.REGISTRATION_PARTY_TYPE
              'TO_CHAR(NULL),'||     --ZX_LINE.HISTORICAL_FLAG
              'TO_CHAR(NULL),'||     --ZX_LINE.MRC_TAX_LINE_FLAG
              'DECODE(APP.POSTING_CONTROL_ID,-3, ''N'', ''Y'') POSTED_FLAG,'||     --POSTED_FLAG
              'TO_CHAR(NULL),'||     --ZX_LINE.REPORTING_ONLY_FLAG
              'TO_CHAR(NULL),'||     --ZX_LINE.TAX_AMT_INCLUDED_FLAG
              'TO_CHAR(NULL),'||     --ZX_LINE.TAX_ONLY_LINE_FLAG
        'TO_NUMBER(NULL),    -- ZX_DET.EVENT_CLASS_MAPPING_ID,
         TO_CHAR(NULL),    --ZX_DET.TRX_LEVEL_TYPE,
         TO_CHAR(NULL),       -- Place of supply type code
         TO_NUMBER(NULL),    --ZX_DET.POA_LOCATION_ID,
         TO_NUMBER(NULL),    --ZX_DET.POO_LOCATION_ID,
         TO_CHAR(NULL),       -- Default Place of supply type code
         TO_NUMBER(NULL),    --ZX_DET.LINE_AMT,
         TO_NUMBER(NULL),
         ARCS.REVERSAL_DATE,
         ARCS.STATUS,
         ARDTAX.ACCTD_AMOUNT_CR,
         ARDTAX.ACCTD_AMOUNT_DR,
         APP.STATUS,
         TO_CHAR(NULL),
         TO_CHAR(NULL),
         ARDTAX.LINE_ID ,
         TO_CHAR(NULL),       --zx_det.entity_code,
   APP.GL_POSTED_DATE,
         APP.GL_DATE,
         TO_NUMBER(NULL),
         TO_NUMBER(NULL),
   TO_CHAR(NULL),
   TO_CHAR(NULL)';

Line: 4476

      'SELECT DISTINCT '||
              'ARCS.SET_OF_BOOKS_ID,
              ARCS.CASH_RECEIPT_ID, '||
              'ARCS.DOC_SEQUENCE_ID,
              SEQ.NAME,
              TO_NUMBER(NULL), '||
              'DECODE(ARD.SOURCE_TYPE,''EDISC'',''EDISC'',''UNEDISC'',
                    ''UNEDISC'',''REC'',''APP''), '||
              'DECODE(ARD.SOURCE_TYPE,''EDISC'',''EDISC'',''UNEDISC'',
                    ''UNEDISC'',''REC'',''APP''), '||
              ' ''APP'',
              APP.RECEIVABLE_APPLICATION_ID, '||
              ' ''APP'','||
              'ZX_DET.ADJUSTED_DOC_ENTITY_CODE,'||    --INV
              'ZX_DET.ADJUSTED_DOC_TRX_ID,'|| -- Applied_to_trx_id -- adjusted_doc_id in eTax
              'ZX_DET.ADJUSTED_DOC_EVENT_CLASS_CODE,'||   -- INV
              'ZX_DET.TRX_NUMBER,'||  --Applied_doc_number
              'ZX_DET.BATCH_SOURCE_ID,'||
              'ARDTAX.TAX_CODE_ID,'||
              'DECODE(ARDTAX.SOURCE_TYPE,''TAX'',''TAX'',''DEFERRED_TAX'',''INTERIM'',
                ''UNEDISC_NON_REC_TAX'',''NON-RECOVERABLE'',
                ''EDISC_NON_REC_TAX'',''NON-RECOVERABLE'',NULL), ' || -- REG. TYPE CODE
              'TO_NUMBER(NULL),
              TO_CHAR(NULL),
              ARD.SOURCE_TABLE,
              ARD.SOURCE_ID,
              TO_NUMBER(NULL) ,'||
              'TO_NUMBER(NULL), ' ||
              '(nvl(ARDTAX.TAXABLE_ENTERED_CR,0) - nvl(ARDTAX.TAXABLE_ENTERED_DR,0)),'|| -- Total Amount
              'TO_NUMBER(NULL),
              (nvl(ARDTAX.AMOUNT_CR,0)-nvl(ARDTAX.AMOUNT_DR,0)),'||
              '(nvl(ARDTAX.ACCTD_AMOUNT_CR,0) - nvl(ARDTAX.ACCTD_AMOUNT_DR,0)),
              ARDTAX.TAX_LINK_ID , '||
              '(nvl(ARDTAX.TAXABLE_ENTERED_CR,0) - nvl(ARDTAX.TAXABLE_ENTERED_DR,0)),'||
              '(nvl(ARDTAX.TAXABLE_ACCOUNTED_CR,0) - nvl(ARDTAX.TAXABLE_ACCOUNTED_DR,0)),'|| -- ar matrix ++ 20
              'ARD.LINE_ID,
              TO_NUMBER(NULL),
              TO_CHAR(NULL),
              TO_CHAR(NULL),
              TO_CHAR(NULL),
              TO_CHAR(NULL), '||
              'DECODE(ARDTAX.SOURCE_TYPE_SECONDARY,''RECONCILE'',''Y'','||
              ' ''ASSIGNMENT_RECONCILE'',''Y'',''N''),'  ||
              'ZX_DET.INTERNAL_ORGANIZATION_ID,
              TO_NUMBER(NULL), ' ||
              -- 'ARCS.REVERSAL_DATE,
              'APP.AMOUNT_APPLIED,
              APP.TAX_APPLIED,
              ZX_RATE.PERCENTAGE_RATE,
              ZX_RATE.TAX_RATE_CODE,
              ZX_RATE.VAT_TRANSACTION_TYPE_CODE,
              -- ZX_RATE.RATE_TYPE_CODE,
              ZX_TAX.TAX_TYPE_CODE,
              ZX_RATE.TAX_RATE_NAME,
              ARCS.RECEIPT_NUMBER,
              ZX_DET.TRX_DESCRIPTION,
              ARCS.DOC_SEQUENCE_VALUE,
              ARCS.RECEIPT_DATE,
              ARCS.DEPOSIT_DATE,
              ZX_DET.TRX_DUE_DATE,
              ZX_DET.TRX_SHIPPING_DATE,
              ZX_DET.TRX_COMMUNICATED_DATE,
              ARCS.CURRENCY_CODE,
              ARCS.EXCHANGE_RATE_TYPE,
              ARCS.EXCHANGE_DATE,
              ZX_DET.CURRENCY_CONVERSION_RATE,
              TO_CHAR(NULL),
              ZX_DET.FOB_POINT,
              ZX_DET.TRX_WAYBILL_NUMBER,
              ZX_DET.BATCH_SOURCE_NAME,
              TO_CHAR(NULL),
              -- ZX_RATE.RATE_TYPE_CODE,
              ZX_RATE.DESCRIPTION,
              TO_CHAR(NULL),
              TO_NUMBER(NULL),
              TO_CHAR(NULL),
              TO_CHAR(NULL),
              TO_CHAR(NULL),
              TO_CHAR(NULL),
              TO_CHAR(NULL),
              TO_CHAR(NULL),
              TO_CHAR(NULL),
              TO_CHAR(NULL),
              TO_CHAR(NULL),
              TO_CHAR(NULL),
              TO_CHAR(NULL),
              TO_CHAR(NULL),
              TO_CHAR(NULL),
              TO_CHAR(NULL),
              TO_CHAR(NULL),
              TO_CHAR(NULL),
              TO_CHAR(NULL),
              ZX_DET.APPLICATION_ID,
              ZX_DET.DOC_EVENT_STATUS,
              ZX_DET.APPLICATION_DOC_STATUS,
              ZX_DET.ESTABLISHMENT_ID,
              ''AR'', --EXTRACT_SOURCE_LEDGER,
              --ZX_DET.FUNCTIONAL_CURRECNY_CODE,
              --ZX_DET.LEDGER_NAME,
              ZX_DET.MINIMUM_ACCOUNTABLE_UNIT,
              ZX_DET.PRECISION,
              TO_NUMBER(NULL),   --RECEIPT_CLASS_ID,
              ZX_DET.APPLIED_TO_APPLICATION_ID,
              ZX_DET.APPLIED_TO_TRX_LINE_ID,
              ZX_DET.APPLIED_TO_ENTITY_CODE,
              ZX_DET.TRX_ID,
              ZX_DET.APPLIED_TO_EVENT_CLASS_CODE,
              ZX_DET.TRX_NUMBER,
              ZX_DET.RELATED_DOC_APPLICATION_ID,
              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.ADJUSTED_DOC_APPLICATION_ID,
              ZX_DET.ADJUSTED_DOC_DATE,
              --ZX_DET.BANKING_TP_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_RATE.DEF_REC_SETTLEMENT_OPTION_CODE,
              ZX_DET.DEFAULT_TAXATION_COUNTRY,
              ZX_DET.DOCUMENT_SUB_TYPE,
              TO_NUMBER(NULL),     --ZX_DET.ASSESSABLE_VALUE,
              ZX_DET.TRX_BUSINESS_CATEGORY,
              ZX_DET.LINE_INTENDED_USE,
              ZX_DET.PRODUCT_CATEGORY,
              ZX_DET.PRODUCT_FISC_CLASSIFICATION,
              ZX_DET.SUPPLIER_EXCHANGE_RATE,
              ZX_DET.SUPPLIER_TAX_INVOICE_DATE,
              ZX_DET.SUPPLIER_TAX_INVOICE_NUMBER,
              ZX_DET.USER_DEFINED_FISC_CLASS,
              TO_NUMBER(NULL),    --ZZX_LINE.EXCEPTION_RATE,
              TO_NUMBER(NULL),    --ZX_LINE.EXEMPT_RATE_MODIFIER,
              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_CHAR(NULL),    --ZX_RATE.RECOVERY_RATE_CODE,
              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_DATE(NULL),   --ZX_LINE.TAX_DATE,
              TO_DATE(NULL),   --ZX_LINE.TAX_DETERMINE_DATE,
              TO_DATE(NULL),   --ZX_DET.TAX_INVOICE_DATE,
              TO_CHAR(NULL),    --ZX_DET.TAX_INVOICE_NUMBER,
              ZX_RATE.TAX_JURISDICTION_CODE,
              ZX_RATE.TAX_REGIME_CODE,
              ZX_RATE.TAX_STATUS_CODE,
              TO_NUMBER(NULL),  --ZX_LINE.TAX_STATUS_ID,
              ZX_RATE.TAX,
              ZX_DET.SHIP_FROM_PARTY_TAX_PROF_ID,
              ZX_DET.SHIP_FROM_SITE_TAX_PROF_ID,
              ZX_DET.SHIP_TO_PARTY_TAX_PROF_ID,
              ZX_DET.SHIP_TO_SITE_TAX_PROF_ID,
              ZX_DET.BILL_TO_PARTY_TAX_PROF_ID,
              ZX_DET.BILL_TO_SITE_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_CHAR(NULL),'||  --ZX_LINE.HQ_ESTB_REG_NUMBER,
              'TO_CHAR(NULL),'||  --zx_line.tax_registration_number
              'TO_CHAR(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),'||     --ZX_LINE.HISTORICAL_FLAG
              'TO_CHAR(NULL),'||     --ZX_LINE.MRC_TAX_LINE_FLAG
              'DECODE(APP.GL_POSTED_DATE, NULL, ''N'', ''Y'') POSTED_FLAG,'||     --POSTED_FLAG
              'TO_CHAR(NULL),'||     --ZX_LINE.REPORTING_ONLY_FLAG
              'TO_CHAR(NULL),'||     --ZX_LINE.TAX_AMT_INCLUDED_FLAG
              'TO_CHAR(NULL),'||     --ZX_LINE.TAX_ONLY_LINE_FLAG
              'ZX_DET.EVENT_CLASS_MAPPING_ID,
              ZX_DET.TRX_LEVEL_TYPE,
              TO_CHAR(NULL),       -- Place of supply type code
              ZX_DET.POA_LOCATION_ID,
              ZX_DET.POO_LOCATION_ID,
              TO_CHAR(NULL),       -- Default Place of supply type code
              TO_NUMBER(NULL),    --ZX_DET.LINE_AMT,
              TO_NUMBER(NULL),
              ARCS.REVERSAL_DATE,
              ARCS.STATUS,
              ARDTAX.ACCTD_AMOUNT_CR,
              ARDTAX.ACCTD_AMOUNT_DR,
              APP.STATUS,
              TO_CHAR(NULL),
              TO_CHAR(NULL),
              ARDTAX.LINE_ID ,
              ZX_DET.ENTITY_CODE,
              APP.GL_POSTED_DATE,
              APP.GL_DATE,
              TO_NUMBER(NULL),
              TO_NUMBER(NULL),
              TO_CHAR(NULL),
              TO_CHAR(NULL)';

Line: 4796

      'SELECT DISTINCT '||
             'ADJ.SET_OF_BOOKS_ID,
             ADJ.ADJUSTMENT_ID, '||
             'ADJ.DOC_SEQUENCE_ID,
             SEQ.NAME,'||
             'TO_NUMBER(NULL), '||
             '''ADJ'','||
             '''ADJ'',
             TO_CHAR(NULL),
             TO_NUMBER(NULL), '||
             'TO_CHAR(NULL),
             TO_CHAR(NULL),'||    --INV
             'ADJ.CUSTOMER_TRX_ID,'|| -- Applied_to_trx_id -- adjusted_doc_id in eTax
             'TO_CHAR(NULL),'||   -- INV
             'ZX_DET.TRX_NUMBER,'||  --Applied_doc_number
             'ZX_DET.BATCH_SOURCE_ID,'||
             'ARDTAX.TAX_CODE_ID,'||
             'DECODE(ARDTAX.SOURCE_TYPE,''TAX'',''TAX'',''DEFERRED_TAX'',''INTERIM'',
                ''ADJ_NON_REC_TAX'',''NON-RECOVERABLE'',
                ''FINCHRG_NON_REC_TAX'',''NON-RECOVERABLE'',NULL),'|| -- REG. TYPE CODE
             'TO_NUMBER(NULL),'||
             'TO_CHAR(NULL),
             ARD.SOURCE_TABLE,
             ARD.SOURCE_ID,
             TO_NUMBER(NULL),'||
             'TO_NUMBER(NULL), ' ||
             'SUM((NVL(ARDTAX.TAXABLE_ENTERED_CR,0) - NVL(ARDTAX.TAXABLE_ENTERED_DR,0))),'||--Total Amount
             'TO_NUMBER(NULL),
             SUM((nvl(ARDTAX.AMOUNT_CR,0) - nvl(ARDTAX.AMOUNT_DR,0))),'||
             'SUM((NVL(ARDTAX.ACCTD_AMOUNT_CR,0) - NVL(ARDTAX.ACCTD_AMOUNT_DR,0))),'||
             'ARDTAX.TAX_LINK_ID, '||  -- Tax Line number populating with tax_link_id
             'SUM((NVL(ARDTAX.TAXABLE_ENTERED_CR,0) - NVL(ARDTAX.TAXABLE_ENTERED_DR,0))),'||
             'SUM((NVL(ARDTAX.TAXABLE_ACCOUNTED_CR,0) - NVL(ARDTAX.TAXABLE_ACCOUNTED_DR,0))),'|| -- ar matrix ++ 24
             -- 'to_number(NULL),
             'ARD.LINE_ID,
             TO_NUMBER(NULL),
             TO_CHAR(NULL),
             TO_CHAR(NULL),
             TO_CHAR(NULL),
             TO_CHAR(NULL), '||
             'DECODE(ARDTAX.SOURCE_TYPE_SECONDARY,''RECONCILE'',''Y'','||
              ' ''ASSIGNMENT_RECONCILE'',''Y'',''N''), ' ||
             'ZX_DET.ORG_ID,'||  -- Org_id
             'TO_NUMBER(NULL), ' ||
             -- 'TO_DATE(NULL),
             'TO_NUMBER(NULL),   --Applied_amount
             TO_NUMBER(NULL),   --tax_amount
             ZX_RATE.PERCENTAGE_RATE,
             ZX_RATE.TAX_RATE_CODE, '|| -- TO_CHAR(NULL),
             'ZX_RATE.VAT_TRANSACTION_TYPE_CODE,
             -- ZX_RATE.RATE_TYPE_CODE,
             TO_CHAR(NULL),    --ZX_TAX.TAX_TYPE_CODE,
             ZX_RATE.TAX_RATE_NAME,
             ADJ.ADJUSTMENT_NUMBER,
             TO_CHAR(NULL),  --ZX_DET.TRX_DESCRIPTION,
             ADJ.DOC_SEQUENCE_VALUE,
             ADJ.APPLY_DATE,
             TO_DATE(NULL),   --Deposit Date
             TO_DATE(NULL),    --ZX_DET.TRX_DUE_DATE,
             TO_DATE(NULL),    --ZX_DET.TRX_SHIPPING_DATE,
             TO_DATE(NULL),    --ZX_DET.TRX_COMMUNICATED_DATE,
             ZX_DET.INVOICE_CURRENCY_CODE ,
             TO_CHAR(NULL), --ZX_DET.CURRENCY_CONVERSION_TYPE,
             TO_DATE(NULL),   --ZX_DET.CURRENCY_CONVERSION_DATE,
             ZX_DET.EXCHANGE_RATE,  --ZX_DET.CURRENCY_CONVERSION_RATE,
             TO_CHAR(NULL),
             ZX_DET.FOB_POINT,
             ZX_DET.WAYBILL_NUMBER,'||
             'BAT.NAME,
             TYPES.DESCRIPTION,
             TO_CHAR(NULL),
             TO_CHAR(NULL),
             TO_NUMBER(NULL),
             TO_CHAR(NULL),
             TO_CHAR(NULL),
             TO_CHAR(NULL),
             TO_CHAR(NULL),
             TO_CHAR(NULL),
             TO_CHAR(NULL),
             TO_CHAR(NULL),
             TO_CHAR(NULL),
             TO_CHAR(NULL),
             TO_CHAR(NULL),
             TO_CHAR(NULL),
             TO_CHAR(NULL),
             TO_CHAR(NULL),
             TO_CHAR(NULL),
             TO_CHAR(NULL),
             TO_CHAR(NULL),
             TO_CHAR(NULL),
             NVL(ZX_DET.APPLICATION_ID,222),
             TO_CHAR(NULL),    --ZX_DET.DOC_EVENT_STATUS,
             TO_CHAR(NULL),    --ZX_DET.APPLICATION_DOC_STATUS,
             TO_NUMBER(NULL),  --ZX_DET.ESTABLISHMENT_ID,
             ''AR'', --EXTRACT_SOURCE_LEDGER,
             --ZX_DET.FUNCTIONAL_CURRECNY_CODE,
             --ZX_DET.LEDGER_NAME,
             TO_NUMBER(NULL), --ZX_DET.MINIMUM_ACCOUNTABLE_UNIT,
             TO_NUMBER(NULL), --ZX_DET.PRECISION,
             TO_NUMBER(NULL), --RECEIPT_CLASS_ID,
             TO_NUMBER(NULL), --ZX_DET.APPLIED_TO_APPLICATION_ID,
             ARD.REF_CUSTOMER_TRX_LINE_ID, --ZX_DET.APPLIED_TO_TRX_LINE_ID,
             TO_CHAR(NULL),   --ZX_DET.APPLIED_TO_ENTITY_CODE,
             TO_NUMBER(NULL), --ZX_DET.APPLIED_TO_TRX_ID,
             TO_CHAR(NULL),   --ZX_DET.APPLIED_TO_EVENT_CLASS_CODE,
             TO_CHAR(NULL),   --ZX_DET.APPLIED_TO_TRX_NUMBER,
             TO_NUMBER(NULL), --ZX_DET.RELATED_DOC_APPLICATION_ID,
             TO_DATE(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.ADJUSTED_DOC_APPLICATION_ID,
             'ZX_DET.TRX_DATE,'|| --ZX_DET.ADJUSTED_DOC_DATE,
             '--ZX_DET.BANKING_TP_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,
             TO_CHAR(NULL),   --ZX_RATE.DEF_REC_SETTLEMENT_OPTION_CODE,
             TO_CHAR(NULL),   --ZX_DET.DEFAULT_TAXATION_COUNTRY,
             TO_CHAR(NULL),   --ZX_DET.DOCUMENT_SUB_TYPE,
             TO_NUMBER(NULL), --ZX_DET.ASSESSABLE_VALUE,
             TO_CHAR(NULL),   --ZX_DET.TRX_BUSINESS_CATEGORY,
             TO_CHAR(NULL),   --ZX_DET.LINE_INTENDED_USE,
             TO_CHAR(NULL),   --ZX_DET.PRODUCT_CATEGORY,
             TO_CHAR(NULL),   --ZX_DET.PRODUCT_FISC_CLASSIFICATION,
             TO_NUMBER(NULL), --ZX_DET.SUPPLIER_EXCHANGE_RATE,
             TO_DATE(NULL),   --ZX_DET.SUPPLIER_TAX_INVOICE_DATE,
             TO_CHAR(NULL),   --ZX_DET.SUPPLIER_TAX_INVOICE_NUMBER,
             TO_CHAR(NULL),   --ZX_DET.USER_DEFINED_FISC_CLASS,
             TO_NUMBER(NULL),    --ZX_LINE.EXCEPTION_RATE,
             TO_NUMBER(NULL),    --ZX_LINE.EXEMPT_RATE_MODIFIER,
             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_CHAR(NULL),   --   ZX_RATE.RECOVERY_RATE_CODE,
             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_DATE(NULL),   --ZX_LINE.TAX_DATE,
             TO_DATE(NULL),   --ZX_LINE.TAX_DETERMINE_DATE,
             TO_DATE(NULL),   --ZX_DET.TAX_INVOICE_DATE,
             TO_CHAR(NULL),  --ZX_DET.TAX_INVOICE_NUMBER,
             ZX_RATE.TAX_JURISDICTION_CODE,
             ZX_RATE.TAX_REGIME_CODE,
             ZX_RATE.TAX_STATUS_CODE,
             TO_NUMBER(NULL),  --ZX_LINE.TAX_STATUS_ID,
             ZX_RATE.TAX,
             TO_NUMBER(NULL),  --ZX_DET.SHIP_FROM_PARTY_TAX_PROF_ID,
             TO_NUMBER(NULL),  --ZX_DET.SHIP_FROM_SITE_TAX_PROF_ID,
             TO_NUMBER(NULL),  --ZX_DET.SHIP_TO_PARTY_TAX_PROF_ID,
             TO_NUMBER(NULL),  --ZX_DET.SHIP_TO_SITE_TAX_PROF_ID,
             TO_NUMBER(NULL),  --ZX_DET.BILL_TO_PARTY_TAX_PROF_ID,
             TO_NUMBER(NULL),  --ZX_DET.BILL_TO_SITE_TAX_PROF_ID,
             TO_NUMBER(NULL),  --ZX_DET.SHIP_THIRD_PTY_ACCT_SITE_ID,
             TO_NUMBER(NULL),  --ZX_DET.BILL_THIRD_PTY_ACCT_SITE_ID,
             ZX_DET.SHIP_TO_SITE_USE_ID,  --ZX_DET.SHIP_TO_CUST_ACCT_SITE_USE_ID,
             ZX_DET.BILL_TO_SITE_USE_ID,   --ZX_DET.BILL_TO_CUST_ACCT_SITE_USE_ID,
             ZX_DET.SHIP_TO_CUSTOMER_ID,    --ZX_DET.SHIP_THIRD_PTY_ACCT_ID,
             ZX_DET.BILL_TO_CUSTOMER_ID,   --ZX_DET.BILL_THIRD_PTY_ACCT_ID,
             TO_CHAR(NULL),'||  --ZX_LINE.HQ_ESTB_REG_NUMBER,
             'TO_CHAR(NULL),'||  --zx_line.tax_registration_number
             'TO_CHAR(NULL),'||     --ZX_LINE.LEGAL_ENTITY_TAX_REG_NUMBER,
             'TO_NUMBER(NULL),   --ZX_DET.OWN_HQ_SITE_TAX_PROF_ID,
             TO_NUMBER(NULL),  --ZX_DET.OWN_HQ_PARTY_TAX_PROF_ID,
             TO_CHAR(NULL),   --ZX_DET.PORT_OF_ENTRY_CODE,
             TO_CHAR(NULL),'||     --ZX_LINE.REGISTRATION_PARTY_TYPE,
             'TO_CHAR(NULL),'||     --ZX_LINE.HISTORICAL_FLAG,
             'TO_CHAR(NULL),'||     --ZX_LINE.MRC_TAX_LINE_FLAG,
             'DECODE(ADJ.POSTING_CONTROL_ID,-3, ''N'', ''Y'') POSTED_FLAG,'||     --POSTED_FLAG,
             'TO_CHAR(NULL),'||     --ZX_LINE.REPORTING_ONLY_FLAG,
             'TO_CHAR(NULL),'||     --ZX_LINE.TAX_AMT_INCLUDED_FLAG,
             'TO_CHAR(NULL),'||     --ZX_LINE.TAX_ONLY_LINE_FLAG
             'TO_NUMBER(NULL),   --ZX_DET.EVENT_CLASS_MAPPING_ID,
             TO_CHAR(NULL),   --ZX_DET.TRX_LEVEL_TYPE,
             TO_CHAR(NULL),       -- Place of supply type code
             TO_NUMBER(NULL),  --ZX_DET.POA_LOCATION_ID,
             TO_NUMBER(NULL),   --ZX_DET.POO_LOCATION_ID,
             TO_CHAR(NULL),'||       -- Default Place of supply type code
             'SUM(NVL(ARD.AMOUNT_CR,0) - NVL(ARD.AMOUNT_DR,0)),'|| --ZX_DET.LINE_AMT
             'TO_NUMBER(NULL),
             TO_DATE(NULL),
             TO_CHAR(NULL),
             SUM(ARDTAX.ACCTD_AMOUNT_CR),
             SUM(ARDTAX.ACCTD_AMOUNT_DR),
             TO_CHAR(NULL),
             TO_CHAR(NULL),
             TO_CHAR(NULL),
             ZX_DET.CUSTOMER_TRX_ID,   --ARDTAX.LINE_ID,
             ''TRANSACTIONS'',  --ZX_DET.ENTITY_CODE,
             ADJ.GL_POSTED_DATE,
             ADJ.GL_DATE,
             TO_NUMBER(NULL),
             TO_NUMBER(NULL),
             TO_CHAR(NULL),
             TO_CHAR(NULL)';

Line: 5122

      'SELECT DISTINCT '||
            'ADJ.SET_OF_BOOKS_ID,
            ADJ.ADJUSTMENT_ID, '||
            'ADJ.DOC_SEQUENCE_ID,
            SEQ.NAME,'||
            'TO_NUMBER(NULL), '||
            '''ADJ'','||
            '''ADJ'',
            TO_CHAR(NULL),
            TO_NUMBER(NULL), '||
            'TO_CHAR(NULL),
            TO_CHAR(NULL),'||    --INV
            'TO_NUMBER(NULL),'|| -- Applied_to_trx_id -- adjusted_doc_id in eTax
            'TO_CHAR(NULL),'||   -- INV
            'ZX_DET.TRX_NUMBER,'||  --Applied_doc_number
            'ZX_DET.BATCH_SOURCE_ID,'||
            'ARDTAX.TAX_CODE_ID,'||
            'DECODE(ARDTAX.SOURCE_TYPE,''TAX'',''TAX'',''DEFERRED_TAX'',''INTERIM'',
                ''ADJ_NON_REC_TAX'',''NON-RECOVERABLE'',
                ''FINCHRG_NON_REC_TAX'',''NON-RECOVERABLE'',NULL),'|| -- REG. TYPE CODE
            'TO_NUMBER(NULL),'||
            'TO_CHAR(NULL),
            ARD.SOURCE_TABLE,
            ARD.SOURCE_ID,
            TO_NUMBER(NULL),'||
            'TO_NUMBER(NULL), ' ||
            '(nvl(ARDTAX.TAXABLE_ENTERED_CR,0) - nvl(ARDTAX.TAXABLE_ENTERED_DR,0)),'||--Total Amount
            'TO_NUMBER(NULL),
            (nvl(ARDTAX.AMOUNT_CR,0) - nvl(ARDTAX.AMOUNT_DR,0)),'||
            '(nvl(ARDTAX.ACCTD_AMOUNT_CR,0) - nvl(ARDTAX.ACCTD_AMOUNT_DR,0)),'||
            ' ARDTAX.TAX_LINK_ID, '||
            '(nvl(ARDTAX.TAXABLE_ENTERED_CR,0) - nvl(ARDTAX.TAXABLE_ENTERED_DR,0)),'||
            '(nvl(ARDTAX.TAXABLE_ACCOUNTED_CR,0) - nvl(ARDTAX.TAXABLE_ACCOUNTED_DR,0)),'|| -- ar matrix ++ 24
            'ARD.LINE_ID,
            TO_NUMBER(NULL),
            TO_CHAR(NULL),
            TO_CHAR(NULL),
            TO_CHAR(NULL),
            TO_CHAR(NULL), '||
            'DECODE(ARDTAX.SOURCE_TYPE_SECONDARY,''RECONCILE'',''Y'','||
            '''ASSIGNMENT_RECONCILE'',''Y'',''N''), ' ||
            'ZX_DET.ORG_ID,'||  -- Org_id
            'TO_NUMBER(NULL), ' ||
            -- 'TO_DATE(NULL),
            'TO_NUMBER(NULL),   --Applied_amount
            TO_NUMBER(NULL),   --tax_amount
            TO_NUMBER(NULL),
            TO_CHAR(NULL),
            TO_CHAR(NULL), '|| --ZX_RATE.VAT_TRANSACTION_TYPE_CODE,
            -- ZX_RATE.RATE_TYPE_CODE,
            'TO_CHAR(NULL),   --ZX_TAX.TAX_TYPE_CODE,
            TO_CHAR(NULL), --ZX_RATE.TAX_RATE_NAME,
            ADJ.ADJUSTMENT_NUMBER,
            TO_CHAR(NULL),  --ZX_DET.TRX_DESCRIPTION,
            ADJ.DOC_SEQUENCE_VALUE,
            ADJ.APPLY_DATE,
            TO_DATE(NULL),   --Deposit Date
            TO_DATE(NULL),    --ZX_DET.TRX_DUE_DATE,
            TO_DATE(NULL),    --ZX_DET.TRX_SHIPPING_DATE,
            TO_DATE(NULL),    --ZX_DET.TRX_COMMUNICATED_DATE,
            ZX_DET.INVOICE_CURRENCY_CODE ,
            TO_CHAR(NULL), --ZX_DET.CURRENCY_CONVERSION_TYPE,
            TO_DATE(NULL),   --ZX_DET.CURRENCY_CONVERSION_DATE,
            ZX_DET.EXCHANGE_RATE,  --ZX_DET.CURRENCY_CONVERSION_RATE,
            TO_CHAR(NULL),
            ZX_DET.FOB_POINT,
            ZX_DET.WAYBILL_NUMBER,'||
            'BAT.NAME,
            TYPES.DESCRIPTION,
            TO_CHAR(NULL),
            TO_CHAR(NULL),
            TO_NUMBER(NULL),
            TO_CHAR(NULL),
            TO_CHAR(NULL),
            TO_CHAR(NULL),
            TO_CHAR(NULL),
            TO_CHAR(NULL),
            TO_CHAR(NULL),
            TO_CHAR(NULL),
            TO_CHAR(NULL),
            TO_CHAR(NULL),
            TO_CHAR(NULL),
            TO_CHAR(NULL),
            TO_CHAR(NULL),
            TO_CHAR(NULL),
            TO_CHAR(NULL),
            TO_CHAR(NULL),
            TO_CHAR(NULL),
            TO_CHAR(NULL),
            NVL(ZX_DET.APPLICATION_ID,222),
            TO_CHAR(NULL),    --ZX_DET.DOC_EVENT_STATUS,
            TO_CHAR(NULL),    --ZX_DET.APPLICATION_DOC_STATUS,
            TO_NUMBER(NULL),  --ZX_DET.ESTABLISHMENT_ID,
            ''AR'', --EXTRACT_SOURCE_LEDGER,
            --ZX_DET.FUNCTIONAL_CURRECNY_CODE,
            --ZX_DET.LEDGER_NAME,
            TO_NUMBER(NULL), --ZX_DET.MINIMUM_ACCOUNTABLE_UNIT,
            TO_NUMBER(NULL), --ZX_DET.PRECISION,
            TO_NUMBER(NULL), --RECEIPT_CLASS_ID,
            TO_NUMBER(NULL), --ZX_DET.APPLIED_TO_APPLICATION_ID,
            TO_NUMBER(NULL), --ZX_DET.APPLIED_TO_TRX_LINE_ID,
            TO_CHAR(NULL),  --ZX_DET.APPLIED_TO_ENTITY_CODE,
            ZX_DET.CUSTOMER_TRX_ID, --ZX_DET.APPLIED_TO_TRX_ID,
            TO_CHAR(NULL),     --ZX_DET.APPLIED_TO_EVENT_CLASS_CODE,
            ZX_DET.TRX_NUMBER, --ZX_DET.APPLIED_TO_TRX_NUMBER,
            TO_NUMBER(NULL),   --ZX_DET.RELATED_DOC_APPLICATION_ID,
            TO_DATE(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.ADJUSTED_DOC_APPLICATION_ID,
            TO_DATE(NULL), --ZX_DET.ADJUSTED_DOC_DATE,
            --ZX_DET.BANKING_TP_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,
            TO_CHAR(NULL),   --ZX_RATE.DEF_REC_SETTLEMENT_OPTION_CODE,
            TO_CHAR(NULL),   --ZX_DET.DEFAULT_TAXATION_COUNTRY,
            TO_CHAR(NULL),   --ZX_DET.DOCUMENT_SUB_TYPE,
            TO_NUMBER(NULL), --ZX_DET.ASSESSABLE_VALUE,
            TO_CHAR(NULL),   --ZX_DET.TRX_BUSINESS_CATEGORY,
            TO_CHAR(NULL),   --ZX_DET.LINE_INTENDED_USE,
            TO_CHAR(NULL),   --ZX_DET.PRODUCT_CATEGORY,
            TO_CHAR(NULL),   --ZX_DET.PRODUCT_FISC_CLASSIFICATION,
            TO_NUMBER(NULL), --ZX_DET.SUPPLIER_EXCHANGE_RATE,
            TO_DATE(NULL),   --ZX_DET.SUPPLIER_TAX_INVOICE_DATE,
            TO_CHAR(NULL),   --ZX_DET.SUPPLIER_TAX_INVOICE_NUMBER,
            TO_CHAR(NULL),   --ZX_DET.USER_DEFINED_FISC_CLASS,
            TO_NUMBER(NULL),    --ZX_LINE.EXCEPTION_RATE,
            TO_NUMBER(NULL),    --ZX_LINE.EXEMPT_RATE_MODIFIER,
            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_CHAR(NULL),   --   ZX_RATE.RECOVERY_RATE_CODE,
            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_DATE(NULL),   --ZX_LINE.TAX_DATE,
            TO_DATE(NULL),   --ZX_LINE.TAX_DETERMINE_DATE,
            TO_DATE(NULL),   --ZX_DET.TAX_INVOICE_DATE,
            TO_CHAR(NULL),  --ZX_DET.TAX_INVOICE_NUMBER,
            TO_CHAR(NULL),  --ZX_RATE.TAX_JURISDICTION_CODE,
            TO_CHAR(NULL),  --ZX_RATE.TAX_REGIME_CODE,
            TO_CHAR(NULL),  --ZX_RATE.TAX_STATUS_CODE,
            TO_NUMBER(NULL),  --ZX_LINE.TAX_STATUS_ID,
            TO_CHAR(NULL),  --ZX_RATE.TAX,
            TO_NUMBER(NULL),  --ZX_DET.SHIP_FROM_PARTY_TAX_PROF_ID,
            TO_NUMBER(NULL),  --ZX_DET.SHIP_FROM_SITE_TAX_PROF_ID,
            TO_NUMBER(NULL),  --ZX_DET.SHIP_TO_PARTY_TAX_PROF_ID,
            TO_NUMBER(NULL),  --ZX_DET.SHIP_TO_SITE_TAX_PROF_ID,
            TO_NUMBER(NULL),  --ZX_DET.BILL_TO_PARTY_TAX_PROF_ID,
            TO_NUMBER(NULL),  --ZX_DET.BILL_TO_SITE_TAX_PROF_ID,
            TO_NUMBER(NULL),  --ZX_DET.SHIP_THIRD_PTY_ACCT_SITE_ID,
            TO_NUMBER(NULL),  --ZX_DET.BILL_THIRD_PTY_ACCT_SITE_ID,
            ZX_DET.SHIP_TO_SITE_USE_ID,  --ZX_DET.SHIP_TO_CUST_ACCT_SITE_USE_ID,
            ZX_DET.BILL_TO_SITE_USE_ID,   --ZX_DET.BILL_TO_CUST_ACCT_SITE_USE_ID,
            ZX_DET.SHIP_TO_CUSTOMER_ID,    --ZX_DET.SHIP_THIRD_PTY_ACCT_ID,
            ZX_DET.BILL_TO_CUSTOMER_ID,   --ZX_DET.BILL_THIRD_PTY_ACCT_ID,
            TO_CHAR(NULL),'||  --ZX_LINE.HQ_ESTB_REG_NUMBER,
            'TO_CHAR(NULL),'||  --zx_line.tax_registration_number
            'TO_CHAR(NULL),'||     --ZX_LINE.LEGAL_ENTITY_TAX_REG_NUMBER,
            'TO_NUMBER(NULL),   --ZX_DET.OWN_HQ_SITE_TAX_PROF_ID,
            TO_NUMBER(NULL),  --ZX_DET.OWN_HQ_PARTY_TAX_PROF_ID,
            TO_CHAR(NULL),   --ZX_DET.PORT_OF_ENTRY_CODE,
            TO_CHAR(NULL),'||     --ZX_LINE.REGISTRATION_PARTY_TYPE,
            'DECODE(ADJ.UPGRADE_METHOD, ''11I'', ''Y'',''11IMFAR'', ''Y'',''N''),'||     --ZX_LINE.HISTORICAL_FLAG,
            'TO_CHAR(NULL),'||     --ZX_LINE.MRC_TAX_LINE_FLAG,
            'DECODE(ADJ.POSTING_CONTROL_ID,-3, ''N'', ''Y'') POSTED_FLAG,'||     --POSTED_FLAG,
            'TO_CHAR(NULL),'||     --ZX_LINE.REPORTING_ONLY_FLAG,
            'TO_CHAR(NULL),'||     --ZX_LINE.TAX_AMT_INCLUDED_FLAG,
            'TO_CHAR(NULL),'||     --ZX_LINE.TAX_ONLY_LINE_FLAG
            'TO_NUMBER(NULL),   --ZX_DET.EVENT_CLASS_MAPPING_ID,
            TO_CHAR(NULL),   --ZX_DET.TRX_LEVEL_TYPE,
            TO_CHAR(NULL),       -- Place of supply type code
            TO_NUMBER(NULL),  --ZX_DET.POA_LOCATION_ID,
            TO_NUMBER(NULL),   --ZX_DET.POO_LOCATION_ID,
            TO_CHAR(NULL),       -- Default Place of supply type code
            TO_NUMBER(NULL), --ZX_DET.LINE_AMT,
            TO_NUMBER(NULL),
            TO_DATE(NULL),
            TO_CHAR(NULL),
            ARDTAX.ACCTD_AMOUNT_CR,
            ARDTAX.ACCTD_AMOUNT_DR,
            TO_CHAR(NULL),
            TO_CHAR(NULL),
            TO_CHAR(NULL),
            ARDTAX.LINE_ID,
            ''TRANSACTIONS'',  --ZX_DET.ENTITY_CODE,
            ADJ.GL_POSTED_DATE,
            ADJ.GL_DATE,
            TO_NUMBER(NULL),
            TO_NUMBER(NULL),
            TO_CHAR(NULL),
            TO_CHAR(NULL)';

Line: 5396

      'SELECT DISTINCT '||
            'ADJ.SET_OF_BOOKS_ID,
             ADJ.ADJUSTMENT_ID, '||
            'ADJ.DOC_SEQUENCE_ID,
             SEQ.NAME,'||
            'TO_NUMBER(NULL), '||
            '''ADJ'','||
            ' ''ADJ'',
             TO_CHAR(NULL),
             TO_NUMBER(NULL), '||
            'TO_CHAR(NULL),
            ZX_DET.ADJUSTED_DOC_ENTITY_CODE,'||    --INV
            'ZX_DET.ADJUSTED_DOC_TRX_ID,'|| -- Applied_to_trx_id -- adjusted_doc_id in eTax
            'ZX_DET.ADJUSTED_DOC_EVENT_CLASS_CODE,'||   -- INV
            'ZX_DET.ADJUSTED_DOC_NUMBER,'||  --Applied_doc_number
            'ZX_DET.BATCH_SOURCE_ID,'||
            'ARDTAX.TAX_CODE_ID,'||
            'DECODE(ARDTAX.SOURCE_TYPE,''TAX'',''TAX'',''DEFERRED_TAX'',''INTERIM'',
                ''ADJ_NON_REC_TAX'',''NON-RECOVERABLE'',
                ''FINCHRG_NON_REC_TAX'',''NON-RECOVERABLE'',NULL),'|| -- REG. TYPE CODE
             'TO_NUMBER(NULL),'||
            'TO_CHAR(NULL),
             ARD.SOURCE_TABLE,
             ARD.SOURCE_ID,
             TO_NUMBER(NULL),'||
            'TO_NUMBER(NULL), ' ||
            '(nvl(ARDTAX.TAXABLE_ENTERED_CR,0) - nvl(ARDTAX.TAXABLE_ENTERED_DR,0)),'||--Total Amount
            'TO_NUMBER(NULL),
            (nvl(ARDTAX.AMOUNT_CR,0) - nvl(ARDTAX.AMOUNT_DR,0)),'||
            '(nvl(ARDTAX.ACCTD_AMOUNT_CR,0) - nvl(ARDTAX.ACCTD_AMOUNT_DR,0)),'||
            ' TO_NUMBER(NULL), '||
            '(nvl(ARDTAX.TAXABLE_ENTERED_CR,0) - nvl(ARDTAX.TAXABLE_ENTERED_DR,0)),'||
            '(nvl(ARDTAX.TAXABLE_ACCOUNTED_CR,0) - nvl(ARDTAX.TAXABLE_ACCOUNTED_DR,0)),'|| -- ar matrix ++ 24
            'ARD.LINE_ID,
             TO_NUMBER(NULL),
             TO_CHAR(NULL),
            TO_CHAR(NULL),
             TO_CHAR(NULL),
             TO_CHAR(NULL), '||
            'DECODE(ARDTAX.SOURCE_TYPE_SECONDARY,''RECONCILE'',''Y'','||
            ' ''ASSIGNMENT_RECONCILE'',''Y'',''N''), ' ||
            'ZX_DET.INTERNAL_ORGANIZATION_ID,'||  -- Org_id
            'TO_NUMBER(NULL), ' ||
           -- 'TO_DATE(NULL),
            'TO_NUMBER(NULL),   --Applied_amount
             TO_NUMBER(NULL),   --tax_amount
             ZX_RATE.PERCENTAGE_RATE,
             ZX_RATE.TAX_RATE_CODE,
             ZX_RATE.VAT_TRANSACTION_TYPE_CODE,
       --      ZX_RATE.RATE_TYPE_CODE,
       ZX_TAX.TAX_TYPE_CODE,
             ZX_RATE.TAX_RATE_NAME,
             ADJ.ADJUSTMENT_NUMBER,
              ZX_DET.TRX_DESCRIPTION,
              ADJ.DOC_SEQUENCE_VALUE,
              ADJ.APPLY_DATE,
              TO_DATE(NULL),   --Deposit Date
              ZX_DET.TRX_DUE_DATE,
              ZX_DET.TRX_SHIPPING_DATE,
              ZX_DET.TRX_COMMUNICATED_DATE,
              ZX_DET.TRX_CURRENCY_CODE,
              ZX_DET.CURRENCY_CONVERSION_TYPE,
              ZX_DET.CURRENCY_CONVERSION_DATE,
              ZX_DET.CURRENCY_CONVERSION_RATE,
              TO_CHAR(NULL),
              ZX_DET.FOB_POINT,
              ZX_DET.TRX_WAYBILL_NUMBER,'||
             'ZX_DET.BATCH_SOURCE_NAME,
              ZX_DET.TRX_TYPE_DESCRIPTION,
        ZX_RATE.DESCRIPTION,
              TO_CHAR(NULL),
               TO_NUMBER(NULL),
               TO_CHAR(NULL),
             TO_CHAR(NULL),
              TO_CHAR(NULL),
              TO_CHAR(NULL),
              TO_CHAR(NULL),
              TO_CHAR(NULL),
              TO_CHAR(NULL),
              TO_CHAR(NULL),
              TO_CHAR(NULL),
              TO_CHAR(NULL),
              TO_CHAR(NULL),
              TO_CHAR(NULL),
              TO_CHAR(NULL),
              TO_CHAR(NULL),
              TO_CHAR(NULL),
              TO_CHAR(NULL),
              TO_CHAR(NULL),
             ZX_DET.APPLICATION_ID,
              ZX_DET.DOC_EVENT_STATUS,
         ZX_DET.APPLICATION_DOC_STATUS,
              ZX_DET.ESTABLISHMENT_ID,
              ''AR'', --EXTRACT_SOURCE_LEDGER,
              --ZX_DET.FUNCTIONAL_CURRECNY_CODE,
              --ZX_DET.LEDGER_NAME,
              ZX_DET.MINIMUM_ACCOUNTABLE_UNIT,
              ZX_DET.PRECISION,
              TO_NUMBER(NULL), --RECEIPT_CLASS_ID,
              ZX_DET.APPLIED_TO_APPLICATION_ID,
              ZX_DET.APPLIED_TO_TRX_LINE_ID,
              ZX_DET.APPLIED_TO_ENTITY_CODE,
              ZX_DET.APPLIED_TO_TRX_ID,
              ZX_DET.APPLIED_TO_EVENT_CLASS_CODE,
              ZX_DET.APPLIED_TO_TRX_NUMBER,
              ZX_DET.RELATED_DOC_APPLICATION_ID,
              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.ADJUSTED_DOC_APPLICATION_ID,
              ZX_DET.ADJUSTED_DOC_DATE,
              --ZX_DET.BANKING_TP_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_RATE.DEF_REC_SETTLEMENT_OPTION_CODE,
              ZX_DET.DEFAULT_TAXATION_COUNTRY,
              ZX_DET.DOCUMENT_SUB_TYPE,
         ZX_DET.ASSESSABLE_VALUE,
              ZX_DET.TRX_BUSINESS_CATEGORY,
              ZX_DET.LINE_INTENDED_USE,
              ZX_DET.PRODUCT_CATEGORY,
              ZX_DET.PRODUCT_FISC_CLASSIFICATION,
              ZX_DET.SUPPLIER_EXCHANGE_RATE,
              ZX_DET.SUPPLIER_TAX_INVOICE_DATE,
              ZX_DET.SUPPLIER_TAX_INVOICE_NUMBER,
              ZX_DET.USER_DEFINED_FISC_CLASS,
              TO_NUMBER(NULL),    --ZX_LINE.EXCEPTION_RATE,
              TO_NUMBER(NULL),    --ZX_LINE.EXEMPT_RATE_MODIFIER,
              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_CHAR(NULL),   --   ZX_RATE.RECOVERY_RATE_CODE,
              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_DATE(NULL),   --ZX_LINE.TAX_DATE,
              TO_DATE(NULL),   --ZX_LINE.TAX_DETERMINE_DATE,
              TO_DATE(NULL),   --ZX_DET.TAX_INVOICE_DATE,
              TO_CHAR(NULL),  --ZX_DET.TAX_INVOICE_NUMBER,
              ZX_RATE.TAX_JURISDICTION_CODE,
              ZX_RATE.TAX_REGIME_CODE,
              ZX_RATE.TAX_STATUS_CODE,
              TO_NUMBER(NULL),  --ZX_LINE.TAX_STATUS_ID,
              ZX_RATE.TAX,
              ZX_DET.SHIP_FROM_PARTY_TAX_PROF_ID,
              ZX_DET.SHIP_FROM_SITE_TAX_PROF_ID,
              ZX_DET.SHIP_TO_PARTY_TAX_PROF_ID,
              ZX_DET.SHIP_TO_SITE_TAX_PROF_ID,
              ZX_DET.BILL_TO_PARTY_TAX_PROF_ID,
              ZX_DET.BILL_TO_SITE_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_CHAR(NULL),'||  --ZX_LINE.HQ_ESTB_REG_NUMBER,
              'TO_CHAR(NULL),'||  --zx_line.tax_registration_number
              'TO_CHAR(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),'||     --ZX_LINE.HISTORICAL_FLAG,
              'TO_CHAR(NULL),'||     --ZX_LINE.MRC_TAX_LINE_FLAG,
          'DECODE(ADJ.GL_POSTED_DATE, NULL, ''N'', ''Y'') POSTED_FLAG,'||     --POSTED_FLAG,
              'TO_CHAR(NULL),'||     --ZX_LINE.REPORTING_ONLY_FLAG,
              'TO_CHAR(NULL),'||     --ZX_LINE.TAX_AMT_INCLUDED_FLAG,
              'TO_CHAR(NULL),'||     --ZX_LINE.TAX_ONLY_LINE_FLAG
              'ZX_DET.EVENT_CLASS_MAPPING_ID,
         ZX_DET.TRX_LEVEL_TYPE,
         TO_CHAR(NULL),       -- Place of supply type code
         ZX_DET.POA_LOCATION_ID,
         ZX_DET.POO_LOCATION_ID,
         TO_CHAR(NULL),       -- Default Place of supply type code
         ZX_DET.LINE_AMT,
         TO_NUMBER(NULL),
         TO_DATE(NULL),
         TO_CHAR(NULL),
         ARDTAX.ACCTD_AMOUNT_CR,
         ARDTAX.ACCTD_AMOUNT_DR,
         TO_CHAR(NULL),
         TO_CHAR(NULL),
         TO_CHAR(NULL),
         ARDTAX.LINE_ID,
   ZX_DET.ENTITY_CODE,
   ADJ.GL_POSTED_DATE,
         ADJ.GL_DATE,
         TO_NUMBER(NULL),
         TO_NUMBER(NULL),
   TO_CHAR(NULL),
   TO_CHAR(NULL)';

Line: 5675

      'SELECT DISTINCT '||
            'ADJ.SET_OF_BOOKS_ID,
             ADJ.ADJUSTMENT_ID, '||
            'ADJ.DOC_SEQUENCE_ID,
             SEQ.NAME,'||
            'TO_NUMBER(NULL), '||
            '''ADJ'','||
            ' ZX_DET.EVENT_CLASS_CODE,
             TO_CHAR(NULL),
             TO_NUMBER(NULL), '||
            'TO_CHAR(NULL),
            ZX_DET.ADJUSTED_DOC_ENTITY_CODE,'||    --INV
            'ZX_DET.ADJUSTED_DOC_TRX_ID,'|| -- Applied_to_trx_id -- adjusted_doc_id in eTax
            'ZX_DET.ADJUSTED_DOC_EVENT_CLASS_CODE,'||
            'ZX_DET.TRX_NUMBER,'||  --Applied_doc_number
            'TO_NUMBER(NULL),'|| --ZX_DET.BATCH_SOURCE_ID
            'ARDTAX.TAX_CODE_ID,'||
            'DECODE(ARDTAX.SOURCE_TYPE,''TAX'',''TAX'',''DEFERRED_TAX'',''INTERIM'',
                ''ADJ_NON_REC_TAX'',''NON-RECOVERABLE'',
                ''FINCHRG_NON_REC_TAX'',''NON-RECOVERABLE'',NULL),'|| -- REG. TYPE CODE
             'TO_NUMBER(NULL),'||
            'TO_CHAR(NULL),
             ARD.SOURCE_TABLE,
             ARD.SOURCE_ID,
             TO_NUMBER(NULL),'||
            'TO_NUMBER(NULL), ' ||
            'sum((nvl(ARDTAX.TAXABLE_ENTERED_CR,0) - nvl(ARDTAX.TAXABLE_ENTERED_DR,0))),'||--Total Amount
            'TO_NUMBER(NULL),
            SUM((nvl(ARDTAX.AMOUNT_CR,0) - nvl(ARDTAX.AMOUNT_DR,0))),'||
            'sum((nvl(ARDTAX.ACCTD_AMOUNT_CR,0) - nvl(ARDTAX.ACCTD_AMOUNT_DR,0))),'||
            'ARDTAX.TAX_LINK_ID, '||  -- Tax Line number populating with tax_link_id
            'sum((nvl(ARDTAX.TAXABLE_ENTERED_CR,0) - nvl(ARDTAX.TAXABLE_ENTERED_DR,0))),'||
            'sum((nvl(ARDTAX.TAXABLE_ACCOUNTED_CR,0) - nvl(ARDTAX.TAXABLE_ACCOUNTED_DR,0))),'|| -- ar matrix ++ 24
           -- 'to_number(NULL),
             'ard.line_id,
             TO_NUMBER(NULL),
             TO_CHAR(NULL),
            TO_CHAR(NULL),
             TO_CHAR(NULL),
             TO_CHAR(NULL), '||
            'DECODE(ARDTAX.SOURCE_TYPE_SECONDARY,''RECONCILE'',''Y'','||
            ' ''ASSIGNMENT_RECONCILE'',''Y'',''N''), ' ||
            'ZX_DET.INTERNAL_ORGANIZATION_ID,'||  -- Org_id
            'TO_NUMBER(NULL), ' ||
           -- 'TO_DATE(NULL),
            'TO_NUMBER(NULL),   --Applied_amount
             TO_NUMBER(NULL),   --tax_amount
             TO_NUMBER(NULL),
             TO_CHAR(NULL),
             ZX_RATE.VAT_TRANSACTION_TYPE_CODE,' ||
       --      ZX_RATE.RATE_TYPE_CODE,
             'to_char(NULL),'||    --ZX_TAX.TAX_TYPE_CODE,
             'ZX_RATE.TAX_RATE_NAME,
             ADJ.ADJUSTMENT_NUMBER,
              TO_CHAR(NULL),'||  --ZX_DET.TRX_DESCRIPTION,
              'ADJ.DOC_SEQUENCE_VALUE,
              ADJ.APPLY_DATE,
              TO_DATE(NULL), '||  --Deposit Date
              'TO_DATE(NULL), '||   --ZX_DET.TRX_DUE_DATE,
              'TO_DATE(NULL), '||   --ZX_DET.TRX_SHIPPING_DATE,
              'TO_DATE(NULL), '||   --ZX_DET.TRX_COMMUNICATED_DATE,
              'ZX_DET.TRX_CURRENCY_CODE ,'||
              'TO_CHAR(NULL),'|| --ZX_DET.CURRENCY_CONVERSION_TYPE,
              'TO_DATE(NULL),'||   --ZX_DET.CURRENCY_CONVERSION_DATE,
              'TO_NUMBER(NULL),'||  --ZX_DET.CURRENCY_CONVERSION_RATE,
              'TO_CHAR(NULL),
              ZX_DET.FOB_POINT,
              ZX_DET.TRX_WAYBILL_NUMBER,'||
             'TO_CHAR(NULL),'||--BAT.NAME,
              'TO_CHAR(NULL),'||--TYPES.DESCRIPTION,
        'to_char(null),
              TO_CHAR(NULL),
               TO_NUMBER(NULL),
               TO_CHAR(NULL),
             TO_CHAR(NULL),
              TO_CHAR(NULL),
              TO_CHAR(NULL),
              TO_CHAR(NULL),
              TO_CHAR(NULL),
              TO_CHAR(NULL),
              TO_CHAR(NULL),
              TO_CHAR(NULL),
              TO_CHAR(NULL),
              TO_CHAR(NULL),
              TO_CHAR(NULL),
              TO_CHAR(NULL),
              TO_CHAR(NULL),
              TO_CHAR(NULL),
              TO_CHAR(NULL),
              TO_CHAR(NULL),
              ZX_DET.APPLICATION_ID,
              TO_CHAR(NULL),'||    --ZX_DET.DOC_EVENT_STATUS,
              'TO_CHAR(NULL),'||    --ZX_DET.APPLICATION_DOC_STATUS,
              'TO_NUMBER(NULL),'||  --ZX_DET.ESTABLISHMENT_ID,
              '''AR'','|| --EXTRACT_SOURCE_LEDGER,
              --ZX_DET.FUNCTIONAL_CURRECNY_CODE,
              --ZX_DET.LEDGER_NAME,
              'TO_NUMBER(NULL),'|| --ZX_DET.MINIMUM_ACCOUNTABLE_UNIT,
              'TO_NUMBER(NULL),'|| --ZX_DET.PRECISION,
              'TO_NUMBER(NULL),'|| --RECEIPT_CLASS_ID,
              'TO_NUMBER(NULL),'|| --ZX_DET.APPLIED_TO_APPLICATION_ID,
              'ZX_DET.ADJUSTED_DOC_LINE_ID,'|| --ZX_DET.APPLIED_TO_TRX_LINE_ID,
              'TO_CHAR(NULL),'||  --ZX_DET.APPLIED_TO_ENTITY_CODE,
              'TO_NUMBER(NULL),'|| --ZX_DET.APPLIED_TO_TRX_ID,
              'TO_CHAR(NULL),'||   --ZX_DET.APPLIED_TO_EVENT_CLASS_CODE,
              'TO_CHAR(NULL),'||   --ZX_DET.APPLIED_TO_TRX_NUMBER,
              'TO_NUMBER(NULL),'|| --ZX_DET.RELATED_DOC_APPLICATION_ID,
              'TO_DATE(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,
              'ZX_DET.ADJUSTED_DOC_APPLICATION_ID, '||--ZX_DET.ADJUSTED_DOC_APPLICATION_ID,
              'ZX_DET.ADJUSTED_DOC_DATE, '||--ZX_DET.ADJUSTED_DOC_DATE,
              --ZX_DET.BANKING_TP_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,
              'TO_CHAR(NULL), '||  --ZX_RATE.DEF_REC_SETTLEMENT_OPTION_CODE,
              'TO_CHAR(NULL), '||  --ZX_DET.DEFAULT_TAXATION_COUNTRY,
              'TO_CHAR(NULL), '||  --ZX_DET.DOCUMENT_SUB_TYPE,
              'TO_NUMBER(NULL),'|| --ZX_DET.ASSESSABLE_VALUE,
              'TO_CHAR(NULL), '||  --ZX_DET.TRX_BUSINESS_CATEGORY,
              'TO_CHAR(NULL), '||  --ZX_DET.LINE_INTENDED_USE,
              'TO_CHAR(NULL), '||  --ZX_DET.PRODUCT_CATEGORY,
              'TO_CHAR(NULL), '||  --ZX_DET.PRODUCT_FISC_CLASSIFICATION,
              'TO_NUMBER(NULL),'|| --ZX_DET.SUPPLIER_EXCHANGE_RATE,
              'TO_DATE(NULL), '||  --ZX_DET.SUPPLIER_TAX_INVOICE_DATE,
              'TO_CHAR(NULL), '||  --ZX_DET.SUPPLIER_TAX_INVOICE_NUMBER,
              'TO_CHAR(NULL), '||  --ZX_DET.USER_DEFINED_FISC_CLASS,
              'TO_NUMBER(NULL), '||   --ZX_LINE.EXCEPTION_RATE,
              'TO_NUMBER(NULL), '||   --ZX_LINE.EXEMPT_RATE_MODIFIER,
              '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_CHAR(NULL),  '|| --   ZX_RATE.RECOVERY_RATE_CODE,
              '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_DATE(NULL), '||  --ZX_LINE.TAX_DATE,
              'TO_DATE(NULL), '||  --ZX_LINE.TAX_DETERMINE_DATE,
              'TO_DATE(NULL), '||  --ZX_DET.TAX_INVOICE_DATE,
              'TO_CHAR(NULL),'||  --ZX_DET.TAX_INVOICE_NUMBER,
              'ZX_RATE.TAX_JURISDICTION_CODE,
              ZX_RATE.TAX_REGIME_CODE,
              ZX_RATE.TAX_STATUS_CODE,
              TO_NUMBER(NULL), '|| --ZX_LINE.TAX_STATUS_ID,
              'ZX_RATE.TAX,
              ZX_DET.SHIP_FROM_PARTY_TAX_PROF_ID,
              ZX_DET.SHIP_FROM_SITE_TAX_PROF_ID,
              ZX_DET.SHIP_TO_PARTY_TAX_PROF_ID,
              ZX_DET.SHIP_TO_SITE_TAX_PROF_ID,
              ZX_DET.BILL_TO_PARTY_TAX_PROF_ID,
              ZX_DET.BILL_TO_SITE_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_CHAR(NULL),'||  --ZX_LINE.HQ_ESTB_REG_NUMBER,
              'TO_CHAR(NULL),'||  --zx_line.tax_registration_number
              'TO_CHAR(NULL),'||     --ZX_LINE.LEGAL_ENTITY_TAX_REG_NUMBER,
              'TO_NUMBER(NULL),'||   --ZX_DET.OWN_HQ_SITE_TAX_PROF_ID,
              'TO_NUMBER(NULL),'||  --ZX_DET.OWN_HQ_PARTY_TAX_PROF_ID,
              'TO_CHAR(NULL), '||  --ZX_DET.PORT_OF_ENTRY_CODE,
              'TO_CHAR(NULL),'||     --ZX_LINE.REGISTRATION_PARTY_TYPE,
              'TO_CHAR(NULL),'||     --ZX_LINE.HISTORICAL_FLAG,
              'TO_CHAR(NULL),'||     --ZX_LINE.MRC_TAX_LINE_FLAG,
              'DECODE(ADJ.POSTING_CONTROL_ID,-3, ''N'', ''Y''),'||-- POSTED_FLAG,'||     --POSTED_FLAG,
              'TO_CHAR(NULL),'||     --ZX_LINE.REPORTING_ONLY_FLAG,
              'TO_CHAR(NULL),'||     --ZX_LINE.TAX_AMT_INCLUDED_FLAG,
              'TO_CHAR(NULL),'||     --ZX_LINE.TAX_ONLY_LINE_FLAG
              'TO_NUMBER(NULL),'||   --ZX_DET.EVENT_CLASS_MAPPING_ID,
              'TO_CHAR(NULL),'||   --ZX_DET.TRX_LEVEL_TYPE,
              'TO_CHAR(NULL), '||      -- Place of supply type code
              'TO_NUMBER(NULL),'||  --ZX_DET.POA_LOCATION_ID,
              'TO_NUMBER(NULL),'||   --ZX_DET.POO_LOCATION_ID,
              'TO_CHAR(NULL), '||      -- Default Place of supply type code
              'TO_NUMBER(NULL), '||--ZX_DET.LINE_AMT,
              'TO_NUMBER(NULL),
              TO_DATE(NULL),
              TO_CHAR(NULL),
              SUM(ARDTAX.ACCTD_AMOUNT_CR),
              sum(ARDTAX.ACCTD_AMOUNT_DR),
              TO_CHAR(NULL),
              TO_CHAR(NULL),
              TO_CHAR(NULL),
              ZX_DET.TRX_ID, '||  --ARDTAX.LINE_ID,
              'TO_CHAR(NULL), '|| --ZX_DET.ENTITY_CODE,
              'ADJ.GL_POSTED_DATE,
              ADJ.GL_DATE,
              TO_NUMBER(NULL),
              TO_NUMBER(NULL),
              TO_CHAR(NULL),
              TO_CHAR(NULL)';

Line: 6001

      'SELECT  '||
           'ARCS.SET_OF_BOOKS_ID,
             ARCS.CASH_RECEIPT_ID,'||
            'ARCS.DOC_SEQUENCE_ID,
             SEQ.NAME,'||
            'TO_NUMBER(NULL),'||
            '''MISC_CASH_RECEIPT'','||
            '''MISC_CASH_RECEIPT'',
             TO_CHAR(NULL),
             TO_NUMBER(NULL), '||
            'TO_CHAR(NULL),
             TO_CHAR(NULL),
             TO_NUMBER(NULL),'||
            'TO_CHAR(NULL),
             TO_CHAR(NULL),
            TO_NUMBER(NULL),'||
            'ARDTAX.TAX_CODE_ID,'||
            '''TAX'','|| -- REGISTER TYPE CODE
             'TO_NUMBER(NULL),'||
            'TO_CHAR(NULL),
             ARD.SOURCE_TABLE,
             ARD.SOURCE_ID,
             TO_NUMBER(NULL) ,'||
            'TO_NUMBER(NULL), ' ||
            'nvl(ARDTAX.TAXABLE_ENTERED_CR,0) - nvl(ARDTAX.TAXABLE_ENTERED_DR,0) ,'|| -- Total Amount
            'TO_NUMBER(NULL),
            nvl(ARDTAX.AMOUNT_CR,0) - nvl(ARDTAX.AMOUNT_DR,0),'||
            'nvl(ARDTAX.ACCTD_AMOUNT_CR,0) - nvl(ARDTAX.ACCTD_AMOUNT_DR,0) ,'||
            ' TO_NUMBER(NULL), '||
            'nvl(ARDTAX.TAXABLE_ENTERED_CR,0) - nvl(ARDTAX.TAXABLE_ENTERED_DR,0) ,'||
            'nvl(ARDTAX.TAXABLE_ACCOUNTED_CR,0) - nvl(ARDTAX.TAXABLE_ACCOUNTED_DR,0),'|| -- ar matrix ++ 25
            'ARD.LINE_ID,
             TO_NUMBER(NULL),
             TO_CHAR(NULL),
             TO_CHAR(NULL),
             TO_CHAR(NULL),
             TO_CHAR(NULL),'||
             '''N'', ' ||
            'DIST.ORG_ID,
            TO_NUMBER(NULL), ' ||
        --'ARCS.REVERSAL_DATE,
            'TO_NUMBER(NULL),   --amount_applied
             TO_NUMBER(NULL),  --tax_applied
             ZX_RATE.PERCENTAGE_RATE,  --ZX_TAX.PERCENTAGE_RATE,
             ZX_RATE.TAX_RATE_CODE,
             ZX_RATE.VAT_TRANSACTION_TYPE_CODE,
       --      ZX_RATE.RATE_TYPE_CODE,
       ZX_TAX.TAX_TYPE_CODE,
             ZX_RATE.TAX_RATE_NAME,
             ARCS.RECEIPT_NUMBER,
              TO_CHAR(NULL),
              ARCS.DOC_SEQUENCE_VALUE,
              ARCS.RECEIPT_DATE,
             ARCS.DEPOSIT_DATE,
              TO_DATE(NULL), ' ||
             'TO_DATE(NULL),
              TO_DATE(NULL),
              ARCS.CURRENCY_CODE,
              ARCS.EXCHANGE_RATE_TYPE,
              ARCS.EXCHANGE_DATE,
              ARCS.EXCHANGE_RATE,
              TO_CHAR(NULL),
              TO_CHAR(NULL),
              TO_CHAR(NULL),
              TO_CHAR(NULL),
              ARCS.TYPE,
        ZX_RATE.DESCRIPTION,
              TO_CHAR(NULL),
               TO_NUMBER(NULL),
               ARD.SOURCE_TYPE,
             TO_CHAR(NULL),
              TO_CHAR(NULL),
              TO_CHAR(NULL),
              TO_CHAR(NULL),
              TO_CHAR(NULL),
              TO_CHAR(NULL),
              TO_CHAR(NULL),
              TO_CHAR(NULL),
              TO_CHAR(NULL),
              TO_CHAR(NULL),
              TO_CHAR(NULL),
              TO_CHAR(NULL),
              TO_CHAR(NULL),
              TO_CHAR(NULL),
              TO_CHAR(NULL),
              TO_CHAR(NULL),
              222 ,--ZX_DET.APPLICATION_ID,
              TO_CHAR(NULL)  ,--ZX_DET.DOC_EVENT_STATUS,
              TO_CHAR(NULL)  ,--ZX_DET.APPLICATION_DOC_STATUS,
              TO_NUMBER(NULL) ,-- ZX_DET.ESTABLISHMENT_ID,
              ''AR'',    --EXTRACT_SOURCE_LEDGER,
             --TO_CHAR(NULL)  ,--ZX_DET.FUNCTIONAL_CURRECNY_CODE,
             --TO_CHAR(NULL)  ,--ZX_DET.LEDGER_NAME,
              TO_NUMBER(NULL)  ,--ZX_DET.MINIMUM_ACCOUNTABLE_UNIT,
              TO_NUMBER(NULL) ,-- ZX_DET.PRECISION,
              ARM.RECEIPT_CLASS_ID ,-- RECEIPT_CLASS_ID,   --Check this
              TO_NUMBER(NULL)  ,--ZX_DET.APPLIED_TO_APPLICATION_ID,
              TO_NUMBER(NULL)  ,--ZX_DET.APPLIED_TO_TRX_LINE_ID
              TO_CHAR(NULL)  ,--ZX_DET.APPLIED_TO_ENTITY_CODE,
              TO_NUMBER(NULL)  ,--ZX_DET.APPLIED_TO_TRX_ID,
              TO_CHAR(NULL)  ,--ZX_DET.APPLIED_TO_EVENT_CLASS_CODE
              TO_CHAR(NULL), -- ZX_DET.APPLIED_TO_TRX_NUMBER
              TO_NUMBER(NULL), -- ZX_DET.RELATED_DOC_APPLICATION_ID,
              TO_DATE(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.ADJUSTED_DOC_APPLICATION_ID
              TO_DATE(NULL), -- ZX_DET.ADJUSTED_DOC_DATE,
            --TO_CHAR(NULL)  ,--ZX_DET.BANKING_TP_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,
              TO_CHAR(NULL)  ,--ZX_DET.DEF_REC_SETTLEMENT_OPTION_CODE,
              TO_CHAR(NULL) , --ZX_DET.DEFAULT_TAXATION_COUNTRY,
              TO_CHAR(NULL) , --ZX_DET.DOCUMENT_SUB_TYPE,
              TO_CHAR(NULL),  --ZX_DET.ASSESSABLE_VALUE,
              TO_CHAR(NULL) , --ZX_DET.TRX_BUSINESS_CATEGORY,
              TO_CHAR(NULL) , --ZX_DET.LINE_INTENDED_USE,
              TO_CHAR(NULL) , --ZX_DET.PRODUCT_CATEGORY,
              TO_CHAR(NULL) , --ZX_DET.PRODUCT_FISC_CLASSIFICATION,
              TO_NUMBER(NULL) ,-- ZX_DET.SUPPLIER_EXCHANGE_RATE,
              TO_DATE(NULL)  , --ZX_DET.SUPPLIER_TAX_INVOICE_DATE,
              TO_CHAR(NULL)  ,--ZX_DET.SUPPLIER_TAX_INVOICE_NUMBER,
              TO_CHAR(NULL) , --ZX_DET.USER_DEFINED_FISC_CLASS,
              TO_NUMBER(NULL), -- ZX_DET.EXCEPTION_RATE,
              TO_NUMBER(NULL)  ,--ZX_DET.EXEMPT_RATE_MODIFIER,
              TO_NUMBER(NULL) , --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_CHAR(NULL),      --ZX_RATE.RECOVERY_RATE_CODE,
              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_DATE(NULL),  --ZX_LINE.TAX_DATE,
              TO_DATE(NULL),  --ZX_LINE.TAX_DETERMINE_DATE,
              TO_DATE(NULL),  --ZX_LINE.TAX_INVOICE_DATE,
              TO_CHAR(NULL),   --ZX_LINE.TAX_INVOICE_NUMBER,
              ZX_RATE.TAX_JURISDICTION_CODE,
              ZX_RATE.TAX_REGIME_CODE,
              ZX_RATE.TAX_STATUS_CODE,
              TO_NUMBER(NULL),  --ZX_LINE.TAX_STATUS_ID,
              ZX_RATE.TAX,
              TO_NUMBER(NULL), -- ZX_DET.SHIP_FROM_PARTY_TAX_PROF_ID,
              TO_NUMBER(NULL), -- ZX_DET.SHIP_FROM_SITE_TAX_PROF_ID,
              TO_NUMBER(NULL), -- ZX_DET.SHIP_TO_PARTY_TAX_PROF_ID,
              TO_NUMBER(NULL), -- ZX_DET.SHIP_TO_SITE_TAX_PROF_ID,
              TO_NUMBER(NULL), -- ZX_DET.BILL_TO_PARTY_TAX_PROF_ID,
              TO_NUMBER(NULL), -- ZX_DET.BILL_TO_SITE_TAX_PROF_ID,
              TO_NUMBER(NULL), -- ZX_DET.SHIP_FROM_PARTY_TAX_PROF_ID,
              TO_NUMBER(NULL), -- ZX_DET.SHIP_FROM_SITE_TAX_PROF_ID,
              TO_NUMBER(NULL), -- ZX_DET.SHIP_TO_PARTY_TAX_PROF_ID,
              TO_NUMBER(NULL), -- ZX_DET.SHIP_TO_SITE_TAX_PROF_ID,
              TO_NUMBER(NULL), -- ZX_DET.BILL_TO_PARTY_TAX_PROF_ID,
              TO_NUMBER(NULL), -- ZX_DET.BILL_TO_SITE_TAX_PROF_ID,
              TO_CHAR(NULL),'||  --ZX_LINE.HQ_ESTB_REG_NUMBER,
              'TO_CHAR(NULL),'||  --zx_line.tax_registration_number
              'TO_CHAR(NULL),'||     --ZX_LINE.LEGAL_ENTITY_TAX_REG_NUMBER,
              'TO_NUMBER(NULL), -- ZX_DET.OWN_HQ_PARTY_SITE_PROF_ID,
              TO_NUMBER(NULL), -- ZX_DET.OWN_HQ_PARTY_TAX_PROF_ID,
              TO_CHAR(NULL) ,  --ZX_DET.PORT_OF_ENTRY_CODE,
              TO_CHAR(NULL),'||     --ZX_LINE.REGISTRATION_PARTY_TYPE
              'TO_CHAR(NULL),'||     --ZX_LINE.HISTORICAL_FLAG
              'TO_CHAR(NULL),'||     --ZX_LINE.MRC_TAX_LINE_FLAG
        'DECODE(DIST.GL_POSTED_DATE, NULL, ''N'', ''Y'') POSTED_FLAG,'||     --POSTED_FLAG
              'TO_CHAR(NULL),'||     --ZX_LINE.REPORTING_ONLY_FLAG
              'TO_CHAR(NULL),'||     --ZX_LINE.TAX_AMT_INCLUDED_FLAG
              'TO_CHAR(NULL),'||     --ZX_LINE.TAX_ONLY_FLAG
         'TO_NUMBER(NULL) ,-- ZX_DET.EVENT_CLASS_MAPPING_ID,
         TO_CHAR(NULL)  ,--ZX_DET.TRX_LEVEL_TYPE,
         TO_CHAR(NULL),       -- Place of supply type code
         TO_NUMBER(NULL), -- ZX_DET.POA_LOCATION_ID,
         TO_NUMBER(NULL), -- ZX_DET.POO_LOCATION_ID,
         TO_CHAR(NULL),       -- Default Place of supply type code
         TO_NUMBER(NULL), -- ZX_DET.LINE_AMT,
         TO_NUMBER(NULL),
         ARCS.REVERSAL_DATE,
         ARCS.STATUS,
        -- sum(ARDTAX.ACCTD_AMOUNT_CR),
        -- sum(ARDTAX.ACCTD_AMOUNT_DR),
         ARDTAX.ACCTD_AMOUNT_CR,
         ARDTAX.ACCTD_AMOUNT_DR,
         TO_CHAR(NULL),
         TO_CHAR(NULL),
         TO_CHAR(NULL),
         ARCS.CASH_RECEIPT_ID ,
   ''RECEIPTS'',   --ZX_DET.ENTITY_CODE,
         DIST.GL_POSTED_DATE,
         DIST.GL_DATE,
         TO_NUMBER(NULL),
         ARCS.REMITTANCE_BANK_ACCOUNT_ID ,
   TO_CHAR(NULL),
   TO_CHAR(NULL)';

Line: 6275

      'SELECT  '||
           'ARCS.SET_OF_BOOKS_ID,
             ARCS.CASH_RECEIPT_ID,'||
            'ARCS.DOC_SEQUENCE_ID,
             SEQ.NAME,'||
            'TO_NUMBER(NULL),'||
            '''MISC_CASH_RECEIPT'','||
            '''MISC_CASH_RECEIPT'',
             TO_CHAR(NULL),
             TO_NUMBER(NULL), '||
            'TO_CHAR(NULL),
             TO_CHAR(NULL),
             TO_NUMBER(NULL),'||
            'TO_CHAR(NULL),
             TO_CHAR(NULL),
            TO_NUMBER(NULL),'||
            'ARDTAX.TAX_CODE_ID,'||
            '''TAX'','|| -- REGISTER TYPE CODE
             'TO_NUMBER(NULL),'||
            'TO_CHAR(NULL),
             ARD.SOURCE_TABLE,
             ARD.SOURCE_ID,
             TO_NUMBER(NULL) ,'||
            'TO_NUMBER(NULL), ' ||
            'nvl(ARDTAX.TAXABLE_ENTERED_CR,0) - nvl(ARDTAX.TAXABLE_ENTERED_DR,0) ,'|| -- Total Amount
            'TO_NUMBER(NULL),
            nvl(ARDTAX.AMOUNT_CR,0) - nvl(ARDTAX.AMOUNT_DR,0),'||
            'nvl(ARDTAX.ACCTD_AMOUNT_CR,0) - nvl(ARDTAX.ACCTD_AMOUNT_DR,0) ,'||
            ' TO_NUMBER(NULL), '||
            'nvl(ARDTAX.TAXABLE_ENTERED_CR,0) - nvl(ARDTAX.TAXABLE_ENTERED_DR,0) ,'||
            'nvl(ARDTAX.TAXABLE_ACCOUNTED_CR,0) - nvl(ARDTAX.TAXABLE_ACCOUNTED_DR,0),'|| -- ar matrix ++ 25
            'ARD.LINE_ID,
             TO_NUMBER(NULL),
             TO_CHAR(NULL),
             TO_CHAR(NULL),
             TO_CHAR(NULL),
             TO_CHAR(NULL),'||
             '''N'', ' ||
            'DIST.ORG_ID,
            TO_NUMBER(NULL), ' ||
        --'ARCS.REVERSAL_DATE,
            'TO_NUMBER(NULL),   --amount_applied
             TO_NUMBER(NULL),  --tax_applied
             ZX_RATE.PERCENTAGE_RATE,  --ZX_TAX.PERCENTAGE_RATE,
             ZX_RATE.TAX_RATE_CODE,
             ZX_RATE.VAT_TRANSACTION_TYPE_CODE,
       --      ZX_RATE.RATE_TYPE_CODE,
       ZX_TAX.TAX_TYPE_CODE,
             ZX_RATE.TAX_RATE_NAME,
             ARCS.RECEIPT_NUMBER,
              TO_CHAR(NULL),
              ARCS.DOC_SEQUENCE_VALUE,
              ARCS.RECEIPT_DATE,
             ARCS.DEPOSIT_DATE,
              TO_DATE(NULL), ' ||
             'TO_DATE(NULL),
              TO_DATE(NULL),
              ARCS.CURRENCY_CODE,
              ARCS.EXCHANGE_RATE_TYPE,
              ARCS.EXCHANGE_DATE,
              ARCS.EXCHANGE_RATE,
              TO_CHAR(NULL),
              TO_CHAR(NULL),
              TO_CHAR(NULL),
              TO_CHAR(NULL),
              ARCS.TYPE,
        ZX_RATE.DESCRIPTION,
              TO_CHAR(NULL),
               TO_NUMBER(NULL),
               ARD.SOURCE_TYPE,
             TO_CHAR(NULL),
              TO_CHAR(NULL),
              TO_CHAR(NULL),
              TO_CHAR(NULL),
              TO_CHAR(NULL),
              TO_CHAR(NULL),
              TO_CHAR(NULL),
              TO_CHAR(NULL),
              TO_CHAR(NULL),
              TO_CHAR(NULL),
              TO_CHAR(NULL),
              TO_CHAR(NULL),
              TO_CHAR(NULL),
              TO_CHAR(NULL),
              TO_CHAR(NULL),
              TO_CHAR(NULL),
              222 ,--ZX_DET.APPLICATION_ID,
              TO_CHAR(NULL)  ,--ZX_DET.DOC_EVENT_STATUS,
              TO_CHAR(NULL)  ,--ZX_DET.APPLICATION_DOC_STATUS,
              TO_NUMBER(NULL) ,-- ZX_DET.ESTABLISHMENT_ID,
              ''AR'',    --EXTRACT_SOURCE_LEDGER,
             --TO_CHAR(NULL)  ,--ZX_DET.FUNCTIONAL_CURRECNY_CODE,
             --TO_CHAR(NULL)  ,--ZX_DET.LEDGER_NAME,
              TO_NUMBER(NULL)  ,--ZX_DET.MINIMUM_ACCOUNTABLE_UNIT,
              TO_NUMBER(NULL) ,-- ZX_DET.PRECISION,
              ARM.RECEIPT_CLASS_ID ,-- RECEIPT_CLASS_ID,   --Check this
              TO_NUMBER(NULL)  ,--ZX_DET.APPLIED_TO_APPLICATION_ID,
              TO_NUMBER(NULL)  ,--ZX_DET.APPLIED_TO_TRX_LINE_ID
              TO_CHAR(NULL)  ,--ZX_DET.APPLIED_TO_ENTITY_CODE,
              TO_NUMBER(NULL)  ,--ZX_DET.APPLIED_TO_TRX_ID,
              TO_CHAR(NULL)  ,--ZX_DET.APPLIED_TO_EVENT_CLASS_CODE
              TO_CHAR(NULL), -- ZX_DET.APPLIED_TO_TRX_NUMBER
              TO_NUMBER(NULL), -- ZX_DET.RELATED_DOC_APPLICATION_ID,
              TO_DATE(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.ADJUSTED_DOC_APPLICATION_ID
              TO_DATE(NULL), -- ZX_DET.ADJUSTED_DOC_DATE,
            --TO_CHAR(NULL)  ,--ZX_DET.BANKING_TP_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,
              TO_CHAR(NULL)  ,--ZX_DET.DEF_REC_SETTLEMENT_OPTION_CODE,
              TO_CHAR(NULL) , --ZX_DET.DEFAULT_TAXATION_COUNTRY,
              TO_CHAR(NULL) , --ZX_DET.DOCUMENT_SUB_TYPE,
              TO_CHAR(NULL) , --ZX_DET.ASSESSABLE_VALUE,
              TO_CHAR(NULL) , --ZX_DET.TRX_BUSINESS_CATEGORY,
              TO_CHAR(NULL) , --ZX_DET.LINE_INTENDED_USE,
              TO_CHAR(NULL) , --ZX_DET.PRODUCT_CATEGORY,
              TO_CHAR(NULL) , --ZX_DET.PRODUCT_FISC_CLASSIFICATION,
              TO_NUMBER(NULL) ,-- ZX_DET.SUPPLIER_EXCHANGE_RATE,
              TO_DATE(NULL)  , --ZX_DET.SUPPLIER_TAX_INVOICE_DATE,
              TO_CHAR(NULL)  ,--ZX_DET.SUPPLIER_TAX_INVOICE_NUMBER,
              TO_CHAR(NULL) , --ZX_DET.USER_DEFINED_FISC_CLASS,
              TO_NUMBER(NULL), -- ZX_DET.EXCEPTION_RATE,
              TO_NUMBER(NULL)  ,--ZX_DET.EXEMPT_RATE_MODIFIER,
              TO_NUMBER(NULL) , --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_CHAR(NULL),      --ZX_RATE.RECOVERY_RATE_CODE,
              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_DATE(NULL),  --ZX_LINE.TAX_DATE,
              TO_DATE(NULL),  --ZX_LINE.TAX_DETERMINE_DATE,
              TO_DATE(NULL),  --ZX_LINE.TAX_INVOICE_DATE,
              TO_CHAR(NULL),   --ZX_LINE.TAX_INVOICE_NUMBER,
              ZX_RATE.TAX_JURISDICTION_CODE,
              ZX_RATE.TAX_REGIME_CODE,
              ZX_RATE.TAX_STATUS_CODE,
              TO_NUMBER(NULL),  --ZX_LINE.TAX_STATUS_ID,
              ZX_RATE.TAX,
              TO_NUMBER(NULL), -- ZX_DET.SHIP_FROM_PARTY_TAX_PROF_ID,
              TO_NUMBER(NULL), -- ZX_DET.SHIP_FROM_SITE_TAX_PROF_ID,
              TO_NUMBER(NULL), -- ZX_DET.SHIP_TO_PARTY_TAX_PROF_ID,
              TO_NUMBER(NULL), -- ZX_DET.SHIP_TO_SITE_TAX_PROF_ID,
              TO_NUMBER(NULL), -- ZX_DET.BILL_TO_PARTY_TAX_PROF_ID,
              TO_NUMBER(NULL), -- ZX_DET.BILL_TO_SITE_TAX_PROF_ID,
              TO_NUMBER(NULL), -- ZX_DET.SHIP_FROM_PARTY_TAX_PROF_ID,
              TO_NUMBER(NULL), -- ZX_DET.SHIP_FROM_SITE_TAX_PROF_ID,
              TO_NUMBER(NULL), -- ZX_DET.SHIP_TO_PARTY_TAX_PROF_ID,
              TO_NUMBER(NULL), -- ZX_DET.SHIP_TO_SITE_TAX_PROF_ID,
              TO_NUMBER(NULL), -- ZX_DET.BILL_TO_PARTY_TAX_PROF_ID,
              TO_NUMBER(NULL), -- ZX_DET.BILL_TO_SITE_TAX_PROF_ID,
              TO_CHAR(NULL),'||  --ZX_LINE.HQ_ESTB_REG_NUMBER,
              'TO_CHAR(NULL),'||  --zx_line.tax_registration_number
              'TO_CHAR(NULL),'||     --ZX_LINE.LEGAL_ENTITY_TAX_REG_NUMBER,
              'TO_NUMBER(NULL), -- ZX_DET.OWN_HQ_PARTY_SITE_PROF_ID,
              TO_NUMBER(NULL), -- ZX_DET.OWN_HQ_PARTY_TAX_PROF_ID,
              TO_CHAR(NULL) ,  --ZX_DET.PORT_OF_ENTRY_CODE,
              TO_CHAR(NULL),'||     --ZX_LINE.REGISTRATION_PARTY_TYPE
              'TO_CHAR(NULL),'||     --ZX_LINE.HISTORICAL_FLAG
              'TO_CHAR(NULL),'||     --ZX_LINE.MRC_TAX_LINE_FLAG
          'DECODE(DIST.GL_POSTED_DATE, NULL, ''N'', ''Y'') POSTED_FLAG,'||     --POSTED_FLAG
              'TO_CHAR(NULL),'||     --ZX_LINE.REPORTING_ONLY_FLAG
              'TO_CHAR(NULL),'||     --ZX_LINE.TAX_AMT_INCLUDED_FLAG
              'TO_CHAR(NULL),'||     --ZX_LINE.TAX_ONLY_FLAG
         'TO_NUMBER(NULL) ,-- ZX_DET.EVENT_CLASS_MAPPING_ID,
         TO_CHAR(NULL)  ,--ZX_DET.TRX_LEVEL_TYPE,
         TO_CHAR(NULL),       -- Place of supply type code
         TO_NUMBER(NULL), -- ZX_DET.POA_LOCATION_ID,
         TO_NUMBER(NULL), -- ZX_DET.POO_LOCATION_ID,
         TO_CHAR(NULL),       -- Default Place of supply type code
         TO_NUMBER(NULL), -- ZX_DET.LINE_AMT,
         TO_NUMBER(NULL),
         ARCS.REVERSAL_DATE,
         ARCS.STATUS,
         ARDTAX.ACCTD_AMOUNT_CR,
         ARDTAX.ACCTD_AMOUNT_DR,
         TO_CHAR(NULL),
         TO_CHAR(NULL),
         TO_CHAR(NULL),
         ARDTAX.LINE_ID ' ||
    ',''RECEIPTS'','||
  'DIST.GL_POSTED_DATE,
         DIST.GL_DATE,
         TO_NUMBER(NULL),
         ARCS.REMITTANCE_BANK_ACCOUNT_ID ,
   TO_CHAR(NULL),
   TO_CHAR(NULL)';

Line: 6538

      'SELECT  '||
      'ARCS.SET_OF_BOOKS_ID,
             ARCS.CASH_RECEIPT_ID,'||
            'ARCS.DOC_SEQUENCE_ID,
             SEQ.NAME,'||
            'TO_NUMBER(NULL),'||
            '''MISC_CASH_RECEIPT'','||
            '''MISC_CASH_RECEIPT'',
             TO_CHAR(NULL),
             TO_NUMBER(NULL),
            TO_CHAR(NULL),
             TO_CHAR(NULL),
             TO_NUMBER(NULL),
             TO_CHAR(NULL),
             TO_CHAR(NULL),
             TO_NUMBER(NULL),'||
            'ARDTAX.TAX_CODE_ID,'||
            '''TAX'','|| -- REGISTER TYPE CODE
             'TO_NUMBER(NULL),'||
            'TO_CHAR(NULL),
             ARD.SOURCE_TABLE,
             ARD.SOURCE_ID,
             TO_NUMBER(NULL),'||
            'TO_NUMBER(NULL), ' ||
            '(nvl(ARDTAX.TAXABLE_ENTERED_CR,0) - nvl(ARDTAX.TAXABLE_ENTERED_DR,0)),'||
            'TO_NUMBER(NULL), --Tax Line ID
            (nvl(ARDTAX.AMOUNT_CR,0) - nvl(ARDTAX.AMOUNT_DR,0)),'||
            '(nvl(ARDTAX.ACCTD_AMOUNT_CR,0) - nvl(ARDTAX.ACCTD_AMOUNT_DR,0)),
             TO_NUMBER(NULL), '||  --Tax Line Number
            '(nvl(ARDTAX.TAXABLE_ENTERED_CR,0) - nvl(ARDTAX.TAXABLE_ENTERED_DR,0)),'||
            '(nvl(ARDTAX.TAXABLE_ACCOUNTED_CR,0) - nvl(ARDTAX.TAXABLE_ACCOUNTED_DR,0)),'|| -- ar matrix ++ 26
            'TO_NUMBER(NULL),'||   -- Trx_line_id
             'TO_NUMBER(NULL),
             TO_CHAR(NULL),
             TO_CHAR(NULL),
             TO_CHAR(NULL),
             TO_CHAR(NULL),
             ''N'', ' ||    --Reconcialiation Flag
            'DIST.ORG_ID,
            TO_NUMBER(NULL), ' ||
            'ARCS.REVERSAL_DATE,
             TO_NUMBER(NULL),   -- Amount_applied
             TO_NUMBER(NULL),   -- tax_Amount
             TO_NUMBER(NULL), --ZX_TAX.PERCENTAGE_RATE,
             ZX_RATE.TAX_RATE_CODE,
             ZX_RATE.VAT_TRANSACTION_TYPE_CODE,
       --      ZX_RATE.RATE_TYPE_CODE,
       ZX_TAX.TAX_TYPE_CODE,
             ZX_RATE.TAX_RATE_NAME,
             ARCS.RECEIPT_NUMBER,
              TO_CHAR(NULL),
              ARCS.DOC_SEQUENCE_VALUE,
              ARCS.RECEIPT_DATE,
              ARCS.DEPOSIT_DATE,
              TO_DATE(NULL), ' ||
             'TO_DATE(NULL),
              TO_DATE(NULL),
              ARCS.CURRENCY_CODE,
              ARCS.EXCHANGE_RATE_TYPE,
              ARCS.EXCHANGE_DATE,
              ARCS.EXCHANGE_RATE,'||
             'TO_CHAR(NULL),     --trx_sic_code
              TO_CHAR(NULL),    --FOB
              TO_CHAR(NULL),   --Waybill Number
              TO_CHAR(NULL),   --batch source name
              TO_CHAR(NULL),'|| --trx_type_description
              'TO_CHAR(NULL),
               TO_NUMBER(NULL),
               TO_CHAR(NULL),
             TO_CHAR(NULL),
              TO_CHAR(NULL),
              TO_CHAR(NULL),
              TO_CHAR(NULL),
              TO_CHAR(NULL),
              TO_CHAR(NULL),
              TO_CHAR(NULL),
              TO_CHAR(NULL),
              TO_CHAR(NULL),
              TO_CHAR(NULL),
              TO_CHAR(NULL),
              TO_CHAR(NULL),
              TO_CHAR(NULL),
              TO_CHAR(NULL),
              TO_CHAR(NULL),
              TO_CHAR(NULL),
              TO_NUMBER(NULL),  --ZX_DET.APPLICATION_ID
             TO_CHAR(NULL) ,-- ZX_DET.DOC_EVENT_STATUS
        TO_CHAR(NULL) ,-- ZX_DET.APPLICATION_DOC_STATUS,
               TO_NUMBER(NULL)  ,--ZX_DET.ESTABLISHMENT_ID
              ''AR'',     --EXTRACT_SOURCE_LEDGER
             TO_CHAR(NULL) ,-- ZX_DET.FUNCTIONAL_CURRECNY_CODE
             TO_CHAR(NULL) ,-- ZX_DET.LEDGER_NAME
               TO_NUMBER(NULL) , --ZX_DET.MINIMUM_ACCOUNTABLE_UNIT
               TO_NUMBER(NULL),  --ZX_DET.PRECISION
               TO_NUMBER(NULL),  --RECEIPT_CLASS_ID
               TO_NUMBER(NULL),  --ZX_DET.ADJUSTED_DOC_APPLICATION_ID
               TO_DATE(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
               TO_NUMBER(NULL),  --ZX_DET.ADJUSTED_DOC_TRX_ID
               TO_NUMBER(NULL),  --ZX_DET.RELATED_DOC_APPLICATION_ID
               TO_DATE(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_TO_APPLICATION_ID
               TO_NUMBER(NULL),  --ZX_DET.APPLIED_TO_TRX_LINE_ID
             TO_CHAR(NULL), -- ZX_DET.BANKING_TP_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
             TO_CHAR(NULL) -- ZX_DET.DEF_REC_SETTLEMENT_OPTION_CODE
             TO_CHAR(NULL) -- ZX_DET.DEFAULT_TAXATION_COUNTRY
             TO_CHAR(NULL) -- ZX_DET.DOCUMENT_SUB_TYPE
              TO_CHAR(NULL) , --ZX_DET.ASSESSABLE_VALUE,
             TO_CHAR(NULL) -- ZX_DET.TRX_BUSINESS_CATEGORY
             TO_CHAR(NULL) -- ZX_DET.LINE_INTENDED_USE
             TO_CHAR(NULL) -- ZX_DET.PRODUCT_CATEGORY
             TO_CHAR(NULL) -- ZX_DET.PRODUCT_FISC_CLASSIFICATION
               TO_NUMBER(NULL)  --ZX_DET.SUPPLIER_EXCHANGE_RATE
               TO_DATE(NULL),  -- ZX_DET.SUPPLIER_TAX_INVOICE_DATE
             TO_CHAR(NULL), -- ZX_DET.SUPPLIER_TAX_INVOICE_NUMBER
             TO_CHAR(NULL), -- ZX_DET.USER_DEFINED_FISC_CLASS
               TO_NUMBER(NULL),  --ZX_DET.EXCEPTION_RATE
             TO_CHAR(NULL), -- ZX_DET.EXEMPT_RATE_MODIFIER
              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_char(NULL),  --ZX_RATE.RECOVERY_RATE_CODE
              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_DATE(NULL),  --ZX_LINE.TAX_DATE
              TO_DATE(NULL),  --ZX_LINE.TAX_DETERMINE_DATE
              TO_DATE(NULL),  --ZX_LINE.TAX_INVOICE_DATE
              TO_CHAR(NULL),   --ZX_LINE.TAX_INVOICE_NUMBER
              ZX_RATE.TAX_JURISDICTION_CODE,
              ZX_RATE.TAX_REGIME_CODE,
              ZX_RATE.TAX_STATUS_CODE,
              ZX_RATE.TAX,
               TO_NUMBER(NULL) , --ZX_DET.SHIP_FROM_PARTY_TAX_PROF_ID
               TO_NUMBER(NULL) , --ZX_DET.SHIP_FROM_SITE_TAX_PROF_ID
               TO_NUMBER(NULL)  ,--ZX_DET.SHIP_TO_PARTY_TAX_PROF_ID
               TO_NUMBER(NULL)  ,--ZX_DET.SHIP_TO_SITE_TAX_PROF_ID
               TO_NUMBER(NULL) , --ZX_DET.BILL_TO_PARTY_TAX_PROF_ID
               TO_NUMBER(NULL)  ,--ZX_DET.BILL_TO_SITE_TAX_PROF_ID
              TO_CHAR(NULL),'||  --ZX_LINE.HQ_ESTB_REG_NUMBER
              'TO_CHAR(NULL),'||  --zx_line.tax_registration_number
              'TO_CHAR(NULL),'||     --ZX_LINE.LEGAL_ENTITY_TAX_REG_NUMBER
              ' TO_NUMBER(NULL)  ,--ZX_DET.OWN_HQ_PARTY_SITE_PROF_ID,
               TO_NUMBER(NULL) , --ZX_DET.OWN_HQ_PARTY_TAX_PROF_ID,
              TO_CHAR(NULL) ,--ZX_DET.PORT_OF_ENTRY_CODE,
              TO_CHAR(NULL),'||     --ZX_LINE.REGISTRATION_PARTY_TYPE
              'TO_CHAR(NULL),'||     --ZX_LINE.HISTORICAL_FLAG
              'TO_CHAR(NULL),'||     --ZX_LINE.MRC_TAX_LINE_FLAG
           'TO_CHAR(NULL) POSTED_FLAG,'||     -- POSTED_FLAG
              'TO_CHAR(NULL),'||     --ZX_LINE.REPORTING_ONLY_FLAG
              'TO_CHAR(NULL),'||     --ZX_LINE.TAX_AMT_INCLUDED_FLAG
              'TO_CHAR(NULL),'||     --ZX_LINE.TAX_ONLY_FLAG
         ' TO_NUMBER(NULL) . --ZX_DET.EVENT_CLASS_MAPPING_ID,
         TO_CHAR(NULL) --ZX_DET.TRX_LEVEL_TYPE,
         TO_CHAR(NULL),       -- Place of supply type code
          TO_NUMBER(NULL) . --ZX_DET.POA_LOCATION_ID,
          TO_NUMBER(NULL) . --ZX_DET.POO_LOCATION_ID,
         TO_CHAR(NULL),       -- Default Place of supply type code
          TO_NUMBER(NULL),  --ZX_DET.LINE_AMT,
         TO_NUMBER(NULL) ';

Line: 6794

'SELECT  '||
 'ZX_DET.LEDGER_ID,
       ZX_DET.TRX_ID, '||
      'ZX_DET.DOC_SEQ_ID,
       ZX_DET.DOC_SEQ_NAME,
       TO_NUMBER(NULL),
       ''BR'', '||
       '''BR'', '||
      ' TO_CHAR(NULL),
       TO_NUMBER(NULL), '||
      ' TO_CHAR(NULL),
       TO_CHAR(NULL),
       TO_NUMBER(NULL),'||
      ' TO_CHAR(NULL),
       TO_CHAR(NULL), '||
      'ZX_DET.BATCH_SOURCE_ID,'||
      'ARDTAX.TAX_CODE_ID,'||
      'DECODE(ARDTAX.SOURCE_TYPE,''TAX'',''TAX'',''DEFERRED_TAX'',''INTERIM''
      ,NULL), ' || -- REG. TYPE CODE
       'TO_NUMBER(NULL),
       TO_CHAR(NULL),
       TO_CHAR(NULL),
       TO_NUMBER(NULL),
       TO_NUMBER(NULL) ,'||
      'TO_NUMBER(NULL), ' ||
       'sum(nvl(ARDTAX.TAXABLE_ENTERED_CR,0)-nvl(ARDTAX.TAXABLE_ENTERED_DR,0)),'||-- Total Amount
      'TO_NUMBER(NULL),
      sum(nvl(ARDTAX.AMOUNT_CR,0)-nvl(ARDTAX.AMOUNT_DR,0)),'||
      'sum(nvl(ARDTAX.ACCTD_AMOUNT_CR,0) - nvl(ARDTAX.ACCTD_AMOUNT_DR,0)) ,'||
      'TO_NUMBER(NULL), '||
      'sum(nvl(ARDTAX.TAXABLE_ENTERED_CR,0) - nvl(ARDTAX.TAXABLE_ENTERED_DR,0)) ,'||
      'sum(nvl(ARDTAX.TAXABLE_ACCOUNTED_CR,0) - nvl(ARDTAX.TAXABLE_ACCOUNTED_DR,0)),'|| -- ar matrix ++ 27
      'TO_NUMBER(NULL),
       TO_NUMBER(NULL), '||
      'TO_CHAR(NULL),'||
      'TO_CHAR(NULL),
       TO_CHAR(NULL),
       TO_CHAR(NULL),
       ''N'', ' ||
      'ZX_DET.INTERNAL_ORGANIZATION_ID,
      TO_NUMBER(NULL), ' ||
      --'TO_DATE(NULL),
       'TO_NUMBER(NULL), --amount_applied
       TO_NUMBER(NULL), --tax_applied
       ZX_RATE.PERCENTAGE_RATE,
       ZX_RATE.TAX_RATE_CODE,
       ZX_RATE.VAT_TRANSACTION_TYPE_CODE,
       --ZX_RATE.RATE_TYPE_CODE,
       ZX_TAX.TAX_TYPE_CODE,
       ZX_RATE.TAX_RATE_NAME,
      ZX_DET.TRX_NUMBER,
       ZX_DET.TRX_DESCRIPTION,
       ZX_DET.DOC_SEQ_VALUE,
       ZX_DET.TRX_DATE,
       TO_DATE(NULL), --Deposit Date
       ZX_DET.TRX_DUE_DATE,
       ZX_DET.TRX_SHIPPING_DATE,
       ZX_DET.TRX_COMMUNICATED_DATE,
       ZX_DET.TRX_CURRENCY_CODE,
       ZX_DET.CURRENCY_CONVERSION_TYPE,
       ZX_DET.CURRENCY_CONVERSION_DATE,
       ZX_DET.CURRENCY_CONVERSION_RATE,
       TO_CHAR(NULL),
       ZX_DET.FOB_POINT,
       ZX_DET.TRX_WAYBILL_NUMBER,
       ZX_DET.BATCH_SOURCE_NAME, '||
       'ZX_DET.TRX_TYPE_DESCRIPTION,
       ZX_RATE.DESCRIPTION,
      TO_CHAR(NULL),
      TO_NUMBER(NULL),
       TO_CHAR(NULL),
       LINE.ATTRIBUTE_CATEGORY,
        LINE.ATTRIBUTE1,
        LINE.ATTRIBUTE2,
        LINE.ATTRIBUTE3,
        LINE.ATTRIBUTE4,
        LINE.ATTRIBUTE5,
        LINE.ATTRIBUTE6,
        LINE.ATTRIBUTE7,
        LINE.ATTRIBUTE8,
        LINE.ATTRIBUTE9,
        LINE.ATTRIBUTE10,
        LINE.ATTRIBUTE11,
        LINE.ATTRIBUTE12,
        LINE.ATTRIBUTE13,
        LINE.ATTRIBUTE14,
        LINE.ATTRIBUTE15,
       ZX_DET.APPLICATION_ID,
        ZX_DET.DOC_EVENT_STATUS,
         ZX_DET.APPLICATION_DOC_STATUS,
        ZX_DET.ESTABLISHMENT_ID,
        ''AR'', --EXTRACT_SOURCE_LEDGER,
        --ZX_DET.FUNCTIONAL_CURRECNY_CODE,
        --ZX_DET.LEDGER_NAME,
        ZX_DET.MINIMUM_ACCOUNTABLE_UNIT,
        ZX_DET.PRECISION,
        to_number(NULL),   --RECEIPT_CLASS_ID,
              ZX_DET.APPLIED_TO_APPLICATION_ID,
              ZX_DET.APPLIED_TO_TRX_LINE_ID,
              ZX_DET.APPLIED_TO_ENTITY_CODE,
              ZX_DET.APPLIED_TO_TRX_ID,
              ZX_DET.APPLIED_TO_EVENT_CLASS_CODE,
              ZX_DET.APPLIED_TO_TRX_NUMBER,
              ZX_DET.RELATED_DOC_APPLICATION_ID,
              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.ADJUSTED_DOC_APPLICATION_ID,
              ZX_DET.ADJUSTED_DOC_DATE,
        --ZX_DET.BANKING_TP_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_RATE.DEF_REC_SETTLEMENT_OPTION_CODE,
        ZX_DET.DEFAULT_TAXATION_COUNTRY,
        ZX_DET.DOCUMENT_SUB_TYPE,
        ZX_DET.ASSESSABLE_VALUE,
        ZX_DET.TRX_BUSINESS_CATEGORY,
        ZX_DET.LINE_INTENDED_USE,
        ZX_DET.PRODUCT_CATEGORY,
        ZX_DET.PRODUCT_FISC_CLASSIFICATION,
        ZX_DET.SUPPLIER_EXCHANGE_RATE,
        ZX_DET.SUPPLIER_TAX_INVOICE_DATE,
        ZX_DET.SUPPLIER_TAX_INVOICE_NUMBER,
        ZX_DET.USER_DEFINED_FISC_CLASS,
        TO_NUMBER(NULL),    --ZX_LINE.EXCEPTION_RATE,
        TO_NUMBER(NULL),    --ZX_LINE.EXEMPT_RATE_MODIFIER,
        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_CHAR(NULL),    --ZX_RATE.RECOVERY_RATE_CODE,
        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_DATE(NULL),  --ZX_LINE.TAX_DATE,
        TO_DATE(NULL),  --ZX_LINE.TAX_DETERMINE_DATE,
        TO_DATE(NULL),  --ZX_DET.TAX_INVOICE_DATE,
        TO_CHAR(NULL),   --ZX_DET.TAX_INVOICE_NUMBER,
        ZX_RATE.TAX_JURISDICTION_CODE,
        ZX_RATE.TAX_REGIME_CODE,
        ZX_RATE.TAX_STATUS_CODE,
        TO_NUMBER(NULL),  --ZX_LINE.TAX_STATUS_ID,
        ZX_RATE.TAX,
        ZX_DET.SHIP_FROM_PARTY_TAX_PROF_ID,
        ZX_DET.SHIP_FROM_SITE_TAX_PROF_ID,
        ZX_DET.SHIP_TO_PARTY_TAX_PROF_ID,
        ZX_DET.SHIP_TO_SITE_TAX_PROF_ID,
        ZX_DET.BILL_TO_PARTY_TAX_PROF_ID,
        ZX_DET.BILL_TO_SITE_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_CHAR(NULL),'||  --ZX_LINE.HQ_ESTB_REG_NUMBER,
              'TO_CHAR(NULL),'||  --zx_line.tax_registration_number
        'TO_CHAR(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),'||     --ZX_LINE.HISTORICAL_FLAG,
        'TO_CHAR(NULL),'||     --ZX_LINE.MRC_TAX_LINE_FLAG,
     'DECODE(TH.GL_POSTED_DATE, NULL, ''N'', ''Y'') POSTED_FLAG,'||     --POSTED_FLAG,
        'TO_CHAR(NULL),'||     --ZX_LINE.REPORTING_ONLY_FLAG,
        'TO_CHAR(NULL),'||     --ZX_LINE.TAX_AMT_INCLUDED_FLAG,
        'TO_CHAR(NULL),'||     --ZX_LINE.TAX_ONLY_LINE_FLAG
         'ZX_DET.EVENT_CLASS_MAPPING_ID,
         ZX_DET.TRX_LEVEL_TYPE,
         TO_CHAR(NULL),       -- Place of supply type code
         ZX_DET.POA_LOCATION_ID,
         ZX_DET.POO_LOCATION_ID,
         TO_CHAR(NULL),       -- Default Place of supply type code
         ZX_DET.LINE_AMT,
         TO_NUMBER(NULL),
         TO_DATE(NULL),
         TO_CHAR(NULL),
         sum(ARDTAX.ACCTD_AMOUNT_CR),
         sum(ARDTAX.ACCTD_AMOUNT_DR),
         TO_CHAR(NULL),
         TO_CHAR(NULL),
         TO_CHAR(NULL),
         ZX_DET.TRX_ID ,
         ZX_DET.ENTITY_CODE,
   TH.GL_POSTED_DATE,
         TH.GL_DATE,
         TO_NUMBER(NULL),
         TO_NUMBER(NULL),
   TO_CHAR(NULL),
   TO_CHAR(NULL)';

Line: 7200

'SELECT DISTINCT '||
       'ZX_DET.LEDGER_ID,
       ZX_DET.TRX_ID, '||
      'ZX_DET.DOC_SEQ_ID,
       ZX_DET.DOC_SEQ_NAME,
       TO_NUMBER(NULL),
       ''BR'', '||
       '''BR'', '||
      ' TO_CHAR(NULL),
       TO_NUMBER(NULL), '||
      ' TO_CHAR(NULL),
       TO_CHAR(NULL),
       TO_NUMBER(NULL),'||
      ' TO_CHAR(NULL),
       TO_CHAR(NULL), '||
      'ZX_DET.BATCH_SOURCE_ID,'||
      'ARDTAX.TAX_CODE_ID,'||
      'DECODE(ARDTAX.SOURCE_TYPE,''TAX'',''TAX'',''DEFERRED_TAX'',''INTERIM''
      ,NULL), ' || -- REG. TYPE CODE
       'TO_NUMBER(NULL),
       TO_CHAR(NULL),
       ARDTAX.SOURCE_TABLE,
       ARDTAX.SOURCE_ID,
       TO_NUMBER(NULL),'||
      'TO_NUMBER(NULL), ' ||
      '(nvl(ARDTAX.TAXABLE_ENTERED_CR,0) - nvl(ARDTAX.TAXABLE_ENTERED_DR,0)) ,'|| -- Total Amount
      'TO_NUMBER(NULL),
      (nvl(ARDTAX.AMOUNT_CR,0)-nvl(ARDTAX.AMOUNT_DR,0)),'||
      '(nvl(ARDTAX.ACCTD_AMOUNT_CR,0) - nvl(ARDTAX.ACCTD_AMOUNT_DR,0)) ,
       TO_NUMBER(NULL), '||
      '(nvl(ARDTAX.TAXABLE_ENTERED_CR,0) - nvl(ARDTAX.TAXABLE_ENTERED_DR,0)),'||
      '(nvl(ARDTAX.TAXABLE_ACCOUNTED_CR,0) - nvl(ARDTAX.TAXABLE_ACCOUNTED_DR,0)),'|| -- ar matrix ++ 30
      'TO_NUMBER(NULL),
       TO_NUMBER(NULL),
       TO_CHAR(NULL),
       TO_CHAR(NULL),
       TO_CHAR(NULL),
       TO_CHAR(NULL),'||
       '''N'', ' ||
      'ZX_DET.INTERNAL_ORGANIZATION_ID,'||  -- Org_id
      'LINE.BR_REF_CUSTOMER_TRX_ID, ' ||  --add in BR_REF_CUSTOMER_TRX_ID
      --'TO_DATE(NULL),
       'TO_NUMBER(NULL),  --amount_applied
       TO_NUMBER(NULL),  --tax_applied
       ZX_RATE.PERCENTAGE_RATE,
       ZX_RATE.TAX_RATE_CODE,
       ZX_RATE.VAT_TRANSACTION_TYPE_CODE,
       --ZX_RATE.RATE_TYPE_CODE,
       ZX_TAX.TAX_TYPE_CODE,
       ZX_RATE.TAX_RATE_NAME,
       ZX_DET.TRX_NUMBER,
       ZX_DET.TRX_DESCRIPTION,
       ZX_DET.DOC_SEQ_VALUE,
       ZX_DET.TRX_DATE,
       TO_DATE(NULL),   -- Deposit Date
       ZX_DET.TRX_DUE_DATE,
       ZX_DET.TRX_SHIPPING_DATE,
       ZX_DET.TRX_COMMUNICATED_DATE,
       ZX_DET.TRX_CURRENCY_CODE,
       ZX_DET.CURRENCY_CONVERSION_TYPE,
       ZX_DET.CURRENCY_CONVERSION_DATE,
       ZX_DET.CURRENCY_CONVERSION_RATE,
       TO_CHAR(NULL),
       ZX_DET.FOB_POINT,
       ZX_DET.TRX_WAYBILL_NUMBER,
       ZX_DET.BATCH_SOURCE_NAME,
       ZX_DET.TRX_TYPE_DESCRIPTION,
       ZX_RATE.DESCRIPTION,
      TO_CHAR(NULL),
       TO_NUMBER(NULL),
       TO_CHAR(NULL),
       LINE.ATTRIBUTE_CATEGORY,
        LINE.ATTRIBUTE1,
        LINE.ATTRIBUTE2,
        LINE.ATTRIBUTE3,
        LINE.ATTRIBUTE4,
        LINE.ATTRIBUTE5,
        LINE.ATTRIBUTE6,
        LINE.ATTRIBUTE7,
        LINE.ATTRIBUTE8,
        LINE.ATTRIBUTE9,
        LINE.ATTRIBUTE10,
        LINE.ATTRIBUTE11,
        LINE.ATTRIBUTE12,
        LINE.ATTRIBUTE13,
        LINE.ATTRIBUTE14,
        LINE.ATTRIBUTE15,
       ZX_DET.APPLICATION_ID,
        ZX_DET.DOC_EVENT_STATUS,
         ZX_DET.APPLICATION_DOC_STATUS,
        ZX_DET.ESTABLISHMENT_ID,
        ''AR'', --EXTRACT_SOURCE_LEDGER,
        --ZX_DET.FUNCTIONAL_CURRECNY_CODE,
        --ZX_DET.LEDGER_NAME,
        ZX_DET.MINIMUM_ACCOUNTABLE_UNIT,
        ZX_DET.PRECISION,
        TO_NUMBER(NULL),  --RECEIPT_CLASS_ID,
        ZX_DET.APPLIED_TO_APPLICATION_ID,
        ZX_DET.APPLIED_TO_TRX_LINE_ID,
        ZX_DET.APPLIED_TO_ENTITY_CODE,
        ZX_DET.APPLIED_TO_TRX_ID,
        ZX_DET.APPLIED_TO_EVENT_CLASS_CODE,
        ZX_DET.APPLIED_TO_TRX_NUMBER,
        ZX_DET.RELATED_DOC_APPLICATION_ID,
        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.ADJUSTED_DOC_APPLICATION_ID,
        ZX_DET.ADJUSTED_DOC_DATE,
        --ZX_DET.BANKING_TP_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_RATE.DEF_REC_SETTLEMENT_OPTION_CODE,
        ZX_DET.DEFAULT_TAXATION_COUNTRY,
        ZX_DET.DOCUMENT_SUB_TYPE,
        ZX_DET.ASSESSABLE_VALUE,
        ZX_DET.TRX_BUSINESS_CATEGORY,
        ZX_DET.LINE_INTENDED_USE,
        ZX_DET.PRODUCT_CATEGORY,
        ZX_DET.PRODUCT_FISC_CLASSIFICATION,
        ZX_DET.SUPPLIER_EXCHANGE_RATE,
        ZX_DET.SUPPLIER_TAX_INVOICE_DATE,
        ZX_DET.SUPPLIER_TAX_INVOICE_NUMBER,
        ZX_DET.USER_DEFINED_FISC_CLASS,
        TO_NUMBER(NULL),    --ZX_LINE.EXCEPTION_RATE,
        TO_NUMBER(NULL),    --ZX_LINE.EXEMPT_RATE_MODIFIER,
        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_CHAR(NULL),    --ZX_RATE.RECOVERY_RATE_CODE,
        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_DATE(NULL),  --ZX_LINE.TAX_DATE,
        TO_DATE(NULL),  --ZX_LINE.TAX_DETERMINE_DATE,
        TO_DATE(NULL),  --ZX_DET.TAX_INVOICE_DATE,
        TO_CHAR(NULL),   --ZX_DET.TAX_INVOICE_NUMBER,
        ZX_RATE.TAX_JURISDICTION_CODE,
        ZX_RATE.TAX_REGIME_CODE,
        ZX_RATE.TAX_STATUS_CODE,
        TO_NUMBER(NULL),  --ZX_LINE.TAX_STATUS_ID,
        ZX_RATE.TAX,
        ZX_DET.SHIP_FROM_PARTY_TAX_PROF_ID,
        ZX_DET.SHIP_FROM_SITE_TAX_PROF_ID,
        ZX_DET.SHIP_TO_PARTY_TAX_PROF_ID,
        ZX_DET.SHIP_TO_SITE_TAX_PROF_ID,
        ZX_DET.BILL_TO_PARTY_TAX_PROF_ID,
        ZX_DET.BILL_TO_SITE_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_CHAR(NULL),'||  --ZX_LINE.HQ_ESTB_REG_NUMBER,
              'TO_CHAR(NULL),'||  --zx_line.tax_registration_number
        'TO_CHAR(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),'||     --ZX_LINE.HISTORICAL_FLAG
        'TO_CHAR(NULL),'||     --ZX_LINE.MRC_TAX_LINE_FLAG
    'DECODE(TH.GL_POSTED_DATE, NULL, ''N'', ''Y'') POSTED_FLAG,'||     --POSTED_FLAG
        'TO_CHAR(NULL),'||     --ZX_LINE.REPORTING_ONLY_FLAG
        'TO_CHAR(NULL),'||     --ZX_LINE.TAX_AMT_INCLUDED_FLAG
        'TO_CHAR(NULL),'||    --ZX_LINE.TAX_ONLY_LINE_FLAG
         'ZX_DET.EVENT_CLASS_MAPPING_ID,
         ZX_DET.TRX_LEVEL_TYPE,
         TO_CHAR(NULL),       -- Place of supply type code
         ZX_DET.POA_LOCATION_ID,
         ZX_DET.POO_LOCATION_ID,
         TO_CHAR(NULL),       -- Default Place of supply type code
         ZX_DET.LINE_AMT,
         TO_NUMBER(NULL),
         TO_DATE(NULL),
         TO_CHAR(NULL),
         ARDTAX.ACCTD_AMOUNT_CR,
         ARDTAX.ACCTD_AMOUNT_DR,
         TO_CHAR(NULL),
         TO_CHAR(NULL),
         TO_CHAR(NULL),
         ARDTAX.LINE_ID ,
  ZX_DET.ENTITY_CODE,
  TH.GL_POSTED_DATE,
         TH.GL_DATE,
         TO_NUMBER(NULL),
         TO_NUMBER(NULL),
   TO_CHAR(NULL),
   TO_CHAR(NULL)';

Line: 7488

       'SELECT  DISTINCT ZX_DET.LEDGER_ID,
        ZX_DET.TRX_ID    ,
        ZX_DET.DOC_SEQ_ID ,
        ZX_DET.DOC_SEQ_NAME ,
        ZX_DET.RECEIVABLES_TRX_TYPE_ID,
        ZX_DET.LINE_CLASS,
        ZX_DET.EVENT_CLASS_CODE ,
        TO_CHAR(NULL) ,'|| --APPLIED_FROM_ENTITY_CODE
       'TO_NUMBER(NULL)  ,'||--APPLIED_FROM_TRX_ID
       'TO_CHAR(NULL)  ,'||--APPLIED_FROM_EVENT_CLASS_CODE
       'TO_CHAR(NULL)  ,'||  -- ADJUSTED_DOC_ENTITY_CODE --APPLIED_TO_ENTITY_CODE
       'ZX_DET.ADJUSTED_DOC_TRX_ID ,'|| --ADJSUTED_DOC_ID --APPLIED_TO_TRX_ID
       --'TO_CHAR(NULL)  ,'||  --ADJUSTED_DOC_EVENT_CLASS_CODE  --APPLIED_TO_EVENT_CLASS_CODE
       'ZX_DET.ADJUSTED_DOC_EVENT_CLASS_CODE ,'|| --ADJUSTED_DOC_EVENT_CLASS_CODE Bug 9031051
       'ZX_DET.ADJUSTED_DOC_NUMBER  ,'|| --ADJUSTED_DOC_NUMBER  --APPLIED_TO_TRX_NUMBER
       'ZX_DET.BATCH_SOURCE_ID,
        ZX_LINE.TAX_RATE_ID ,
        TO_CHAR(NULL) ,   -- ZX_ACCOUNTS.INTERIM_TAX_CCID
        ZX_DET.PRODUCT_ID,
        ZX_DET.PRODUCT_DESCRIPTION,
        TO_CHAR(NULL), --TAXABLE_LINE_SOURCE_TABLE,
        TO_NUMBER(NULL), --TAXABLE_ITEM_SOURCE_ID,
        TO_NUMBER(NULL), --ZX_LINE.TAX_EXEMPTION_ID ,
        TO_NUMBER(NULL), --ZX_LINE.TAX_EXCEPTION_ID  ,
        TO_NUMBER(NULL),  --TAXABLE_LINE_TOTAL_AMOUNT  ,
        ZX_LINE.TAX_LINE_ID,
        TO_NUMBER(NULL), --ZX_LINE.TAX_AMT,
        TO_NUMBER(NULL), --NVL(ZX_LINE.TAX_AMT_FUNCL_CURR,ZX_LINE.TAX_AMT)  ,
        TO_NUMBER(NULL), --ZX_LINE.TAX_LINE_NUMBER,
        TO_NUMBER(NULL), --ZX_LINE.TAXABLE_AMT,
        TO_NUMBER(NULL), --NVL(ZX_LINE.TAXABLE_AMT_FUNCL_CURR,ZX_LINE.TAXABLE_AMT) ,
        ZX_DET.TRX_LINE_ID,
        TO_NUMBER(NULL), --ZX_LINE.TRX_LINE_QUANTITY  ,
        ZX_DET.EXEMPT_CERTIFICATE_NUMBER,
        TO_CHAR(NULL), --ZX_LINE.EXEMPT_REASON_CODE   ,
        TO_CHAR(NULL), --exception_reason_code
        ZX_DET.UOM_CODE,
        TO_CHAR(NULL)  ,'||--RECONCILIATION_FLAG
       'ZX_DET.INTERNAL_ORGANIZATION_ID ,'||--ORG_ID
       'TO_NUMBER(NULL),'||--BR_REF_CUSTOMER_TRX_ID
        'TO_NUMBER(NULL)   ,'||--AMOUNT_APPLIED
        'TO_NUMBER(NULL),'||  --TAX_APPLIED
       'TO_NUMBER(NULL), --ZX_LINE.TAX_PROVIDER_ID
        TO_CHAR(NULL), --ZX_LINE.TAX_RATE_CODE,
        TO_CHAR(NULL), --ZX_RATE.VAT_TRANSACTION_TYPE_CODE,
        TO_CHAR(NULL), --ZX_TAX.TAX_TYPE_CODE,
        TO_CHAR(NULL), --ZX_RATE.TAX_RATE_NAME,
        ZX_DET.TRX_NUMBER,
        ZX_DET.TRX_DESCRIPTION,
        ZX_DET.DOC_SEQ_VALUE,
        ZX_DET.TRX_DATE,
        TO_DATE(NULL),   --Deposit Date
        ZX_DET.TRX_DUE_DATE ,
        ZX_DET.TRX_SHIPPING_DATE ,
        ZX_DET.TRX_COMMUNICATED_DATE ,
        ZX_DET.TRX_CURRENCY_CODE,
        ZX_DET.CURRENCY_CONVERSION_TYPE,
        ZX_DET.CURRENCY_CONVERSION_DATE,
        ZX_DET.CURRENCY_CONVERSION_RATE,
        ZX_DET.TRX_SIC_CODE,
        ZX_DET.FOB_POINT,
        ZX_DET.TRX_WAYBILL_NUMBER,
        ZX_DET.BATCH_SOURCE_NAME,
        ZX_DET.TRX_TYPE_DESCRIPTION,
        TO_CHAR(NULL), --ZX_RATE.DESCRIPTION,
        ZX_DET.TRX_LINE_DESCRIPTION,
        TO_NUMBER(NULL), --ZX_LINE.TRX_LINE_NUMBER,
        ZX_DET.TRX_LINE_TYPE,
        TO_CHAR(NULL), --ZX_LINE.ATTRIBUTE_CATEGORY,
        TO_CHAR(NULL), --ZX_LINE.ATTRIBUTE1,
        TO_CHAR(NULL), --ZX_LINE.ATTRIBUTE2,
        TO_CHAR(NULL), --ZX_LINE.ATTRIBUTE3,
        TO_CHAR(NULL), --ZX_LINE.ATTRIBUTE4,
        TO_CHAR(NULL), --ZX_LINE.ATTRIBUTE5,
        TO_CHAR(NULL), --ZX_LINE.ATTRIBUTE6,
        TO_CHAR(NULL), --ZX_LINE.ATTRIBUTE7,
        TO_CHAR(NULL), --ZX_LINE.ATTRIBUTE8,
        TO_CHAR(NULL), --ZX_LINE.ATTRIBUTE9,
       TO_CHAR(NULL), -- ZX_LINE.ATTRIBUTE10,
        TO_CHAR(NULL), --ZX_LINE.ATTRIBUTE11,
        TO_CHAR(NULL), --ZX_LINE.ATTRIBUTE12,
        TO_CHAR(NULL), --ZX_LINE.ATTRIBUTE13,
        TO_CHAR(NULL), --ZX_LINE.ATTRIBUTE14,
        TO_CHAR(NULL), --ZX_LINE.ATTRIBUTE15,
        ZX_DET.APPLICATION_ID,
        ZX_DET.DOC_EVENT_STATUS,
         ZX_DET.APPLICATION_DOC_STATUS,
        ZX_DET.ESTABLISHMENT_ID,
        ''AR'','||
        'ZX_DET.MINIMUM_ACCOUNTABLE_UNIT,
        ZX_DET.PRECISION,
        TO_NUMBER(NULL),
        ZX_DET.APPLIED_TO_APPLICATION_ID,
        ZX_DET.ADJUSTED_DOC_LINE_ID,   --ZX_DET.APPLIED_TO_TRX_LINE_ID,
        ZX_DET.APPLIED_TO_ENTITY_CODE,
        ZX_DET.APPLIED_TO_TRX_ID,
        ZX_DET.APPLIED_TO_EVENT_CLASS_CODE,
        ZX_DET.APPLIED_TO_TRX_NUMBER,
        ZX_DET.RELATED_DOC_APPLICATION_ID,
        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.ADJUSTED_DOC_APPLICATION_ID,
        ZX_DET.ADJUSTED_DOC_DATE,
        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,
        TO_CHAR(NULL),
        ZX_DET.DEFAULT_TAXATION_COUNTRY,
        ZX_DET.DOCUMENT_SUB_TYPE,
         ZX_DET.ASSESSABLE_VALUE,
        ZX_DET.TRX_BUSINESS_CATEGORY,
        ZX_DET.LINE_INTENDED_USE,
        ZX_DET.PRODUCT_CATEGORY,
        ZX_DET.PRODUCT_FISC_CLASSIFICATION,
        ZX_DET.SUPPLIER_EXCHANGE_RATE,
        ZX_DET.SUPPLIER_TAX_INVOICE_DATE,
        ZX_DET.SUPPLIER_TAX_INVOICE_NUMBER,
        ZX_DET.USER_DEFINED_FISC_CLASS,
        TO_NUMBER(NULL),  --ZX_LINE.EXCEPTION_RATE,
        TO_NUMBER(NULL),  --ZX_LINE.EXEMPT_RATE_MODIFIER,
        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_CHAR(NULL),   -- RECOVERY_RATE_CODE,
        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_DATE(NULL),  --ZX_LINE.TAX_DATE,
        TO_DATE(NULL),  --ZX_LINE.TAX_DETERMINE_DATE,
        ZX_DET.TAX_INVOICE_DATE,
        ZX_DET.TAX_INVOICE_NUMBER,
        TO_CHAR(NULL), --ZX_LINE.TAX_JURISDICTION_CODE,
        TO_CHAR(NULL), --ZX_LINE.TAX_REGIME_CODE,
        TO_CHAR(NULL), --ZX_LINE.TAX_STATUS_CODE,
         TO_NUMBER(NULL),  --ZX_LINE.TAX_STATUS_ID,
        TO_CHAR(NULL), --ZX_LINE.TAX,
        ZX_DET.SHIP_FROM_PARTY_TAX_PROF_ID  ,
        ZX_DET.SHIP_FROM_SITE_TAX_PROF_ID,
        ZX_DET.SHIP_TO_PARTY_TAX_PROF_ID  ,
        ZX_DET.SHIP_TO_SITE_TAX_PROF_ID  ,
        ZX_DET.BILL_TO_PARTY_TAX_PROF_ID,
        ZX_DET.BILL_TO_SITE_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_CHAR(NULL), --ZX_LINE.HQ_ESTB_REG_NUMBER ,
        TO_CHAR(NULL), --zx_line.tax_registration_number,
        TO_CHAR(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), --ZX_LINE.HISTORICAL_FLAG,
        TO_CHAR(NULL), --ZX_LINE.MRC_TAX_LINE_FLAG,
        TO_CHAR(NULL), -- POSTED_FLAG,
        TO_CHAR(NULL), --ZX_LINE.REPORTING_ONLY_FLAG,
        TO_CHAR(NULL), --ZX_LINE.TAX_AMT_INCLUDED_FLAG,
        TO_CHAR(NULL), --ZX_LINE.TAX_ONLY_LINE_FLAG,
         ZX_DET.EVENT_CLASS_MAPPING_ID,
         ZX_DET.TRX_LEVEL_TYPE,
         TO_CHAR(NULL), --ZX_LINE.PLACE_OF_SUPPLY_TYPE_CODE,
         ZX_DET.POA_LOCATION_ID,
         ZX_DET.POO_LOCATION_ID,
         TO_CHAR(NULL), --ZX_TAX.DEF_PLACE_OF_SUPPLY_TYPE_CODE,
         ZX_DET.LINE_AMT,
         TO_NUMBER(NULL),  --ZX_LINE.TAX_PROVIDER_ID,
         TO_DATE(NULL),
         TO_CHAR(NULL),
         TO_NUMBER(NULL),
         TO_NUMBER(NULL),
         TO_CHAR(NULL),
         TO_CHAR(NULL),
         TO_CHAR(NULL),
         TO_CHAR(NULL),
         ZX_DET.ENTITY_CODE,
         TO_DATE(NULL),
         ZX_DET.TRX_LINE_GL_DATE,
         ZX_DET.UNIT_PRICE,
         TO_NUMBER(NULL),
         TO_CHAR(NULL),
         TO_CHAR(NULL)';

Line: 7691

     ||' AND NOT EXISTS (SELECT 1 FROM ZX_LINES ZX_LINE1
                            WHERE ZX_LINE1.APPLICATION_ID           = ZX_DET.APPLICATION_ID
                            AND ZX_LINE1.ENTITY_CODE              = ZX_DET.ENTITY_CODE
                            AND ZX_LINE1.EVENT_CLASS_CODE         = ZX_DET.EVENT_CLASS_CODE
                            AND ZX_LINE1.TRX_ID                   = ZX_DET.TRX_ID
                            AND ZX_LINE1.TRX_LINE_ID              = ZX_DET.TRX_LINE_ID
                            AND ZX_LINE1.INTERNAL_ORGANIZATION_ID = ZX_DET.INTERNAL_ORGANIZATION_ID) '
     ||' AND ZX_DET.EVENT_CLASS_CODE IN (''CREDIT_MEMO'')'
     ||' AND ZX_DET.ADJUSTED_DOC_TRX_ID IS NOT NULL '
     || L_WHERE_REP_CONTEXT_NO_TAX
     || L_WHERE_LEDGER_ID_NO_TAX
     || L_WHERE_LEGAL_ENTITY_ID_NO_TAX
     || L_WHERE_REG_TYPE_AR_TRX_NO_TAX
     || L_WHERE_PARTY_NAME_NO_TAX
     || L_WHERE_BATCH_NAME_NO_TAX
     || L_WHERE_TRX_NUMBER_INV
     || L_WHERE_GL_TRX_DATE_INV
     || L_WHERE_TRX_DATE_INV
     || L_WHERE_GL_DATE_INV_NO_TAX
     || L_WHERE_DOC_SUB_TYPE_NO_TAX
     || L_WHERE_TRX_BUS_CAT_NO_TAX
     || L_WHERE_TAX_INVOICE_DATE
     || L_WHERE_TAX_JURIS_CODE_NO_TAX
     || L_WHERE_FIRST_PTY_TAX_REG_NUM     --L_WHERE_FIRST_REG_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_CODE_NO_TAX
     || L_WHERE_TAX_TYPE_CODE_NO_TAX
     || L_WHERE_CURRENCY_CODE_NO_TAX
     || L_WHERE_EXEM_STATUS_NO_TAX
     || L_WHERE_TAX_TRX_TYPE_NO_TAX
     || L_WHERE_TAX_LTE;

Line: 8112

    g_last_updated_by   := fnd_global.user_id;

Line: 8113

    g_last_update_login := fnd_global.login_id;

Line: 8114

    g_last_update_date  := sysdate;

Line: 8332

      IF (i >= C_LINES_PER_INSERT) THEN
          total_rec := total_rec + i;

Line: 8334

        insert_ar_trx_info;

Line: 8351

      insert_ar_trx_info;

Line: 8427

 |   insert_ar_trx_info                                                      |
 |   name changed from INSERT_AR_SUB_ITF                                     |
 |   (rewrite from INSERT_SQL_AR)                                            |
 | DESCRIPTION                                                               |
 |    This procedure inserts AR data into ZX_AR_EXTRACT_PKG_SUB_ITF table    |
 |                                                                           |
 | SCOPE - Private                                                           |
 |                                                                           |
 | NOTES                                                                     |
 |                                                                           |
 | MODIFICATION HISTORY                                                      |
 |  04-JAN-03   S. korrapati Created                                         |
 |  30-JUN-04   Amol Pai     Added Insert into ar and common extension       |
 |                           tables (moved code from populate to build_sql)  |
 |                                                                           |
 +===========================================================================*/
PROCEDURE insert_ar_trx_info
IS

  l_count       number;

Line: 8451

        FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.insert_ar_trx_info.BEGIN',
                                      'ZX_AR_EXTRACT_PKG: insert_ar_trx_info(+)');

Line: 8453

        FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.insert_ar_trx_info',
                                      'Rows fetched : '||to_char(GT_LEDGER_ID.COUNT));

Line: 8460

    INSERT INTO ZX_REP_TRX_DETAIL_T(
        DETAIL_TAX_LINE_ID,
        LEDGER_ID,
        TRX_ID ,
        DOC_SEQ_ID,
        DOC_SEQ_NAME ,
        TRX_TYPE_ID ,
        TRX_LINE_CLASS,
        EVENT_CLASS_CODE ,
        APPLIED_FROM_ENTITY_CODE,
        APPLIED_FROM_TRX_ID,
        APPLIED_FROM_EVENT_CLASS_CODE,
        ADJUSTED_DOC_ENTITY_CODE ,
        ADJUSTED_DOC_TRX_ID ,
        ADJUSTED_DOC_EVENT_CLASS_CODE ,
        ADJUSTED_DOC_NUMBER ,
        TRX_BATCH_SOURCE_ID,
        TAX_RATE_ID ,
        TAX_RATE_REGISTER_TYPE_CODE,
        PRODUCT_ID,
        PRODUCT_DESCRIPTION,
        TAXABLE_LINE_SOURCE_TABLE ,
        TAXABLE_ITEM_SOURCE_ID,
        TAX_EXEMPTION_ID ,
        TAX_EXCEPTION_ID ,
        TAXABLE_LINE_TOTAL_AMOUNT,
        TAX_LINE_ID ,
        TAX_AMT ,
        TAX_AMT_FUNCL_CURR ,
        TAX_LINE_NUMBER ,
        TAXABLE_AMT ,
        TAXABLE_AMT_FUNCL_CURR ,
        TRX_LINE_ID ,
        TRX_LINE_QUANTITY ,
        EXEMPT_CERTIFICATE_NUMBER,
        EXEMPT_REASON_CODE ,
        TAX_EXCEPTION_REASON_CODE ,
        UOM_CODE,
        RECONCILIATION_FLAG ,
        INTERNAL_ORGANIZATION_ID,
        BR_REF_CUSTOMER_TRX_ID,
      --  REVERSE_FLAG,
        AMOUNT_APPLIED,
        TAX_APPLIED,
        TAX_RATE,
        TAX_RATE_CODE,
        TAX_RATE_VAT_TRX_TYPE_CODE,
        TAX_TYPE_CODE,
        TAX_RATE_CODE_NAME ,
        TRX_NUMBER ,
        TRX_DESCRIPTION ,
        DOC_SEQ_VALUE,
        TRX_DATE,
        DEPOSIT_DATE,
        TRX_DUE_DATE ,
        TRX_SHIPPING_DATE ,
        TRX_COMMUNICATED_DATE ,
        TRX_CURRENCY_CODE,
        CURRENCY_CONVERSION_TYPE,
        CURRENCY_CONVERSION_DATE,
        CURRENCY_CONVERSION_RATE,
        TRX_SIC_CODE,
        FOB_POINT,
        TRX_WAYBILL_NUMBER  ,
        TRX_BATCH_SOURCE_NAME,
        TRX_TYPE_DESCRIPTION,
        TRX_TYPE_MNG,
        TAX_RATE_CODE_DESCRIPTION ,
        TRX_LINE_DESCRIPTION,
        TRX_LINE_NUMBER,
        TRX_LINE_TYPE,
        TAX_LINE_USER_CATEGORY ,
        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 ,
        APPLICATION_ID,
        DOC_EVENT_STATUS,
        APPLICATION_DOC_STATUS,
        ESTABLISHMENT_ID,
        EXTRACT_SOURCE_LEDGER ,
        --FUNCTIONAL_CURRENCY_CODE,
        --LEDGER_NAME,
        MINIMUM_ACCOUNTABLE_UNIT,
        PRECISION,
        RECEIPT_CLASS_ID ,
        APPLIED_TO_APPLICATION_ID,
        APPLIED_TO_TRX_LINE_ID,
        APPLIED_TO_ENTITY_CODE ,
        APPLIED_TO_TRX_ID,
        APPLIED_TO_EVENT_CLASS_CODE ,
        APPLIED_TO_TRX_NUMBER ,
        RELATED_DOC_APPLICATION_ID ,
        RELATED_DOC_DATE ,
        RELATED_DOC_ENTITY_CODE ,
        RELATED_DOC_EVENT_CLASS_CODE ,
        RELATED_DOC_NUMBER ,
        RELATED_DOC_TRX_ID ,
        ADJUSTED_DOC_APPLICATION_ID ,
        ADJUSTED_DOC_DATE ,
        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 ,
        DEF_REC_SETTLEMENT_OPTION_CODE,
        DEFAULT_TAXATION_COUNTRY,
        DOCUMENT_SUB_TYPE,
        ASSESSABLE_VALUE,
        TRX_BUSINESS_CATEGORY,
        LINE_INTENDED_USE,
        PRODUCT_CATEGORY  ,
        PRODUCT_FISC_CLASSIFICATION,
        SUPPLIER_EXCHANGE_RATE,
        SUPPLIER_TAX_INVOICE_DATE,
        SUPPLIER_TAX_INVOICE_NUMBER,
        USER_DEFINED_FISC_CLASS,
        EXCEPTION_RATE,
        EXEMPT_RATE_MODIFIER,
        ORIG_TAX_AMT,
        ORIG_TAX_AMT_TAX_CURR ,
        ORIG_TAXABLE_AMT,
        ORIG_TAXABLE_AMT_TAX_CURR,
        recovery_rate_code,
        TAX_AMT_TAX_CURR ,
        TAX_APPORTIONMENT_LINE_NUMBER,
        TAX_CURRENCY_CODE,
        TAX_DATE,
        TAX_DETERMINE_DATE,
        TAX_INVOICE_DATE,
        TAX_INVOICE_NUMBER ,
        TAX_JURISDICTION_CODE,
       -- TAX_RATE_VAT_TRX_TYPE_DESC ,
        TAX_REGIME_CODE,
        TAX_STATUS_CODE,
        TAX_STATUS_ID,
        TAX,
        SHIP_FROM_PARTY_TAX_PROF_ID,
        SHIP_FROM_SITE_TAX_PROF_ID,
        SHIP_TO_PARTY_TAX_PROF_ID  ,
        SHIP_TO_SITE_TAX_PROF_ID  ,
        BILL_TO_PARTY_TAX_PROF_ID,
        BILL_TO_SITE_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,
        HISTORICAL_FLAG,
        MRC_TAX_LINE_FLAG,
        POSTED_FLAG,
        REPORTING_ONLY_FLAG,
        TAX_AMT_INCLUDED_FLAG,
        TAX_ONLY_FLAG,
        EVENT_CLASS_MAPPING_ID,
        TRX_LEVEL_TYPE,
        PLACE_OF_SUPPLY_TYPE_CODE,
        POA_LOCATION_ID,
        POO_LOCATION_ID,
        DEF_PLACE_OF_SUPPLY_TYPE_CODE,
        TRX_LINE_AMT,
        TAX_PROVIDER_ID,
        CREATED_BY ,
        CREATION_DATE ,
        LAST_UPDATED_BY,
        LAST_UPDATE_DATE,
        LAST_UPDATE_LOGIN,
        REQUEST_ID,
        AR_CASH_RECEIPT_REVERSE_DATE,
        AR_CASH_RECEIPT_REVERSE_STATUS,
        ACCTD_AMOUNT_CR,
        ACCTD_AMOUNT_DR,
        REC_APPLICATION_STATUS,
        ACCOUNT_CLASS,
        LATEST_REC_FLAG,
        ACTG_SOURCE_ID,
        ENTITY_CODE,
        POSTED_DATE,
        GL_DATE,
        UNIT_PRICE,
        BANK_ACCOUNT_ID,
        REP_CONTEXT_ID,
        OFFSET_TAX_RATE_CODE,
        OFFSET_FLAG)
  VALUES(
        ZX_REP_TRX_DETAIL_T_S.NEXTVAL,
        GT_LEDGER_ID(i),
        GT_TRX_ID(i),
        GT_DOC_SEQ_ID(i),
        GT_DOC_SEQ_NAME(i),
        GT_TRX_TYPE_ID(i),
        GT_LINE_CLASS(i),
        GT_EVENT_CLASS_CODE(i),
        GT_APPLIED_FROM_ENTITY_CODE(i),
        GT_APPLIED_FROM_TRX_ID(i),
        GT_APPLIED_FROM_EVENT_CLS_CD(i),
        GT_ADJUSTED_DOC_ENTITY_CODE(i),
        GT_ADJUSTED_DOC_TRX_ID(i),
        GT_ADJUSTED_DOC_EVENT_CLS_CD(i),
        GT_ADJUSTED_DOC_NUMBER(i),
        GT_BATCH_SOURCE_ID(i),
        GT_TAX_RATE_ID(i),
       -- g_register_type,
        GT_TAX_RATE_REG_TYPE_CODE(i),
        GT_PRODUCT_ID(i),
        GT_PRODUCT_DESCRIPTION(i),
        GT_TAXABLE_LINE_SOURCELE(i),
        GT_TAXABLE_ITEM_SOURCE_ID(i),
        GT_TAX_EXEMPTION_ID(i),
        GT_TAX_EXCEPTION_ID(i),
        GT_TAXABLE_LINE_TOTAL_AMOUNT(i),
        GT_TAX_LINE_ID(i),
        GT_TAX_AMT(i),
        GT_TAX_AMT_FUNCL_CURR(i),
        GT_TAX_LINE_NUMBER(i),
        GT_TAXABLE_AMT(i),
        GT_TAXABLE_AMT_FUNCL_CURR(i),
        GT_TRX_LINE_ID(i),
        GT_TRX_LINE_QUANTITY(i),
        GT_EXEMPT_CERTIFICATE_NUMBER(i),
        GT_EXEMPT_REASON_CODE(i),
        GT_TAX_EXCEPTION_REASON_CODE(i),
        GT_UOM_CODE(i),
        GT_RECONCILIATION_FLAG(i),
        GT_INTERNAL_ORGANIZATION_ID(i),
        GT_BR_REF_CUSTOMER_TRX_ID(i),
     --   GT_REVERSE_FLAG(i),   -- REVERSAL_DATE    Check this column
        GT_AMOUNT_APPLIED(i),
        GT_TAX_APPLIED(i),
        GT_TAX_RATE(i),
        GT_TAX_RATE_CODE(i),
        GT_TAX_RATE_VAT_TRX_TYPE_CODE(i),
        GT_TAX_TYPE_CODE(i),
        GT_TAX_RATE_CODE_NAME(i),     --  Do we need to rename tax_rate_name?
        GT_TRX_NUMBER(i),
        GT_TRX_DESCRIPTION(i),
        GT_DOC_SEQ_VALUE(i),
        GT_TRX_DATE(i),
        GT_DEPOSIT_DATE(i),
        GT_TRX_DUE_DATE(i),
        GT_TRX_SHIPPING_DATE(i),
        GT_TRX_COMMUNICATED_DATE(i),
        GT_TRX_CURRENCY_CODE(i),
        GT_CURRENCY_CONVERSION_TYPE(i),
        GT_CURRENCY_CONVERSION_DATE(i),
        GT_CURRENCY_CONVERSION_RATE(i),
        GT_TRX_SIC_CODE(i),
        GT_FOB_POINT(i),
        GT_TRX_WAYBILL_NUMBER(i),
        GT_TRX_BATCH_SOURCE_NAME(i),
        GT_TRX_TYPE_DESCRIPTION(i),
        GT_TRX_TYPE_DESCRIPTION(i),
        GT_TAX_RATE_CODE_DESCRIPTION(i), --populate
        GT_TRX_LINE_DESCRIPTION(i),
        GT_TRX_LINE_NUMBER(i),
        GT_TRX_LINE_TYPE(i),
        GT_TAX_LINE_USER_CATEGORY(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_APPLICATION_ID(i),
        GT_DOC_EVENT_STATUS(i),
        GT_APPLICATION_DOC_STATUS(i),
        GT_ESTABLISHMENT_ID(i),
        GT_EXTRACT_SOURCE_LEDGER(i),
      --  GT_FUNCTIONAL_CURRECNY_CODE(i),
      --  GT_LEDGER_NAME(i),
        GT_MINIMUM_ACCOUNTABLE_UNIT(i),
        GT_PRECISION(i),
        GT_RECEIPT_CLASS_ID(i),
        GT_APPLIED_TO_APPLICATION_ID(i),
        GT_APPLIED_TO_TRX_LINE_ID(i),
        GT_APPLIED_TO_ENTITY_CODE(i),
        GT_APPLIED_TO_TRX_ID(i),
        GT_APPLIED_TO_EVENT_CLS_CODE(i),
        GT_APPLIED_TO_TRX_NUMBER(i),
        GT_RELATED_DOC_APPLICATION_ID(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_ADJUSTED_DOC_APPL_ID(i),
        GT_ADJUSTED_DOC_DATE(i),
        GT_REF_DOC_APPLICATION_ID(i),
        GT_REF_DOC_ENTITY_CODE(i),
        GT_REF_DOC_EVENT_CLASS_CODE(i),
        GT_REF_DOC_LINE_ID(i),
        GT_REF_DOC_LINE_QUANTITY(i),
        GT_REF_DOC_TRX_ID(i),
        GT_DEF_REC_SETTLEMENT_OPT_CD(i),
        GT_DEFAULT_TAXATION_COUNTRY(i),
        GT_DOCUMENT_SUB_TYPE(i),
        GT_ASSESSABLE_VALUE(i),
        GT_TRX_BUSINESS_CATEGORY(i),
        GT_LINE_INTENDED_USE(i),
        GT_PRODUCT_CATEGORY(i),
        GT_PROD_FISC_CLASSIFICATION(i),
        GT_SUPPLIER_EXCHANGE_RATE(i),
        GT_SUPPLIER_TAX_INVOICE_DATE(i),
        GT_SUPPLIER_TAX_INVOICE_NUM(i),
        GT_USER_DEFINED_FISC_CLASS(i),
        GT_EXCEPTION_RATE(i),
        GT_EXEMPT_RATE_MODIFIER(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_RECOVERY_RATE_CODE(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_INVOICE_DATE(i),
        GT_TAX_INVOICE_NUMBER(i),
        GT_TAX_JURISDICTION_CODE(i),
        GT_TAX_REGIME_CODE(i),
        GT_TAX_STATUS_CODE(i),
        GT_TAX_STATUS_ID(i),
        GT_TAX(i),
        GT_SHIP_FROM_PTY_TAX_PROF_ID(i),
        GT_SHIP_FROM_SITE_TAX_PROF_ID(i),
        GT_SHIP_TO_PARTY_TAX_PROF_ID(i),
        GT_SHIP_TO_SITE_TAX_PROF_ID(i),
        GT_BILL_TO_PTY_TAX_PROF_ID(i),
        GT_BILL_TO_SITE_TAX_PROF_ID(i),
        GT_SHIPPING_TP_ADDRESS_ID(i),    --SHIP_THIRD_PTY_ACCT_SITE_ID
        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_PARTY_SITE_PROF_ID(i),
        GT_OWN_HQ_PARTY_TAX_PROF_ID(i),
        GT_PORT_OF_ENTRY_CODE(i),
        GT_REGISTRATION_PARTY_TYPE(i),
        GT_HISTORICAL_FLAG(i),
        GT_MRC_TAX_LINE_FLAG(i),
        GT_POSTED_FLAG(i),
        GT_REPORTING_ONLY_FLAG(i),
        GT_TAX_AMT_INCLUDED_FLAG(i),
        GT_TAX_ONLY_LINE_FLAG(i),
        GT_EVENT_CLASS_MAPPING_ID(i),
        GT_TRX_LEVEL_TYPE(i),
        GT_PLACE_OF_SUPPLY_TYPE_CODE(i),
        GT_POA_LOCATION_ID(i),
        GT_POO_LOCATION_ID(i),
        GT_DEF_PLACE_OF_SUP_TYPE_CODE(i),
        GT_LINE_AMT(i),
        GT_TAX_PROVIDER_ID(i),
        G_CREATED_BY ,
        G_CREATION_DATE ,
        G_LAST_UPDATED_BY,
        G_LAST_UPDATE_DATE,
        G_LAST_UPDATE_LOGIN,
--        1,
--        SYSDATE,
--        1,
--        SYSDATE,
--        1,
        g_request_id,
   GT_AR_CASH_RCPT_RVRS_DATE(i),
        GT_AR_CASH_RCPT_RVRS_STATUS(i),
        GT_ACCTD_AMOUNT_CR(i),
        GT_ACCTD_AMOUNT_DR(i),
        GT_REC_APPLICATION_STATUS(i),
        GT_ACCOUNT_CLASS(i),
        GT_LATEST_REC_FLAG(i),
        GT_ACTG_SOURCE_ID(i),
  GT_ENTITY_CODE(i),
  GT_POSTED_DATE(i),
       GT_GL_DATE(i),
        GT_UNIT_PRICE(i),
       GT_BANKING_ACCOUNT_ID(i),
       G_REP_CONTEXT_ID,
       GT_OFFSET_TAX_RATE(i),
       GT_OFFSET_FLAG(i));

Line: 8875

       FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.insert_ar_trx_info',
                      'Number of AR rows successfully inserted = '||TO_CHAR(NVL(GT_LEDGER_ID.COUNT, 0)));

Line: 8877

        FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.insert_ar_trx_info.END',
                                      'ZX_AR_EXTRACT_PKG: insert_ar_trx_info(-)');

Line: 8885

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

Line: 8889

                     'ZX.TRL.ZX_AR_EXTRACT_PKG.insert_ar_trx_info',
                      g_error_buffer);

Line: 8894

END insert_ar_trx_info;

Line: 8920

   GT_LEDGER_ID.DELETE;

Line: 8921

   GT_TRX_ID.DELETE;

Line: 8922

   GT_DOC_SEQ_ID.DELETE;

Line: 8923

   GT_DOC_SEQ_NAME.DELETE;

Line: 8924

   GT_TRX_TYPE_ID.DELETE;

Line: 8925

   GT_LINE_CLASS.DELETE;

Line: 8926

   GT_EVENT_CLASS_CODE.DELETE;

Line: 8927

   GT_APPLIED_FROM_ENTITY_CODE.DELETE;

Line: 8928

   GT_APPLIED_FROM_TRX_ID.DELETE;

Line: 8929

   GT_APPLIED_FROM_EVENT_CLS_CD.DELETE;

Line: 8930

   GT_ADJUSTED_DOC_ENTITY_CODE.DELETE;

Line: 8931

   GT_ADJUSTED_DOC_TRX_ID.DELETE;

Line: 8932

   GT_ADJUSTED_DOC_EVENT_CLS_CD.DELETE;

Line: 8933

   GT_ADJUSTED_DOC_NUMBER.DELETE;

Line: 8934

   GT_BATCH_SOURCE_ID.DELETE;

Line: 8935

   GT_TAX_RATE_ID.DELETE;

Line: 8936

   GT_TAX_RATE_REG_TYPE_CODE.DELETE;   --Check this

Line: 8937

   GT_PRODUCT_ID.DELETE;

Line: 8938

   GT_PRODUCT_DESCRIPTION.DELETE;

Line: 8939

   GT_TAXABLE_LINE_SOURCELE.DELETE;

Line: 8940

   GT_TAXABLE_ITEM_SOURCE_ID.DELETE;

Line: 8941

   GT_TAX_EXEMPTION_ID.DELETE;

Line: 8942

   GT_TAX_EXCEPTION_ID.DELETE;

Line: 8943

   GT_TAXABLE_LINE_TOTAL_AMOUNT.DELETE;

Line: 8944

   GT_TAX_LINE_ID.DELETE;

Line: 8945

   GT_TAX_AMT.DELETE;

Line: 8946

   GT_TAX_AMT_FUNCL_CURR.DELETE;

Line: 8947

   GT_TAX_LINE_NUMBER.DELETE;

Line: 8948

   GT_TAXABLE_AMT.DELETE;

Line: 8949

   GT_TAXABLE_AMT_FUNCL_CURR.DELETE;

Line: 8950

   GT_TRX_LINE_ID.DELETE;

Line: 8951

   GT_TRX_LINE_QUANTITY.DELETE;

Line: 8952

   GT_EXEMPT_CERTIFICATE_NUMBER.DELETE;

Line: 8953

   GT_EXEMPT_REASON_CODE.DELETE;

Line: 8954

   GT_TAX_EXCEPTION_REASON_CODE.DELETE;

Line: 8955

   GT_UOM_CODE.DELETE;

Line: 8956

   GT_RECONCILIATION_FLAG.DELETE;

Line: 8957

   GT_INTERNAL_ORGANIZATION_ID.DELETE;

Line: 8958

   GT_BR_REF_CUSTOMER_TRX_ID.DELETE;

Line: 8960

   GT_AMOUNT_APPLIED.DELETE;

Line: 8961

   GT_TAX_APPLIED.DELETE;

Line: 8962

   GT_TAX_RATE.DELETE;

Line: 8963

   GT_TAX_RATE_CODE.DELETE;

Line: 8964

   GT_TAX_RATE_VAT_TRX_TYPE_CODE.DELETE;

Line: 8965

   GT_TAX_TYPE_CODE.DELETE;

Line: 8966

   GT_TAX_RATE_CODE_NAME.DELETE;     --  Do we need to rename tax_rate_name?

Line: 8967

   GT_TRX_NUMBER.DELETE;

Line: 8968

   GT_TRX_DESCRIPTION.DELETE;

Line: 8969

   GT_DOC_SEQ_VALUE.DELETE;

Line: 8970

   GT_TRX_DATE.DELETE;

Line: 8971

   GT_DEPOSIT_DATE.DELETE;

Line: 8972

   GT_TRX_DUE_DATE.DELETE;

Line: 8973

   GT_TRX_SHIPPING_DATE.DELETE;

Line: 8974

   GT_TRX_COMMUNICATED_DATE.DELETE;

Line: 8975

   GT_TRX_CURRENCY_CODE.DELETE;

Line: 8976

   GT_CURRENCY_CONVERSION_TYPE.DELETE;

Line: 8977

   GT_CURRENCY_CONVERSION_DATE.DELETE;

Line: 8978

   GT_CURRENCY_CONVERSION_RATE.DELETE;

Line: 8979

   GT_TRX_SIC_CODE.DELETE;

Line: 8980

   GT_FOB_POINT.DELETE;

Line: 8981

   GT_TRX_WAYBILL_NUMBER.DELETE;

Line: 8982

   GT_TRX_BATCH_SOURCE_NAME.DELETE;

Line: 8983

   GT_TRX_TYPE_DESCRIPTION.DELETE;

Line: 8984

   GT_TAX_RATE_CODE_DESCRIPTION.DELETE;

Line: 8985

   GT_TRX_LINE_DESCRIPTION.DELETE;

Line: 8986

   GT_TRX_LINE_NUMBER.DELETE;

Line: 8987

   GT_TRX_LINE_TYPE.DELETE;

Line: 8988

   GT_TAX_LINE_USER_CATEGORY.DELETE;

Line: 8989

   GT_TAX_LINE_USER_ATTRIBUTE1.DELETE;

Line: 8990

   GT_TAX_LINE_USER_ATTRIBUTE2.DELETE;

Line: 8991

   GT_TAX_LINE_USER_ATTRIBUTE3.DELETE;

Line: 8992

   GT_TAX_LINE_USER_ATTRIBUTE4.DELETE;

Line: 8993

   GT_TAX_LINE_USER_ATTRIBUTE5.DELETE;

Line: 8994

   GT_TAX_LINE_USER_ATTRIBUTE6.DELETE;

Line: 8995

   GT_TAX_LINE_USER_ATTRIBUTE7.DELETE;

Line: 8996

   GT_TAX_LINE_USER_ATTRIBUTE8.DELETE;

Line: 8997

   GT_TAX_LINE_USER_ATTRIBUTE9.DELETE;

Line: 8998

   GT_TAX_LINE_USER_ATTRIBUTE10.DELETE;

Line: 8999

   GT_TAX_LINE_USER_ATTRIBUTE11.DELETE;

Line: 9000

   GT_TAX_LINE_USER_ATTRIBUTE12.DELETE;

Line: 9001

   GT_TAX_LINE_USER_ATTRIBUTE13.DELETE;

Line: 9002

   GT_TAX_LINE_USER_ATTRIBUTE14.DELETE;

Line: 9003

   GT_TAX_LINE_USER_ATTRIBUTE15.DELETE;

Line: 9004

   GT_APPLICATION_ID.DELETE;

Line: 9005

   GT_DOC_EVENT_STATUS.DELETE;

Line: 9006

   GT_APPLICATION_DOC_STATUS.DELETE;

Line: 9007

   GT_ESTABLISHMENT_ID.DELETE;

Line: 9008

   GT_EXTRACT_SOURCE_LEDGER.DELETE;

Line: 9011

   GT_MINIMUM_ACCOUNTABLE_UNIT.DELETE;

Line: 9012

   GT_PRECISION.DELETE;

Line: 9013

   GT_RECEIPT_CLASS_ID.DELETE;

Line: 9014

   GT_APPLIED_TO_APPLICATION_ID.DELETE;

Line: 9015

   GT_APPLIED_TO_TRX_LINE_ID.DELETE;

Line: 9016

   GT_APPLIED_TO_ENTITY_CODE.DELETE;

Line: 9017

   GT_APPLIED_TO_TRX_ID.DELETE;

Line: 9018

   GT_APPLIED_TO_EVENT_CLS_CODE.DELETE;

Line: 9019

   GT_APPLIED_TO_TRX_NUMBER.DELETE;

Line: 9020

   GT_RELATED_DOC_APPLICATION_ID.DELETE;

Line: 9021

   GT_RELATED_DOC_DATE.DELETE;

Line: 9022

   GT_RELATED_DOC_ENTITY_CODE.DELETE;

Line: 9023

   GT_RELATED_DOC_EVENT_CLS_CODE.DELETE;

Line: 9024

   GT_RELATED_DOC_NUMBER.DELETE;

Line: 9025

   GT_RELATED_DOC_TRX_ID.DELETE;

Line: 9026

   GT_ADJUSTED_DOC_APPL_ID.DELETE;

Line: 9027

   GT_ADJUSTED_DOC_DATE.DELETE;

Line: 9028

   GT_REF_DOC_APPLICATION_ID.DELETE;

Line: 9029

   GT_REF_DOC_ENTITY_CODE.DELETE;

Line: 9030

   GT_REF_DOC_EVENT_CLASS_CODE.DELETE;

Line: 9031

   GT_REF_DOC_LINE_ID.DELETE;

Line: 9032

   GT_REF_DOC_LINE_QUANTITY.DELETE;

Line: 9033

   GT_REF_DOC_TRX_ID.DELETE;

Line: 9034

   GT_DEF_REC_SETTLEMENT_OPT_CD.DELETE;

Line: 9035

   GT_DEFAULT_TAXATION_COUNTRY.DELETE;

Line: 9036

   GT_DOCUMENT_SUB_TYPE.DELETE;

Line: 9037

   GT_ASSESSABLE_VALUE.DELETE;

Line: 9038

   GT_TRX_BUSINESS_CATEGORY.DELETE;

Line: 9039

   GT_LINE_INTENDED_USE.DELETE;

Line: 9040

   GT_PRODUCT_CATEGORY.DELETE;

Line: 9041

   GT_PROD_FISC_CLASSIFICATION.DELETE;

Line: 9042

   GT_SUPPLIER_EXCHANGE_RATE.DELETE;

Line: 9043

   GT_SUPPLIER_TAX_INVOICE_DATE.DELETE;

Line: 9044

   GT_SUPPLIER_TAX_INVOICE_NUM.DELETE;

Line: 9045

   GT_USER_DEFINED_FISC_CLASS.DELETE;

Line: 9046

   GT_EXCEPTION_RATE.DELETE;

Line: 9047

   GT_EXEMPT_RATE_MODIFIER.DELETE;

Line: 9048

   GT_ORIG_TAX_AMT.DELETE;

Line: 9049

   GT_ORIG_TAX_AMT_TAX_CURR.DELETE;

Line: 9050

   GT_ORIG_TAXABLE_AMT.DELETE;

Line: 9051

   GT_ORIG_TAXABLE_AMT_TAX_CURR.DELETE;

Line: 9052

   GT_RECOVERY_RATE_CODE.DELETE;

Line: 9053

   GT_TAX_AMT_TAX_CURR.DELETE;

Line: 9054

   GT_TAX_APPORTIONMENT_LINE_NUM.DELETE;

Line: 9055

   GT_TAX_CURRENCY_CODE.DELETE;

Line: 9056

   GT_TAX_DATE.DELETE;

Line: 9057

   GT_TAX_DETERMINE_DATE.DELETE;

Line: 9058

   GT_TAX_INVOICE_DATE.DELETE;

Line: 9059

   GT_TAX_INVOICE_NUMBER.DELETE;

Line: 9060

   GT_TAX_JURISDICTION_CODE.DELETE;

Line: 9061

   GT_TAX_REGIME_CODE.DELETE;

Line: 9062

   GT_TAX_STATUS_CODE.DELETE;

Line: 9063

   GT_TAX_STATUS_ID.DELETE;

Line: 9064

   GT_TAX.DELETE;

Line: 9065

   GT_SHIP_FROM_PTY_TAX_PROF_ID.DELETE;

Line: 9066

   GT_SHIP_FROM_SITE_TAX_PROF_ID.DELETE;

Line: 9067

   GT_SHIP_TO_PARTY_TAX_PROF_ID.DELETE;

Line: 9068

   GT_SHIP_TO_SITE_TAX_PROF_ID.DELETE;

Line: 9069

   GT_BILL_TO_PTY_TAX_PROF_ID.DELETE;

Line: 9070

   GT_BILL_TO_SITE_TAX_PROF_ID.DELETE;

Line: 9071

   GT_HQ_ESTB_REG_NUMBER.DELETE;

Line: 9072

   gt_tax_line_registration_num.delete;

Line: 9073

   GT_LEGAL_ENTITY_TAX_REG_NUM.DELETE;

Line: 9074

   GT_OWN_HQ_PARTY_SITE_PROF_ID.DELETE;

Line: 9075

   GT_OWN_HQ_PARTY_TAX_PROF_ID.DELETE;

Line: 9076

   GT_PORT_OF_ENTRY_CODE.DELETE;

Line: 9077

   GT_REGISTRATION_PARTY_TYPE.DELETE;

Line: 9078

   GT_HISTORICAL_FLAG.DELETE;

Line: 9079

   GT_MRC_TAX_LINE_FLAG.DELETE;

Line: 9080

   GT_POSTED_FLAG.DELETE;

Line: 9081

   GT_REPORTING_ONLY_FLAG.DELETE;

Line: 9082

   GT_TAX_AMT_INCLUDED_FLAG.DELETE;

Line: 9083

   GT_TAX_ONLY_LINE_FLAG.DELETE;

Line: 9090

   GT_EVENT_CLASS_MAPPING_ID.DELETE;

Line: 9091

   GT_TRX_LEVEL_TYPE.DELETE;

Line: 9092

   GT_PLACE_OF_SUPPLY_TYPE_CODE.DELETE;

Line: 9093

   GT_POA_LOCATION_ID.DELETE;

Line: 9094

   GT_POO_LOCATION_ID.DELETE;

Line: 9095

   GT_DEF_PLACE_OF_SUP_TYPE_CODE.DELETE;

Line: 9096

   GT_LINE_AMT.DELETE;

Line: 9097

   GT_TAX_PROVIDER_ID.DELETE;

Line: 9098

   GT_AR_CASH_RCPT_RVRS_DATE.DELETE;

Line: 9099

   GT_AR_CASH_RCPT_RVRS_STATUS.DELETE;

Line: 9100

   GT_ACCTD_AMOUNT_CR.DELETE;

Line: 9101

   GT_ACCTD_AMOUNT_DR.DELETE;

Line: 9102

   GT_REC_APPLICATION_STATUS.DELETE;

Line: 9103

   GT_ACCOUNT_CLASS.DELETE;

Line: 9104

   GT_LATEST_REC_FLAG.DELETE;

Line: 9105

   GT_ACTG_SOURCE_ID.DELETE;

Line: 9106

   GT_ENTITY_CODE.DELETE;

Line: 9107

   GT_POSTED_DATE.DELETE;

Line: 9108

   GT_GL_DATE.DELETE;

Line: 9109

   GT_UNIT_PRICE.DELETE;

Line: 9110

   GT_BANKING_ACCOUNT_ID.DELETE;