eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.RG_SRS_DSS_TEMPLATE_V

Source

View Text - Preformatted


SELECT meaning template_name, -100 template_id, -1 ledger_id from gl_lookups WHERE lookup_type='LITERAL' and lookup_code='N/A' union select meaning template_name, -1 template_id, -1 ledger_id from gl_lookups where lookup_type='LITERAL' and lookup_code='ALL' union select st.template_name, st.template_id, st.ledger_id from gl_summary_templates st

View Text - HTML Formatted

SELECT MEANING TEMPLATE_NAME
, -100 TEMPLATE_ID
, -1 LEDGER_ID
FROM GL_LOOKUPS
WHERE LOOKUP_TYPE='LITERAL'
AND LOOKUP_CODE='N/A' UNION SELECT MEANING TEMPLATE_NAME
, -1 TEMPLATE_ID
, -1 LEDGER_ID
FROM GL_LOOKUPS
WHERE LOOKUP_TYPE='LITERAL'
AND LOOKUP_CODE='ALL' UNION SELECT ST.TEMPLATE_NAME
, ST.TEMPLATE_ID
, ST.LEDGER_ID
FROM GL_SUMMARY_TEMPLATES ST