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

TABLE: AK.AK_CATEGORY_USAGES

Object Details
Object Name: AK_CATEGORY_USAGES
Object Type: TABLE
Owner: AK
FND Design Data: TableAK.AK_CATEGORY_USAGES
Subobject Name:
Status: VALID


Defines relationship between attachment region item and categories


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
AK_CATEGORY_USAGES_U1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnREGION_CODE
ColumnREGION_APPLICATION_ID
ColumnATTRIBUTE_CODE
ColumnATTRIBUTE_APPLICATION_ID
ColumnCATEGORY_NAME
Columns
Name Datatype Length Mandatory Comments
REGION_CODE VARCHAR2 (30) Yes region code
REGION_APPLICATION_ID NUMBER (15) Yes region application id
ATTRIBUTE_CODE VARCHAR2 (30) Yes Code of attribute
ATTRIBUTE_APPLICATION_ID NUMBER (15) Yes Product team's application ID which the attribute belong to
CATEGORY_NAME VARCHAR2 (30) Yes Name of category in FND_DOCUMENT_CATEGORIES table that's assigned to the region.
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) Yes Standard Who Column
CATEGORY_ID NUMBER (15)
Reference to category
APPLICATION_ID NUMBER (15)
Application id
SHOW_ALL VARCHAR2 (1)
Flag indicates whether all attachments of all categories will be shown for this region.
Query Text

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


SELECT REGION_CODE
,      REGION_APPLICATION_ID
,      ATTRIBUTE_CODE
,      ATTRIBUTE_APPLICATION_ID
,      CATEGORY_NAME
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      CATEGORY_ID
,      APPLICATION_ID
,      SHOW_ALL
FROM AK.AK_CATEGORY_USAGES;

Dependencies

[top of page]

AK.AK_CATEGORY_USAGES does not reference any database object

AK.AK_CATEGORY_USAGES is referenced by following:

SchemaAPPS
SynonymAK_CATEGORY_USAGES