[Home] [Help] [Dependency Information]
Object Name: | JTF_DSP_TPL_CTG |
---|---|
Object Type: | TABLE |
Owner: | JTF |
FND Design Data: | JTF.JTF_DSP_TPL_CTG |
Subobject Name: | |
Status: | VALID |
JTF_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 JTF_DSP_CONTEXT_B.
Tablespace: | APPS_TS_ARCHIVE |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
JTF_DSP_TPL_CTG_N1 | NORMAL | NONUNIQUE | APPS_TS_ARCHIVE | ITEM_ID |
JTF_DSP_TPL_CTG_N2 | NORMAL | NONUNIQUE | APPS_TS_ARCHIVE | CATEGORY_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TPL_CTG_ID | NUMBER | (15) | Yes | Template Category Identifier. |
CREATED_BY | NUMBER | (15) | Yes | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
CREATION_DATE | DATE | Yes | Standard who column - date when this row was created. | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column - date when a user last updated this row. | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | |
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. | |
SECURITY_GROUP | NUMBER | |||
SECURITY_GROUP_ID | NUMBER | Security Group Identifier. |
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
, OBJECT_VERSION_NUMBER
, CATEGORY_ID
, ITEM_ID
, SECURITY_GROUP
, SECURITY_GROUP_ID
FROM JTF.JTF_DSP_TPL_CTG;
JTF.JTF_DSP_TPL_CTG does not reference any database object
JTF.JTF_DSP_TPL_CTG is referenced by following:
|
|
|