View: CSR_RULES_VL

Product:	CSR - Scheduler
Description:
Implementation/DBA Data:	APPS.CSR_RULES_VL

View Text

SELECT B.RULE_ID
, B.OBJECT_VERSION_NUMBER
, B.BASE_RULE_ID
, B.APPL_ID
, B.RESP_ID
, B.USER_ID
, B.TERR_ID
, B.RESOURCE_TYPE
, B.RESOURCE_ID
, B.ENABLED_FLAG
, B.RULE_RANK
, B.RULE_DOC
, B.CREATED_BY
, B.CREATION_DATE
, B.LAST_UPDATED_BY
, B.LAST_UPDATE_DATE
, B.LAST_UPDATE_LOGIN
, T.RULE_NAME
, T.DESCRIPTION
FROM CSR_RULES_B B
, CSR_RULES_TL T
WHERE B.RULE_ID = T.RULE_ID
AND T.LANGUAGE = USERENV('LANG')