oracle 模板数据,请问EBS Oracle XML Pulisher管理员中与模板和数据定义相关的数据存在哪些表中？...

贡献一个Query：

select fa.application_name concurrent_program_appl_name,

fcp.user_concurrent_program_name,

fcp.concurrent_program_name,

(select decode(fe.execution_method_code,

'K',

fl.meaning,

'P',

fl.meaning || ' : ' || '$' || fa.basepath ||

'/reports/US/' || fe.execution_file_name || '.rdf')

from fnd_application fa

where fa.application_id = fe.application_id) execution_method,

xdd.data_source_name,

xdd.data_source_code,

xl_xdd.file_name data_source_file_name,

xl_xdd.file_data data_source_file_data,

xt.template_name,

xt.template_code,

xl_xt.file_name template_file_name,

xl_xt.file_data template_file_data

from fnd_concurrent_programs_vl fcp,

fnd_application_vl         fa,

fnd_executables_vl         fe,

fnd_lookups                fl,

fnd_application            fa2,

xdo_ds_definitions_vl      xdd,

xdo.xdo_lobs               xl_xdd,

xdo_templates_vl           xt,

xdo.xdo_lobs               xl_xt

where fcp.application_id = fa.application_id

and fcp.executable_application_id = fe.application_id

and fcp.executable_id = fe.executable_id

and fe.execution_method_code = fl.lookup_code

and fl.lookup_type = 'CP_EXECUTION_METHOD_CODE'

and fcp.output_file_type = 'XML'

and fcp.application_id = fa2.application_id

and fa.application_short_name = xdd.application_short_name

and fcp.concurrent_program_name = xdd.data_source_code

and xdd.application_short_name = xl_xdd.application_short_name(+)

and xdd.data_source_code = xl_xdd.lob_code(+)

and trunc(sysdate) between trunc(nvl(xdd.start_date, sysdate)) and

trunc(nvl(xdd.end_date, sysdate))

and xl_xdd.xdo_file_type(+) = 'XML-DATA-TEMPLATE'

and xdd.application_short_name = xt.ds_app_short_name

and xdd.data_source_code = xt.data_source_code

and xt.application_short_name = xl_xt.application_short_name(+)

and xt.template_code = xl_xt.lob_code(+)

and trunc(sysdate) between trunc(nvl(xt.start_date, sysdate)) and  trunc(nvl(xt.end_date, sysdate))

and xl_xt.xdo_file_type(+) = 'RTF'

-- and fcp.concurrent_program_name = 'XLAAARPT' --Concurrent Program Name

order by fcp.user_concurrent_program_name,

xdd.data_source_name,

xt.template_name;