Instance Migration Scripts - XML Publisher reports

-- 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.application_short_name = b.application_short_name