-- Query to check XML Publisher Verification
SELECT b.*
FROM apps.xdo_lobs l, apps.xdo_templates_b b
WHERE l.application_short_name = 'QP'
AND l.lob_code IN ('XYZ123')
AND l.lob_code = b.template_code
-- Check Form Function
SELECT *
FROM apps.fnd_form_functions_vl
WHERE form_id IN (SELECT form_id
FROM apps.fnd_form_vl
WHERE form_name = 'XYZ_COPY_PARAM_SHIP_PATH')
-- Check Data Defination & Template
SELECT application_short_name,data_source_code,data_source_name
FROM apps.xdo_ds_definitions_tl
WHERE data_source_name like 'XYZ Daily Order Booking Notification'
AND LANGUAGE = USERENV ('lang');
SELECT application_short_name,template_code,template_name
FROM apps.xdo_templates_tl
WHERE template_name like 'XYZ Daily Order Booking Notification'
AND LANGUAGE = USERENV ('lang');
SELECT lob_type,application_short_name,lob_code,file_name
FROM apps.xdo_lobs
WHERE file_name in ('XYZ_DOCN_REP.rtf','XYZ_DOCN_REP.xml')