Oracle EBS-SQL (SYS-7):表单个性化查询.sql
SELECT * FROM FND_FORM_CUSTOM_RULES;SELECT * FROM FND_FORM_CUSTOM_ACTIONS;
SELECT * FROM FND_FORM_CUSTOM_PARAMS;
SELECT * FROM FND_FORM_CUSTOM_SCOPES;
select ffcr.id ID号,
FFCR.FUNCTION_NAME 功能代码,
fffv.USER_FUNCTION_NAME 功能名称,
ffcr.sequence 序号,
ffcr.description 功能描述,
ffcr.trigger_event 触发器事件,
ffcr.trigger_object 触发器对像,
ffcr.condition 条件,
ffcr.fire_in_enter_query 处理模式,
ffca.sequence 活动序号,
decode(ffca.action_type, 'M','消息','P','特性','B','内置','菜单'),
ffca.summary 活动说明,
ffca.language 语言,
ffca.enabled 启用,
decode(ffca.builtin_type,'C','启动SRS表单','E',‘启动功能','OTHER') 内置类型,
ffca.*,
ffcs.* from FND_FORM_CUSTOM_RULES ffcr,
FND_FORM_CUSTOM_ACTIONS ffca,
FND_FORM_CUSTOM_SCOPESffcs,
FND_FORM_FUNCTIONS_VL fffv
where ffcr.id = ffca.rule_id
and ffcr.id = ffcs.rule_id(+)
and ffcr.function_name = fffv.FUNCTION_NAME
页:
[1]