SELECT   ffcr.SEQUENCE Seq, ffcr.description Description,
        
DECODE (ffcr.rule_type,
                
'F', 'Form',
                
'A', 'Function',
                
'Other'
               
) Levels,
        
ffcr.enabled
Enabled, ffcr.trigger_event Trigger_Event,
        
ffcr.trigger_object
Trigger_Object, ffcr.condition Condition,
        
DECODE (ffcr.fire_in_enter_query,
                
'Y', 'Both',
                
'N', 'Not in Enter-Query Mode',
                
'O', 'Only in Enter-Query Mode',
                
'Other'
               
) Processing_Mode
   
FROM apps.fnd_form_custom_rules ffcr
  
WHERE ffcr.function_name = function name
    
AND ffcr.form_name = 'form name'
ORDER BY ffcr.SEQUENCE;
 
No comments:
Post a Comment