ZX_ACCT_SALES_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 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 TAX_AMT_INCLUDED_FLAG TAX_EVENT_CLASS_CODE TAX_EVENT_TYPE_CODE TAX_INCLUSION_FLAG TAX_INVOICE_DATE TAX_INVOICE_NUMBER TAX_REPORTING_FLAG TRX_BUSINESS_CATEGORY TRX_LINE_DATE TRX_LINE_DESCRIPTION USER_DEFINED_FISC_CLASS HQ_ESTB_REG_NUMBER INCLUSIVE_FLAG LEGAL_ENTITY_TAX_REG_NUMBER OFFSET_FLAG OFFSET_TAX_RATE_CODE PLACE_OF_SUPPLY REPORTABLE_FLAG SELF_ASSESSED_FLAG TAX TAX_CURRENCY_CODE TAX_CURRENCY_CONVERSION_DATE TAX_CURRENCY_CONVERSION_RATE TAX_CURRENCY_CONVERSION_TYPE TAX_DATE TAX_DIST_AMT TAX_DIST_AMT_TAX_CURR TAX_JURISDICTION_CODE TAX_ONLY_LINE_FLAG TAX_POINT_BASIS TAX_POINT_DATE TAX_RATE TAX_RATE_CODE TAX_RATE_TYPE TAX_REGIME_CODE TAX_REGISTRATION_NUMBER TAX_STATUS_CODE 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, 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, 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, ZxLineDetFac.TAX_REPORTING_FLAG, ZxLineDetFac.TRX_BUSINESS_CATEGORY, ZxLineDetFac.TRX_LINE_DATE, ZxLineDetFac.TRX_LINE_DESCRIPTION, ZxLineDetFac.USER_DEFINED_FISC_CLASS, (SELECT registration_number FROM zx_registrations WHERE registration_id = ZxLineDetFac.First_pty_reg_id AND ROWNUM = 1 ) HQ_ESTB_REG_NUMBER, 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 SELF_ASSESSED_FLAG, null TAX, null TAX_CURRENCY_CODE , null TAX_CURRENCY_CONVERSION_DATE , null TAX_CURRENCY_CONVERSION_RATE , null TAX_CURRENCY_CONVERSION_TYPE , null TAX_DATE, null TAX_DIST_AMT, null TAX_DIST_AMT_TAX_CURR, null TAX_JURISDICTION_CODE, null TAX_ONLY_LINE_FLAG, NULL TAX_POINT_BASIS, null TAX_POINT_DATE, null TAX_RATE , null TAX_RATE_CODE , null TAX_RATE_TYPE, null TAX_REGIME_CODE , (SELECT registration_number FROM zx_registrations WHERE registration_id = ZxLineDetFac.Third_pty_reg_id AND ROWNUM = 1 ) TAX_REGISTRATION_NUMBER, null TAX_STATUS_CODE , 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 = 'SALES_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, ZxTrxTaxDist.tax_dist_id LINE_NUMBER, ZxLineDetFac.LEDGER_ID, ZxTrxTaxDist.tax_dist_id TAX_REC_NREC_DIST_REF_ID, ZxLines.TAX_LINE_ID TAX_LINE_REF_ID, ZxTrxTaxDist.tax_dist_id SOURCE_DISTRIBUTION_ID_NUM_1, ZxTrxTaxDist.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, ZxLineDetFac.LINE_INTENDED_USE INTENDED_USE, 'Tax' DISTRIBUTION_TYPE, ZxLineDetFac.DOCUMENT_SUB_TYPE, ZxTrxTaxDist.TAX_DIST_AMT ENTERED_AMOUNT, ZxTrxTaxDist.trx_currency_code ENTERED_CURRENCY_CODE, ZxTrxTaxDist.TAX_DIST_AMT_FUNCL_CURR ACCOUNTED_AMOUNT, ZxTrxTaxDist.GL_DATE, 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, 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, ZxLineDetFac.TAX_REPORTING_FLAG, ZxLineDetFac.TRX_BUSINESS_CATEGORY, ZxLines.TRX_LINE_DATE, ZxLineDetFac.TRX_LINE_DESCRIPTION, ZxLineDetFac.USER_DEFINED_FISC_CLASS, (SELECT registration_number FROM zx_registrations WHERE registration_id = ZxLineDetFac.First_pty_reg_id AND ROWNUM = 1 ) HQ_ESTB_REG_NUMBER, ZxTrxTaxDist.INCLUSIVE_FLAG, ZxLines.LEGAL_ENTITY_TAX_REG_NUMBER, ZxLines.OFFSET_FLAG, ZxLines.OFFSET_TAX_RATE_CODE, ZxLines.PLACE_OF_SUPPLY, ZxTrxTaxDist.REPORTABLE_FLAG, ZxLines.SELF_ASSESSED_FLAG, ZxTrxTaxDist.TAX , ZxTrxTaxDist.TAX_CURRENCY_CODE , ZxTrxTaxDist.TAX_CURRENCY_CONVERSION_DATE , ZxTrxTaxDist.TAX_CURRENCY_CONVERSION_RATE , ZxTrxTaxDist.TAX_CURRENCY_CONVERSION_TYPE , ZxLines.TAX_DATE, ZxTrxTaxDist.TAX_DIST_AMT, ZxTrxTaxDist.TAX_DIST_AMT_TAX_CURR, ZxTrxTaxDist.TAX_JURISDICTION_CODE, ZxTrxTaxDist.TAX_ONLY_LINE_FLAG, ZxTrxTaxDist.TAX_POINT_BASIS, ZxTrxTaxDist.TAX_POINT_DATE, ZxTrxTaxDist.TAX_RATE , ZxTrxTaxDist.TAX_RATE_CODE , ZxLines.TAX_RATE_TYPE, ZxTrxTaxDist.TAX_REGIME_CODE , (SELECT registration_number FROM zx_registrations WHERE registration_id = ZxLineDetFac.Third_pty_reg_id AND ROWNUM = 1 ) TAX_REGISTRATION_NUMBER, ZxTrxTaxDist.TAX_STATUS_CODE , ZxLines.TAX_TYPE_CODE, ZxTrxTaxDist.CREDIT_ACCOUNT_CCID, ZxTrxTaxDist.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_trx_tax_distributions ZxTrxTaxDist, 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 = 'SALES_TRANSACTION' AND ZxLineDetFac.event_class_code != 'ADVANCE_RECEIPT' 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 = ZxTrxTaxDist.APPLICATION_ID and ZxLines.ENTITY_CODE = ZxTrxTaxDist.ENTITY_CODE and ZxLines.EVENT_CLASS_CODE = ZxTrxTaxDist.EVENT_CLASS_CODE and ZxLines.TRX_ID = ZxTrxTaxDist.TRX_ID and ZxLines.TRX_LINE_ID = ZxTrxTaxDist.TRX_LINE_ID and ZxLines.TAX_LINE_ID = ZxTrxTaxDist.TAX_LINE_ID and ZxLines.TRX_LEVEL_TYPE = ZxTrxTaxDist.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, ZxTrxTaxDist.tax_dist_id LINE_NUMBER, ZxLineDetFac.LEDGER_ID, ZxTrxTaxDist.tax_dist_id TAX_REC_NREC_DIST_REF_ID, ZxLines.TAX_LINE_ID TAX_LINE_REF_ID, ZxTrxTaxDist.tax_dist_id SOURCE_DISTRIBUTION_ID_NUM_1, ZxTrxTaxDist.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, ZxLineDetFac.LINE_INTENDED_USE INTENDED_USE, decode(ZxTrxTaxDist.event_type_code,'ADVANCE_RECEIPT_CREATE','Tax','Tax_Reversal') DISTRIBUTION_TYPE, ZxLineDetFac.DOCUMENT_SUB_TYPE, ZxTrxTaxDist.TAX_DIST_AMT ENTERED_AMOUNT, ZxTrxTaxDist.trx_currency_code ENTERED_CURRENCY_CODE, ZxTrxTaxDist.TAX_DIST_AMT_FUNCL_CURR ACCOUNTED_AMOUNT, ZxTrxTaxDist.GL_DATE, 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, 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, ZxLineDetFac.TAX_REPORTING_FLAG, ZxLineDetFac.TRX_BUSINESS_CATEGORY, ZxLines.TRX_LINE_DATE, ZxLineDetFac.TRX_LINE_DESCRIPTION, ZxLineDetFac.USER_DEFINED_FISC_CLASS, (SELECT registration_number FROM zx_registrations WHERE registration_id = ZxLineDetFac.First_pty_reg_id AND ROWNUM = 1 ) HQ_ESTB_REG_NUMBER, ZxTrxTaxDist.INCLUSIVE_FLAG, ZxLines.LEGAL_ENTITY_TAX_REG_NUMBER, ZxLines.OFFSET_FLAG, ZxLines.OFFSET_TAX_RATE_CODE, ZxLines.PLACE_OF_SUPPLY, ZxTrxTaxDist.REPORTABLE_FLAG, ZxLines.SELF_ASSESSED_FLAG, ZxTrxTaxDist.TAX , ZxTrxTaxDist.TAX_CURRENCY_CODE , ZxTrxTaxDist.TAX_CURRENCY_CONVERSION_DATE , ZxTrxTaxDist.TAX_CURRENCY_CONVERSION_RATE , ZxTrxTaxDist.TAX_CURRENCY_CONVERSION_TYPE , ZxLines.TAX_DATE, ZxTrxTaxDist.TAX_DIST_AMT, ZxTrxTaxDist.TAX_DIST_AMT_TAX_CURR, ZxTrxTaxDist.TAX_JURISDICTION_CODE, ZxTrxTaxDist.TAX_ONLY_LINE_FLAG, ZxTrxTaxDist.TAX_POINT_BASIS, ZxTrxTaxDist.TAX_POINT_DATE, ZxTrxTaxDist.TAX_RATE , ZxTrxTaxDist.TAX_RATE_CODE , ZxLines.TAX_RATE_TYPE, ZxTrxTaxDist.TAX_REGIME_CODE , (SELECT registration_number FROM zx_registrations WHERE registration_id = ZxLineDetFac.Third_pty_reg_id AND ROWNUM = 1 ) TAX_REGISTRATION_NUMBER, ZxTrxTaxDist.TAX_STATUS_CODE , ZxLines.TAX_TYPE_CODE, ZxTrxTaxDist.CREDIT_ACCOUNT_CCID, ZxTrxTaxDist.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_trx_tax_distributions ZxTrxTaxDist, 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 = 'SALES_TRANSACTION' AND ZxLineDetFac.event_class_code = 'ADVANCE_RECEIPT' 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 = ZxTrxTaxDist.APPLICATION_ID AND ZxLines.ENTITY_CODE = ZxTrxTaxDist.ENTITY_CODE AND ZxLines.EVENT_CLASS_CODE = ZxTrxTaxDist.EVENT_CLASS_CODE AND ZxLines.TRX_ID = ZxTrxTaxDist.TRX_ID AND ZxLines.TRX_LINE_ID = ZxTrxTaxDist.TRX_LINE_ID AND ZxLines.TAX_LINE_ID = ZxTrxTaxDist.TAX_LINE_ID 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 XlaTransEnt.source_id_int_1 = ZxLineDetFac.TRX_ID AND XlaTransEnt.entity_id = XlaEvent.entity_id AND ZxLineDetFac.ledger_id = GlLedger.ledger_id AND XlaTransEnt.entity_code = 'SALES_TRANSACTION' AND XlaEvent.event_id = ZxTrxTaxDist.accounting_event_id) ) |