Product: | INL - Oracle Landed Cost Management |
---|---|
Description: | This view shows corrected information of matches between actual and estimated amounts of a Landed Cost Shipment. |
Implementation/DBA Data: | APPS.INL_CORR_MATCHES_V |
SELECT MAT1.MATCH_ID
, NVL(MAT2.ADJ_GROUP_DATE
, MAT1.ADJ_GROUP_DATE) ADJ_GROUP_DATE
, MAT1.MATCH_TYPE_CODE MATCH_TYPE_CODE
, MAT1.SHIP_HEADER_ID SHIP_HEADER_ID
, MAT1.FROM_PARENT_TABLE_NAME FROM_PARENT_TABLE_NAME
, MAT1.FROM_PARENT_TABLE_ID FROM_PARENT_TABLE_ID
, MAT1.TO_PARENT_TABLE_NAME TO_PARENT_TABLE_NAME
, MAT1.TO_PARENT_TABLE_ID TO_PARENT_TABLE_ID
, MAT1.MATCHED_QTY MATCHED_QTY
, MAT1.MATCHED_UOM_CODE MATCHED_UOM_CODE
, NVL( DECODE( MAT1.MATCHED_CURR_CODE
, MAT2.MATCHED_CURR_CODE
, MAT2.MATCHED_AMT
, INL_LANDEDCOST_PVT.CONVERTED_AMT( MAT2.MATCHED_AMT
, MAT2.MATCHED_CURR_CODE
, MAT1.MATCHED_CURR_CODE
, MAT1.MATCHED_CURR_CONVERSION_TYPE
, MAT1.MATCHED_CURR_CONVERSION_DATE))
, MAT1.MATCHED_AMT) MATCHED_AMT
, DECODE(MAT2.MATCH_ID
, MAT1.MATCH_ID
, NULL
, MAT2.MATCH_ID) CORRECTION_MATCH_ID
, MAT1.MATCHED_CURR_CODE MATCHED_CURR_CODE
, MAT1.MATCHED_CURR_CONVERSION_TYPE MATCHED_CURR_CONVERSION_TYPE
, MAT1.MATCHED_CURR_CONVERSION_DATE MATCHED_CURR_CONVERSION_DATE
, MAT1.MATCHED_CURR_CONVERSION_RATE MATCHED_CURR_CONVERSION_RATE
, NVL(MAT2.ADJ_ALREADY_GENERATED_FLAG
, MAT1.ADJ_ALREADY_GENERATED_FLAG) ADJ_ALREADY_GENERATED_FLAG
, MAT1.REPLACE_ESTIM_QTY_FLAG REPLACE_ESTIM_QTY_FLAG
, NVL(MAT2.EXISTING_MATCH_INFO_FLAG
, MAT1.EXISTING_MATCH_INFO_FLAG) EXISTING_MATCH_INFO_FLAG
, MAT1.CHARGE_LINE_TYPE_ID CHARGE_LINE_TYPE_ID
, MAT1.PARTY_ID PARTY_ID
, MAT1.PARTY_SITE_ID PARTY_SITE_ID
, MAT1.TAX_CODE TAX_CODE
, MAT1.NREC_TAX_AMT NREC_TAX_AMT
, MAT1.TAX_AMT_INCLUDED_FLAG TAX_AMT_INCLUDED_FLAG
, MAT1.MATCH_AMOUNT_ID MATCH_AMOUNT_ID
, MAT1.PROGRAM_ID PROGRAM_ID
, MAT1.PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, MAT1.PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, MAT1.REQUEST_ID REQUEST_ID
, MAT1.CREATED_BY CREATED_BY
, MAT1.CREATION_DATE CREATION_DATE
, MAT1.LAST_UPDATED_BY LAST_UPDATED_BY
, MAT1.LAST_UPDATE_DATE LAST_UPDATE_DATE
, MAT1.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM INL_MATCHES MAT1
, INL_MATCHES MAT2
WHERE MAT2.PARENT_MATCH_ID (+) = MAT1.MATCH_ID
AND MAT2.MATCH_TYPE_CODE (+) = 'CORRECTION' ORDER BY MAT1.MATCH_ID