View: RG_SRS_DSS_TEMPLATE_V

Product:	RG - Application Report Generator
Description:	10SC ONLY
Implementation/DBA Data:	APPS.RG_SRS_DSS_TEMPLATE_V

View Text

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

Columns