ZX_P2P_CALC_TXN_INPUT_V

Details

• Schema: FUSION

• Object owner: ZX

• Object type: VIEW

Columns

Name

INTERNAL_ORGANIZATION_ID DOCUMENT_TYPE_ID TRANSACTION_ID APPLICATION_CODE DOCUMENT_LEVEL_ACTION TRX_DATE TRX_CURRENCY_CODE LEGAL_ENTITY_NUMBER ESTABLISHMENT_NUMBER TRANSACTION_NUMBER TRANSACTION_DESCRIPTION DOCUMENT_SEQUENCE_VALUE TRANSACTION_DUE_DATE ALLOW_TAX_CALCULATION TRANSACTION_LINE_ID TRX_LEVEL_TYPE LINE_LEVEL_ACTION LINE_CLASS TRANSACTION_SHIPPING_DATE TRANSACTION_RECEIPT_DATE TRANSACTION_LINE_TYPE TRANSACTION_LINE_DATE PROVNL_TAX_DETERMINATION_DATE TRX_BUSINESS_CATEGORY LINE_INTENDED_USE LINE_AMT_INCLUDES_TAX_FLAG LINE_AMOUNT OTHER_INCLUSIVE_TAX_AMOUNT TRANSACTION_LINE_QUANTITY UNIT_PRICE CASH_DISCOUNT VOLUME_DISCOUNT TRADING_DISCOUNT TRANSPORTATION_CHARGE INSURANCE_CHARGE OTHER_CHARGE PRODUCT_ID UOM_CODE PRODUCT_TYPE PRODUCT_CODE FOB_POINT SHIP_TO_PARTY_NUMBER SHIP_TO_PARTY_NAME SHIP_FROM_PARTY_NUMBER SHIP_FROM_PARTY_NAME SHIP_TO_LOC_ID SHIP_TO_GEOGRAPHY_TYPE1 SHIP_TO_GEOGRAPHY_VALUE1 SHIP_TO_GEOGRAPHY_TYPE2 SHIP_TO_GEOGRAPHY_VALUE2 SHIP_TO_GEOGRAPHY_TYPE3 SHIP_TO_GEOGRAPHY_VALUE3 SHIP_TO_GEOGRAPHY_TYPE4 SHIP_TO_GEOGRAPHY_VALUE4 SHIP_TO_GEOGRAPHY_TYPE5 SHIP_TO_GEOGRAPHY_VALUE5 SHIP_TO_GEOGRAPHY_TYPE6 SHIP_TO_GEOGRAPHY_VALUE6 SHIP_TO_GEOGRAPHY_TYPE7 SHIP_TO_GEOGRAPHY_VALUE7 SHIP_TO_GEOGRAPHY_TYPE8 SHIP_TO_GEOGRAPHY_VALUE8 SHIP_TO_GEOGRAPHY_TYPE9 SHIP_TO_GEOGRAPHY_VALUE9 SHIP_TO_GEOGRAPHY_TYPE10 SHIP_TO_GEOGRAPHY_VALUE10 SHIP_FROM_LOC_ID SHIP_FROM_GEOGRAPHY_TYPE1 SHIP_FROM_GEOGRAPHY_VALUE1 SHIP_FROM_GEOGRAPHY_TYPE2 SHIP_FROM_GEOGRAPHY_VALUE2 SHIP_FROM_GEOGRAPHY_TYPE3 SHIP_FROM_GEOGRAPHY_VALUE3 SHIP_FROM_GEOGRAPHY_TYPE4 SHIP_FROM_GEOGRAPHY_VALUE4 SHIP_FROM_GEOGRAPHY_TYPE5 SHIP_FROM_GEOGRAPHY_VALUE5 SHIP_FROM_GEOGRAPHY_TYPE6 SHIP_FROM_GEOGRAPHY_VALUE6 SHIP_FROM_GEOGRAPHY_TYPE7 SHIP_FROM_GEOGRAPHY_VALUE7 SHIP_FROM_GEOGRAPHY_TYPE8 SHIP_FROM_GEOGRAPHY_VALUE8 SHIP_FROM_GEOGRAPHY_TYPE9 SHIP_FROM_GEOGRAPHY_VALUE9 SHIP_FROM_GEOGRAPHY_TYPE10 SHIP_FROM_GEOGRAPHY_VALUE10 POA_LOC_ID POA_GEOGRAPHY_TYPE1 POA_GEOGRAPHY_VALUE1 POA_GEOGRAPHY_TYPE2 POA_GEOGRAPHY_VALUE2 POA_GEOGRAPHY_TYPE3 POA_GEOGRAPHY_VALUE3 POA_GEOGRAPHY_TYPE4 POA_GEOGRAPHY_VALUE4 POA_GEOGRAPHY_TYPE5 POA_GEOGRAPHY_VALUE5 POA_GEOGRAPHY_TYPE6 POA_GEOGRAPHY_VALUE6 POA_GEOGRAPHY_TYPE7 POA_GEOGRAPHY_VALUE7 POA_GEOGRAPHY_TYPE8 POA_GEOGRAPHY_VALUE8 POA_GEOGRAPHY_TYPE9 POA_GEOGRAPHY_VALUE9 POA_GEOGRAPHY_TYPE10 POA_GEOGRAPHY_VALUE10 POO_LOC_ID POO_GEOGRAPHY_TYPE1 POO_GEOGRAPHY_VALUE1 POO_GEOGRAPHY_TYPE2 POO_GEOGRAPHY_VALUE2 POO_GEOGRAPHY_TYPE3 POO_GEOGRAPHY_VALUE3 POO_GEOGRAPHY_TYPE4 POO_GEOGRAPHY_VALUE4 POO_GEOGRAPHY_TYPE5 POO_GEOGRAPHY_VALUE5 POO_GEOGRAPHY_TYPE6 POO_GEOGRAPHY_VALUE6 POO_GEOGRAPHY_TYPE7 POO_GEOGRAPHY_VALUE7 POO_GEOGRAPHY_TYPE8 POO_GEOGRAPHY_VALUE8 POO_GEOGRAPHY_TYPE9 POO_GEOGRAPHY_VALUE9 POO_GEOGRAPHY_TYPE10 POO_GEOGRAPHY_VALUE10 BILL_TO_PARTY_NUMBER BILL_TO_PARTY_NAME BILL_FROM_PARTY_NUMBER BILL_FROM_PARTY_NAME BILL_TO_LOC_ID BILL_TO_GEOGRAPHY_TYPE1 BILL_TO_GEOGRAPHY_VALUE1 BILL_TO_GEOGRAPHY_TYPE2 BILL_TO_GEOGRAPHY_VALUE2 BILL_TO_GEOGRAPHY_TYPE3 BILL_TO_GEOGRAPHY_VALUE3 BILL_TO_GEOGRAPHY_TYPE4 BILL_TO_GEOGRAPHY_VALUE4 BILL_TO_GEOGRAPHY_TYPE5 BILL_TO_GEOGRAPHY_VALUE5 BILL_TO_GEOGRAPHY_TYPE6 BILL_TO_GEOGRAPHY_VALUE6 BILL_TO_GEOGRAPHY_TYPE7 BILL_TO_GEOGRAPHY_VALUE7 BILL_TO_GEOGRAPHY_TYPE8 BILL_TO_GEOGRAPHY_VALUE8 BILL_TO_GEOGRAPHY_TYPE9 BILL_TO_GEOGRAPHY_VALUE9 BILL_TO_GEOGRAPHY_TYPE10 BILL_TO_GEOGRAPHY_VALUE10 BILL_FROM_LOC_ID BILL_FROM_GEOGRAPHY_TYPE1 BILL_FROM_GEOGRAPHY_VALUE1 BILL_FROM_GEOGRAPHY_TYPE2 BILL_FROM_GEOGRAPHY_VALUE2 BILL_FROM_GEOGRAPHY_TYPE3 BILL_FROM_GEOGRAPHY_VALUE3 BILL_FROM_GEOGRAPHY_TYPE4 BILL_FROM_GEOGRAPHY_VALUE4 BILL_FROM_GEOGRAPHY_TYPE5 BILL_FROM_GEOGRAPHY_VALUE5 BILL_FROM_GEOGRAPHY_TYPE6 BILL_FROM_GEOGRAPHY_VALUE6 BILL_FROM_GEOGRAPHY_TYPE7 BILL_FROM_GEOGRAPHY_VALUE7 BILL_FROM_GEOGRAPHY_TYPE8 BILL_FROM_GEOGRAPHY_VALUE8 BILL_FROM_GEOGRAPHY_TYPE9 BILL_FROM_GEOGRAPHY_VALUE9 BILL_FROM_GEOGRAPHY_TYPE10 BILL_FROM_GEOGRAPHY_VALUE10 ACCOUNT_CCID APPLIED_FROM_DOCUMENT_TYPE_ID APPLIED_FROM_TRANSACTION_ID APPLIED_FROM_LINE_ID APPLIED_FROM_TRX_LEVEL_TYPE APPLIED_FROM_DOC_NUMBER ADJUSTED_DOC_DOCUMENT_TYPE_ID ADJUSTED_DOC_TRANSACTION_ID ADJUSTED_DOC_LINE_ID ADJUSTED_DOC_TRX_LEVEL_TYPE ADJUSTED_DOC_NUMBER ADJUSTED_DOC_DATE ASSESSABLE_VALUE TRX_LINE_NUMBER TRX_LINE_DESCRIPTION PRODUCT_DESCRIPTION HEADER_CHAR1 HEADER_CHAR2 HEADER_CHAR3 HEADER_CHAR4 HEADER_CHAR5 HEADER_CHAR6 HEADER_CHAR7 HEADER_CHAR8 HEADER_CHAR9 HEADER_CHAR10 HEADER_CHAR11 HEADER_CHAR12 HEADER_CHAR13 HEADER_CHAR14 HEADER_CHAR15 HEADER_CHAR16 HEADER_CHAR17 HEADER_CHAR18 HEADER_CHAR19 HEADER_CHAR20 HEADER_CHAR21 HEADER_CHAR22 HEADER_CHAR23 HEADER_CHAR24 HEADER_CHAR25 HEADER_CHAR26 HEADER_CHAR27 HEADER_CHAR28 HEADER_CHAR29 HEADER_CHAR30 HEADER_NUMERIC1 HEADER_NUMERIC2 HEADER_NUMERIC3 HEADER_NUMERIC4 HEADER_NUMERIC5 HEADER_NUMERIC6 HEADER_NUMERIC7 HEADER_NUMERIC8 HEADER_NUMERIC9 HEADER_NUMERIC10 HEADER_DATE1 HEADER_DATE2 HEADER_DATE3 HEADER_DATE4 HEADER_DATE5 LINE_CHAR1 LINE_CHAR2 LINE_CHAR3 LINE_CHAR4 LINE_CHAR5 LINE_CHAR6 LINE_CHAR7 LINE_CHAR8 LINE_CHAR9 LINE_CHAR10 LINE_CHAR11 LINE_CHAR12 LINE_CHAR13 LINE_CHAR14 LINE_CHAR15 LINE_CHAR16 LINE_CHAR17 LINE_CHAR18 LINE_CHAR19 LINE_CHAR20 LINE_CHAR21 LINE_CHAR22 LINE_CHAR23 LINE_CHAR24 LINE_CHAR25 LINE_CHAR26 LINE_CHAR27 LINE_CHAR28 LINE_CHAR29 LINE_CHAR30 LINE_NUMERIC1 LINE_NUMERIC2 LINE_NUMERIC3 LINE_NUMERIC4 LINE_NUMERIC5 LINE_NUMERIC6 LINE_NUMERIC7 LINE_NUMERIC8 LINE_NUMERIC9 LINE_NUMERIC10 LINE_DATE1 LINE_DATE2 LINE_DATE3 LINE_DATE4 LINE_DATE5 EXEMPT_CERTIFICATE_NUMBER EXEMPT_REASON EXEMPTION_CONTROL_FLAG TAX_CODE DOC_SEQ_NAME BATCH_SOURCE_NAME TRX_TYPE_DESCRIPTION TRX_LINE_GL_DATE TRX_LINE_CURRENCY_CONV_DATE TRX_LINE_CURRENCY_CONV_RATE TRX_LINE_CURRENCY_CONV_TYPE TRX_LINE_MAU TRX_LINE_PRECISION PRODUCT_ORG_ID EXEMPT_REASON_CODE APPLIED_TO_DOCUMENT_TYPE_ID APPLIED_TO_TRANSACTION_ID APPLIED_TO_TRX_LINE_ID APPLIED_TO_TRX_LEVEL_TYPE APPLIED_TO_DOC_NUMBER CHAR1 CHAR2 CHAR3 CHAR4 CHAR5 CHAR6 CHAR7 CHAR8 CHAR9 CHAR10 CURRENCY_CONVERSION_RATE CURRENCY_CONVERSION_DATE CURRENCY_CONVERSION_TYPE DATE1 DATE2 DATE3 DATE4 DATE5 DATE6 DATE7 DATE8 DATE9 DATE10 DOCUMENT_SUB_TYPE FIRST_PTY_ORG_ID ESTABLISHMENT_ID INTERNAL_ORG_LOCATION_ID REF_DOC_DOCUMENT_TYPE_ID REF_DOC_TRANSACTION_ID REF_DOC_LINE_ID REF_DOC_TRX_LEVEL_TYPE REL_DOC_DOCUMENT_TYPE_ID RELATED_DOC_DATE RELATED_DOC_NUMBER REL_DOC_TRANSACTION_ID SOURCE_DOCUMENT_TYPE_ID SOURCE_TRANSACTION_ID SOURCE_TRX_LEVEL_TYPE SOURCE_LINE_ID SUPPLIER_TAX_INVOICE_DATE SUPPLIER_TAX_INVOICE_NUMBER SUPPLIER_EXCHANGE_RATE TAX_INVOICE_NUMBER TAX_INVOICE_DATE USER_DEFINED_FISC_CLASS PRODUCT_CATEGORY PRODUCT_FISC_CLASSIFICATION TRANSFER_CHARGE START_EXPENSE_DATE MERCHANT_PARTY_COUNTRY MERCHANT_PARTY_DOCUMENT_NUMBER MERCHANT_PARTY_NAME MERCHANT_PARTY_REFERENCE MERCHANT_PARTY_TAX_REG_NUMBER MERCHANT_PARTY_TAXPAYER_ID NUMERIC1 NUMERIC2 NUMERIC3 NUMERIC4 NUMERIC5 NUMERIC6 NUMERIC7 NUMERIC8 NUMERIC9 NUMERIC10

Query

SQL_Statement

SELECT internal_organization_id, event_class_mapping_id document_type_id, trx_id transaction_id, application_short_name application_code, tax_event_type_code document_level_action, trx_date, trx_currency_code, legal_entity_number, establishment_number, trx_number transaction_number, trx_description transaction_description, doc_seq_value document_sequence_value, trx_due_date transaction_due_date, allow_tax_calculation_flag allow_tax_calculation, trx_line_id transaction_line_id, trx_level_type, line_level_action1 line_level_action, line_class, trx_shipping_date transaction_shipping_date, trx_receipt_date transaction_receipt_date, trx_line_type transaction_line_type, trx_line_date transaction_line_date, provnl_tax_determination_date, trx_business_category1 trx_business_category, line_intended_use, line_amt_includes_tax_flag1 line_amt_includes_tax_flag, line_amt line_amount, other_inclusive_tax_amount1 other_inclusive_tax_amount, trx_line_quantity transaction_line_quantity, unit_price, cash_discount, volume_discount, trading_discount, transportation_charge, insurance_charge, other_charge, product_id, uom_code, product_type, product_code, fob_point, ship_to_party_number, ship_to_party_name, ship_from_party_number, ship_from_party_name, ship_to_location_id ship_to_loc_id, ship_to_geography_type1, ship_to_geography_value1, ship_to_geography_type2, ship_to_geography_value2, ship_to_geography_type3, ship_to_geography_value3, ship_to_geography_type4, ship_to_geography_value4, ship_to_geography_type5, ship_to_geography_value5, ship_to_geography_type6, ship_to_geography_value6, ship_to_geography_type7, ship_to_geography_value7, ship_to_geography_type8, ship_to_geography_value8, ship_to_geography_type9, ship_to_geography_value9, ship_to_geography_type10, ship_to_geography_value10, ship_from_location_id ship_from_loc_id, ship_from_geography_type1, ship_from_geography_value1, ship_from_geography_type2, ship_from_geography_value2, ship_from_geography_type3, ship_from_geography_value3, ship_from_geography_type4, ship_from_geography_value4, ship_from_geography_type5, ship_from_geography_value5, ship_from_geography_type6, ship_from_geography_value6, ship_from_geography_type7, ship_from_geography_value7, ship_from_geography_type8, ship_from_geography_value8, ship_from_geography_type9, ship_from_geography_value9, ship_from_geography_type10, ship_from_geography_value10, poa_location_id poa_loc_id, poa_geography_type1, poa_geography_value1, poa_geography_type2, poa_geography_value2, poa_geography_type3, poa_geography_value3, poa_geography_type4, poa_geography_value4, poa_geography_type5, poa_geography_value5, poa_geography_type6, poa_geography_value6, poa_geography_type7, poa_geography_value7, poa_geography_type8, poa_geography_value8, poa_geography_type9, poa_geography_value9, poa_geography_type10, poa_geography_value10, poo_location_id poo_loc_id, poo_geography_type1, poo_geography_value1, poo_geography_type2, poo_geography_value2, poo_geography_type3, poo_geography_value3, poo_geography_type4, poo_geography_value4, poo_geography_type5, poo_geography_value5, poo_geography_type6, poo_geography_value6, poo_geography_type7, poo_geography_value7, poo_geography_type8, poo_geography_value8, poo_geography_type9, poo_geography_value9, poo_geography_type10, poo_geography_value10, bill_to_party_number, bill_to_party_name, bill_from_party_number, bill_from_party_name, bill_to_location_id bill_to_loc_id, bill_to_geography_type1, bill_to_geography_value1, bill_to_geography_type2, bill_to_geography_value2, bill_to_geography_type3, bill_to_geography_value3, bill_to_geography_type4, bill_to_geography_value4, bill_to_geography_type5, bill_to_geography_value5, bill_to_geography_type6, bill_to_geography_value6, bill_to_geography_type7, bill_to_geography_value7, bill_to_geography_type8, bill_to_geography_value8, bill_to_geography_type9, bill_to_geography_value9, bill_to_geography_type10, bill_to_geography_value10, bill_from_location_id bill_from_loc_id, bill_from_geography_type1, bill_from_geography_value1, bill_from_geography_type2, bill_from_geography_value2, bill_from_geography_type3, bill_from_geography_value3, bill_from_geography_type4, bill_from_geography_value4, bill_from_geography_type5, bill_from_geography_value5, bill_from_geography_type6, bill_from_geography_value6, bill_from_geography_type7, bill_from_geography_value7, bill_from_geography_type8, bill_from_geography_value8, bill_from_geography_type9, bill_from_geography_value9, bill_from_geography_type10, bill_from_geography_value10, account_ccid, applied_from_document_type_id1 applied_from_document_type_id, applied_from_trx_id applied_from_transaction_id, applied_from_line_id, applied_from_trx_level_type, applied_from_trx_number applied_from_doc_number, adjusted_doc_document_type_id1 adjusted_doc_document_type_id, adjusted_doc_trx_id adjusted_doc_transaction_id, adjusted_doc_line_id, adjusted_doc_trx_level_type, adjusted_doc_number, adjusted_doc_date, assessable_value, trx_line_number, trx_line_description, product_description, header_ext_varchar_attribute1 header_char1, header_ext_varchar_attribute2 header_char2, header_ext_varchar_attribute3 header_char3, header_ext_varchar_attribute4 header_char4, header_ext_varchar_attribute5 header_char5, header_ext_varchar_attribute6 header_char6, header_ext_varchar_attribute7 header_char7, header_ext_varchar_attribute8 header_char8, header_ext_varchar_attribute9 header_char9, header_ext_varchar_attribute10 header_char10, header_ext_varchar_attribute11 header_char11, header_ext_varchar_attribute12 header_char12, header_ext_varchar_attribute13 header_char13, header_ext_varchar_attribute14 header_char14, header_ext_varchar_attribute15 header_char15, header_ext_varchar_attribute16 header_char16, header_ext_varchar_attribute17 header_char17, header_ext_varchar_attribute18 header_char18, header_ext_varchar_attribute19 header_char19, header_ext_varchar_attribute20 header_char20, header_ext_varchar_attribute21 header_char21, header_ext_varchar_attribute22 header_char22, header_ext_varchar_attribute23 header_char23, header_ext_varchar_attribute24 header_char24, header_ext_varchar_attribute25 header_char25, header_ext_varchar_attribute26 header_char26, header_ext_varchar_attribute27 header_char27, header_ext_varchar_attribute28 header_char28, header_ext_varchar_attribute29 header_char29, header_ext_varchar_attribute30 header_char30, header_ext_number_attribute1 header_numeric1, header_ext_number_attribute2 header_numeric2, header_ext_number_attribute3 header_numeric3, header_ext_number_attribute4 header_numeric4, header_ext_number_attribute5 header_numeric5, header_ext_number_attribute6 header_numeric6, header_ext_number_attribute7 header_numeric7, header_ext_number_attribute8 header_numeric8, header_ext_number_attribute9 header_numeric9, header_ext_number_attribute10 header_numeric10, header_ext_date_attribute1 header_date1, header_ext_date_attribute2 header_date2, header_ext_date_attribute3 header_date3, header_ext_date_attribute4 header_date4, header_ext_date_attribute5 header_date5, line_ext_varchar_attribute1 line_char1, line_ext_varchar_attribute2 line_char2, line_ext_varchar_attribute3 line_char3, line_ext_varchar_attribute4 line_char4, line_ext_varchar_attribute5 line_char5, line_ext_varchar_attribute6 line_char6, line_ext_varchar_attribute7 line_char7, line_ext_varchar_attribute8 line_char8, line_ext_varchar_attribute9 line_char9, line_ext_varchar_attribute10 line_char10, line_ext_varchar_attribute11 line_char11, line_ext_varchar_attribute12 line_char12, line_ext_varchar_attribute13 line_char13, line_ext_varchar_attribute14 line_char14, line_ext_varchar_attribute15 line_char15, line_ext_varchar_attribute16 line_char16, line_ext_varchar_attribute17 line_char17, line_ext_varchar_attribute18 line_char18, line_ext_varchar_attribute19 line_char19, line_ext_varchar_attribute20 line_char20, line_ext_varchar_attribute21 line_char21, line_ext_varchar_attribute22 line_char22, line_ext_varchar_attribute23 line_char23, line_ext_varchar_attribute24 line_char24, line_ext_varchar_attribute25 line_char25, line_ext_varchar_attribute26 line_char26, line_ext_varchar_attribute27 line_char27, line_ext_varchar_attribute28 line_char28, line_ext_varchar_attribute29 line_char29, line_ext_varchar_attribute30 line_char30, line_ext_number_attribute1 line_numeric1, line_ext_number_attribute2 line_numeric2, line_ext_number_attribute3 line_numeric3, line_ext_number_attribute4 line_numeric4, line_ext_number_attribute5 line_numeric5, line_ext_number_attribute6 line_numeric6, line_ext_number_attribute7 line_numeric7, line_ext_number_attribute8 line_numeric8, line_ext_number_attribute9 line_numeric9, line_ext_number_attribute10 line_numeric10, line_ext_date_attribute1 line_date1, line_ext_date_attribute2 line_date2, line_ext_date_attribute3 line_date3, line_ext_date_attribute4 line_date4, line_ext_date_attribute5 line_date5, exempt_certificate_number, exempt_reason , exemption_control_flag, tax_code, doc_seq_name, batch_source_name, trx_type_description, trx_line_gl_date, trx_line_currency_conv_date, trx_line_currency_conv_rate, trx_line_currency_conv_type, trx_line_mau, trx_line_precision, product_org_id, exempt_reason_code, applied_to_document_type_id, applied_to_transaction_id, applied_to_trx_line_id, applied_to_trx_level_type, applied_to_doc_number, char1, char2, char3, char4, char5, char6, char7, char8, char9, char10, currency_conversion_rate, currency_conversion_date, currency_conversion_type, date1, date2, date3, date4, date5, date6, date7, date8, date9, date10, document_sub_type, first_pty_org_id, establishment_id, internal_org_location_id, ref_doc_document_type_id, ref_doc_transaction_id, ref_doc_line_id, ref_doc_trx_level_type, rel_doc_document_type_id, related_doc_date, related_doc_number, rel_doc_transaction_id, source_document_type_id, source_transaction_id, source_trx_level_type, source_line_id, supplier_tax_invoice_date, supplier_tax_invoice_number, supplier_exchange_rate, tax_invoice_number, tax_invoice_date, user_defined_fisc_class, product_category, product_fisc_classification, transfer_charge, start_expense_date, merchant_party_country, merchant_party_document_number, merchant_party_name, merchant_party_reference, merchant_party_tax_reg_number, merchant_party_taxpayer_id, numeric1, numeric2, numeric3, numeric4, numeric5, numeric6, numeric7, numeric8, numeric9, numeric10 FROM (SELECT zldf.internal_organization_id, zldf.event_class_mapping_id, zldf.trx_id, ztppo.application_short_name, zldf.tax_event_type_code, zldf.trx_date, zldf.trx_currency_code, ztppo.legal_entity_number, ztppo.establishment_number, zldf.trx_number, zldf.trx_description, zldf.doc_seq_value, zldf.trx_due_date, ztppo.allow_tax_calculation_flag, zldf.trx_line_id, zldf.trx_level_type, DECODE(ztppo.record_for_partners_flag,'N', DECODE(zldf.line_level_action,'UPDATE','QUOTE','CREATE','QUOTE','ALLOCATE_TAX_ONLY_ADJUSTMENT', 'QUOTE','ALLOCATE_LINE_ONLY_ADJUSTMENT','QUOTE','LINE_INFO_TAX_ONLY', 'QUOTE','DISCARD','CANCEL',zldf.line_level_action), 'Y', DECODE(zldf.tax_event_type_code, 'UPDATE', DECODE(zldf.line_level_action,'CREATE_TAX_ONLY','QUOTE', 'COPY_AND_CREATE','UPDATE','ALLOCATE_TAX_ONLY_ADJUSTMENT', 'CREATE','ALLOCATE_LINE_ONLY_ADJUSTMENT','CREATE','LINE_INFO_TAX_ONLY','UPDATE', 'DISCARD','CANCEL', DECODE(ztppo.partner_processing_flag,'F', DECODE(zldf.line_level_action, 'UPDATE', 'CREATE', zldf.line_level_action), DECODE(zldf.inclusive_tax_override_flag, 'Y','UPDATE', ZLDF.LINE_LEVEL_ACTION))), DECODE(zldf.line_level_action,'CREATE_TAX_ONLY','QUOTE', 'COPY_AND_CREATE','CREATE','ALLOCATE_TAX_ONLY_ADJUSTMENT', 'CREATE','ALLOCATE_LINE_ONLY_ADJUSTMENT','CREATE','LINE_INFO_TAX_ONLY','CREATE', 'DISCARD','CANCEL', DECODE(ztppo.partner_processing_flag,'F', DECODE(zldf.line_level_action, 'UPDATE', 'CREATE', zldf.line_level_action), DECODE(zldf.inclusive_tax_override_flag, 'Y','UPDATE', ZLDF.LINE_LEVEL_ACTION))))) line_level_action1, zldf.line_class, zldf.trx_shipping_date, zldf.trx_receipt_date, zldf.trx_line_type, zldf.trx_line_date, zldf.provnl_tax_determination_date, NVL(zldf.trx_business_category, ztppo.event_class_code) trx_business_category1, zldf.line_intended_use, DECODE (zldf.line_amt_includes_tax_flag, 'I','A', line_amt_includes_tax_flag) line_amt_includes_tax_flag1, zldf.line_amt, DECODE(zldf.line_amt_includes_tax_flag, 'S', ZX_TPI_SERVICES_PKG.get_incl_tax_amt(zldf.application_id, zldf.entity_code, zldf.event_class_code, zldf.trx_id, zldf.trx_line_id, zldf.trx_level_type, ztppo.tax_provider_id),NULL) other_inclusive_tax_amount1, zldf.trx_line_quantity, zldf.unit_price, zldf.cash_discount, zldf.volume_discount, zldf.trading_discount, zldf.transportation_charge, zldf.insurance_charge, zldf.other_charge, zldf.product_id, zldf.uom_code, zldf.product_type, zldf.product_code, zldf.fob_point, ptnr.ship_to_party_number, ptnr.ship_to_party_name, ptnr.ship_from_party_number, ptnr.ship_from_party_name, zldf.ship_to_location_id, ptnr.ship_to_geography_type1, ptnr.ship_to_geography_value1, ptnr.ship_to_geography_type2, ptnr.ship_to_geography_value2, ptnr.ship_to_geography_type3, ptnr.ship_to_geography_value3, ptnr.ship_to_geography_type4, ptnr.ship_to_geography_value4, ptnr.ship_to_geography_type5, ptnr.ship_to_geography_value5, ptnr.ship_to_geography_type6, ptnr.ship_to_geography_value6, ptnr.ship_to_geography_type7, ptnr.ship_to_geography_value7, ptnr.ship_to_geography_type8, ptnr.ship_to_geography_value8, ptnr.ship_to_geography_type9, ptnr.ship_to_geography_value9, ptnr.ship_to_geography_type10, ptnr.ship_to_geography_value10, zldf.ship_from_location_id, ptnr.ship_from_geography_type1, ptnr.ship_from_geography_value1, ptnr.ship_from_geography_type2, ptnr.ship_from_geography_value2, ptnr.ship_from_geography_type3, ptnr.ship_from_geography_value3, ptnr.ship_from_geography_type4, ptnr.ship_from_geography_value4, ptnr.ship_from_geography_type5, ptnr.ship_from_geography_value5, ptnr.ship_from_geography_type6, ptnr.ship_from_geography_value6, ptnr.ship_from_geography_type7, ptnr.ship_from_geography_value7, ptnr.ship_from_geography_type8, ptnr.ship_from_geography_value8, ptnr.ship_from_geography_type9, ptnr.ship_from_geography_value9, ptnr.ship_from_geography_type10, ptnr.ship_from_geography_value10, zldf.poa_location_id, ptnr.poa_geography_type1, ptnr.poa_geography_value1, ptnr.poa_geography_type2, ptnr.poa_geography_value2, ptnr.poa_geography_type3, ptnr.poa_geography_value3, ptnr.poa_geography_type4, ptnr.poa_geography_value4, ptnr.poa_geography_type5, ptnr.poa_geography_value5, ptnr.poa_geography_type6, ptnr.poa_geography_value6, ptnr.poa_geography_type7, ptnr.poa_geography_value7, ptnr.poa_geography_type8, ptnr.poa_geography_value8, ptnr.poa_geography_type9, ptnr.poa_geography_value9, ptnr.poa_geography_type10, ptnr.poa_geography_value10, zldf.poo_location_id, ptnr.poo_geography_type1, ptnr.poo_geography_value1, ptnr.poo_geography_type2, ptnr.poo_geography_value2, ptnr.poo_geography_type3, ptnr.poo_geography_value3, ptnr.poo_geography_type4, ptnr.poo_geography_value4, ptnr.poo_geography_type5, ptnr.poo_geography_value5, ptnr.poo_geography_type6, ptnr.poo_geography_value6, ptnr.poo_geography_type7, ptnr.poo_geography_value7, ptnr.poo_geography_type8, ptnr.poo_geography_value8, ptnr.poo_geography_type9, ptnr.poo_geography_value9, ptnr.poo_geography_type10, ptnr.poo_geography_value10, ptnr.bill_to_party_number, ptnr.bill_to_party_name, ptnr.bill_from_party_number, ptnr.bill_from_party_name, zldf.bill_to_location_id, ptnr.bill_to_geography_type1, ptnr.bill_to_geography_value1, ptnr.bill_to_geography_type2, ptnr.bill_to_geography_value2, ptnr.bill_to_geography_type3, ptnr.bill_to_geography_value3, ptnr.bill_to_geography_type4, ptnr.bill_to_geography_value4, ptnr.bill_to_geography_type5, ptnr.bill_to_geography_value5, ptnr.bill_to_geography_type6, ptnr.bill_to_geography_value6, ptnr.bill_to_geography_type7, ptnr.bill_to_geography_value7, ptnr.bill_to_geography_type8, ptnr.bill_to_geography_value8, ptnr.bill_to_geography_type9, ptnr.bill_to_geography_value9, ptnr.bill_to_geography_type10, ptnr.bill_to_geography_value10, zldf.bill_from_location_id, ptnr.bill_from_geography_type1, ptnr.bill_from_geography_value1, ptnr.bill_from_geography_type2, ptnr.bill_from_geography_value2, ptnr.bill_from_geography_type3, ptnr.bill_from_geography_value3, ptnr.bill_from_geography_type4, ptnr.bill_from_geography_value4, ptnr.bill_from_geography_type5, ptnr.bill_from_geography_value5, ptnr.bill_from_geography_type6, ptnr.bill_from_geography_value6, ptnr.bill_from_geography_type7, ptnr.bill_from_geography_value7, ptnr.bill_from_geography_type8, ptnr.bill_from_geography_value8, ptnr.bill_from_geography_type9, ptnr.bill_from_geography_value9, ptnr.bill_from_geography_type10, ptnr.bill_from_geography_value10, zldf.account_ccid, decode(zldf.applied_from_application_id, 222, NULL, 200, decode(zldf.APPLIED_FROM_EVENT_CLASS_CODE, 'STANDARD INVOICES', 1, 'PREPAYMENT INVOICES', 7, 'EXPENSE REPORTS', 2, NULL), 201, decode(zldf.APPLIED_FROM_EVENT_CLASS_CODE, 'PO_PA', 3, 'RELEASE', 12, 'CHARGES', 11, NULL), NULL) APPLIED_FROM_DOCUMENT_TYPE_ID1, zldf.applied_from_trx_id, zldf.applied_from_line_id, zldf.applied_from_trx_level_type, zldf.applied_from_trx_number, decode(zldf.adjusted_doc_application_id, 222, decode(zldf.ADJUSTED_DOC_EVENT_CLASS_CODE, 'INVOICE', 4, 'DEBIT_MEMO', 5, 'CREDIT_MEMO', 6, NULL), 200, decode(zldf.ADJUSTED_DOC_EVENT_CLASS_CODE, 'STANDARD INVOICES', 1, 'PREPAYMENT INVOICES', 7, 'EXPENSE REPORTS', 2, NULL), 201, decode(zldf.ADJUSTED_DOC_EVENT_CLASS_CODE, 'PO_PA', 3, 'RELEASE', 12, 'CHARGES', 11, NULL), NULL) ADJUSTED_DOC_DOCUMENT_TYPE_ID1, zldf.adjusted_doc_trx_id, zldf.adjusted_doc_line_id, zldf.adjusted_doc_trx_level_type, zldf.adjusted_doc_number, zldf.adjusted_doc_date, zldf.assessable_value, zldf.trx_line_number, zldf.trx_line_description, zldf.product_description, zpshea.HEADER_EXT_VARCHAR_ATTRIBUTE1, zpshea.HEADER_EXT_VARCHAR_ATTRIBUTE2, zpshea.HEADER_EXT_VARCHAR_ATTRIBUTE3, zpshea.HEADER_EXT_VARCHAR_ATTRIBUTE4, zpshea.HEADER_EXT_VARCHAR_ATTRIBUTE5, zpshea.HEADER_EXT_VARCHAR_ATTRIBUTE6, zpshea.HEADER_EXT_VARCHAR_ATTRIBUTE7, zpshea.HEADER_EXT_VARCHAR_ATTRIBUTE8, zpshea.HEADER_EXT_VARCHAR_ATTRIBUTE9, zpshea.HEADER_EXT_VARCHAR_ATTRIBUTE10, zpshea.HEADER_EXT_VARCHAR_ATTRIBUTE11, zpshea.HEADER_EXT_VARCHAR_ATTRIBUTE12, zpshea.HEADER_EXT_VARCHAR_ATTRIBUTE13, zpshea.HEADER_EXT_VARCHAR_ATTRIBUTE14, zpshea.HEADER_EXT_VARCHAR_ATTRIBUTE15, zpshea.HEADER_EXT_VARCHAR_ATTRIBUTE16, zpshea.HEADER_EXT_VARCHAR_ATTRIBUTE17, zpshea.HEADER_EXT_VARCHAR_ATTRIBUTE18, zpshea.HEADER_EXT_VARCHAR_ATTRIBUTE19, zpshea.HEADER_EXT_VARCHAR_ATTRIBUTE20, zpshea.HEADER_EXT_VARCHAR_ATTRIBUTE21, zpshea.HEADER_EXT_VARCHAR_ATTRIBUTE22, zpshea.HEADER_EXT_VARCHAR_ATTRIBUTE23, zpshea.HEADER_EXT_VARCHAR_ATTRIBUTE24, zpshea.HEADER_EXT_VARCHAR_ATTRIBUTE25, zpshea.HEADER_EXT_VARCHAR_ATTRIBUTE26, zpshea.HEADER_EXT_VARCHAR_ATTRIBUTE27, zpshea.HEADER_EXT_VARCHAR_ATTRIBUTE28, zpshea.HEADER_EXT_VARCHAR_ATTRIBUTE29, zpshea.HEADER_EXT_VARCHAR_ATTRIBUTE30, zpshea.HEADER_EXT_NUMBER_ATTRIBUTE1, zpshea.HEADER_EXT_NUMBER_ATTRIBUTE2, zpshea.HEADER_EXT_NUMBER_ATTRIBUTE3, zpshea.HEADER_EXT_NUMBER_ATTRIBUTE4, zpshea.HEADER_EXT_NUMBER_ATTRIBUTE5, zpshea.HEADER_EXT_NUMBER_ATTRIBUTE6, zpshea.HEADER_EXT_NUMBER_ATTRIBUTE7, zpshea.HEADER_EXT_NUMBER_ATTRIBUTE8, zpshea.HEADER_EXT_NUMBER_ATTRIBUTE9, zpshea.HEADER_EXT_NUMBER_ATTRIBUTE10, zpshea.HEADER_EXT_DATE_ATTRIBUTE1, zpshea.HEADER_EXT_DATE_ATTRIBUTE2, zpshea.HEADER_EXT_DATE_ATTRIBUTE3, zpshea.HEADER_EXT_DATE_ATTRIBUTE4, zpshea.HEADER_EXT_DATE_ATTRIBUTE5, zpslea.LINE_EXT_VARCHAR_ATTRIBUTE1, zpslea.LINE_EXT_VARCHAR_ATTRIBUTE2, zpslea.LINE_EXT_VARCHAR_ATTRIBUTE3, zpslea.LINE_EXT_VARCHAR_ATTRIBUTE4, zpslea.LINE_EXT_VARCHAR_ATTRIBUTE5, zpslea.LINE_EXT_VARCHAR_ATTRIBUTE6, zpslea.LINE_EXT_VARCHAR_ATTRIBUTE7, zpslea.LINE_EXT_VARCHAR_ATTRIBUTE8, zpslea.LINE_EXT_VARCHAR_ATTRIBUTE9, zpslea.LINE_EXT_VARCHAR_ATTRIBUTE10, zpslea.LINE_EXT_VARCHAR_ATTRIBUTE11, zpslea.LINE_EXT_VARCHAR_ATTRIBUTE12, zpslea.LINE_EXT_VARCHAR_ATTRIBUTE13, zpslea.LINE_EXT_VARCHAR_ATTRIBUTE14, zpslea.LINE_EXT_VARCHAR_ATTRIBUTE15, zpslea.LINE_EXT_VARCHAR_ATTRIBUTE16, zpslea.LINE_EXT_VARCHAR_ATTRIBUTE17, zpslea.LINE_EXT_VARCHAR_ATTRIBUTE18, zpslea.LINE_EXT_VARCHAR_ATTRIBUTE19, zpslea.LINE_EXT_VARCHAR_ATTRIBUTE20, zpslea.LINE_EXT_VARCHAR_ATTRIBUTE21, zpslea.LINE_EXT_VARCHAR_ATTRIBUTE22, zpslea.LINE_EXT_VARCHAR_ATTRIBUTE23, zpslea.LINE_EXT_VARCHAR_ATTRIBUTE24, zpslea.LINE_EXT_VARCHAR_ATTRIBUTE25, zpslea.LINE_EXT_VARCHAR_ATTRIBUTE26, zpslea.LINE_EXT_VARCHAR_ATTRIBUTE27, zpslea.LINE_EXT_VARCHAR_ATTRIBUTE28, zpslea.LINE_EXT_VARCHAR_ATTRIBUTE29, zpslea.LINE_EXT_VARCHAR_ATTRIBUTE30, zpslea.LINE_EXT_NUMBER_ATTRIBUTE1, zpslea.LINE_EXT_NUMBER_ATTRIBUTE2, zpslea.LINE_EXT_NUMBER_ATTRIBUTE3, zpslea.LINE_EXT_NUMBER_ATTRIBUTE4, zpslea.LINE_EXT_NUMBER_ATTRIBUTE5, zpslea.LINE_EXT_NUMBER_ATTRIBUTE6, zpslea.LINE_EXT_NUMBER_ATTRIBUTE7, zpslea.LINE_EXT_NUMBER_ATTRIBUTE8, zpslea.LINE_EXT_NUMBER_ATTRIBUTE9, zpslea.LINE_EXT_NUMBER_ATTRIBUTE10, zpslea.LINE_EXT_DATE_ATTRIBUTE1, zpslea.LINE_EXT_DATE_ATTRIBUTE2, zpslea.LINE_EXT_DATE_ATTRIBUTE3, zpslea.LINE_EXT_DATE_ATTRIBUTE4, zpslea.LINE_EXT_DATE_ATTRIBUTE5, zldf.EXEMPT_CERTIFICATE_NUMBER, zldf.EXEMPT_REASON, zldf.EXEMPTION_CONTROL_FLAG, Decode(NVL(zldf.input_tax_classification_code, zldf.output_tax_classification_code), NULL,'LOCATION', (SELECT zx.tax_type_code FROM zx_sco_taxes zx,zx_sco_rates zr WHERE zx.tax = zr.tax AND zx.tax_regime_code = zr.tax_regime_code AND zx.live_for_processing_flag = 'Y' AND zr.tax_rate_code = NVL(zldf.input_tax_classification_code, zldf.output_tax_classification_code) AND (tax_type_code = 'LOCATION' OR (tax_type_code = 'SALES_TAX' AND (tax_rate_code = 'STATE' OR tax_rate_code = 'COUNTY' OR tax_rate_code = 'CITY' OR tax_rate_code LIKE '%_COUNTY' OR tax_rate_code LIKE '%_CITY'))) AND rownum = 1)) tax_type_code, 'Y' tax_calculation_flag, NVL(zldf.input_tax_classification_code, zldf.output_tax_classification_code) tax_code, zldf.DOC_SEQ_NAME, zldf.BATCH_SOURCE_NAME, zldf.TRX_TYPE_DESCRIPTION, zldf.TRX_LINE_GL_DATE, zldf.TRX_LINE_CURRENCY_CONV_DATE, zldf.TRX_LINE_CURRENCY_CONV_RATE, zldf.TRX_LINE_CURRENCY_CONV_TYPE, zldf.TRX_LINE_MAU, zldf.TRX_LINE_PRECISION, zldf.PRODUCT_ORG_ID, zldf.EXEMPT_REASON_CODE, decode(zldf.APPLIED_TO_APPLICATION_ID, 222, decode(zldf.APPLIED_TO_EVENT_CLASS_CODE, 'INVOICE', 4, 'DEBIT_MEMO', 5, 'CREDIT_MEMO', 6, NULL), 200, decode(zldf.APPLIED_TO_EVENT_CLASS_CODE, 'STANDARD INVOICES', 1, 'PREPAYMENT INVOICES', 7, 'EXPENSE REPORTS', 2, NULL), 201, decode(zldf.APPLIED_TO_EVENT_CLASS_CODE, 'PO_PA', 3, 'RELEASE', 12, 'CHARGES', 11, NULL), NULL) APPLIED_TO_DOCUMENT_TYPE_ID, zldf.applied_from_trx_id applied_to_transaction_id, zldf.applied_to_trx_line_id, zldf.applied_to_trx_level_type, zldf.applied_to_trx_number APPLIED_TO_DOC_NUMBER, zldf.CHAR1, zldf.CHAR2, zldf.CHAR3, zldf.CHAR4, zldf.CHAR5, zldf.CHAR6, zldf.CHAR7, zldf.CHAR8, zldf.CHAR9, zldf.CHAR10, zldf.CURRENCY_CONVERSION_RATE, zldf.CURRENCY_CONVERSION_DATE, zldf.CURRENCY_CONVERSION_TYPE, zldf.DATE1, zldf.DATE2, zldf.DATE3, zldf.DATE4, zldf.DATE5, zldf.DATE6, zldf.DATE7, zldf.DATE8, zldf.DATE9, zldf.DATE10, zldf.DOCUMENT_SUB_TYPE, zldf.FIRST_PTY_ORG_ID, zldf.ESTABLISHMENT_ID, zldf.INTERNAL_ORG_LOCATION_ID, decode(zldf.REF_DOC_APPLICATION_ID, 222, decode(zldf.REF_DOC_EVENT_CLASS_CODE, 'INVOICE', 4, 'DEBIT_MEMO', 5, 'CREDIT_MEMO', 6, NULL), 200, decode(zldf.REF_DOC_EVENT_CLASS_CODE, 'STANDARD INVOICES', 1, 'PREPAYMENT INVOICES', 7, 'EXPENSE REPORTS', 2, NULL), 201, decode(zldf.REF_DOC_EVENT_CLASS_CODE, 'PO_PA', 3, 'RELEASE', 12, 'CHARGES', 11, NULL), NULL) REF_DOC_DOCUMENT_TYPE_ID, zldf.ref_doc_trx_id ref_doc_transaction_id, zldf.ref_doc_line_id, zldf.ref_doc_trx_level_type, decode(zldf.RELATED_DOC_APPLICATION_ID, 222, decode(zldf.RELATED_DOC_EVENT_CLASS_CODE, 'INVOICE', 4, 'DEBIT_MEMO', 5, 'CREDIT_MEMO', 6, NULL), 200, decode(zldf.RELATED_DOC_EVENT_CLASS_CODE, 'STANDARD INVOICES', 1, 'PREPAYMENT INVOICES', 7, 'EXPENSE REPORTS', 2, NULL), 201, decode(zldf.RELATED_DOC_EVENT_CLASS_CODE, 'PO_PA', 3, 'RELEASE', 12, 'CHARGES', 11, NULL), NULL) REL_DOC_DOCUMENT_TYPE_ID, zldf.related_doc_date, zldf.related_doc_number, zldf.related_doc_trx_id rel_doc_transaction_id, decode(zldf.SOURCE_APPLICATION_ID, 222, decode(zldf.SOURCE_EVENT_CLASS_CODE, 'INVOICE', 4, 'DEBIT_MEMO', 5, 'CREDIT_MEMO', 6, NULL), 200, decode(zldf.SOURCE_EVENT_CLASS_CODE, 'STANDARD INVOICES', 1, 'PREPAYMENT INVOICES', 7, 'EXPENSE REPORTS', 2, NULL), 201, decode(zldf.SOURCE_EVENT_CLASS_CODE, 'PO_PA', 3, 'RELEASE', 12, 'CHARGES', 11, NULL), NULL) SOURCE_DOCUMENT_TYPE_ID, zldf.source_trx_id source_transaction_id, zldf.source_trx_level_type, zldf.source_line_id, zldf.SUPPLIER_TAX_INVOICE_DATE, zldf.SUPPLIER_TAX_INVOICE_NUMBER, zldf.SUPPLIER_EXCHANGE_RATE, zldf.TAX_INVOICE_NUMBER, zldf.TAX_INVOICE_DATE, zldf.USER_DEFINED_FISC_CLASS, zldf.PRODUCT_CATEGORY, zldf.PRODUCT_FISC_CLASSIFICATION, zldf.TRANSFER_CHARGE, zldf.START_EXPENSE_DATE, zldf.MERCHANT_PARTY_COUNTRY, zldf.MERCHANT_PARTY_DOCUMENT_NUMBER, zldf.MERCHANT_PARTY_NAME, zldf.MERCHANT_PARTY_REFERENCE, zldf.MERCHANT_PARTY_TAX_REG_NUMBER, zldf.MERCHANT_PARTY_TAXPAYER_ID, zldf.NUMERIC1, zldf.NUMERIC2, zldf.NUMERIC3, zldf.NUMERIC4, zldf.NUMERIC5, zldf.NUMERIC6, zldf.NUMERIC7, zldf.NUMERIC8, zldf.NUMERIC9, zldf.NUMERIC10 FROM ZX_LINES_DET_FACTORS zldf, ZX_PRVDR_HDR_EXTNS_GT zpshea, ZX_PRVDR_LINE_EXTNS_GT zpslea, ZX_TRX_PRE_PROC_OPTIONS_GT ztppo, ZX_PTNR_LOCATION_INFO_GT ptnr WHERE zldf.application_id = ztppo.application_id AND zldf.entity_code = ztppo.entity_code AND zldf.event_class_code = ztppo.event_class_code AND zldf.trx_id = ztppo.trx_id AND zldf.event_class_mapping_id = ptnr.event_class_mapping_id AND zldf.trx_id = ptnr.trx_id AND zldf.trx_line_id = ptnr.trx_line_id AND zldf.trx_level_type = ptnr.trx_level_type AND zpslea.application_id = ztppo.application_id AND zpslea.entity_code = ztppo.entity_code AND zpslea.event_class_code = ztppo.event_class_code AND zpslea.trx_id = ztppo.trx_id AND zpslea.trx_line_id = zldf.trx_line_id AND zpslea.trx_level_type = zldf.trx_level_type AND zpslea.provider_id = ztppo.tax_provider_id AND zpslea.tax_regime_code = ztppo.tax_regime_code AND zpshea.application_id = ztppo.application_id AND zpshea.entity_code = ztppo.entity_code AND zpshea.event_class_code = ztppo.event_class_code AND zpshea.trx_id = ztppo.trx_id AND zpshea.provider_id = ztppo.tax_provider_id AND zpshea.tax_regime_code = ztppo.tax_regime_code AND ((ztppo.record_flag = 'Y' AND ztppo.quote_flag = 'N' AND ((ztppo.tax_event_type_code = 'UPDATE' AND ( (ztppo.record_for_partners_flag = 'Y' AND ( (ztppo.partner_processing_flag = 'F' AND zldf.trx_id = ztppo.trx_id AND zldf.line_level_action <> 'CREATE_TAX_ONLY') OR (ztppo.partner_processing_flag <> 'F' AND (zldf.event_id = ztppo.event_id OR (zldf.trx_id = ztppo.trx_id AND zldf.line_level_action = 'DELETE') ) ) ) ) OR (ztppo.record_for_partners_flag = 'N' AND zldf.trx_id = ZTPPO.TRX_ID) ) ) OR (ztppo.tax_event_type_code in ('CREATE', 'CREATE_REVERSE_DOCUMENT') and zldf.event_id = ZTPPO.EVENT_ID) OR (ztppo.tax_event_type_code = 'OVERRIDE_TAX' and (zldf.inclusive_tax_override_flag='Y')) ) ) OR (ztppo.record_flag = 'N' OR ztppo.quote_flag = 'Y' ))) WHERE (tax_calculation_flag = 'Y' OR (tax_calculation_flag = 'N' AND tax_code IS NOT NULL)) AND tax_type_code IS NOT NULL