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
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