![Forms Personalization Tables, www.askhareesh.com](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgGB4CLVHSrF_udrMJM3DxZ_9u3ugTLfA-p77-CenO6XxtkCTICBBw4EgmqcmRUx9fvQ_DoRe18diGA6wShSPP7kyBn1KQP-uG4NW-oj4fiMG42zeVt6t0JopORvPbrtl617OXQxaDCwZY/s200/AskHareesh.png)
FND_FORM_CUSTOM_RULES
FND_FORM_CUSTOM_SCOPES
FND_FORM_CUSTOM_ACTIONS
FND_FORM_CUSTOM_PARAMS
FND_FORM_CUSTOM_PROP_VALUES
FND_FORM_CUSTOM_PROP_LIST
Query to get list all the forms in Oracle Applications that have been customized using Forms Personlization:
SELECT DISTINCT A.FORM_NAME, A.ENABLED, C.USER_FORM_NAME, D.APPLICATION_NAME 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;
No comments:
Post a Comment