Product: | AMS - Marketing |
---|---|
Description: | This view returns all the Content Rules defined in Marketing. |
Implementation/DBA Data: | APPS.AMS_CONTENT_RULES_VL |
SELECT ACRB.CONTENT_RULE_ID
, ACRB.CREATED_BY
, ACRB.CREATION_DATE
, ACRB.LAST_UPDATED_BY
, ACRB.LAST_UPDATE_DATE
, ACRB.LAST_UPDATE_LOGIN
, ACRB.OBJECT_VERSION_NUMBER
, ACRB.OBJECT_TYPE
, ACRB.OBJECT_ID
, ACRB.SENDER
, ACRB.REPLY_TO
, ACRB.COVER_LETTER_ID
, ACRB.TABLE_OF_CONTENT_FLAG
, ACRB.TRIGGER_CODE
, ACRB.ENABLED_FLAG
, ACRB.DEFAULT_FLAG
, ACRT.EMAIL_SUBJECT
, ACRB.SENDER_DISPLAY_NAME
, ACRB.DELIVERY_MODE
FROM AMS_CONTENT_RULES_B ACRB
, AMS_CONTENT_RULES_TL ACRT
WHERE ACRB.CONTENT_RULE_ID = ACRT.CONTENT_RULE_ID
AND ACRT.LANGUAGE= USERENV('LANG')