SQL to inspect form personalization

最新推荐文章于 2024-03-28 11:40:37 发布

最新推荐文章于 2024-03-28 11:40:37 发布 · 93 阅读

本文提供了两个SQL查询示例，用于检索与特定功能名称和个人化描述相关的定制规则及操作。这些查询有助于理解如何针对特定需求调整系统行为。

SQL to inspect form personalization:

SELECT * FROM fnd_form_custom_rules WHERE function_name LIKE '%OEXOEORD%' AND description LIKE '%Order Confirmation'; SELECT * FROM fnd_form_custom_actions WHERE rule_id IN (SELECT id FROM fnd_form_custom_rules WHERE function_name LIKE '%OEXOEORD%' AND description LIKE '%Order Confirmation');