DBA Data[Home] [Help] [Dependency Information]

TABLE: GL.GL_SUMMARY_TEMPLATES

Object Details
Object Name: GL_SUMMARY_TEMPLATES
Object Type: TABLE
Owner: GL
FND Design Data: TableSQLGL.GL_SUMMARY_TEMPLATES
Subobject Name:
Status: VALID


GL_SUMMARY_TEMPLATES stores the summary account templates you define using the Summary Accounts form. Each row includes the ledger identifier, the start period name, the earliest budget name, the description, and the template contents. STATUS is usually 'F' for "Current". When you first add a template, STATUS is 'A' until the Add/Delete Summary Templates program completes and sets STATUS to 'F'. When you delete a template, STATUS is 'D' until the Add/Delete Summary Templates program completes and deletes the row.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
GL_SUMMARY_TEMPLATES_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnTEMPLATE_ID
Columns
Name Datatype Length Mandatory Comments
TEMPLATE_ID NUMBER (15) Yes Summary template defining column
LEDGER_ID NUMBER (15) Yes Ledger defining column
STATUS VARCHAR2 (1) Yes Status column used internally by summarization program
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER (15) Yes Standard Who column
TEMPLATE_NAME VARCHAR2 (50) Yes Summary template name
CONCATENATED_DESCRIPTION VARCHAR2 (240) Yes Summary template concatenated segments
ACCOUNT_CATEGORY_CODE VARCHAR2 (1) Yes Account category
FUNDS_CHECK_LEVEL_CODE VARCHAR2 (1)
No longer used in R12
MAX_CODE_COMBINATION_ID NUMBER (15) Yes Key flexfield combination defining column for maximum detail flexfield
START_ACTUALS_PERIOD_NAME VARCHAR2 (15) Yes Start period name
AMOUNT_TYPE VARCHAR2 (4)
No longer used in R12
BOUNDARY_CODE VARCHAR2 (1)
No longer used in R12
CREATED_BY NUMBER (15)
Standard Who column
CREATION_DATE DATE

Standard Who column
DR_CR_CODE VARCHAR2 (1)
No longer used in R12
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
FUNDING_BUDGET_VERSION_ID NUMBER (15)
No longer used in R12
SEGMENT1_TYPE VARCHAR2 (25)
Summary segment type column
SEGMENT2_TYPE VARCHAR2 (25)
Summary segment type column
SEGMENT3_TYPE VARCHAR2 (25)
Summary segment type column
SEGMENT4_TYPE VARCHAR2 (25)
Summary segment type column
SEGMENT5_TYPE VARCHAR2 (25)
Summary segment type column
SEGMENT6_TYPE VARCHAR2 (25)
Summary segment type column
SEGMENT7_TYPE VARCHAR2 (25)
Summary segment type column
SEGMENT8_TYPE VARCHAR2 (25)
Summary segment type column
SEGMENT9_TYPE VARCHAR2 (25)
Summary segment type column
SEGMENT10_TYPE VARCHAR2 (25)
Summary segment type column
SEGMENT11_TYPE VARCHAR2 (25)
Summary segment type column
SEGMENT12_TYPE VARCHAR2 (25)
Summary segment type column
SEGMENT13_TYPE VARCHAR2 (25)
Summary segment type column
SEGMENT14_TYPE VARCHAR2 (25)
Summary segment type column
SEGMENT15_TYPE VARCHAR2 (25)
Summary segment type column
SEGMENT16_TYPE VARCHAR2 (25)
Summary segment type column
SEGMENT17_TYPE VARCHAR2 (25)
Summary segment type column
SEGMENT18_TYPE VARCHAR2 (25)
Summary segment type column
SEGMENT19_TYPE VARCHAR2 (25)
Summary segment type column
SEGMENT20_TYPE VARCHAR2 (25)
Summary segment type column
SEGMENT21_TYPE VARCHAR2 (25)
Summary segment type column
SEGMENT22_TYPE VARCHAR2 (25)
Summary segment type column
SEGMENT23_TYPE VARCHAR2 (25)
Summary segment type column
SEGMENT24_TYPE VARCHAR2 (25)
Summary segment type column
SEGMENT25_TYPE VARCHAR2 (25)
Summary segment type column
SEGMENT26_TYPE VARCHAR2 (25)
Summary segment type column
SEGMENT27_TYPE VARCHAR2 (25)
Summary segment type column
SEGMENT28_TYPE VARCHAR2 (25)
Summary segment type column
SEGMENT29_TYPE VARCHAR2 (25)
Summary segment type column
SEGMENT30_TYPE VARCHAR2 (25)
Summary segment type column
DESCRIPTION VARCHAR2 (240)
Summary template description
ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield segment
CONTEXT VARCHAR2 (150)
Descriptive flexfield context
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT TEMPLATE_ID
,      LEDGER_ID
,      STATUS
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      TEMPLATE_NAME
,      CONCATENATED_DESCRIPTION
,      ACCOUNT_CATEGORY_CODE
,      FUNDS_CHECK_LEVEL_CODE
,      MAX_CODE_COMBINATION_ID
,      START_ACTUALS_PERIOD_NAME
,      AMOUNT_TYPE
,      BOUNDARY_CODE
,      CREATED_BY
,      CREATION_DATE
,      DR_CR_CODE
,      LAST_UPDATE_LOGIN
,      FUNDING_BUDGET_VERSION_ID
,      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
,      DESCRIPTION
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      CONTEXT
FROM GL.GL_SUMMARY_TEMPLATES;

Dependencies

[top of page]

GL.GL_SUMMARY_TEMPLATES does not reference any database object

GL.GL_SUMMARY_TEMPLATES is referenced by following:

SchemaAPPS
SynonymGL_SUMMARY_TEMPLATES