知道Form执行文件的名字情况下,如何来查找对应的功能名称
- SELECT a.form_name||' : '||nvl(b.description, b.user_form_name)
- FROM APPS.FND_FORM a, APPS.FND_FORM_TL b
- WHERE a.form_id = b.form_id
- AND a.form_name IN ('INVTTMTX');
知道功能名称的情况下,如何来查找对应的fmx名称
- SELECT a.form_name,b.description
- FROM APPS.FND_FORM a, APPS.FND_FORM_TL b
- WHERE a.form_id = b.form_id
- AND Upper(b.description) like upper('%Transact Move Orders%');
- --或者
- SELECT a.form_name,b.user_form_name
- FROM APPS.FND_FORM a, APPS.FND_FORM_TL b
- WHERE a.form_id = b.form_id
- AND Upper(b.user_form_name) like upper('%Transact Move Orders%');
同样,如果我们知道了Report执行文件的名字情况下,如何来查找对应Report的功能名称
- SELECT b.executable_name||' : '||c.description
- FROM APPS.FND_CONCURRENT_PROGRAMS a, APPS.FND_EXECUTABLES b, APPS.FND_CONCURRENT_PROGRAMS_TL c
- WHERE a.executable_id = b.executable_id
- AND a.concurrent_program_id = c.concurrent_program_id
- AND b.execution_file_name IN ('INVARPAR');
类似,知道Report功能的情况下,如何来查找对应report执行文件的名称
- SELECT b.executable_name||' : '||c.description
- FROM APPS.FND_CONCURRENT_PROGRAMS a, APPS.FND_EXECUTABLES b, APPS.FND_CONCURRENT_PROGRAMS_TL c
- WHERE a.executable_id = b.executable_id
- AND a.concurrent_program_id = c.concurrent_program_id
- AND Upper(c.description) LIKE Upper('%Min%Max%Plan%');
这里INVISMMX.rdf就为对应的Report执行文件的名称