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

TABLE: PSB.PSB_SUMMARY_TEMPLATES

Object Details
Object Name: PSB_SUMMARY_TEMPLATES
Object Type: TABLE
Owner: PSB
FND Design Data: TablePSB.PSB_SUMMARY_TEMPLATES
Subobject Name:
Status: VALID


PSB_SUMMARY_TEMPLATES stores the list of summary templates for which
summary budget totals are maintained in Public Sector Budgeting.
Summary templates definitions are defined and maintained in
Oracle Public Sector General Ledger.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
PSB_SUMMARY_TEMPLATES_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnSET_OF_BOOKS_ID
ColumnTEMPLATE_ID
Columns
Name Datatype Length Mandatory Comments
TEMPLATE_ID NUMBER (15) Yes General Ledger summary template unique identifier
TEMPLATE_NAME VARCHAR2 (100)
General Ledger summary template name
EFFECTIVE_START_DATE DATE
Yes When defining a subset of the General Ledger summary templates for rollups in Public Sector Budgeting, translate the START_PERIOD_NAME in GL_SUMMARY_TEMPLATES by mapping into one of the Public Sector Budgeting periods base
SET_OF_BOOKS_ID NUMBER (15) Yes General Ledger Set of Books identifier for the summary template
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER (15) Yes Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
CREATED_BY NUMBER (15) Yes Standard Who column
CREATION_DATE DATE
Yes Standard Who column
Query Text

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


SELECT TEMPLATE_ID
,      TEMPLATE_NAME
,      EFFECTIVE_START_DATE
,      SET_OF_BOOKS_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
FROM PSB.PSB_SUMMARY_TEMPLATES;

Dependencies

[top of page]

PSB.PSB_SUMMARY_TEMPLATES does not reference any database object

PSB.PSB_SUMMARY_TEMPLATES is referenced by following:

SchemaAPPS
SynonymPSB_SUMMARY_TEMPLATES