VIEW: INL.INL_MATCHES#

Source

View Text - Preformatted

select MATCH_ID MATCH_ID, MATCH_TYPE_CODE MATCH_TYPE_CODE, SHIP_HEADER_ID SHIP_HEADER_ID, 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, PARENT_MATCH_ID PARENT_MATCH_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, ADJ_ALREADY_GENERATED_FLAG ADJ_ALREADY_GENERATED_FLAG, REPLACE_ESTIM_QTY_FLAG REPLACE_ESTIM_QTY_FLAG, EXISTING_MATCH_INFO_FLAG EXISTING_MATCH_INFO_FLAG, CHARGE_LINE_TYPE_ID CHARGE_LINE_TYPE_ID, PARTY_ID PARTY_ID, PARTY_SITE_ID PARTY_SITE_ID, TAX_CODE TAX_CODE, NREC_TAX_AMT NREC_TAX_AMT, TAX_AMT_INCLUDED_FLAG TAX_AMT_INCLUDED_FLAG, MATCH_AMOUNT_ID MATCH_AMOUNT_ID, MATCH_INT_ID MATCH_INT_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, REQUEST_ID REQUEST_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, ADJ_GROUP_DATE ADJ_GROUP_DATE, ADJUSTMENT_NUM ADJUSTMENT_NUM from "INL"."INL_MATCHES"

View Text - HTML Formatted

SELECT MATCH_ID MATCH_ID
, MATCH_TYPE_CODE MATCH_TYPE_CODE
, SHIP_HEADER_ID SHIP_HEADER_ID
, 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
, PARENT_MATCH_ID PARENT_MATCH_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
, ADJ_ALREADY_GENERATED_FLAG ADJ_ALREADY_GENERATED_FLAG
, REPLACE_ESTIM_QTY_FLAG REPLACE_ESTIM_QTY_FLAG
, EXISTING_MATCH_INFO_FLAG EXISTING_MATCH_INFO_FLAG
, CHARGE_LINE_TYPE_ID CHARGE_LINE_TYPE_ID
, PARTY_ID PARTY_ID
, PARTY_SITE_ID PARTY_SITE_ID
, TAX_CODE TAX_CODE
, NREC_TAX_AMT NREC_TAX_AMT
, TAX_AMT_INCLUDED_FLAG TAX_AMT_INCLUDED_FLAG
, MATCH_AMOUNT_ID MATCH_AMOUNT_ID
, MATCH_INT_ID MATCH_INT_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, REQUEST_ID REQUEST_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
, ADJ_GROUP_DATE ADJ_GROUP_DATE
, ADJUSTMENT_NUM ADJUSTMENT_NUM
FROM "INL"."INL_MATCHES"