Here you go

Showing posts with label Oracle Personalizations. Show all posts
Showing posts with label Oracle Personalizations. Show all posts

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