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.

[Home] [Help]

View: GL_SUMMARY_TEMPLATES_NAMES_V

Product:	GL - General Ledger
Description:	10SC ONLY
Implementation/DBA Data:	APPS.GL_SUMMARY_TEMPLATES_NAMES_V

View Text

SELECT ST.TEMPLATE_NAME TEMPLATE_NAME
, ST.TEMPLATE_ID TEMPLATE_ID
, ST.LEDGER_ID LEDGER_ID
, ST.STATUS STATUS
, ST.CONCATENATED_DESCRIPTION CONCATENATED_DESCRIPTION
, ST.ACCOUNT_CATEGORY_CODE ACCOUNT_CATEGORY_CODE
, ST.MAX_CODE_COMBINATION_ID MAX_CODE_COMBINATION_ID
, ST.START_ACTUALS_PERIOD_NAME START_ACTUALS_PERIOD_NAME
FROM GL_SUMMARY_TEMPLATES ST

Columns

Name
TEMPLATE_NAME
TEMPLATE_ID
LEDGER_ID
STATUS
CONCATENATED_DESCRIPTION
ACCOUNT_CATEGORY_CODE
MAX_CODE_COMBINATION_ID
START_ACTUALS_PERIOD_NAME