[Home] [Help]
View: PQH_RULES_V
Product: | PQH - Public Sector HR |
Description: | Rules View |
Implementation/DBA Data: |
APPS.PQH_RULES_V
|
View Text
SELECT RUL.RULE_ID
, RUL.RULE_SET_ID
, RUL.APPLICATION_ID
, RUL.MESSAGE_NAME
, B.MESSAGE_TEXT
, RUL.OBJECT_VERSION_NUMBER
, RUL.CREATION_DATE
, RUL.CREATED_BY
, RUL.LAST_UPDATE_LOGIN
, RUL.LAST_UPDATED_BY
, RUL.LAST_UPDATE_DATE
FROM PQH_RULES RUL
, FND_NEW_MESSAGES B
WHERE RUL.APPLICATION_ID = B.APPLICATION_ID
AND RUL.MESSAGE_NAME = B.MESSAGE_NAME
AND B.LANGUAGE_CODE = USERENV('LANG')
Columns
Name |
RULE_ID |
RULE_SET_ID |
APPLICATION_ID |
MESSAGE_NAME |
MESSAGE_TEXT |
OBJECT_VERSION_NUMBER |
CREATION_DATE |
CREATED_BY |
LAST_UPDATE_LOGIN |
LAST_UPDATED_BY |
LAST_UPDATE_DATE |