Showing posts with label Form Personalization. Show all posts
Showing posts with label Form Personalization. Show all posts

Thursday, 10 September 2015

Query to Get Oracle Application's Form Personalization Details

SELECT DISTINCT FCR.ID,
                FCR.FORM_NAME,
                FCR.ENABLED,
                FFT.USER_FORM_NAME,
                FAT.APPLICATION_NAME,
                FCR.DESCRIPTION,
                FCA.ACTION_TYPE,
                FCA.ENABLED,
                FCA.OBJECT_TYPE,
                FCA.MESSAGE_TYPE,
                FCA.MESSAGE_TEXT
  FROM FND_FORM_CUSTOM_RULES FCR,
       FND_FORM FF,
       FND_FORM_TL FFT,
       FND_APPLICATION_TL FAT,
       FND_FORM_CUSTOM_ACTIONS FCA
 WHERE   FCR.FORM_NAME = FF.FORM_NAME
       AND FF.FORM_ID = FFT.FORM_ID
       AND FF.APPLICATION_ID = FAT.APPLICATION_ID
       AND FCR.ENABLED = 'Y'
       AND FCR.ID = FCA.RULE_ID
       AND FAT.APPLICATION_ID = 222                          --For Receivables
       --AND FFT.USER_FORM_NAME LIKE 'Receipts%'  --All the Forms that Start with Receipts