View: INL_CORR_MATCH_AMOUNTS_V

Product:	INL - Oracle Landed Cost Management
Description:	This view shows matches between actual and estimated charge amounts of a Landed Cost Shipment, grouped by Charge Line Type.
Implementation/DBA Data:	APPS.INL_CORR_MATCH_AMOUNTS_V

View Text

SELECT MA.MATCH_AMOUNT_ID
, (SELECT SUM(INL_LANDEDCOST_PVT.CONVERTED_AMT (NVL(M.MATCHED_AMT
, 0)
, M.MATCHED_CURR_CODE
, MA.MATCHED_CURR_CODE
, MA.MATCHED_CURR_CONVERSION_TYPE
, MA.MATCHED_CURR_CONVERSION_DATE))
FROM INL_CORR_MATCHES_V M
FROM INL_CORR_MATCHES_V M
WHERE M.MATCH_AMOUNT_ID = MA.MATCH_AMOUNT_ID) MATCHED_AMT
, MA.MATCHED_CURR_CODE
, MA.MATCHED_CURR_CONVERSION_TYPE
, MA.MATCHED_CURR_CONVERSION_DATE
, MA.MATCHED_CURR_CONVERSION_RATE
, MA.PROGRAM_ID
, MA.PROGRAM_UPDATE_DATE
, MA.PROGRAM_APPLICATION_ID
, MA.REQUEST_ID
, MA.CREATED_BY
, MA.CREATION_DATE
, MA.LAST_UPDATED_BY
, MA.LAST_UPDATE_DATE
, MA.LAST_UPDATE_LOGIN
FROM INL_MATCH_AMOUNTS MA

Columns