[Home] [Help]
View: AR_CASH_AUTO_RULE_SETS_VL
View Text
SELECT AUTOSET.ROWID ROW_ID
, AUTOSET.AUTOMATCH_SET_ID
, AUTOSETTL.AUTOMATCH_SET_NAME
, AUTOSETTL.DESCRIPTION
, AUTOSET.START_DATE
, AUTOSET.END_DATE
, AUTOSET.EXCEPTION_REASON
, AUTOSET.ACTIVE_FLAG
, AUTOSET.CREATED_BY
, AUTOSET.CREATION_DATE
, AUTOSET.LAST_UPDATED_BY
, AUTOSET.LAST_UPDATE_DATE
, AUTOSET.LAST_UPDATE_LOGIN
FROM AR_CASH_AUTO_RULE_SETS AUTOSET
, AR_CASH_AUTO_RULE_SETS_TL AUTOSETTL
WHERE AUTOSET.AUTOMATCH_SET_ID = AUTOSETTL.AUTOMATCH_SET_ID
AND AUTOSETTL.LANGUAGE = USERENV('LANG')
Columns
Name |
ROW_ID |
AUTOMATCH_SET_ID |
AUTOMATCH_SET_NAME |
DESCRIPTION |
START_DATE |
END_DATE |
EXCEPTION_REASON |
ACTIVE_FLAG |
CREATED_BY |
CREATION_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_DATE |
LAST_UPDATE_LOGIN |