[Script]Oracle EBS中,如何通过Form,Report的执行文件来查找对应的功能名称,或者如何反向查找

知道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\');
Output:INVTTMTX : Perform miscellaneous transactions

知道功能名称的情况下,如何来查找对应的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%\');
Output:INVTOTRX

同样,如果我们知道了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\');
Output:INVARPAR : Physical inventory adjustments report

类似,知道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%\');
Output:INVISMMX : Min-max planning report
这里INVISMMX.rdf就为对应的Report执行文件的名称


转载请注明出处:http://blog.csdn.net/pan_tian/article/details/7701995

======EOF======

请使用浏览器的分享功能分享到微信等