CHECK TEMPLATE NAME

CHECK TEMPLATE NAME

SQL> select distinct t.USER_CONCURRENT_PROGRAM_NAME,tt.TEMPLATE_NAME ,
fa.APPLICATION_NAME
from apps.fnd_concurrent_programs_tl t,
apps.fnd_concurrent_programs b,
apps.XDO_TEMPLATES_TL tt,
apps.fnd_application_tl fa
WHERE b.application_id = t.application_id
AND b.concurrent_program_id = t.concurrent_program_id
AND t.LANGUAGE = USERENV ('LANG')
and b.EXECUTION_METHOD_CODE='P'
and t.USER_CONCURRENT_PROGRAM_NAME like 'KK%'
and b.OUTPUT_FILE_TYPE='XML'
and b.application_id=fa.application_id
and fa.LANGUAGE='US'
and b.ENABLED_FLAG='Y'
and fa.application_id<>800
and tt.template_code=b.CONCURRENT_PROGRAM_NAME

---------------------------