Query - Get Form Personalization Details from Database

SELECT 
DISTINCT
fcr.form_name , 
fft.user_form_name, 
fcr.enabled, 
app.application_name ,
fcr.description,
ca.action_type,
ca.enabled,
ca.object_type
FROM 
     FND_FORM_CUSTOM_RULES fcr,
     FND_FORM ff,
     FND_FORM_TL fft,
     FND_APPLICATION_TL app,
     FND_FORM_CUSTOM_ACTIONS caWHERE 
fcr.form_name = ff.form_name
AND fcr.enabled ='Y'
AND ff.form_Id = fft.form_Id
AND ff.application_Id = app.application_Id
AND app.application_Id = 660 --For Order Management
AND fcr.id = ca.rule_id
AND fcr.form_name LIKE  '%form_name%' -- LIKE  'OEXOEORD' for Sales Order Form

Posted in: Oracle Apps Query,Oracle Notebook