EBS Personalizations
SELECT
FA.APPLICATION_NAME,
FOM.FORM_NAME,
FOM_TL.USER_FORM_NAME,
PER.FUNCTION_NAME,
PER.SEQUENCE,
PER.DESCRIPTION,
PER.TRIGGER_EVENT,
PER.TRIGGER_OBJECT,
PER.CONDITION,
PER.ENABLED PERSONALIZATION_ENABLED,
PER_CA.SEQUENCE ACTION_SEQ,
PROPERTY_VALUE,
PER_CA.TARGET_OBJECT,
PER_CA.ENABLED ACTION_ENABLED,
PER_CA.ACTION_TYPE,
OBJECT_TYPE ACTION_OBJECT_TYPE,
MESSAGE_TYPE,
MESSAGE_TEXT
FROM
FND_FORM_CUSTOM_RULES PER,
FND_FORM FOM,
FND_FORM_TL FOM_TL,
FND_APPLICATION_VL FA,
FND_FORM_CUSTOM_ACTIONS PER_CA
WHERE
FOM.FORM_NAME = PER.FORM_NAME
AND FOM.FORM_ID = FOM_TL.FORM_ID
AND FA.APPLICATION_ID = FOM_TL.APPLICATION_ID
AND PER.ID = PER_CA.RULE_ID
ORDER BY 1,2,3,4,5
No comments:
Post a Comment
Thanks for making a comment.