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

TABLE: IBE.IBE_DSP_TPL_CTG

Object Details
Object Name: IBE_DSP_TPL_CTG
Object Type: TABLE
Owner: IBE
FND Design Data: TableIBE.IBE_DSP_TPL_CTG
Subobject Name:
Status: VALID


IBE_DSP_TPL_CTG stores the relationships between categories and logical templates.The logical templates assigned to the categories need be applicable to 'CATEGORY' with type 'TEMPLATE'. For any category, only its assigned logical templates can be associated to a display style, defined in IBE_DSP_CONTEXT_B.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
IBE_DSP_TPL_CTG_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnITEM_ID
IBE_DSP_TPL_CTG_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCATEGORY_ID
Columns
Name Datatype Length Mandatory Comments
TPL_CTG_ID NUMBER (15) Yes Template Category Identifier.
CREATED_BY NUMBER (15) Yes Standard WHO column
CREATION_DATE DATE
Yes Standard WHO column
LAST_UPDATED_BY NUMBER (15) Yes Standard WHO column
LAST_UPDATE_DATE DATE
Yes Standard WHO column
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO column
SECURITY_GROUP_ID NUMBER

Security Group Identifier.
OBJECT_VERSION_NUMBER NUMBER (9) Yes Object Version Number for Locking.
CATEGORY_ID NUMBER
Yes Category Identifier.
ITEM_ID NUMBER
Yes Template (Or Item ) Identifier.
Query Text

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


SELECT TPL_CTG_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      SECURITY_GROUP_ID
,      OBJECT_VERSION_NUMBER
,      CATEGORY_ID
,      ITEM_ID
FROM IBE.IBE_DSP_TPL_CTG;

Dependencies

[top of page]

IBE.IBE_DSP_TPL_CTG does not reference any database object

IBE.IBE_DSP_TPL_CTG is referenced by following:

SchemaAPPS
SynonymIBE_DSP_TPL_CTG