Here you go

Wednesday, March 23, 2016

Query to find all EBS Personalizations

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.