VIEW: INL.INL_MATCHES_INT#

Source

View Text - Preformatted

select MATCH_INT_ID MATCH_INT_ID, GROUP_ID GROUP_ID, PROCESSING_STATUS_CODE PROCESSING_STATUS_CODE, TRANSACTION_TYPE TRANSACTION_TYPE, MATCH_TYPE_CODE MATCH_TYPE_CODE, FROM_PARENT_TABLE_NAME FROM_PARENT_TABLE_NAME, FROM_PARENT_TABLE_ID FROM_PARENT_TABLE_ID, TO_PARENT_TABLE_NAME TO_PARENT_TABLE_NAME, TO_PARENT_TABLE_ID TO_PARENT_TABLE_ID, MATCHED_QTY MATCHED_QTY, MATCHED_UOM_CODE MATCHED_UOM_CODE, MATCHED_AMT MATCHED_AMT, MATCHED_CURR_CODE MATCHED_CURR_CODE, MATCHED_CURR_CONVERSION_TYPE MATCHED_CURR_CONVERSION_TYPE, MATCHED_CURR_CONVERSION_DATE MATCHED_CURR_CONVERSION_DATE, MATCHED_CURR_CONVERSION_RATE MATCHED_CURR_CONVERSION_RATE, REPLACE_ESTIM_QTY_FLAG REPLACE_ESTIM_QTY_FLAG, CHARGE_LINE_TYPE_ID CHARGE_LINE_TYPE_ID, PARTY_ID PARTY_ID, PARTY_NUMBER PARTY_NUMBER, PARTY_SITE_ID PARTY_SITE_ID, PARTY_SITE_NUMBER PARTY_SITE_NUMBER, TAX_CODE TAX_CODE, NREC_TAX_AMT NREC_TAX_AMT, TAX_AMT_INCLUDED_FLAG TAX_AMT_INCLUDED_FLAG, MATCH_AMOUNT_INT_ID MATCH_AMOUNT_INT_ID, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, REQUEST_ID REQUEST_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, ADJ_GROUP_DATE ADJ_GROUP_DATE, MATCH_AMOUNTS_FLAG MATCH_AMOUNTS_FLAG from "INL"."INL_MATCHES_INT"

View Text - HTML Formatted

SELECT MATCH_INT_ID MATCH_INT_ID
, GROUP_ID GROUP_ID
, PROCESSING_STATUS_CODE PROCESSING_STATUS_CODE
, TRANSACTION_TYPE TRANSACTION_TYPE
, MATCH_TYPE_CODE MATCH_TYPE_CODE
, FROM_PARENT_TABLE_NAME FROM_PARENT_TABLE_NAME
, FROM_PARENT_TABLE_ID FROM_PARENT_TABLE_ID
, TO_PARENT_TABLE_NAME TO_PARENT_TABLE_NAME
, TO_PARENT_TABLE_ID TO_PARENT_TABLE_ID
, MATCHED_QTY MATCHED_QTY
, MATCHED_UOM_CODE MATCHED_UOM_CODE
, MATCHED_AMT MATCHED_AMT
, MATCHED_CURR_CODE MATCHED_CURR_CODE
, MATCHED_CURR_CONVERSION_TYPE MATCHED_CURR_CONVERSION_TYPE
, MATCHED_CURR_CONVERSION_DATE MATCHED_CURR_CONVERSION_DATE
, MATCHED_CURR_CONVERSION_RATE MATCHED_CURR_CONVERSION_RATE
, REPLACE_ESTIM_QTY_FLAG REPLACE_ESTIM_QTY_FLAG
, CHARGE_LINE_TYPE_ID CHARGE_LINE_TYPE_ID
, PARTY_ID PARTY_ID
, PARTY_NUMBER PARTY_NUMBER
, PARTY_SITE_ID PARTY_SITE_ID
, PARTY_SITE_NUMBER PARTY_SITE_NUMBER
, TAX_CODE TAX_CODE
, NREC_TAX_AMT NREC_TAX_AMT
, TAX_AMT_INCLUDED_FLAG TAX_AMT_INCLUDED_FLAG
, MATCH_AMOUNT_INT_ID MATCH_AMOUNT_INT_ID
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, REQUEST_ID REQUEST_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, ADJ_GROUP_DATE ADJ_GROUP_DATE
, MATCH_AMOUNTS_FLAG MATCH_AMOUNTS_FLAG
FROM "INL"."INL_MATCHES_INT"