[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | EGO_CATALOG_GROUPS_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  EGO.EGO_CATALOG_GROUPS_V
|
| Subobject Name: | |
| Status: | VALID |
A Business Intelligence System view
View EGO_CATALOG_GROUPS_V provides all the metadata information for catalog categories.
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| CATALOG_GROUP_ID | NUMBER | Yes | Item catalog group identifier.Foreign key to MTL_ITEM_CATALOG_GROUPS_B | |
| CATALOG_GROUP | VARCHAR2 | (40) | catalog group name | |
| PARENT_CATALOG_GROUP_ID | NUMBER | parent catalog group id | ||
| PARENT_CATALOG_GROUP | VARCHAR2 | (40) | parent catalog group name | |
| SEGMENT1 | VARCHAR2 | (40) | Key flexfield segment | |
| SEGMENT2 | VARCHAR2 | (40) | Key flexfield segment | |
| SEGMENT3 | VARCHAR2 | (40) | Key flexfield segment | |
| SEGMENT4 | VARCHAR2 | (40) | Key flexfield segment | |
| SEGMENT5 | VARCHAR2 | (40) | Key flexfield segment | |
| SEGMENT6 | VARCHAR2 | (40) | Key flexfield segment | |
| SEGMENT7 | VARCHAR2 | (40) | Key flexfield segment | |
| SEGMENT8 | VARCHAR2 | (40) | Key flexfield segment | |
| SEGMENT9 | VARCHAR2 | (40) | Key flexfield segment | |
| SEGMENT10 | VARCHAR2 | (40) | Key flexfield segment | |
| SEGMENT11 | VARCHAR2 | (40) | Key flexfield segment | |
| SEGMENT12 | VARCHAR2 | (40) | Key flexfield segment | |
| SEGMENT13 | VARCHAR2 | (40) | Key flexfield segment | |
| SEGMENT14 | VARCHAR2 | (40) | Key flexfield segment | |
| SEGMENT15 | VARCHAR2 | (40) | Key flexfield segment | |
| SEGMENT16 | VARCHAR2 | (40) | Key flexfield segment | |
| SEGMENT17 | VARCHAR2 | (40) | Key flexfield segment | |
| SEGMENT18 | VARCHAR2 | (40) | Key flexfield segment | |
| SEGMENT19 | VARCHAR2 | (40) | Key flexfield segment | |
| SEGMENT20 | VARCHAR2 | (40) | Key flexfield segment | |
| DESCRIPTION | VARCHAR2 | (240) | catalog group description | |
| CREATION_ALLOWED | VARCHAR2 | (1) | Yes | Is creation of catalogs allowed in this catalog group |
| CREATION_ALLOWED_MEANING | VARCHAR2 | (80) | Meaning of creation allowed | |
| DEFAULT_TEMPLATE_ID | NUMBER | Template identifier | ||
| DEFAULT_TEMPLATE_NAME | VARCHAR2 | (30) | Template Name | |
| END_DATE | DATE | End Date | ||
| ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield structure defining column | |
| ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment |
Cut, paste (and edit) the following text to query this object:
SELECT CATALOG_GROUP_ID
, CATALOG_GROUP
, PARENT_CATALOG_GROUP_ID
, PARENT_CATALOG_GROUP
, SEGMENT1
, SEGMENT2
, SEGMENT3
, SEGMENT4
, SEGMENT5
, SEGMENT6
, SEGMENT7
, SEGMENT8
, SEGMENT9
, SEGMENT10
, SEGMENT11
, SEGMENT12
, SEGMENT13
, SEGMENT14
, SEGMENT15
, SEGMENT16
, SEGMENT17
, SEGMENT18
, SEGMENT19
, SEGMENT20
, DESCRIPTION
, CREATION_ALLOWED
, CREATION_ALLOWED_MEANING
, DEFAULT_TEMPLATE_ID
, DEFAULT_TEMPLATE_NAME
, END_DATE
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
FROM APPS.EGO_CATALOG_GROUPS_V;
APPS
EGO_CAT_GRP_TEMPLATES
FND_LOOKUP_VALUES
MTL_ITEM_CATALOG_GROUPS
MTL_ITEM_CATALOG_GROUPS_KFV
MTL_ITEM_TEMPLATES
APPS
EGO_ICC_BULKLOAD_PVT
- show dependent code
EGO_ITEM_COMPARE_PKG
- show dependent code
EGO_RULES_UTIL_PVT
- show dependent code
EGO_UPLOAD_PUB
- show dependent code
INV_EBI_ITEM_HELPER
- show dependent code
|
|
|
|