VIEW: APPS.INL_CORR_MATCH_AMOUNTS_V

Source

View Text - Preformatted

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 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

View Text - HTML Formatted

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
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