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