Oracle-EBS/Personalization .sql at master · MikhailVAS/Oracle-EBS · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
  SELECT DISTINCT a.form_name,
                  a.enabled,
                  c.USER_FORM_NAME,
                  d.APPLICATION_NAME
    FROM FND_FORM_CUSTOM_RULES a,
         FND_FORM             b,
         FND_FORM_TL          c,
         fnd_application_tl   d
   WHERE     enabled = 'Y'
         AND a.form_name = b.form_name
         AND b.form_id = c.form_id
         AND b.application_id = d.application_id
ORDER BY application_name;

/* Oracle Apps: Forms Personalization Tables
Below is the list of tables that are populated when any Forms Personalization is done */
FND_FORM_CUSTOM_RULES
FND_FORM_CUSTOM_SCOPES
FND_FORM_CUSTOM_ACTIONS
FND_FORM_CUSTOM_PARAMS
FND_FORM_CUSTOM_PROP_VALUES
FND_FORM_CUSTOM_PROP_LIST

 SELECT DISTINCT A.Id,
                  A.Form_Name,
                  A.Enabled,
                  C.User_Form_Name,
                  D.Application_Name,
                  a.sequence,
                  A.Description,
                  a.trigger_event,
                  a.trigger_object,
                  a.condition,
                  Ca.Action_Type,
                  ca.summary Action_description,
                  Ca.Enabled,
                  Ca.Object_Type,
                  ca.TARGET_OBJECT,
                  ca.property_value,
                  ca.MESSAGE_TYPE,
                  ca.MESSAGE_TEXT
    FROM FND_FORM_CUSTOM_RULES a,
         FND_FORM b,
         FND_FORM_TL c,
         Fnd_Application_Tl D,
         Fnd_Form_Custom_Actions ca
   WHERE     a.form_name = b.form_name
         AND B.Form_Id = C.Form_Id
         AND B.Application_Id = D.Application_Id
         --       AND D.Application_Id = 660                       --For Order Management
         --       AND C.User_Form_Name LIKE 'Sales%' --All the Forms that Start with Sales
         AND A.Enabled = 'Y'
         AND a.id = ca.rule_id
         AND (   CA.TARGET_OBJECT LIKE '%REQUEST_DATE%'
              OR CA.property_value LIKE '%REQUEST_DATE%'
              OR UPPER (A.Description) LIKE '%REQUEST_DATE%'
              OR UPPER (ca.summary) LIKE '%REQUEST_DATE%')
ORDER BY A.description


  SELECT ROWID,
         ACTION_ID,
         ARGUMENT_TYPE,
         RULE_ID,
         CREATED_BY,
         FOLDER_PROMPT_BLOCK,
         CREATION_DATE,
         LAST_UPDATED_BY,
         LAST_UPDATE_DATE,
         LAST_UPDATE_LOGIN,
         SEQUENCE,
         ACTION_TYPE,
         SUMMARY,
         LANGUAGE,
         ENABLED,
         OBJECT_TYPE,
         TARGET_OBJECT,
         PROPERTY_NAME,
         PROPERTY_VALUE,
         MESSAGE_TYPE,
         MESSAGE_TEXT,
         MENU_ENTRY,
         MENU_LABEL,
         MENU_SEPERATOR,
         MENU_ENABLED_IN,
         BUILTIN_TYPE,
         BUILTIN_ARGUMENTS,
         MENU_ARGUMENT_SHORT,
         MENU_ARGUMENT_LONG
    FROM FND_FORM_CUSTOM_ACTIONS
   WHERE (RULE_ID = '3636')
ORDER BY sequence

SELECT * FROM FND_FORM_CUSTOM_ACTIONS
WHERE BUILTIN_ARGUMENTS IS NOT NULL
AND BUILTIN_TYPE = 'P'
AND ENABLED = 'N'
ORDER BY    to_date(CREATION_DATE,'dd.mm.yyyy')  DESC