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


TABLE: EGO.EGO_PRODUCT_CAT_SET_EXT

Object Details
Object Name: EGO_PRODUCT_CAT_SET_EXT
Object Type: TABLE
Owner: EGO
FND Design Data: TableEGO.EGO_PRODUCT_CAT_SET_EXT
Subobject Name:
Status: VALID


This table is used to store sales and marketing attribute group values for product catalog


Storage Details
Tablespace: Tablespace
PCT Free:
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
EGO_PRODUCT_CAT_SET_EXT_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnEXTENSION_ID
EGO_PRODUCT_CAT_SET_EXT_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCATEGORY_SET_ID
ColumnCATEGORY_ID
Columns
Name Datatype Length Mandatory Comments
EXTENSION_ID NUMBER (15) Yes Unique numeric identifier for the sales and marketing attribute group
CATEGORY_SET_ID NUMBER (15) Yes This is one of the primary keys for category; foreign key to MTL_CATEGORY_SETS_B
CATEGORY_ID NUMBER (15)
This is one of the primary keys for category; foreign key to MTL_CATEGORIES_B
ATTR_GROUP_ID NUMBER (15) Yes Attribute Group of the row; foreign key to EGO_FND_DSC_FLX_CTX_EXT
CREATED_BY NUMBER (15) Yes One of the five standard "WHO" columns
CREATION_DATE DATE
Yes One of the five standard "WHO" columns
LAST_UPDATED_BY NUMBER (15) Yes One of the five standard "WHO" columns
LAST_UPDATE_DATE DATE
Yes One of the five standard "WHO" columns
LAST_UPDATE_LOGIN NUMBER (15)
One of the five standard "WHO" columns
INCLUDE_IN_FORECAST VARCHAR2 (1)
Specifies if this category should be included in forecast
EXPECTED_PURCHASE VARCHAR2 (1)
Specifies if there is a purchase interest for this category
EXCLUDE_USER_VIEW VARCHAR2 (1)
Used to know if a node needs to be skipped
VALUE_ID NUMBER (15)
This column stores the corresponding value-id in the value-set
TOP_NODE NUMBER (15)
This column stores the category whose children and grand-children are to be propagated
FLEX_VALUE_SET_ID NUMBER (15)
This column stores the value set ID for the top node
Query Text

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


SELECT EXTENSION_ID
,      CATEGORY_SET_ID
,      CATEGORY_ID
,      ATTR_GROUP_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      INCLUDE_IN_FORECAST
,      EXPECTED_PURCHASE
,      EXCLUDE_USER_VIEW
,      VALUE_ID
,      TOP_NODE
,      FLEX_VALUE_SET_ID
FROM EGO.EGO_PRODUCT_CAT_SET_EXT;

Dependencies

[top of page]

EGO.EGO_PRODUCT_CAT_SET_EXT does not reference any database object

EGO.EGO_PRODUCT_CAT_SET_EXT is referenced by following:

SchemaAPPS
SynonymEGO_PRODUCT_CAT_SET_EXT