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_V

Product:	GL - General Ledger
Description:
Implementation/DBA Data:	APPS.GL_SUMMARY_TEMPLATES_V

View Text

SELECT ST.ROWID ROW_ID
, ST.TEMPLATE_NAME TEMPLATE_NAME
, LGR.NAME LEDGER_NAME
, ST.START_ACTUALS_PERIOD_NAME START_ACTUALS_PERIOD_NAME
, ST.DESCRIPTION DESCRIPTION
, ST.ACCOUNT_CATEGORY_CODE ACCOUNT_CATEGORY_CODE
, ST.TEMPLATE_ID TEMPLATE_ID
, ST.LEDGER_ID LEDGER_ID
, ST.STATUS STATUS
, ST.LAST_UPDATE_DATE LAST_UPDATE_DATE
, ST.LAST_UPDATED_BY LAST_UPDATED_BY
, ST.CONCATENATED_DESCRIPTION CONCATENATED_DESCRIPTION
, ST.MAX_CODE_COMBINATION_ID MAX_CODE_COMBINATION_ID
, ST.CREATED_BY CREATED_BY
, ST.CREATION_DATE CREATION_DATE
, ST.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, ST.SEGMENT1_TYPE SEGMENT1_TYPE
, ST.SEGMENT2_TYPE SEGMENT2_TYPE
, ST.SEGMENT3_TYPE SEGMENT3_TYPE
, ST.SEGMENT4_TYPE SEGMENT4_TYPE
, ST.SEGMENT5_TYPE SEGMENT5_TYPE
, ST.SEGMENT6_TYPE SEGMENT6_TYPE
, ST.SEGMENT7_TYPE SEGMENT7_TYPE
, ST.SEGMENT8_TYPE SEGMENT8_TYPE
, ST.SEGMENT9_TYPE SEGMENT9_TYPE
, ST.SEGMENT10_TYPE SEGMENT10_TYPE
, ST.SEGMENT11_TYPE SEGMENT11_TYPE
, ST.SEGMENT12_TYPE SEGMENT12_TYPE
, ST.SEGMENT13_TYPE SEGMENT13_TYPE
, ST.SEGMENT14_TYPE SEGMENT14_TYPE
, ST.SEGMENT15_TYPE SEGMENT15_TYPE
, ST.SEGMENT16_TYPE SEGMENT16_TYPE
, ST.SEGMENT17_TYPE SEGMENT17_TYPE
, ST.SEGMENT18_TYPE SEGMENT18_TYPE
, ST.SEGMENT19_TYPE SEGMENT19_TYPE
, ST.SEGMENT20_TYPE SEGMENT20_TYPE
, ST.SEGMENT21_TYPE SEGMENT21_TYPE
, ST.SEGMENT22_TYPE SEGMENT22_TYPE
, ST.SEGMENT23_TYPE SEGMENT23_TYPE
, ST.SEGMENT24_TYPE SEGMENT24_TYPE
, ST.SEGMENT25_TYPE SEGMENT25_TYPE
, ST.SEGMENT26_TYPE SEGMENT26_TYPE
, ST.SEGMENT27_TYPE SEGMENT27_TYPE
, ST.SEGMENT28_TYPE SEGMENT28_TYPE
, ST.SEGMENT29_TYPE SEGMENT29_TYPE
, ST.SEGMENT30_TYPE SEGMENT30_TYPE
, ST.ATTRIBUTE1 ATTRIBUTE1
, ST.ATTRIBUTE2 ATTRIBUTE2
, ST.ATTRIBUTE3 ATTRIBUTE3
, ST.ATTRIBUTE4 ATTRIBUTE4
, ST.ATTRIBUTE5 ATTRIBUTE5
, ST.ATTRIBUTE6 ATTRIBUTE6
, ST.ATTRIBUTE7 ATTRIBUTE7
, ST.ATTRIBUTE8 ATTRIBUTE8
, ST.CONTEXT CONTEXT
FROM GL_SUMMARY_TEMPLATES ST
, GL_LEDGERS LGR
WHERE ST.LEDGER_ID = LGR.LEDGER_ID

Columns

Name
ROW_ID
TEMPLATE_NAME
LEDGER_NAME
START_ACTUALS_PERIOD_NAME
DESCRIPTION
ACCOUNT_CATEGORY_CODE
TEMPLATE_ID
LEDGER_ID
STATUS
LAST_UPDATE_DATE
LAST_UPDATED_BY
CONCATENATED_DESCRIPTION
MAX_CODE_COMBINATION_ID
CREATED_BY
CREATION_DATE
LAST_UPDATE_LOGIN
SEGMENT1_TYPE
SEGMENT2_TYPE
SEGMENT3_TYPE
SEGMENT4_TYPE
SEGMENT5_TYPE
SEGMENT6_TYPE
SEGMENT7_TYPE
SEGMENT8_TYPE
SEGMENT9_TYPE
SEGMENT10_TYPE
SEGMENT11_TYPE
SEGMENT12_TYPE
SEGMENT13_TYPE
SEGMENT14_TYPE
SEGMENT15_TYPE
SEGMENT16_TYPE
SEGMENT17_TYPE
SEGMENT18_TYPE
SEGMENT19_TYPE
SEGMENT20_TYPE
SEGMENT21_TYPE
SEGMENT22_TYPE
SEGMENT23_TYPE
SEGMENT24_TYPE
SEGMENT25_TYPE
SEGMENT26_TYPE
SEGMENT27_TYPE
SEGMENT28_TYPE
SEGMENT29_TYPE
SEGMENT30_TYPE
ATTRIBUTE1
ATTRIBUTE2
ATTRIBUTE3
ATTRIBUTE4
ATTRIBUTE5
ATTRIBUTE6
ATTRIBUTE7
ATTRIBUTE8
CONTEXT