View: AR_CASH_AUTOMATCHES_VL

Product:	AR - Receivables
Description:	View used to implement Automatch Cash Rule UI
Implementation/DBA Data:	APPS.AR_CASH_AUTOMATCHES_VL

View Text

SELECT AUTO.ROWID ROW_ID
, AUTO.AUTOMATCH_ID
, AUTOTL.AUTOMATCH_NAME
, AUTOTL.DESCRIPTION
, AUTO.MATCHING_OPTION
, AUTO.AUTO_MATCH_THRESHOLD
, AUTO.SUGG_MATCH_THRESHOLD
, AUTO.START_DATE
, AUTO.END_DATE
, AUTO.USE_MATCHING_DATE
, AUTO.USE_MATCHING_AMOUNT
, AUTO.ACTIVE_FLAG
, AUTO.MATCH_DATE_BY
, AUTO.CREATED_BY
, AUTO.CREATION_DATE
, AUTO.LAST_UPDATED_BY
, AUTO.LAST_UPDATE_DATE
, AUTO.LAST_UPDATE_LOGIN
FROM AR_CASH_AUTOMATCHES AUTO
, AR_CASH_AUTOMATCHES_TL AUTOTL
WHERE AUTO.AUTOMATCH_ID = AUTOTL.AUTOMATCH_ID
AND AUTOTL.LANGUAGE = USERENV('LANG')

Columns