个性化查询脚本

Select
       Ffcr.Function_Name,
       Ffcr.Description,
       Ffcr.Trigger_Event,
       Ffcr.Trigger_Object,
       Ffcr.Condition,
       Ffcr.Enabled,
       Ffca.Sequence,
       Decode(Ffca.Action_Type,
              'P',
              '特性',
              'M',
              '消息',
              'B',
              '内置',
              '菜单') 活动类型,
       Ffca.Summary,
       Ffca.Enabled,
       (Case
         When Ffca.Action_Type = 'P' And Ffca.Object_Type = 'ITEM' Then
          '项目'
         When Ffca.Action_Type = 'P' And Ffca.Object_Type = 'WINDOW' Then
          '窗口'
         When Ffca.Action_Type = 'P' And Ffca.Object_Type = 'BLOCK' Then
          '块'
         When Ffca.Action_Type = 'P' And Ffca.Object_Type = 'TAB' Then
          '标签页'
         When Ffca.Action_Type = 'P' And Ffca.Object_Type = 'CANVAS' Then
          '画布'
         When Ffca.Action_Type = 'P' And Ffca.Object_Type = 'RADIO BUTTON' Then
          '单选按钮'
         When Ffca.Action_Type = 'P' And Ffca.Object_Type = 'VIEW' Then
          '视图'
         When Ffca.Action_Type = 'P' And Ffca.Object_Type = 'GLOBAL' Then
          '全局'
         When Ffca.Action_Type = 'P' And Ffca.Object_Type = 'LOV' Then
          '值列表'
         When Ffca.Action_Type <> 'P' Then
          Null
         Else
          '其他'
       End) 对象类型,
       (Case
         When Ffca.Action_Type <> 'P' Then
          Null
         Else
          Ffca.Target_Object
       End) 目标对象,
       (Case
         When Ffca.Action_Type <> 'P' Then
          Null
         When Ffca.Property_Name = '1550' Then
          'PROMPT_TEXT'
         When Ffca.Property_Name = '16' Then
          'DISPLAYED'
         When Ffca.Property_Name = '79' Then
          'ENABLED'
         When Ffca.Property_Name = '19' Then
          'ENTERABLED'
         When Ffca.Property_Name = '27' Then
          'QUERYABLE'
         When Ffca.Property_Name = '28' Then
          'REQUIRED'
         When Ffca.Property_Name = '183' Then
          'UPDATE_ALLOWED'
         When Ffca.Property_Name = '143' Then
          'GROUP_NAME'
         When Ffca.Property_Name = '0' Then
          'VALUE'
         When Ffca.Property_Name = '184' Then
          'INSERT_ALLOWED'
         Else
          To_Char(Ffca.Property_Name)
       End) 特性名称,
       (Case
         When Ffca.Action_Type <> 'P' Then
          Null
         When Ffca.Property_Value = '5' Then
          'FALSE'
         When Ffca.Property_Value = '4' Then
          'TRUE'
         Else
          Property_Value
       End) 值,
       (Case
         When Ffca.Action_Type <> 'M' Then
          Null
         When Ffca.Message_Type = 'H' Then
          '提示'
         When Ffca.Message_Type = 'S' Then
          '显示'
         When Ffca.Message_Type = 'W' Then
          '警告'
         When Ffca.Message_Type = 'D' Then
          '调试'
         When Ffca.Message_Type = 'E' Then
          '错误'
         Else
          Ffca.Message_Type
       End) 消息类型,
       (Case
         When Ffca.Action_Type <> 'M' Then
          Null
         Else
          Ffca.Message_Text
       End) 消息文本,
       (Case
         When Ffca.Action_Type <> 'B' Then
          Null
         When Ffca.Builtin_Type = 'Q' Then
          '根据查询创建记录组'
         When Ffca.Builtin_Type = 'C' Then
          '启用SRS表单'
         When Ffca.Builtin_Type = 'E' Then
          '启用功能'
         When Ffca.Builtin_Type = 'G' Then
          'GO_ITEM'
         Else
          Ffca.Builtin_Type
       End) 内置类型,
       (Case
         When Ffca.Action_Type <> 'B' Then
          Null
         Else
          Ffca.Builtin_Arguments
       End) 变元,
       Ffca.Menu_Argument_Short,
       Ffcr.Fire_In_Enter_Query,
       Ffcr.Rule_Key,
       Ffcr.Form_Name,
       Decode(Ffcr.Rule_Type, 'P', '菜单', 'A', '功能') 层,
       Ffca.Argument_Type,
       Ffca.Folder_Prompt_Block,
       Ffca.Menu_Entry,
       Ffca.Menu_Label,
       Ffca.Menu_Seperator,
       Ffca.Menu_Enabled_In,
       Ffca.Menu_Action,
       Ffca.Menu_Argument_Long,
       Ffca.Creation_Date 创建日期,
       Ffca.Last_Update_Date 更新日期,
       ffca.last_updated_by
  From Fnd_Form_Custom_Rules Ffcr, Fnd_Form_Custom_Actions Ffca
 Where Ffcr.Id = Ffca.Rule_Id
 Order By Ffcr.Function_Name, Ffcr.Form_Name, Ffcr.Sequence, Ffca.Sequence