ZX_ACCT_PURCH_EXT_LINES_V

Details

• Schema: FUSION

• Object owner: ZX

• Object type: VIEW

Columns

Name

EVENT_ID LINE_NUMBER LEDGER_ID TAX_REC_NREC_DIST_REF_ID TAX_LINE_REF_ID SOURCE_DISTRIBUTION_ID_NUM_1 ACCOUNT_CCID CHAR1 CHAR10 CHAR2 CHAR3 CHAR4 CHAR5 CHAR6 CHAR7 CHAR8 CHAR9 DATE1 DATE10 DATE2 DATE3 DATE4 DATE5 DATE6 DATE7 DATE8 DATE9 DEFAULT_TAXATION_COUNTRY INTENDED_USE DISTRIBUTION_TYPE DOCUMENT_SUB_TYPE ENTERED_AMOUNT ENTERED_CURRENCY_CODE ACCOUNTED_AMOUNT GL_DATE HQ_ESTB_REG_NUMBER LINE_CLASS LINES_DET_FACTOR_ID NUMERIC1 NUMERIC10 NUMERIC2 NUMERIC3 NUMERIC4 NUMERIC5 NUMERIC6 NUMERIC7 NUMERIC8 NUMERIC9 PROD_FC_CATEG_ID PRODUCT_CATEGORY PRODUCT_CODE PRODUCT_FISC_CLASSIFICATION PRODUCT_ID PRODUCT_ORG_ID PRODUCT_TYPE REC_NREC_RATE REC_NREC_TAX_AMT REC_NREC_TAX_AMT_TAX_CURR RECOVERABLE_FLAG RECOVERY_RATE_CODE RECOVERY_TYPE_CODE SELF_ASSESSED_FLAG TAX TAX_AMT_INCLUDED_FLAG TAX_EVENT_CLASS_CODE TAX_EVENT_TYPE_CODE TAX_INCLUSION_FLAG TAX_INVOICE_DATE TAX_INVOICE_NUMBER TAX_JURISDICTION_CODE TAX_POINT_BASIS TAX_POINT_DATE TAX_RATE_CODE TAX_RATE TAX_REGIME_CODE TAX_REGISTRATION_NUMBER TAX_REPORTING_FLAG TAX_STATUS_CODE TRX_BUSINESS_CATEGORY TRX_LINE_DATE TRX_LINE_DESCRIPTION USER_DEFINED_FISC_CLASS INCLUSIVE_FLAG LEGAL_ENTITY_TAX_REG_NUMBER OFFSET_FLAG OFFSET_TAX_RATE_CODE PLACE_OF_SUPPLY REPORTABLE_FLAG TAX_CURRENCY_CODE TAX_CURRENCY_CONVERSION_DATE TAX_CURRENCY_CONVERSION_RATE TAX_CURRENCY_CONVERSION_TYPE TAX_DATE TAX_ONLY_LINE_FLAG TAX_RATE_TYPE TAX_TYPE_CODE CREDIT_ACCOUNT_CCID DEBIT_ACCOUNT_CCID SHIP_TO_SITE_TAX_PROF_ID SHIP_TO_PARTY_SITE_NAME

Query

SQL_Statement

( ( select XlaEvent.event_id, ZxItemDist.TRX_LINE_DIST_ID LINE_NUMBER, ZxLineDetFac.LEDGER_ID, NULL TAX_REC_NREC_DIST_REF_ID, NULL TAX_LINE_REF_ID, ZxItemDist.trx_line_dist_id SOURCE_DISTRIBUTION_ID_NUM_1 , ZxItemDist.ACCOUNT_CCID, ZxLineDetFac.CHAR1, ZxLineDetFac.CHAR10, ZxLineDetFac.CHAR2, ZxLineDetFac.CHAR3, ZxLineDetFac.CHAR4, ZxLineDetFac.CHAR5, ZxLineDetFac.CHAR6, ZxLineDetFac.CHAR7, ZxLineDetFac.CHAR8, ZxLineDetFac.CHAR9, ZxLineDetFac.DATE1, ZxLineDetFac.DATE10, ZxLineDetFac.DATE2, ZxLineDetFac.DATE3, ZxLineDetFac.DATE4, ZxLineDetFac.DATE5, ZxLineDetFac.DATE6, ZxLineDetFac.DATE7, ZxLineDetFac.DATE8, ZxLineDetFac.DATE9, ZxLineDetFac.DEFAULT_TAXATION_COUNTRY, ZxItemDist.DIST_INTENDED_USE INTENDED_USE, 'Item' DISTRIBUTION_TYPE, ZxLineDetFac.DOCUMENT_SUB_TYPE, ZxItemDist.TRX_LINE_DIST_AMT ENTERED_AMOUNT, ZxLineDetFac.trx_currency_code ENTERED_CURRENCY_CODE, ZxItemDist.TRX_LINE_DIST_AMT_FUNCL_CURR ACCOUNTED_AMOUNT, ZxItemDist.GL_DATE, (SELECT registration_number FROM zx_registrations WHERE registration_id = ZxLineDetFac.First_pty_reg_id AND ROWNUM = 1 ) HQ_ESTB_REG_NUMBER, ZxLineDetFac.LINE_CLASS, ZxLineDetFac.LINES_DET_FACTOR_ID, ZxLineDetFac.NUMERIC1, ZxLineDetFac.NUMERIC10, ZxLineDetFac.NUMERIC2, ZxLineDetFac.NUMERIC3, ZxLineDetFac.NUMERIC4, ZxLineDetFac.NUMERIC5, ZxLineDetFac.NUMERIC6, ZxLineDetFac.NUMERIC7, ZxLineDetFac.NUMERIC8, ZxLineDetFac.NUMERIC9, ZxLineDetFac.PROD_FC_CATEG_ID, ZxLineDetFac.PRODUCT_CATEGORY, ZxLineDetFac.PRODUCT_CODE, ZxLineDetFac.PRODUCT_FISC_CLASSIFICATION, ZxLineDetFac.PRODUCT_ID, ZxLineDetFac.PRODUCT_ORG_ID, ZxLineDetFac.PRODUCT_TYPE, null REC_NREC_RATE, null REC_NREC_TAX_AMT, null REC_NREC_TAX_AMT_TAX_CURR, null RECOVERABLE_FLAG, null RECOVERY_RATE_CODE, null RECOVERY_TYPE_CODE, NULL SELF_ASSESSED_FLAG, NULL TAX, ZxLineDetFac.TAX_AMT_INCLUDED_FLAG, ZxLineDetFac.TAX_EVENT_CLASS_CODE, ZxLineDetFac.TAX_EVENT_TYPE_CODE, ZxItemDist.TAX_INCLUSION_FLAG, ZxLineDetFac.TAX_INVOICE_DATE, ZxLineDetFac.TAX_INVOICE_NUMBER, NULL TAX_JURISDICTION_CODE, NULL TAX_POINT_BASIS, NULL TAX_POINT_DATE, NULL TAX_RATE_CODE , NULL TAX_RATE , NULL TAX_REGIME_CODE, (SELECT registration_number FROM zx_registrations WHERE registration_id = ZxLineDetFac.Third_pty_reg_id AND ROWNUM = 1 ) TAX_REGISTRATION_NUMBER, ZxLineDetFac.TAX_REPORTING_FLAG, NULL TAX_STATUS_CODE, ZxLineDetFac.TRX_BUSINESS_CATEGORY, ZxLineDetFac.TRX_LINE_DATE, ZxLineDetFac.TRX_LINE_DESCRIPTION, ZxLineDetFac.USER_DEFINED_FISC_CLASS, null INCLUSIVE_FLAG, null LEGAL_ENTITY_TAX_REG_NUMBER, null OFFSET_FLAG, null OFFSET_TAX_RATE_CODE, null PLACE_OF_SUPPLY, null REPORTABLE_FLAG, null TAX_CURRENCY_CODE , null TAX_CURRENCY_CONVERSION_DATE , null TAX_CURRENCY_CONVERSION_RATE , null TAX_CURRENCY_CONVERSION_TYPE , null TAX_DATE, null TAX_ONLY_LINE_FLAG, NULL TAX_RATE_TYPE, NULL TAX_TYPE_CODE, ZxItemDist.CREDIT_ACCOUNT_CCID, ZxItemDist.DEBIT_ACCOUNT_CCID, ZxLineDetFac.ship_to_site_tax_prof_id, sites.party_site_name ship_to_party_site_name from zx_lines_det_factors ZxLineDetFac, zx_item_distributions ZxItemDist, gl_ledgers GlLedger, xla_events XlaEvent, xla_transaction_entities XlaTransEnt, zx_party_tax_profile ptp, hz_party_sites sites where ZxLineDetFac.tax_event_class_code = 'PURCHASE_TRANSACTION' AND (ZxLineDetFac.application_id = 235) and sites.party_site_id(+) = ptp.party_id and ptp.party_type_code(+) = 'THIRD_PARTY_SITE' and ptp.party_tax_profile_id(+) = ZxLineDetFac.ship_to_site_tax_prof_id and ZxLineDetFac.APPLICATION_ID = ZxItemDist.APPLICATION_ID AND ZxLineDetFac.ENTITY_CODE = ZxItemDist.ENTITY_CODE AND ZxLineDetFac.EVENT_CLASS_CODE = ZxItemDist.EVENT_CLASS_CODE AND ZxLineDetFac.TRX_ID = ZxItemDist.TRX_ID AND ZxLineDetFac.TRX_LINE_ID = ZxItemDist.TRX_LINE_ID AND ZxLineDetFac.TRX_LEVEL_TYPE = ZxItemDist.TRX_LEVEL_TYPE AND XlaTransEnt.source_id_int_1 = ZxLineDetFac.trx_id AND XlaTransEnt.entity_id = XlaEvent.entity_id AND ZxLineDetFac.ledger_id = GlLedger.ledger_id ) UNION (select XlaEvent.event_id, ZxRecNrecDist.rec_nrec_tax_dist_ID LINE_NUMBER, ZxLineDetFac.LEDGER_ID, ZxRecNrecDist.rec_nrec_tax_dist_ID TAX_REC_NREC_DIST_REF_ID, ZxLines.TAX_LINE_ID TAX_LINE_REF_ID, ZxRecNrecDist.rec_nrec_tax_dist_ID SOURCE_DISTRIBUTION_ID_NUM_1, ZxRecNrecDist.ACCOUNT_CCID, ZxLineDetFac.CHAR1, ZxLineDetFac.CHAR10, ZxLineDetFac.CHAR2, ZxLineDetFac.CHAR3, ZxLineDetFac.CHAR4, ZxLineDetFac.CHAR5, ZxLineDetFac.CHAR6, ZxLineDetFac.CHAR7, ZxLineDetFac.CHAR8, ZxLineDetFac.CHAR9, ZxLineDetFac.DATE1, ZxLineDetFac.DATE10, ZxLineDetFac.DATE2, ZxLineDetFac.DATE3, ZxLineDetFac.DATE4, ZxLineDetFac.DATE5, ZxLineDetFac.DATE6, ZxLineDetFac.DATE7, ZxLineDetFac.DATE8, ZxLineDetFac.DATE9, ZxLineDetFac.DEFAULT_TAXATION_COUNTRY, ZxRecNrecDist.INTENDED_USE, 'Tax' DISTRIBUTION_TYPE, ZxLineDetFac.DOCUMENT_SUB_TYPE, ZxRecNrecDist.REC_NREC_TAX_AMT ENTERED_AMOUNT, ZxRecNrecDist.trx_currency_code ENTERED_CURRENCY_CODE, ZxRecNrecDist.REC_NREC_TAX_AMT_FUNCL_CURR ACCOUNTED_AMOUNT, ZxRecNrecDist.GL_DATE, (SELECT registration_number FROM zx_registrations WHERE registration_id = ZxLineDetFac.First_pty_reg_id AND ROWNUM = 1 ) HQ_ESTB_REG_NUMBER, ZxLineDetFac.LINE_CLASS, ZxLineDetFac.LINES_DET_FACTOR_ID, ZxLineDetFac.NUMERIC1, ZxLineDetFac.NUMERIC10, ZxLineDetFac.NUMERIC2, ZxLineDetFac.NUMERIC3, ZxLineDetFac.NUMERIC4, ZxLineDetFac.NUMERIC5, ZxLineDetFac.NUMERIC6, ZxLineDetFac.NUMERIC7, ZxLineDetFac.NUMERIC8, ZxLineDetFac.NUMERIC9, ZxLineDetFac.PROD_FC_CATEG_ID, ZxLineDetFac.PRODUCT_CATEGORY, ZxLineDetFac.PRODUCT_CODE, ZxLineDetFac.PRODUCT_FISC_CLASSIFICATION, ZxLineDetFac.PRODUCT_ID, ZxLineDetFac.PRODUCT_ORG_ID, ZxLineDetFac.PRODUCT_TYPE, ZxRecNrecDist.REC_NREC_RATE, ZxRecNrecDist.REC_NREC_TAX_AMT, ZxRecNrecDist.REC_NREC_TAX_AMT_TAX_CURR, ZxRecNrecDist.RECOVERABLE_FLAG, ZxRecNrecDist.RECOVERY_RATE_CODE, ZxRecNrecDist.RECOVERY_TYPE_CODE, ZxRecNrecDist.SELF_ASSESSED_FLAG, ZxRecNrecDist.TAX, ZxLineDetFac.TAX_AMT_INCLUDED_FLAG, ZxLineDetFac.TAX_EVENT_CLASS_CODE, ZxLineDetFac.TAX_EVENT_TYPE_CODE, null TAX_INCLUSION_FLAG, ZxLineDetFac.TAX_INVOICE_DATE, ZxLineDetFac.TAX_INVOICE_NUMBER, ZxLines.TAX_JURISDICTION_CODE, ZxRecNrecDist.TAX_POINT_BASIS, ZxRecNrecDist.TAX_POINT_DATE, ZxRecNrecDist.TAX_RATE_CODE , ZxRecNrecDist.TAX_RATE , ZxRecNrecDist.TAX_REGIME_CODE, (SELECT registration_number FROM zx_registrations WHERE registration_id = ZxLineDetFac.Third_pty_reg_id AND ROWNUM = 1 ) TAX_REGISTRATION_NUMBER, ZxLineDetFac.TAX_REPORTING_FLAG, ZxRecNrecDist.TAX_STATUS_CODE, ZxLineDetFac.TRX_BUSINESS_CATEGORY, ZxLines.TRX_LINE_DATE, ZxLineDetFac.TRX_LINE_DESCRIPTION, ZxLineDetFac.USER_DEFINED_FISC_CLASS, ZxRecNrecDist.INCLUSIVE_FLAG, ZxLines.LEGAL_ENTITY_TAX_REG_NUMBER, ZxLines.OFFSET_FLAG, ZxLines.OFFSET_TAX_RATE_CODE, ZxLines.PLACE_OF_SUPPLY, ZxRecNrecDist.REPORTABLE_FLAG, ZxRecNrecDist.TAX_CURRENCY_CODE , ZxRecNrecDist.TAX_CURRENCY_CONVERSION_DATE , ZxRecNrecDist.TAX_CURRENCY_CONVERSION_RATE , ZxRecNrecDist.TAX_CURRENCY_CONVERSION_TYPE , ZxLines.TAX_DATE, ZxRecNrecDist.TAX_ONLY_LINE_FLAG, ZxLines.TAX_RATE_TYPE, ZxLines.TAX_TYPE_CODE, ZxRecNrecDist.CREDIT_ACCOUNT_CCID, ZxRecNrecDist.DEBIT_ACCOUNT_CCID, ZxLineDetFac.ship_to_site_tax_prof_id, sites.party_site_name ship_to_party_site_name from zx_lines_det_factors ZxLineDetFac, zx_lines ZxLines, zx_rec_nrec_dist ZxRecNrecDist, gl_ledgers GlLedger, xla_events XlaEvent, xla_transaction_entities XlaTransEnt, zx_party_tax_profile ptp, hz_party_sites sites where ZxLineDetFac.tax_event_class_code = 'PURCHASE_TRANSACTION' AND (ZxLineDetFac.application_id = 235) and sites.party_site_id(+) = ptp.party_id and ptp.party_type_code(+) = 'THIRD_PARTY_SITE' and ptp.party_tax_profile_id(+) = ZxLineDetFac.ship_to_site_tax_prof_id and ZxLines.APPLICATION_ID = ZxRecNrecDist.APPLICATION_ID and ZxLines.ENTITY_CODE = ZxRecNrecDist.ENTITY_CODE and ZxLines.EVENT_CLASS_CODE = ZxRecNrecDist.EVENT_CLASS_CODE and ZxLines.TRX_ID = ZxRecNrecDist.TRX_ID and ZxLines.TRX_LINE_ID = ZxRecNrecDist.TRX_LINE_ID and ZxLines.TAX_LINE_ID = ZxRecNrecDist.TAX_LINE_ID and ZxLines.TRX_LEVEL_TYPE = ZxRecNrecDist.TRX_LEVEL_TYPE and ZxLineDetFac.APPLICATION_ID = ZxLines.APPLICATION_ID AND ZxLineDetFac.ENTITY_CODE = ZxLines.ENTITY_CODE AND ZxLineDetFac.EVENT_CLASS_CODE = ZxLines.EVENT_CLASS_CODE AND ZxLineDetFac.TRX_ID = ZxLines.TRX_ID AND ZxLineDetFac.TRX_LINE_ID = ZxLines.TRX_LINE_ID AND ZxLineDetFac.TRX_LEVEL_TYPE = ZxLines.TRX_LEVEL_TYPE AND XlaTransEnt.source_id_int_1 = ZxLineDetFac.trx_id AND XlaTransEnt.entity_id = XlaEvent.entity_id AND ZxLineDetFac.ledger_id = GlLedger.ledger_id) UNION (select XlaEvent.event_id, ZxRecNrecDist.rec_nrec_tax_dist_ID LINE_NUMBER, ZxLineDetFac.LEDGER_ID, ZxRecNrecDist.rec_nrec_tax_dist_ID TAX_REC_NREC_DIST_REF_ID, ZxLines.TAX_LINE_ID TAX_LINE_REF_ID, ZxRecNrecDist.rec_nrec_tax_dist_ID SOURCE_DISTRIBUTION_ID_NUM_1, ZxRecNrecDist.ACCOUNT_CCID, ZxLineDetFac.CHAR1, ZxLineDetFac.CHAR10, ZxLineDetFac.CHAR2, ZxLineDetFac.CHAR3, ZxLineDetFac.CHAR4, ZxLineDetFac.CHAR5, ZxLineDetFac.CHAR6, ZxLineDetFac.CHAR7, ZxLineDetFac.CHAR8, ZxLineDetFac.CHAR9, ZxLineDetFac.DATE1, ZxLineDetFac.DATE10, ZxLineDetFac.DATE2, ZxLineDetFac.DATE3, ZxLineDetFac.DATE4, ZxLineDetFac.DATE5, ZxLineDetFac.DATE6, ZxLineDetFac.DATE7, ZxLineDetFac.DATE8, ZxLineDetFac.DATE9, ZxLineDetFac.DEFAULT_TAXATION_COUNTRY, ZxRecNrecDist.INTENDED_USE, decode(ZxRecNrecDist.attribute15,'CM_DM_LIABILITY','AP_Tax_Liability','AP_Tax_Recovery') DISTRIBUTION_TYPE, ZxLineDetFac.DOCUMENT_SUB_TYPE, ZxRecNrecDist.REC_NREC_TAX_AMT ENTERED_AMOUNT, ZxRecNrecDist.trx_currency_code ENTERED_CURRENCY_CODE, ZxRecNrecDist.REC_NREC_TAX_AMT_FUNCL_CURR ACCOUNTED_AMOUNT, ZxRecNrecDist.GL_DATE, (SELECT registration_number FROM zx_registrations WHERE registration_id = ZxLineDetFac.First_pty_reg_id AND ROWNUM = 1 ) HQ_ESTB_REG_NUMBER, ZxLineDetFac.LINE_CLASS, ZxLineDetFac.LINES_DET_FACTOR_ID, ZxLineDetFac.NUMERIC1, ZxLineDetFac.NUMERIC10, ZxLineDetFac.NUMERIC2, ZxLineDetFac.NUMERIC3, ZxLineDetFac.NUMERIC4, ZxLineDetFac.NUMERIC5, ZxLineDetFac.NUMERIC6, ZxLineDetFac.NUMERIC7, ZxLineDetFac.NUMERIC8, ZxLineDetFac.NUMERIC9, ZxLineDetFac.PROD_FC_CATEG_ID, ZxLineDetFac.PRODUCT_CATEGORY, ZxLineDetFac.PRODUCT_CODE, ZxLineDetFac.PRODUCT_FISC_CLASSIFICATION, ZxLineDetFac.PRODUCT_ID, ZxLineDetFac.PRODUCT_ORG_ID, ZxLineDetFac.PRODUCT_TYPE, ZxRecNrecDist.REC_NREC_RATE, ZxRecNrecDist.REC_NREC_TAX_AMT, ZxRecNrecDist.REC_NREC_TAX_AMT_TAX_CURR, ZxRecNrecDist.RECOVERABLE_FLAG, ZxRecNrecDist.RECOVERY_RATE_CODE, ZxRecNrecDist.RECOVERY_TYPE_CODE, ZxRecNrecDist.SELF_ASSESSED_FLAG, ZxRecNrecDist.TAX, ZxLineDetFac.TAX_AMT_INCLUDED_FLAG, ZxLineDetFac.TAX_EVENT_CLASS_CODE, ZxLineDetFac.TAX_EVENT_TYPE_CODE, null TAX_INCLUSION_FLAG, ZxLineDetFac.TAX_INVOICE_DATE, ZxLineDetFac.TAX_INVOICE_NUMBER, ZxLines.TAX_JURISDICTION_CODE, ZxRecNrecDist.TAX_POINT_BASIS, ZxRecNrecDist.TAX_POINT_DATE, ZxRecNrecDist.TAX_RATE_CODE , ZxRecNrecDist.TAX_RATE , ZxRecNrecDist.TAX_REGIME_CODE, (SELECT registration_number FROM zx_registrations WHERE registration_id = ZxLineDetFac.Third_pty_reg_id AND ROWNUM = 1 ) TAX_REGISTRATION_NUMBER, ZxLineDetFac.TAX_REPORTING_FLAG, ZxRecNrecDist.TAX_STATUS_CODE, ZxLineDetFac.TRX_BUSINESS_CATEGORY, ZxLines.TRX_LINE_DATE, ZxLineDetFac.TRX_LINE_DESCRIPTION, ZxLineDetFac.USER_DEFINED_FISC_CLASS, ZxRecNrecDist.INCLUSIVE_FLAG, ZxLines.LEGAL_ENTITY_TAX_REG_NUMBER, ZxLines.OFFSET_FLAG, ZxLines.OFFSET_TAX_RATE_CODE, ZxLines.PLACE_OF_SUPPLY, ZxRecNrecDist.REPORTABLE_FLAG, ZxRecNrecDist.TAX_CURRENCY_CODE , ZxRecNrecDist.TAX_CURRENCY_CONVERSION_DATE , ZxRecNrecDist.TAX_CURRENCY_CONVERSION_RATE , ZxRecNrecDist.TAX_CURRENCY_CONVERSION_TYPE , ZxLines.TAX_DATE, ZxRecNrecDist.TAX_ONLY_LINE_FLAG, ZxLines.TAX_RATE_TYPE, ZxLines.TAX_TYPE_CODE, ZxRecNrecDist.CREDIT_ACCOUNT_CCID, ZxRecNrecDist.DEBIT_ACCOUNT_CCID, ZxLineDetFac.ship_to_site_tax_prof_id, sites.party_site_name ship_to_party_site_name from zx_lines_det_factors ZxLineDetFac, zx_lines ZxLines, zx_rec_nrec_dist ZxRecNrecDist, gl_ledgers GlLedger, xla_events XlaEvent, xla_transaction_entities XlaTransEnt, zx_party_tax_profile ptp, hz_party_sites sites where ZxLineDetFac.tax_event_class_code = 'PURCHASE_TRANSACTION' AND (ZxLineDetFac.application_id = 200) and sites.party_site_id(+) = ptp.party_id and ptp.party_type_code(+) = 'THIRD_PARTY_SITE' and ptp.party_tax_profile_id(+) = ZxLineDetFac.ship_to_site_tax_prof_id and ZxLines.APPLICATION_ID = ZxRecNrecDist.APPLICATION_ID and ZxLines.ENTITY_CODE = ZxRecNrecDist.ENTITY_CODE and ZxLines.EVENT_CLASS_CODE = ZxRecNrecDist.EVENT_CLASS_CODE and ZxLines.TRX_ID = ZxRecNrecDist.TRX_ID and ZxLines.TRX_LINE_ID = ZxRecNrecDist.TRX_LINE_ID and ZxLines.TAX_LINE_ID = ZxRecNrecDist.TAX_LINE_ID and ZxLines.TRX_LEVEL_TYPE = ZxRecNrecDist.TRX_LEVEL_TYPE AND ZxRecNrecDist.RECOVERABLE_FLAG = 'Y' AND ZxRecNrecDist.PROCESS_FINAL_RECOVERY_CODE = 'A' and ZxLineDetFac.APPLICATION_ID = ZxLines.APPLICATION_ID AND ZxLineDetFac.ENTITY_CODE = ZxLines.ENTITY_CODE AND ZxLineDetFac.EVENT_CLASS_CODE = ZxLines.EVENT_CLASS_CODE AND ZxLineDetFac.TRX_ID = ZxLines.TRX_ID AND ZxLineDetFac.TRX_LINE_ID = ZxLines.TRX_LINE_ID AND ZxLineDetFac.TRX_LEVEL_TYPE = ZxLines.TRX_LEVEL_TYPE AND XlaTransEnt.source_id_int_1 = ZxLineDetFac.trx_id AND XlaTransEnt.entity_id = XlaEvent.entity_id AND ZxRecNrecDist.accounting_event_id = XlaEvent.event_id AND ZxLineDetFac.ledger_id = GlLedger.ledger_id) )