VIEW: JA.JAI_AP_MATCH_INV_TAXES#

Source

View Text - Preformatted

select TAX_DISTRIBUTION_ID TAX_DISTRIBUTION_ID, INVOICE_ID INVOICE_ID, PO_HEADER_ID PO_HEADER_ID, PO_LINE_ID PO_LINE_ID, LINE_LOCATION_ID LINE_LOCATION_ID, CHART_OF_ACCOUNTS_ID CHART_OF_ACCOUNTS_ID, SET_OF_BOOKS_ID SET_OF_BOOKS_ID, EXCHANGE_RATE EXCHANGE_RATE, EXCHANGE_RATE_TYPE EXCHANGE_RATE_TYPE, EXCHANGE_DATE EXCHANGE_DATE, CURRENCY_CODE CURRENCY_CODE, DSP_CODE_COMBINATION_ID DSP_CODE_COMBINATION_ID, CODE_COMBINATION_ID CODE_COMBINATION_ID, TAX_ID TAX_ID, TAX_AMOUNT TAX_AMOUNT, LINE_NO LINE_NO, ACCT_PAY_CODE_COMBINATION_ID ACCT_PAY_CODE_COMBINATION_ID, EXCHANGE_RATE_VARIANCE EXCHANGE_RATE_VARIANCE, BASE_AMOUNT BASE_AMOUNT, ACCOUNTING_DATE ACCOUNTING_DATE, MATCH_STATUS_FLAG MATCH_STATUS_FLAG, RATE_VAR_CODE_COMBINATION_ID RATE_VAR_CODE_COMBINATION_ID, DISTRIBUTION_LINE_NUMBER DISTRIBUTION_LINE_NUMBER, ASSETS_TRACKING_FLAG ASSETS_TRACKING_FLAG, REVERSAL_FLAG REVERSAL_FLAG, PARENT_INVOICE_ID PARENT_INVOICE_ID, SHIPMENT_LINE_ID SHIPMENT_LINE_ID, SHIPMENT_HEADER_ID SHIPMENT_HEADER_ID, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, VAT_INVOICE_NO VAT_INVOICE_NO, VAT_INVOICE_DATE VAT_INVOICE_DATE, VAT_INVOICE_ENTERED_DATE VAT_INVOICE_ENTERED_DATE, PO_DISTRIBUTION_ID PO_DISTRIBUTION_ID, PARENT_INVOICE_DISTRIBUTION_ID PARENT_INVOICE_DISTRIBUTION_ID, INVOICE_DISTRIBUTION_ID INVOICE_DISTRIBUTION_ID, RCV_TRANSACTION_ID RCV_TRANSACTION_ID, LINE_TYPE_LOOKUP_CODE LINE_TYPE_LOOKUP_CODE, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, INVOICE_LINE_NUMBER INVOICE_LINE_NUMBER, PARENT_INVOICE_LINE_NUMBER PARENT_INVOICE_LINE_NUMBER, LEGAL_ENTITY_ID LEGAL_ENTITY_ID, RECOVERABLE_FLAG RECOVERABLE_FLAG from "JA"."JAI_AP_MATCH_INV_TAXES"

View Text - HTML Formatted

SELECT TAX_DISTRIBUTION_ID TAX_DISTRIBUTION_ID
, INVOICE_ID INVOICE_ID
, PO_HEADER_ID PO_HEADER_ID
, PO_LINE_ID PO_LINE_ID
, LINE_LOCATION_ID LINE_LOCATION_ID
, CHART_OF_ACCOUNTS_ID CHART_OF_ACCOUNTS_ID
, SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, EXCHANGE_RATE EXCHANGE_RATE
, EXCHANGE_RATE_TYPE EXCHANGE_RATE_TYPE
, EXCHANGE_DATE EXCHANGE_DATE
, CURRENCY_CODE CURRENCY_CODE
, DSP_CODE_COMBINATION_ID DSP_CODE_COMBINATION_ID
, CODE_COMBINATION_ID CODE_COMBINATION_ID
, TAX_ID TAX_ID
, TAX_AMOUNT TAX_AMOUNT
, LINE_NO LINE_NO
, ACCT_PAY_CODE_COMBINATION_ID ACCT_PAY_CODE_COMBINATION_ID
, EXCHANGE_RATE_VARIANCE EXCHANGE_RATE_VARIANCE
, BASE_AMOUNT BASE_AMOUNT
, ACCOUNTING_DATE ACCOUNTING_DATE
, MATCH_STATUS_FLAG MATCH_STATUS_FLAG
, RATE_VAR_CODE_COMBINATION_ID RATE_VAR_CODE_COMBINATION_ID
, DISTRIBUTION_LINE_NUMBER DISTRIBUTION_LINE_NUMBER
, ASSETS_TRACKING_FLAG ASSETS_TRACKING_FLAG
, REVERSAL_FLAG REVERSAL_FLAG
, PARENT_INVOICE_ID PARENT_INVOICE_ID
, SHIPMENT_LINE_ID SHIPMENT_LINE_ID
, SHIPMENT_HEADER_ID SHIPMENT_HEADER_ID
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, VAT_INVOICE_NO VAT_INVOICE_NO
, VAT_INVOICE_DATE VAT_INVOICE_DATE
, VAT_INVOICE_ENTERED_DATE VAT_INVOICE_ENTERED_DATE
, PO_DISTRIBUTION_ID PO_DISTRIBUTION_ID
, PARENT_INVOICE_DISTRIBUTION_ID PARENT_INVOICE_DISTRIBUTION_ID
, INVOICE_DISTRIBUTION_ID INVOICE_DISTRIBUTION_ID
, RCV_TRANSACTION_ID RCV_TRANSACTION_ID
, LINE_TYPE_LOOKUP_CODE LINE_TYPE_LOOKUP_CODE
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, INVOICE_LINE_NUMBER INVOICE_LINE_NUMBER
, PARENT_INVOICE_LINE_NUMBER PARENT_INVOICE_LINE_NUMBER
, LEGAL_ENTITY_ID LEGAL_ENTITY_ID
, RECOVERABLE_FLAG RECOVERABLE_FLAG
FROM "JA"."JAI_AP_MATCH_INV_TAXES"