[Home] [Help]
View: ZX_REP_EXTRACT_V
View Text
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_ID TRX_TYPE_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 TAX
, ZXREPDET.TAX_STATUS_CODE TAX_STATUS_CODE
, ZXREPDET.TAX_REGIME_CODE TAX_REGIME_CODE
, 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
, ZXREPDET.GL_DATE GL_DATE
, 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_DIST_ID ACTG_DIST_ID
, 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.EFFECTIVE_DATE EFFECTIVE_DATE
, 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
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
WHERE
ZXREPCON.REP_CONTEXT_ID = ZXREPDET.REP_CONTEXT_ID
AND ZXREPDET.DETAIL_TAX_LINE_ID = ZXREPACT.DETAIL_TAX_LINE_ID(+)
AND ZXREPDET.DETAIL_TAX_LINE_ID = ZXREPJEX.DETAIL_TAX_LINE_ID(+)
APPS.ZX_REP_EXTRACT_V