Query to list form personalization in oracle apps

Hi friends, we are going to discuss about the Query to list form personalization in oracle apps. We will share the detail sql Query to list form personalization in oracle apps. Using this query we can able to extract Form Personalizations created in oracle application .This Form personalization query helps to extract form personalization created against which oracle forms. Using this form personalization query we can keep track of how many personalization currently working against which oracle forms. In oracle apps application, if we are using form personalization then we should have the track of which personalization working in which oracle forms so that we should have the idea of the oracle form working. Please find below the complete detail about Query to list form personalization in oracle apps.

Query to list form personalization in oracle apps

6 Important Uses in Query to list form personalization in oracle apps

1.FND_FORM_CUSTOM_RULES

2.FND_FORM_CUSTOM_PARAMS

3.FND_FORM_CUSTOM_PROP_VALUES

4.FND_FORM_CUSTOM_PROP_LIST

5.FND_FORM_CUSTOM_SCOPES

6.FND_FORM_CUSTOM_ACTIONS

Detail SQL Query to list form personalization in oracle apps

Here below is the detail sql query which will help to list form personalization in oracle apps

SELECT DISTINCT A.FORM_NAME,

A.FUNCTION_NAME,

A.ENABLED,

C.USER_FORM_NAME,

D.APPLICATION_NAME,

A.SEQUENCE,

A.TRIGGER_EVENT,

A.DESCRIPTION personalization_rule_name,

A.CONDITION

FROM FND_FORM_CUSTOM_RULES A,

FND_FORM B,

FND_FORM_TL C,

FND_APPLICATION_TL D 

WHERE ENABLED = 'Y' 

AND A.FORM_NAME = B.FORM_NAME 

AND B.FORM_ID = C.FORM_ID 

AND B.APPLICATION_ID = D.APPLICATION_ID 

ORDER BY APPLICATION_NAME;

Query to list form personalization in oracle apps