ZX_REP_EXTRACT_V

Details

• Schema: FUSION

• Object owner: FND

• Object type: VIEW

Columns

Name

REQUEST_ID CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LEDGER_ID CHART_OF_ACCOUNTS_ID DETAIL_TAX_LINE_ID EXTRACT_SOURCE_LEDGER EXTRACT_REPORT_LINE_NUMBER REP_ENTITY_ID LEGAL_ENTITY_TAX_REG_NUMBER ORG_INFORMATION2 REP_CONTEXT_LVL_CODE REP_CONTEXT_LVL_MNG TAXPAYER_ID REP_CONTEXT_ENTITY_NAME REP_CONTEXT_ENTITY_LOCATION_ID REP_CONTEXT_ENTITY_CITY REP_CONTEXT_ENTITY_COUNTY REP_CONTEXT_ENTITY_STATE REP_CONTEXT_ENTITY_PROVINCE REP_CONTEXT_ENTITY_ADDRESS1 REP_CONTEXT_ENTITY_ADDRESS2 REP_CONTEXT_ENTITY_ADDRESS3 REP_CONTEXT_ENTITY_COUNTRY REP_CONTEXT_ENTITY_POSTAL_CODE REP_CONTEXT_ENTITY_TEL_NUMBER LEDGER_NAME FUNCTIONAL_CURRENCY_CODE TRX_ID TRX_NUMBER TRX_DESCRIPTION DOC_SEQ_ID DOC_SEQ_NAME DOC_SEQ_VALUE TRX_DATE TRX_LINE_CLASS TRX_CLASS_MNG TRX_TYPE_SEQ_ID TRX_TYPE_MNG APPLIED_FROM_ENTITY_CODE APPLIED_FROM_TRX_ID APPLIED_FROM_EVENT_CLASS_CODE TRX_APPLIED_FROM_CLASS_MNG APPLIED_FROM_TRX_NUMBER ADJUSTED_DOC_ENTITY_CODE ADJUSTED_DOC_TRX_ID ADJUSTED_DOC_EVENT_CLASS_CODE ADJUSTED_DOC_NUMBER ADJUSTED_DOC_DATE TRX_APPLIED_TO_CLASS_MNG APPLIED_TO_TRX_NUMBER TRX_TYPE_DESCRIPTION TRX_DUE_DATE TRX_SHIPPING_DATE TRX_COMMUNICATED_DATE TRX_CURRENCY_CODE CURRENCY_CONVERSION_TYPE CURRENCY_CONVERSION_DATE CURRENCY_CONVERSION_RATE RECONCILIATION_FLAG BALANCING_SEGMENT_VALUE TRX_CONTROL_ACCOUNT_FLEXFIELD BILLING_TRADING_PARTNER_ID BILLING_TP_SITE_ID BILLING_TP_NUMBER BILLING_TP_TAX_REG_NUM BILLING_TP_TAXPAYER_ID BILLING_TP_SITE_NAME BILLING_TP_SITE_NAME_ALT BILLING_TP_SITE_TAX_REG_NUM BILLING_TP_TAX_REPORTING_FLAG BILLING_TP_NAME BILLING_TP_NAME_ALT BILLING_TP_SIC_CODE BILLING_TP_ADDRESS_ID BILLING_TP_CITY BILLING_TP_COUNTY BILLING_TP_STATE BILLING_TP_PROVINCE BILLING_TP_ADDRESS1 BILLING_TP_ADDRESS2 BILLING_TP_ADDRESS3 BILLING_TP_ADDRESS_LINES_ALT BILLING_TP_COUNTRY BILLING_TP_POSTAL_CODE SHIPPING_TRADING_PARTNER_ID SHIPPING_TP_SITE_ID SHIPPING_TP_NUMBER SHIPPING_TP_TAX_REG_NUM SHIPPING_TP_TAXPAYER_ID SHIPPING_TP_SITE_NAME SHIPPING_TP_SITE_TAX_REG_NUM SHIPPING_TP_NAME SHIPPING_TP_NAME_ALT SHIPPING_TP_SIC_CODE SHIPPING_TP_ADDRESS_ID SHIPPING_TP_CITY SHIPPING_TP_COUNTY SHIPPING_TP_STATE SHIPPING_TP_PROVINCE SHIPPING_TP_ADDRESS1 SHIPPING_TP_ADDRESS2 SHIPPING_TP_ADDRESS3 SHIPPING_TP_ADDRESS_LINES_ALT SHIPPING_TP_COUNTRY SHIPPING_TP_POSTAL_CODE BANKING_TP_NAME BANKING_TP_TAXPAYER_ID TRX_BATCH_SOURCE_NAME TRX_SIC_CODE FOB_POINT TRX_WAYBILL_NUMBER POSTED_FLAG TAX_RATE_ID TAX_RATE_CODE TAX_RATE TAX_RATE_VAT_TRX_TYPE_CODE TAX_RATE_CODE_VAT_TRX_TYPE_MNG TAX_RATE_VAT_TRX_TYPE_DESC TAX_RATE_REGISTER_TYPE_CODE TAX_RATE_CODE_REG_TYPE_MEANING TAX_TYPE_CODE TAX_TYPE_MNG TAX_RATE_CODE_NAME TAX_RATE_CODE_DESCRIPTION TAX_RECOVERABLE_FLAG TAX_RECOVERY_RATE MERCHANT_PARTY_DOCUMENT_NUMBER MERCHANT_PARTY_NAME MERCHANT_PARTY_REFERENCE MERCHANT_PARTY_TAX_REG_NUMBER MERCHANT_PARTY_TAXPAYER_ID COUNTRY_OF_SUPPLY START_EXPENSE_DATE TAX_EXEMPTION_ID TAX_EXCEPTION_ID EXEMPT_CERTIFICATE_NUMBER EXEMPT_REASON_CODE TAX_EXEMPT_REASON_MNG TAX_EXCEPTION_REASON_CODE TAX_EXCEPTION_REASON_MNG 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 TAX_AMT TAX_AMT_FUNCL_CURR TAX_LINE_NUMBER TAXABLE_AMT TAXABLE_AMT_FUNCL_CURR TOTAL_ENTERED_AMOUNT TOTAL_ACCOUNTED_AMOUNT TAXABLE_DISC_AMT TAXABLE_DISC_AMT_FUNCL_CURR TAX_DISC_AMT TAX_DISC_AMT_FUNCL_CURR TRX_LINE_NUMBER TAXABLE_LINE_SOURCE_TABLE TRX_LINE_DESCRIPTION PRODUCT_ID TAXABLE_LINE_ITEM_FLEXFIELD PRODUCT_DESCRIPTION TRX_LINE_QUANTITY UOM_CODE TRX_QUANTITY_UOM_MNG TRX_LINE_TYPE ACTG_EVENT_ID ACTG_EVENT_TYPE_CODE ACTG_EVENT_TYPE_MNG ACTG_EVENT_NUMBER ACTG_EVENT_STATUS_FLAG ACTG_EVENT_STATUS_MNG ACTG_SOURCE_TABLE ACTG_SOURCE_ID ACTG_HEADER_ID ACTG_CATEGORY_CODE ACTG_CATEGORY_MNG PERIOD_NAME GL_TRANSFER_FLAG GL_TRANSFER_RUN_ID ACTG_HEADER_DESCRIPTION ACTG_LINE_NUM ACTG_LINE_TYPE_CODE ACTG_LINE_TYPE_MNG ACTG_LINE_CCID ACCOUNT_FLEXFIELD ACCOUNT_DESCRIPTION ACTG_LINE_DESCRIPTION ACTG_STAT_AMT ACTG_ERROR_CODE GL_TRANSFER_CODE ACTG_DOC_SEQUENCE_ID ACTG_DOC_SEQUENCE_NAME ACTG_DOC_SEQUENCE_VALUE ACTG_PARTY_ID ACTG_PARTY_SITE_ID TRX_ARAP_BALANCING_SEGMENT TRX_ARAP_NATURAL_ACCOUNT TRX_TAXABLE_BALANCING_SEGMENT TRX_TAXABLE_NATURAL_ACCOUNT TRX_TAX_BALANCING_SEGMENT TRX_TAX_NATURAL_ACCOUNT TRX_TAXABLE_ACCOUNT TRX_TAXABLE_ACCOUNT_DESC TRX_TAXABLE_BALSEG_DESC TRX_TAXABLE_NATACCT_SEG_DESC NUMERIC1 NUMERIC2 NUMERIC3 NUMERIC4 NUMERIC5 NUMERIC6 NUMERIC7 NUMERIC8 NUMERIC9 NUMERIC10 NUMERIC11 NUMERIC12 NUMERIC13 NUMERIC14 NUMERIC15 NUMERIC16 ATTRIBUTE1 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTE5 ATTRIBUTE6 ATTRIBUTE7 ATTRIBUTE8 ATTRIBUTE9 ATTRIBUTE10 ATTRIBUTE11 ATTRIBUTE12 ATTRIBUTE13 ATTRIBUTE14 ATTRIBUTE15 ATTRIBUTE16 ATTRIBUTE17 ATTRIBUTE18 BUSINESS_LOC_ADDRESS DOCUMENT_SUB_TYPE_MNG TAX_STATUS_MNG TRX_BUSINESS_CATEGORY_MNG GDF_AP_INVOICES_ATT2 GDF_AP_INVOICES_ATT3 GDF_AP_INVOICES_ATT4 GDF_AP_INVOICES_ATT11 GDF_AP_INVOICES_ATT12 GDF_AP_INVOICES_ATT13 GDF_AP_INVOICE_DIST_ATT1 GDF_PO_VENDOR_SITES_ATT17 GDF_RA_CUST_BILL_ATT10 GDF_RA_CUST_BILL_ATT12 GDF_PARTY_SITES_BILL_ATT8 GDF_PARTY_SITES_BILL_ATT9 GDF_RA_CUST_TRX_ATT3 GDF_RA_CUST_TRX_ATT4 GDF_RA_CUST_TRX_ATT5 GDF_RA_CUST_TRX_ATT6 GDF_RA_CUST_TRX_ATT7 GDF_RA_CUST_TRX_ATT8 GDF_RA_CUST_TRX_ATT9 GDF_RA_CUST_TRX_ATT19 GDF_RA_CUST_TRX_LINES_ATT1 GDF_RA_CUST_TRX_LINES_ATT2 GDF_RA_CUST_TRX_TYPES_ATT5 GDF_RA_CUST_TRX_TYPES_ATT6 GDF_RA_CUST_TRX_TYPES_ATT7 GDF_RA_BATCH_SOURCES_ATT1 GDF_RA_BATCH_SOURCES_ATT2 GDF_RA_BATCH_SOURCES_ATT3 GDF_RA_BATCH_SOURCES_ATT4 GDF_RA_BATCH_SOURCES_ATT7 GDF_RA_ADDRESSES_BILL_ATT9 GDF_RA_ADDRESSES_SHIP_ATT9 HQ_ESTB_REG_NUMBER TAX_POINT_BASIS TAX_POINT_DATE LEGAL_MESSAGE_APPL_2 LEGAL_MESSAGE_STATUS LEGAL_MESSAGE_RATE LEGAL_MESSAGE_BASIS LEGAL_MESSAGE_CALC LEGAL_MESSAGE_THRESHOLD LEGAL_MESSAGE_POS LEGAL_MESSAGE_TRN LEGAL_MESSAGE_EXMPT REPORTABLE_FLAG APPLIED_TO_TRX_LEVEL_TYPE LEGAL_REPORTING_STATUS APPLIED_TO_TAX_DIST_ID APPL_TO_TRX_CURR_UNIT_NR_AMT APPL_TO_PER_UNIT_NREC_TAX_AMT APPLIED_TO_UNIT_PRICE APPLIED_TO_TRX_LINE_DIST_QTY APPLIED_TO_DIST_ID MATCH_TYPE FOS_TRANSACTION_ID RECEIPT_SOURCE_CODE DROPSHIP_TYPE_ID REQUISITION_TYPE PORT_OF_ENTRY_CODE PURCHASING_CATEGORY_ID DROP_SHIP_FLAG CONSIGNED_FLAG DESTINATION_TYPE_CODE CONSIGN_ITM_UPON_RECPT_FLAG PORT_OF_DISCHARGE EXPENDITURE_TYPE PORT_OF_LOADING DELIVERY_TYPE DOCUMENT_TYPE SHIPMENT_TYPE HDR_GL_DATE GL_POSTED_DATE POSTED_TO_SLA_FLAG FINAL_DISCHARGE_LOCATION_ID FINAL_TRANSACTION_NODE_FLAG COUNTRY_OF_ORIGIN_CODE FIRST_PTY_REG_ID TAX_RATE_SCHED_ID REPORTING_CURRENCY_CODE PRODUCT_TYPE ASSET_FLAG INTERNAL_ORG_LOCATION_ID MERCHANT_PARTY_TAX_PROF_ID POA_PARTY_TAX_PROF_ID POO_PARTY_TAX_PROF_ID POA_SITE_TAX_PROF_ID POO_SITE_TAX_PROF_ID PAYING_SITE_TAX_PROF_ID TAX_RATE_EFFECTIVE_FROM TAX_RATE_EFFECTIVE_TO THIRD_PTY_REG_ID THIRD_PTY_REG_NUMBER PAYMENT_MATURITY_DATE PAYMENT_CHECK_ID PAYMENT_CLEARED_DATE PAYMENT_TYPE_FLAG IBAN_NUMBER TRX_AMOUNT_REMAINING TAX_AMOUNT_REMAINING PRODUCT_CODE ITEM_UOM EFT_SWIFT_CODE PAYMENT_METHOD_CODE COUNTRY_OF_PAYMENT BOX_NUMBER1_ID BOX_NUMBER2_ID BOX_NUMBER3_ID BOX_NUMBER4_ID BOX_NUMBER5_ID BOX_NUMBER6_ID BOX_NUMBER7_ID BOX_NUMBER8_ID BOX_NUMBER9_ID BOX_NUMBER10_ID BOX_NUMBER1 BOX_NUMBER2 BOX_NUMBER3 BOX_NUMBER4 BOX_NUMBER5 BOX_NUMBER6 BOX_NUMBER7 BOX_NUMBER8 BOX_NUMBER9 BOX_NUMBER10 BOX_VALUE_TYPE_CODE1 BOX_VALUE_TYPE_CODE2 BOX_VALUE_TYPE_CODE3 BOX_VALUE_TYPE_CODE4 BOX_VALUE_TYPE_CODE5 BOX_VALUE_TYPE_CODE6 BOX_VALUE_TYPE_CODE7 BOX_VALUE_TYPE_CODE8 BOX_VALUE_TYPE_CODE9 BOX_VALUE_TYPE_CODE10 BOX_SIGN_FLAG1 BOX_SIGN_FLAG2 BOX_SIGN_FLAG3 BOX_SIGN_FLAG4 BOX_SIGN_FLAG5 BOX_SIGN_FLAG6 BOX_SIGN_FLAG7 BOX_SIGN_FLAG8 BOX_SIGN_FLAG9 BOX_SIGN_FLAG10 PERIODICITY_CODE REPORTING_TYPE_ID GL_DATE SELF_ASSESSED_FLAG SHIP_TO_LOCATION_ID SHIP_TO_LOCATION_CODE SHIP_TO_LOCATION_DESCRIPTION SHIP_TO_ADDRESS_LINE_1 SHIP_TO_ADDRESS_LINE_2 SHIP_TO_ADDRESS_LINE_3 SHIP_TO_ADDRESS_LINE_4 SHIP_TO_COUNTRY SHIP_TO_POSTAL_CODE SHIP_TO_REGION_1 SHIP_TO_REGION_2 SHIP_TO_REGION_3 SHIP_TO_TOWN_OR_CITY

Query

SQL_Statement

SELECT ZXREPCON.REQUEST_ID REQUEST_ID, ZXREPDET.CREATED_BY CREATED_BY, ZXREPDET.CREATION_DATE CREATION_DATE, ZXREPDET.LAST_UPDATED_BY LAST_UPDATED_BY, ZXREPDET.LAST_UPDATE_DATE LAST_UPDATE_DATE, ZXREPDET.LEDGER_ID LEDGER_ID, ZXREPDET.CHART_OF_ACCOUNTS_ID CHART_OF_ACCOUNTS_ID, ZXREPDET.DETAIL_TAX_LINE_ID DETAIL_TAX_LINE_ID, ZXREPDET.EXTRACT_SOURCE_LEDGER EXTRACT_SOURCE_LEDGER, ZXREPDET.EXTRACT_REPORT_LINE_NUMBER EXTRACT_REPORT_LINE_NUMBER, ZXREPCON.REP_ENTITY_ID REP_ENTITY_ID, ZXREPDET.LEGAL_ENTITY_TAX_REG_NUMBER LEGAL_ENTITY_TAX_REG_NUMBER, ZXREPCON.ORG_INFORMATION2 ORG_INFORMATION2, ZXREPCON.REP_CONTEXT_LVL_CODE REP_CONTEXT_LVL_CODE, ZXREPCON.REP_CONTEXT_LVL_MNG REP_CONTEXT_LVL_MNG, ZXREPCON.TAXPAYER_ID TAXPAYER_ID, ZXREPCON.REP_CONTEXT_ENTITY_NAME REP_CONTEXT_ENTITY_NAME, ZXREPCON.REP_CONTEXT_ENTITY_LOCATION_ID REP_CONTEXT_ENTITY_LOCATION_ID, ZXREPCON.REP_CONTEXT_ENTITY_CITY REP_CONTEXT_ENTITY_CITY, ZXREPCON.REP_CONTEXT_ENTITY_COUNTY REP_CONTEXT_ENTITY_COUNTY, ZXREPCON.REP_CONTEXT_ENTITY_STATE REP_CONTEXT_ENTITY_STATE, ZXREPCON.REP_CONTEXT_ENTITY_PROVINCE REP_CONTEXT_ENTITY_PROVINCE, ZXREPCON.REP_CONTEXT_ENTITY_ADDRESS1 REP_CONTEXT_ENTITY_ADDRESS1, ZXREPCON.REP_CONTEXT_ENTITY_ADDRESS2 REP_CONTEXT_ENTITY_ADDRESS2, ZXREPCON.REP_CONTEXT_ENTITY_ADDRESS3 REP_CONTEXT_ENTITY_ADDRESS3, ZXREPCON.REP_CONTEXT_ENTITY_COUNTRY REP_CONTEXT_ENTITY_COUNTRY, ZXREPCON.REP_CONTEXT_ENTITY_POSTAL_CODE REP_CONTEXT_ENTITY_POSTAL_CODE, ZXREPCON.REP_CONTEXT_ENTITY_TEL_NUMBER REP_CONTEXT_ENTITY_TEL_NUMBER, ZXREPDET.LEDGER_NAME LEDGER_NAME, ZXREPDET.FUNCTIONAL_CURRENCY_CODE FUNCTIONAL_CURRENCY_CODE, ZXREPDET.TRX_ID TRX_ID, ZXREPDET.TRX_NUMBER TRX_NUMBER, ZXREPDET.TRX_DESCRIPTION TRX_DESCRIPTION, ZXREPDET.DOC_SEQ_ID DOC_SEQ_ID, ZXREPDET.DOC_SEQ_NAME DOC_SEQ_NAME, ZXREPDET.DOC_SEQ_VALUE DOC_SEQ_VALUE, ZXREPDET.TRX_DATE TRX_DATE, ZXREPDET.TRX_LINE_CLASS TRX_LINE_CLASS, ZXREPDET.TRX_CLASS_MNG TRX_CLASS_MNG, ZXREPDET.TRX_TYPE_SEQ_ID TRX_TYPE_SEQ_ID, ZXREPDET.TRX_TYPE_MNG TRX_TYPE_MNG, ZXREPDET.APPLIED_FROM_ENTITY_CODE APPLIED_FROM_ENTITY_CODE, ZXREPDET.APPLIED_FROM_TRX_ID APPLIED_FROM_TRX_ID, ZXREPDET.APPLIED_FROM_EVENT_CLASS_CODE APPLIED_FROM_EVENT_CLASS_CODE, ZXREPDET.TRX_APPLIED_FROM_CLASS_MNG TRX_APPLIED_FROM_CLASS_MNG, ZXREPDET.APPLIED_FROM_TRX_NUMBER APPLIED_FROM_TRX_NUMBER, ZXREPDET.ADJUSTED_DOC_ENTITY_CODE ADJUSTED_DOC_ENTITY_CODE, ZXREPDET.ADJUSTED_DOC_TRX_ID ADJUSTED_DOC_TRX_ID, ZXREPDET.ADJUSTED_DOC_EVENT_CLASS_CODE ADJUSTED_DOC_EVENT_CLASS_CODE, ZXREPDET.ADJUSTED_DOC_NUMBER ADJUSTED_DOC_NUMBER, ZXREPDET.ADJUSTED_DOC_DATE ADJUSTED_DOC_DATE, ZXREPDET.TRX_APPLIED_TO_CLASS_MNG TRX_APPLIED_TO_CLASS_MNG, ZXREPDET.APPLIED_TO_TRX_NUMBER APPLIED_TO_TRX_NUMBER, ZXREPDET.TRX_TYPE_DESCRIPTION TRX_TYPE_DESCRIPTION, ZXREPDET.TRX_DUE_DATE TRX_DUE_DATE, ZXREPDET.TRX_SHIPPING_DATE TRX_SHIPPING_DATE, ZXREPDET.TRX_COMMUNICATED_DATE TRX_COMMUNICATED_DATE, ZXREPDET.TRX_CURRENCY_CODE TRX_CURRENCY_CODE, ZXREPDET.CURRENCY_CONVERSION_TYPE CURRENCY_CONVERSION_TYPE, ZXREPDET.CURRENCY_CONVERSION_DATE CURRENCY_CONVERSION_DATE, ZXREPDET.CURRENCY_CONVERSION_RATE CURRENCY_CONVERSION_RATE, ZXREPDET.RECONCILIATION_FLAG RECONCILIATION_FLAG, ZXREPACT.BALANCING_SEGMENT_VALUE BALANCING_SEGMENT_VALUE, ZXREPACT.TRX_CONTROL_ACCOUNT_FLEXFIELD TRX_CONTROL_ACCOUNT_FLEXFIELD, ZXREPDET.BILLING_TRADING_PARTNER_ID BILLING_TRADING_PARTNER_ID, ZXREPDET.BILLING_TP_SITE_ID BILLING_TP_SITE_ID, ZXREPDET.BILLING_TP_NUMBER BILLING_TP_NUMBER, ZXREPDET.BILLING_TP_TAX_REG_NUM BILLING_TP_TAX_REG_NUM, ZXREPDET.BILLING_TP_TAXPAYER_ID BILLING_TP_TAXPAYER_ID, ZXREPDET.BILLING_TP_SITE_NAME BILLING_TP_SITE_NAME, ZXREPDET.BILLING_TP_SITE_NAME_ALT BILLING_TP_SITE_NAME_ALT, ZXREPDET.BILLING_TP_SITE_TAX_REG_NUM BILLING_TP_SITE_TAX_REG_NUM, ZXREPDET.BILLING_TP_TAX_REPORTING_FLAG BILLING_TP_TAX_REPORTING_FLAG, ZXREPDET.BILLING_TP_NAME BILLING_TP_NAME, ZXREPDET.BILLING_TP_NAME_ALT BILLING_TP_NAME_ALT, ZXREPDET.BILLING_TP_SIC_CODE BILLING_TP_SIC_CODE, ZXREPDET.BILLING_TP_ADDRESS_ID BILLING_TP_ADDRESS_ID, ZXREPDET.BILLING_TP_CITY BILLING_TP_CITY, ZXREPDET.BILLING_TP_COUNTY BILLING_TP_COUNTY, ZXREPDET.BILLING_TP_STATE BILLING_TP_STATE, ZXREPDET.BILLING_TP_PROVINCE BILLING_TP_PROVINCE, ZXREPDET.BILLING_TP_ADDRESS1 BILLING_TP_ADDRESS1, ZXREPDET.BILLING_TP_ADDRESS2 BILLING_TP_ADDRESS2, ZXREPDET.BILLING_TP_ADDRESS3 BILLING_TP_ADDRESS3, ZXREPDET.BILLING_TP_ADDRESS_LINES_ALT BILLING_TP_ADDRESS_LINES_ALT, ZXREPDET.BILLING_TP_COUNTRY BILLING_TP_COUNTRY, ZXREPDET.BILLING_TP_POSTAL_CODE BILLING_TP_POSTAL_CODE, ZXREPDET.SHIPPING_TRADING_PARTNER_ID SHIPPING_TRADING_PARTNER_ID, ZXREPDET.SHIPPING_TP_SITE_ID SHIPPING_TP_SITE_ID, ZXREPDET.SHIPPING_TP_NUMBER SHIPPING_TP_NUMBER, ZXREPDET.SHIPPING_TP_TAX_REG_NUM SHIPPING_TP_TAX_REG_NUM, ZXREPDET.SHIPPING_TP_TAXPAYER_ID SHIPPING_TP_TAXPAYER_ID, ZXREPDET.SHIPPING_TP_SITE_NAME SHIPPING_TP_SITE_NAME, ZXREPDET.SHIPPING_TP_SITE_TAX_REG_NUM SHIPPING_TP_SITE_TAX_REG_NUM, ZXREPDET.SHIPPING_TP_NAME SHIPPING_TP_NAME, ZXREPDET.SHIPPING_TP_NAME_ALT SHIPPING_TP_NAME_ALT, ZXREPDET.SHIPPING_TP_SIC_CODE SHIPPING_TP_SIC_CODE, ZXREPDET.SHIPPING_TP_ADDRESS_ID SHIPPING_TP_ADDRESS_ID, ZXREPDET.SHIPPING_TP_CITY SHIPPING_TP_CITY, ZXREPDET.SHIPPING_TP_COUNTY SHIPPING_TP_COUNTY, ZXREPDET.SHIPPING_TP_STATE SHIPPING_TP_STATE, ZXREPDET.SHIPPING_TP_PROVINCE SHIPPING_TP_PROVINCE, ZXREPDET.SHIPPING_TP_ADDRESS1 SHIPPING_TP_ADDRESS1, ZXREPDET.SHIPPING_TP_ADDRESS2 SHIPPING_TP_ADDRESS2, ZXREPDET.SHIPPING_TP_ADDRESS3 SHIPPING_TP_ADDRESS3, ZXREPDET.SHIPPING_TP_ADDRESS_LINES_ALT SHIPPING_TP_ADDRESS_LINES_ALT, ZXREPDET.SHIPPING_TP_COUNTRY SHIPPING_TP_COUNTRY, ZXREPDET.SHIPPING_TP_POSTAL_CODE SHIPPING_TP_POSTAL_CODE, ZXREPDET.BANKING_TP_NAME BANKING_TP_NAME, ZXREPDET.BANKING_TP_TAXPAYER_ID BANKING_TP_TAXPAYER_ID, ZXREPDET.TRX_BATCH_SOURCE_NAME TRX_BATCH_SOURCE_NAME, ZXREPDET.TRX_SIC_CODE TRX_SIC_CODE, ZXREPDET.FOB_POINT FOB_POINT, ZXREPDET.TRX_WAYBILL_NUMBER TRX_WAYBILL_NUMBER, ZXREPDET.POSTED_FLAG POSTED_FLAG, ZXREPDET.TAX_RATE_ID TAX_RATE_ID, ZXREPDET.TAX_RATE_CODE TAX_RATE_CODE, ZXREPDET.TAX_RATE TAX_RATE, ZXREPDET.TAX_RATE_VAT_TRX_TYPE_CODE TAX_RATE_VAT_TRX_TYPE_CODE, ZXREPDET.TAX_RATE_CODE_VAT_TRX_TYPE_MNG TAX_RATE_CODE_VAT_TRX_TYPE_MNG, ZXREPDET.TAX_RATE_VAT_TRX_TYPE_DESC TAX_RATE_VAT_TRX_TYPE_DESC, ZXREPDET.TAX_RATE_REGISTER_TYPE_CODE TAX_RATE_REGISTER_TYPE_CODE, ZXREPDET.TAX_RATE_CODE_REG_TYPE_MNG TAX_RATE_CODE_REG_TYPE_MEANING, ZXREPDET.TAX_TYPE_CODE TAX_TYPE_CODE, ZXREPDET.TAX_TYPE_MNG TAX_TYPE_MNG, ZXREPDET.TAX_RATE_CODE_NAME TAX_RATE_CODE_NAME, ZXREPDET.TAX_RATE_CODE_DESCRIPTION TAX_RATE_CODE_DESCRIPTION, ZXREPDET.TAX_RECOVERABLE_FLAG TAX_RECOVERABLE_FLAG, ZXREPDET.TAX_RECOVERY_RATE TAX_RECOVERY_RATE, ZXREPDET.MERCHANT_PARTY_DOCUMENT_NUMBER MERCHANT_PARTY_DOCUMENT_NUMBER, ZXREPDET.MERCHANT_PARTY_NAME MERCHANT_PARTY_NAME, ZXREPDET.MERCHANT_PARTY_REFERENCE MERCHANT_PARTY_REFERENCE, ZXREPDET.MERCHANT_PARTY_TAX_REG_NUMBER MERCHANT_PARTY_TAX_REG_NUMBER, ZXREPDET.MERCHANT_PARTY_TAXPAYER_ID MERCHANT_PARTY_TAXPAYER_ID, ZXREPDET.COUNTRY_OF_SUPPLY COUNTRY_OF_SUPPLY, ZXREPDET.START_EXPENSE_DATE START_EXPENSE_DATE, ZXREPDET.TAX_EXEMPTION_ID TAX_EXEMPTION_ID, ZXREPDET.TAX_EXCEPTION_ID TAX_EXCEPTION_ID, ZXREPDET.EXEMPT_CERTIFICATE_NUMBER EXEMPT_CERTIFICATE_NUMBER, ZXREPDET.EXEMPT_REASON_CODE EXEMPT_REASON_CODE, ZXREPDET.TAX_EXEMPT_REASON_MNG TAX_EXEMPT_REASON_MNG, ZXREPDET.TAX_EXCEPTION_REASON_CODE TAX_EXCEPTION_REASON_CODE, ZXREPDET.TAX_EXCEPTION_REASON_MNG TAX_EXCEPTION_REASON_MNG, ZXREPDET.TAX_LINE_USER_CATEGORY TAX_LINE_USER_CATEGORY, ZXREPDET.TAX_LINE_USER_ATTRIBUTE1 TAX_LINE_USER_ATTRIBUTE1, ZXREPDET.TAX_LINE_USER_ATTRIBUTE2 TAX_LINE_USER_ATTRIBUTE2, ZXREPDET.TAX_LINE_USER_ATTRIBUTE3 TAX_LINE_USER_ATTRIBUTE3, ZXREPDET.TAX_LINE_USER_ATTRIBUTE4 TAX_LINE_USER_ATTRIBUTE4, ZXREPDET.TAX_LINE_USER_ATTRIBUTE5 TAX_LINE_USER_ATTRIBUTE5, ZXREPDET.TAX_LINE_USER_ATTRIBUTE6 TAX_LINE_USER_ATTRIBUTE6, ZXREPDET.TAX_LINE_USER_ATTRIBUTE7 TAX_LINE_USER_ATTRIBUTE7, ZXREPDET.TAX_LINE_USER_ATTRIBUTE8 TAX_LINE_USER_ATTRIBUTE8, ZXREPDET.TAX_LINE_USER_ATTRIBUTE9 TAX_LINE_USER_ATTRIBUTE9, ZXREPDET.TAX_LINE_USER_ATTRIBUTE10 TAX_LINE_USER_ATTRIBUTE10, ZXREPDET.TAX_LINE_USER_ATTRIBUTE11 TAX_LINE_USER_ATTRIBUTE11, ZXREPDET.TAX_LINE_USER_ATTRIBUTE12 TAX_LINE_USER_ATTRIBUTE12, ZXREPDET.TAX_LINE_USER_ATTRIBUTE13 TAX_LINE_USER_ATTRIBUTE13, ZXREPDET.TAX_LINE_USER_ATTRIBUTE14 TAX_LINE_USER_ATTRIBUTE14, ZXREPDET.TAX_LINE_USER_ATTRIBUTE15 TAX_LINE_USER_ATTRIBUTE15, NVL(ZXREPDET.TAX_AMT, 0) TAX_AMT, NVL(ZXREPDET.TAX_AMT_FUNCL_CURR, 0) TAX_AMT_FUNCL_CURR, ZXREPDET.TAX_LINE_NUMBER TAX_LINE_NUMBER, NVL(ZXREPDET.TAXABLE_AMT, 0) TAXABLE_AMT, NVL(ZXREPDET.TAXABLE_AMT_FUNCL_CURR, 0) TAXABLE_AMT_FUNCL_CURR, NVL(ZXREPDET.TAX_AMT, 0) + NVL(ZXREPDET.TAXABLE_AMT, 0) TOTAL_ENTERED_AMOUNT, NVL(ZXREPDET.TAX_AMT_FUNCL_CURR, 0) + NVL(ZXREPDET.TAXABLE_AMT_FUNCL_CURR, 0) TOTAL_ACCOUNTED_AMOUNT, NVL(ZXREPDET.TAXABLE_DISC_AMT, 0) TAXABLE_DISC_AMT, NVL(ZXREPDET.TAXABLE_DISC_AMT_FUNCL_CURR, 0) TAXABLE_DISC_AMT_FUNCL_CURR, NVL(ZXREPDET.TAX_DISC_AMT, 0) TAX_DISC_AMT, NVL(TAX_DISC_AMT_FUNCL_CURR, 0) TAX_DISC_AMT_FUNCL_CURR, ZXREPDET.TRX_LINE_NUMBER TRX_LINE_NUMBER, ZXREPDET.TAXABLE_LINE_SOURCE_TABLE TAXABLE_LINE_SOURCE_TABLE, ZXREPDET.TRX_LINE_DESCRIPTION TRX_LINE_DESCRIPTION, ZXREPDET.PRODUCT_ID PRODUCT_ID, ZXREPDET.TAXABLE_LINE_ITEM_FLEXFIELD TAXABLE_LINE_ITEM_FLEXFIELD, ZXREPDET.PRODUCT_DESCRIPTION PRODUCT_DESCRIPTION, ZXREPDET.TRX_LINE_QUANTITY TRX_LINE_QUANTITY, ZXREPDET.UOM_CODE UOM_CODE, ZXREPDET.TRX_QUANTITY_UOM_MNG TRX_QUANTITY_UOM_MNG, ZXREPDET.TRX_LINE_TYPE TRX_LINE_TYPE, ZXREPACT.ACTG_EVENT_ID ACTG_EVENT_ID, ZXREPACT.ACTG_EVENT_TYPE_CODE ACTG_EVENT_TYPE_CODE, ZXREPACT.ACTG_EVENT_TYPE_MNG ACTG_EVENT_TYPE_MNG, ZXREPACT.ACTG_EVENT_NUMBER ACTG_EVENT_NUMBER, ZXREPACT.ACTG_EVENT_STATUS_FLAG ACTG_EVENT_STATUS_FLAG, ZXREPACT.ACTG_EVENT_STATUS_MNG ACTG_EVENT_STATUS_MNG, ZXREPACT.ACTG_SOURCE_TABLE ACTG_SOURCE_TABLE, ZXREPACT.ACTG_SOURCE_ID ACTG_SOURCE_ID, ZXREPACT.ACTG_HEADER_ID ACTG_HEADER_ID, ZXREPACT.ACTG_CATEGORY_CODE ACTG_CATEGORY_CODE, ZXREPACT.ACTG_CATEGORY_MNG ACTG_CATEGORY_MNG, ZXREPACT.PERIOD_NAME PERIOD_NAME, ZXREPACT.GL_TRANSFER_FLAG GL_TRANSFER_FLAG, ZXREPACT.GL_TRANSFER_RUN_ID GL_TRANSFER_RUN_ID, ZXREPACT.ACTG_HEADER_DESCRIPTION ACTG_HEADER_DESCRIPTION, ZXREPACT.ACTG_LINE_NUM ACTG_LINE_NUM, ZXREPACT.ACTG_LINE_TYPE_CODE ACTG_LINE_TYPE_CODE, ZXREPACT.ACTG_LINE_TYPE_MNG ACTG_LINE_TYPE_MNG, ZXREPACT.ACTG_LINE_CCID ACTG_LINE_CCID, ZXREPACT.ACCOUNT_FLEXFIELD ACCOUNT_FLEXFIELD, ZXREPACT.ACCOUNT_DESCRIPTION ACCOUNT_DESCRIPTION, ZXREPACT.ACTG_LINE_DESCRIPTION ACTG_LINE_DESCRIPTION, ZXREPACT.ACTG_STAT_AMT ACTG_STAT_AMT, ZXREPACT.ACTG_ERROR_CODE ACTG_ERROR_CODE, ZXREPACT.GL_TRANSFER_CODE GL_TRANSFER_CODE, ZXREPACT.ACTG_DOC_SEQUENCE_ID ACTG_DOC_SEQUENCE_ID, ZXREPACT.ACTG_DOC_SEQUENCE_NAME ACTG_DOC_SEQUENCE_NAME, ZXREPACT.ACTG_DOC_SEQUENCE_VALUE ACTG_DOC_SEQUENCE_VALUE, ZXREPACT.ACTG_PARTY_ID ACTG_PARTY_ID, ZXREPACT.ACTG_PARTY_SITE_ID ACTG_PARTY_SITE_ID, ZXREPACT.TRX_ARAP_BALANCING_SEGMENT TRX_ARAP_BALANCING_SEGMENT, ZXREPACT.TRX_ARAP_NATURAL_ACCOUNT TRX_ARAP_NATURAL_ACCOUNT, ZXREPACT.TRX_TAXABLE_BALANCING_SEGMENT TRX_TAXABLE_BALANCING_SEGMENT, ZXREPACT.TRX_TAXABLE_NATURAL_ACCOUNT TRX_TAXABLE_NATURAL_ACCOUNT, ZXREPACT.TRX_TAX_BALANCING_SEGMENT TRX_TAX_BALANCING_SEGMENT, ZXREPACT.TRX_TAX_NATURAL_ACCOUNT TRX_TAX_NATURAL_ACCOUNT, ZXREPACT.TRX_TAXABLE_ACCOUNT TRX_TAXABLE_ACCOUNT, ZXREPACT.TRX_TAXABLE_ACCOUNT_DESC TRX_TAXABLE_ACCOUNT_DESC, ZXREPACT.TRX_TAXABLE_BALSEG_DESC TRX_TAXABLE_BALSEG_DESC, ZXREPACT.TRX_TAXABLE_NATACCT_SEG_DESC TRX_TAXABLE_NATACCT_SEG_DESC, ZXREPJEX.NUMERIC1 NUMERIC1, ZXREPJEX.NUMERIC2 NUMERIC2, ZXREPJEX.NUMERIC3 NUMERIC3, ZXREPJEX.NUMERIC4 NUMERIC4, ZXREPJEX.NUMERIC5 NUMERIC5, ZXREPJEX.NUMERIC6 NUMERIC6, ZXREPJEX.NUMERIC7 NUMERIC7, ZXREPJEX.NUMERIC8 NUMERIC8, ZXREPJEX.NUMERIC9 NUMERIC9, ZXREPJEX.NUMERIC10 NUMERIC10, ZXREPJEX.NUMERIC11 NUMERIC11, ZXREPJEX.NUMERIC12 NUMERIC12, ZXREPJEX.NUMERIC13 NUMERIC13, ZXREPJEX.NUMERIC14 NUMERIC14, ZXREPJEX.NUMERIC15 NUMERIC15, ZXREPJEX.NUMERIC16 NUMERIC16, ZXREPJEX.ATTRIBUTE1 ATTRIBUTE1, ZXREPJEX.ATTRIBUTE2 ATTRIBUTE2, ZXREPJEX.ATTRIBUTE3 ATTRIBUTE3, ZXREPJEX.ATTRIBUTE4 ATTRIBUTE4, ZXREPJEX.ATTRIBUTE5 ATTRIBUTE5, ZXREPJEX.ATTRIBUTE6 ATTRIBUTE6, ZXREPJEX.ATTRIBUTE7 ATTRIBUTE7, ZXREPJEX.ATTRIBUTE8 ATTRIBUTE8, ZXREPJEX.ATTRIBUTE9 ATTRIBUTE9, ZXREPJEX.ATTRIBUTE10 ATTRIBUTE10, ZXREPJEX.ATTRIBUTE11 ATTRIBUTE11, ZXREPJEX.ATTRIBUTE12 ATTRIBUTE12, ZXREPJEX.ATTRIBUTE13 ATTRIBUTE13, ZXREPJEX.ATTRIBUTE14 ATTRIBUTE14, ZXREPJEX.ATTRIBUTE15 ATTRIBUTE15, ZXREPJEX.ATTRIBUTE16 ATTRIBUTE16, ZXREPJEX.ATTRIBUTE17 ATTRIBUTE17, ZXREPJEX.ATTRIBUTE18 ATTRIBUTE18, ZXREPJEX.ATTRIBUTE2 || ' ' || ZXREPJEX.ATTRIBUTE3 || ' ' || ZXREPJEX.ATTRIBUTE4 || ' ' || ZXREPJEX.ATTRIBUTE8 || ' ' || ZXREPJEX.ATTRIBUTE9 BUSINESS_LOC_ADDRESS, ZXREPJEX.DOCUMENT_SUB_TYPE_MNG DOCUMENT_SUB_TYPE_MNG, ZXREPJEX.TAX_STATUS_MNG TAX_STATUS_MNG, ZXREPJEX.TRX_BUSINESS_CATEGORY_MNG TRX_BUSINESS_CATEGORY_MNG, ZXREPJEX.GDF_AP_INVOICES_ATT2 GDF_AP_INVOICES_ATT2, ZXREPJEX.GDF_AP_INVOICES_ATT3 GDF_AP_INVOICES_ATT3, ZXREPJEX.GDF_AP_INVOICES_ATT4 GDF_AP_INVOICES_ATT4, ZXREPJEX.GDF_AP_INVOICES_ATT11 GDF_AP_INVOICES_ATT11, ZXREPJEX.GDF_AP_INVOICES_ATT12 GDF_AP_INVOICES_ATT12, ZXREPJEX.GDF_AP_INVOICES_ATT13 GDF_AP_INVOICES_ATT13, ZXREPJEX.GDF_AP_INVOICE_DIST_ATT1 GDF_AP_INVOICE_DIST_ATT1, ZXREPJEX.GDF_PO_VENDOR_SITES_ATT17 GDF_PO_VENDOR_SITES_ATT17, ZXREPJEX.GDF_RA_CUST_BILL_ATT10 GDF_RA_CUST_BILL_ATT10, ZXREPJEX.GDF_RA_CUST_BILL_ATT12 GDF_RA_CUST_BILL_ATT12, ZXREPJEX.GDF_PARTY_SITES_BILL_ATT8 GDF_PARTY_SITES_BILL_ATT8, ZXREPJEX.GDF_PARTY_SITES_BILL_ATT9 GDF_PARTY_SITES_BILL_ATT9, ZXREPJEX.GDF_RA_CUST_TRX_ATT3 GDF_RA_CUST_TRX_ATT3, ZXREPJEX.GDF_RA_CUST_TRX_ATT4 GDF_RA_CUST_TRX_ATT4, ZXREPJEX.GDF_RA_CUST_TRX_ATT5 GDF_RA_CUST_TRX_ATT5, ZXREPJEX.GDF_RA_CUST_TRX_ATT6 GDF_RA_CUST_TRX_ATT6, ZXREPJEX.GDF_RA_CUST_TRX_ATT7 GDF_RA_CUST_TRX_ATT7, ZXREPJEX.GDF_RA_CUST_TRX_ATT8 GDF_RA_CUST_TRX_ATT8, ZXREPJEX.GDF_RA_CUST_TRX_ATT9 GDF_RA_CUST_TRX_ATT9, ZXREPJEX.GDF_RA_CUST_TRX_ATT19 GDF_RA_CUST_TRX_ATT19, ZXREPJEX.GDF_RA_CUST_TRX_LINES_ATT1 GDF_RA_CUST_TRX_LINES_ATT1, ZXREPJEX.GDF_RA_CUST_TRX_LINES_ATT2 GDF_RA_CUST_TRX_LINES_ATT2, ZXREPJEX.GDF_RA_CUST_TRX_TYPES_ATT5 GDF_RA_CUST_TRX_TYPES_ATT5, ZXREPJEX.GDF_RA_CUST_TRX_TYPES_ATT6 GDF_RA_CUST_TRX_TYPES_ATT6, ZXREPJEX.GDF_RA_CUST_TRX_TYPES_ATT7 GDF_RA_CUST_TRX_TYPES_ATT7, ZXREPJEX.GDF_RA_BATCH_SOURCES_ATT1 GDF_RA_BATCH_SOURCES_ATT1, ZXREPJEX.GDF_RA_BATCH_SOURCES_ATT2 GDF_RA_BATCH_SOURCES_ATT2, ZXREPJEX.GDF_RA_BATCH_SOURCES_ATT3 GDF_RA_BATCH_SOURCES_ATT3, ZXREPJEX.GDF_RA_BATCH_SOURCES_ATT4 GDF_RA_BATCH_SOURCES_ATT4, ZXREPJEX.GDF_RA_BATCH_SOURCES_ATT7 GDF_RA_BATCH_SOURCES_ATT7, ZXREPJEX.GDF_RA_ADDRESSES_BILL_ATT9 GDF_RA_ADDRESSES_BILL_ATT9, ZXREPJEX.GDF_RA_ADDRESSES_SHIP_ATT9 GDF_RA_ADDRESSES_SHIP_ATT9, ZXREPDET.HQ_ESTB_REG_NUMBER HQ_ESTB_REG_NUMBER, ZXREPDET.TAX_POINT_BASIS TAX_POINT_BASIS, ZXREPDET.TAX_POINT_DATE TAX_POINT_DATE, ZXREPDET.LEGAL_MESSAGE_APPL_2 LEGAL_MESSAGE_APPL_2, ZXREPDET.LEGAL_MESSAGE_STATUS LEGAL_MESSAGE_STATUS, ZXREPDET.LEGAL_MESSAGE_RATE LEGAL_MESSAGE_RATE, ZXREPDET.LEGAL_MESSAGE_BASIS LEGAL_MESSAGE_BASIS, ZXREPDET.LEGAL_MESSAGE_CALC LEGAL_MESSAGE_CALC, ZXREPDET.LEGAL_MESSAGE_THRESHOLD LEGAL_MESSAGE_THRESHOLD, ZXREPDET.LEGAL_MESSAGE_POS LEGAL_MESSAGE_POS, ZXREPDET.LEGAL_MESSAGE_TRN LEGAL_MESSAGE_TRN, ZXREPDET.LEGAL_MESSAGE_EXMPT LEGAL_MESSAGE_EXMPT, ZXREPDET.REPORTABLE_FLAG REPORTABLE_FLAG, ZXREPDET.APPLIED_TO_TRX_LEVEL_TYPE APPLIED_TO_TRX_LEVEL_TYPE, ZXREPDET.LEGAL_REPORTING_STATUS LEGAL_REPORTING_STATUS, ZXREPDET.APPLIED_TO_TAX_DIST_ID APPLIED_TO_TAX_DIST_ID, ZXREPDET.APPL_TO_TRX_CURR_UNIT_NR_AMT APPL_TO_TRX_CURR_UNIT_NR_AMT, ZXREPDET.APPL_TO_PER_UNIT_NREC_TAX_AMT APPL_TO_PER_UNIT_NREC_TAX_AMT, ZXREPDET.APPLIED_TO_UNIT_PRICE APPLIED_TO_UNIT_PRICE, ZXREPDET.APPLIED_TO_TRX_LINE_DIST_QTY APPLIED_TO_TRX_LINE_DIST_QTY, ZXREPDET.APPLIED_TO_DIST_ID APPLIED_TO_DIST_ID, ZXREPDET.MATCH_TYPE MATCH_TYPE, ZXREPDET.FOS_TRANSACTION_ID FOS_TRANSACTION_ID, ZXREPDET.RECEIPT_SOURCE_CODE RECEIPT_SOURCE_CODE, ZXREPDET.DROPSHIP_TYPE_ID DROPSHIP_TYPE_ID, ZXREPDET.REQUISITION_TYPE REQUISITION_TYPE, ZXREPDET.PORT_OF_ENTRY_CODE PORT_OF_ENTRY_CODE, ZXREPDET.PURCHASING_CATEGORY_ID PURCHASING_CATEGORY_ID, ZXREPDET.DROP_SHIP_FLAG DROP_SHIP_FLAG, ZXREPDET.CONSIGNED_FLAG CONSIGNED_FLAG, ZXREPDET.DESTINATION_TYPE_CODE DESTINATION_TYPE_CODE, ZXREPDET.CONSIGN_ITM_UPON_RECPT_FLAG CONSIGN_ITM_UPON_RECPT_FLAG, ZXREPDET.PORT_OF_DISCHARGE PORT_OF_DISCHARGE, ZXREPDET.EXPENDITURE_TYPE EXPENDITURE_TYPE, ZXREPDET.PORT_OF_LOADING PORT_OF_LOADING, ZXREPDET.DELIVERY_TYPE DELIVERY_TYPE, ZXREPDET.DOCUMENT_TYPE DOCUMENT_TYPE, ZXREPDET.SHIPMENT_TYPE SHIPMENT_TYPE, ZXREPDET.HDR_GL_DATE HDR_GL_DATE, ZXREPDET.GL_POSTED_DATE GL_POSTED_DATE, ZXREPDET.POSTED_TO_SLA_FLAG POSTED_TO_SLA_FLAG, ZXREPDET.FINAL_DISCHARGE_LOCATION_ID FINAL_DISCHARGE_LOCATION_ID, ZXREPDET.FINAL_TRANSACTION_NODE_FLAG FINAL_TRANSACTION_NODE_FLAG, ZXREPDET.COUNTRY_OF_ORIGIN_CODE COUNTRY_OF_ORIGIN_CODE, ZXREPDET.FIRST_PTY_REG_ID FIRST_PTY_REG_ID, ZXREPDET.TAX_RATE_SCHED_ID TAX_RATE_SCHED_ID, ZXREPDET.REPORTING_CURRENCY_CODE REPORTING_CURRENCY_CODE, ZXREPDET.PRODUCT_TYPE PRODUCT_TYPE, ZXREPDET.ASSET_FLAG ASSET_FLAG, ZXREPDET.INTERNAL_ORG_LOCATION_ID INTERNAL_ORG_LOCATION_ID, ZXREPDET.MERCHANT_PARTY_TAX_PROF_ID MERCHANT_PARTY_TAX_PROF_ID, ZXREPDET.POA_PARTY_TAX_PROF_ID POA_PARTY_TAX_PROF_ID, ZXREPDET.POO_PARTY_TAX_PROF_ID POO_PARTY_TAX_PROF_ID, ZXREPDET.POA_SITE_TAX_PROF_ID POA_SITE_TAX_PROF_ID, ZXREPDET.POO_SITE_TAX_PROF_ID POO_SITE_TAX_PROF_ID, ZXREPDET.PAYING_SITE_TAX_PROF_ID PAYING_SITE_TAX_PROF_ID, ZXREPDET.TAX_RATE_EFFECTIVE_FROM TAX_RATE_EFFECTIVE_FROM, ZXREPDET.TAX_RATE_EFFECTIVE_TO TAX_RATE_EFFECTIVE_TO, ZXREPDET.THIRD_PTY_REG_ID THIRD_PTY_REG_ID, ZXREPDET.THIRD_PTY_REG_NUMBER THIRD_PTY_REG_NUMBER, ZXREPDET.PAYMENT_MATURITY_DATE PAYMENT_MATURITY_DATE, ZXREPDET.PAYMENT_CHECK_ID PAYMENT_CHECK_ID, ZXREPDET.PAYMENT_CLEARED_DATE PAYMENT_CLEARED_DATE, ZXREPDET.PAYMENT_TYPE_FLAG PAYMENT_TYPE_FLAG, ZXREPDET.IBAN_NUMBER IBAN_NUMBER, ZXREPDET.TRX_AMOUNT_REMAINING TRX_AMOUNT_REMAINING, ZXREPDET.TAX_AMOUNT_REMAINING TAX_AMOUNT_REMAINING, ZXREPDET.PRODUCT_CODE PRODUCT_CODE, ZXREPDET.ITEM_UOM ITEM_UOM, ZXREPDET.EFT_SWIFT_CODE EFT_SWIFT_CODE, ZXREPDET.PAYMENT_METHOD_CODE PAYMENT_METHOD_CODE, ZXREPDET.COUNTRY_OF_PAYMENT COUNTRY_OF_PAYMENT, ZXREPJEX.BOX_NUMBER1_ID BOX_NUMBER1_ID, ZXREPJEX.BOX_NUMBER2_ID BOX_NUMBER2_ID, ZXREPJEX.BOX_NUMBER3_ID BOX_NUMBER3_ID, ZXREPJEX.BOX_NUMBER4_ID BOX_NUMBER4_ID, ZXREPJEX.BOX_NUMBER5_ID BOX_NUMBER5_ID, ZXREPJEX.BOX_NUMBER6_ID BOX_NUMBER6_ID, ZXREPJEX.BOX_NUMBER7_ID BOX_NUMBER7_ID, ZXREPJEX.BOX_NUMBER8_ID BOX_NUMBER8_ID, ZXREPJEX.BOX_NUMBER9_ID BOX_NUMBER9_ID, ZXREPJEX.BOX_NUMBER10_ID BOX_NUMBER10_ID, ZXREPJEX.BOX_NUMBER1 BOX_NUMBER1, ZXREPJEX.BOX_NUMBER2 BOX_NUMBER2, ZXREPJEX.BOX_NUMBER3 BOX_NUMBER3, ZXREPJEX.BOX_NUMBER4 BOX_NUMBER4, ZXREPJEX.BOX_NUMBER5 BOX_NUMBER5, ZXREPJEX.BOX_NUMBER6 BOX_NUMBER6, ZXREPJEX.BOX_NUMBER7 BOX_NUMBER7, ZXREPJEX.BOX_NUMBER8 BOX_NUMBER8, ZXREPJEX.BOX_NUMBER9 BOX_NUMBER9, ZXREPJEX.BOX_NUMBER10 BOX_NUMBER10, ZXREPJEX.BOX_VALUE_TYPE_CODE1 BOX_VALUE_TYPE_CODE1, ZXREPJEX.BOX_VALUE_TYPE_CODE2 BOX_VALUE_TYPE_CODE2, ZXREPJEX.BOX_VALUE_TYPE_CODE3 BOX_VALUE_TYPE_CODE3, ZXREPJEX.BOX_VALUE_TYPE_CODE4 BOX_VALUE_TYPE_CODE4, ZXREPJEX.BOX_VALUE_TYPE_CODE5 BOX_VALUE_TYPE_CODE5, ZXREPJEX.BOX_VALUE_TYPE_CODE6 BOX_VALUE_TYPE_CODE6, ZXREPJEX.BOX_VALUE_TYPE_CODE7 BOX_VALUE_TYPE_CODE7, ZXREPJEX.BOX_VALUE_TYPE_CODE8 BOX_VALUE_TYPE_CODE8, ZXREPJEX.BOX_VALUE_TYPE_CODE9 BOX_VALUE_TYPE_CODE9, ZXREPJEX.BOX_VALUE_TYPE_CODE10 BOX_VALUE_TYPE_CODE10, ZXREPJEX.BOX_SIGN_FLAG1 BOX_SIGN_FLAG1, ZXREPJEX.BOX_SIGN_FLAG2 BOX_SIGN_FLAG2, ZXREPJEX.BOX_SIGN_FLAG3 BOX_SIGN_FLAG3, ZXREPJEX.BOX_SIGN_FLAG4 BOX_SIGN_FLAG4, ZXREPJEX.BOX_SIGN_FLAG5 BOX_SIGN_FLAG5, ZXREPJEX.BOX_SIGN_FLAG6 BOX_SIGN_FLAG6, ZXREPJEX.BOX_SIGN_FLAG7 BOX_SIGN_FLAG7, ZXREPJEX.BOX_SIGN_FLAG8 BOX_SIGN_FLAG8, ZXREPJEX.BOX_SIGN_FLAG9 BOX_SIGN_FLAG9, ZXREPJEX.BOX_SIGN_FLAG10 BOX_SIGN_FLAG10, ZXREPJEX.PERIODICITY_CODE PERIODICITY_CODE, ZXREPJEX.REPORTING_TYPE_ID REPORTING_TYPE_ID, ZXREPDET.GL_DATE GL_DATE, ZXREPDET.SELF_ASSESSED_FLAG SELF_ASSESSED_FLAG, ZXREPDET.SHIP_TO_LOCATION_ID SHIP_TO_LOCATION_ID, HRLOC.LOCATION_CODE SHIP_TO_LOCATION_CODE, HRLOC.DESCRIPTION SHIP_TO_LOCATION_DESCRIPTION, HRLOC.ADDRESS_LINE_1 SHIP_TO_ADDRESS_LINE_1, HRLOC.ADDRESS_LINE_2 SHIP_TO_ADDRESS_LINE_2, HRLOC.ADDRESS_LINE_3 SHIP_TO_ADDRESS_LINE_3, HRLOC.ADDRESS_LINE_4 SHIP_TO_ADDRESS_LINE_4, HRLOC.COUNTRY SHIP_TO_COUNTRY, HRLOC.POSTAL_CODE SHIP_TO_POSTAL_CODE, HRLOC.REGION_1 SHIP_TO_REGION_1, HRLOC.REGION_2 SHIP_TO_REGION_2, HRLOC.REGION_3 SHIP_TO_REGION_3, HRLOC.TOWN_OR_CITY SHIP_TO_TOWN_OR_CITY FROM ZX_REP_CONTEXT_T ZXREPCON, ZX_REP_TRX_DETAIL_T ZXREPDET, ZX_REP_ACTG_EXT_T ZXREPACT, ZX_REP_TRX_JX_EXT_T ZXREPJEX , HR_LOCATIONS_ALL HRLOC WHERE ZXREPCON.REP_CONTEXT_ID = NVL(ZXREPDET.REP_CONTEXT_ID, ZXREPCON.REP_CONTEXT_ID) AND ZXREPDET.REQUEST_ID = ZXREPCON.REQUEST_ID AND ZXREPDET.DETAIL_TAX_LINE_ID = ZXREPACT.DETAIL_TAX_LINE_ID(+) AND ZXREPDET.DETAIL_TAX_LINE_ID = ZXREPJEX.DETAIL_TAX_LINE_ID(+) AND ZXREPDET.SHIP_TO_LOCATION_ID = HRLOC.LOCATION_ID(+)