View: EGO_CATALOG_GROUPS_V

Product:	EGO - Advanced Product Catalog
Description:	View on Item Catalog Categories.
Implementation/DBA Data:	APPS.EGO_CATALOG_GROUPS_V

View Text

SELECT CG.ITEM_CATALOG_GROUP_ID CATALOG_GROUP_ID
, CGV.CONCATENATED_SEGMENTS CATALOG_GROUP
, CG.PARENT_CATALOG_GROUP_ID PARENT_CATALOG_GROUP_ID
, CGPV.CONCATENATED_SEGMENTS PARENT_CATALOG_GROUP
, CG.SEGMENT1 SEGMENT1
, CG.SEGMENT2 SEGMENT2
, CG.SEGMENT3 SEGMENT3
, CG.SEGMENT4 SEGMENT4
, CG.SEGMENT5 SEGMENT5
, CG.SEGMENT6 SEGMENT6
, CG.SEGMENT7 SEGMENT7
, CG.SEGMENT8 SEGMENT8
, CG.SEGMENT9 SEGMENT9
, CG.SEGMENT10 SEGMENT10
, CG.SEGMENT11 SEGMENT11
, CG.SEGMENT12 SEGMENT12
, CG.SEGMENT13 SEGMENT13
, CG.SEGMENT14 SEGMENT14
, CG.SEGMENT15 SEGMENT15
, CG.SEGMENT16 SEGMENT16
, CG.SEGMENT17 SEGMENT17
, CG.SEGMENT18 SEGMENT18
, CG.SEGMENT19 SEGMENT19
, CG.SEGMENT20 SEGMENT20
, CG.DESCRIPTION DESCRIPTION
, CG.ITEM_CREATION_ALLOWED_FLAG CREATION_ALLOWED
, L.MEANING CREATION_ALLOWED_MEANING
, IT.TEMPLATE_ID DEFAULT_TEMPLATE_ID
, IT.TEMPLATE_NAME DEFAULT_TEMPLATE_NAME
, CG.INACTIVE_DATE END_DATE
, CGV.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, CGV.ATTRIBUTE1 ATTRIBUTE1
, CGV.ATTRIBUTE2 ATTRIBUTE2
, CGV.ATTRIBUTE3 ATTRIBUTE3
, CGV.ATTRIBUTE4 ATTRIBUTE4
, CGV.ATTRIBUTE5 ATTRIBUTE5
, CGV.ATTRIBUTE6 ATTRIBUTE6
, CGV.ATTRIBUTE7 ATTRIBUTE7
, CGV.ATTRIBUTE8 ATTRIBUTE8
, CGV.ATTRIBUTE9 ATTRIBUTE9
, CGV.ATTRIBUTE10 ATTRIBUTE10
, CGV.ATTRIBUTE11 ATTRIBUTE11
, CGV.ATTRIBUTE12 ATTRIBUTE12
, CGV.ATTRIBUTE13 ATTRIBUTE13
, CGV.ATTRIBUTE14 ATTRIBUTE14
, CGV.ATTRIBUTE15 ATTRIBUTE15
FROM MTL_ITEM_CATALOG_GROUPS CG
, MTL_ITEM_CATALOG_GROUPS_KFV CGV
, MTL_ITEM_CATALOG_GROUPS_KFV CGPV
, MTL_ITEM_TEMPLATES IT
, EGO_CAT_GRP_TEMPLATES EOIT
, FND_LOOKUP_VALUES L
WHERE CG.ITEM_CATALOG_GROUP_ID = CGV.ITEM_CATALOG_GROUP_ID
AND CG.PARENT_CATALOG_GROUP_ID = CGPV.ITEM_CATALOG_GROUP_ID (+)
AND CGV.ITEM_CATALOG_GROUP_ID = EOIT.CATALOG_GROUP_ID (+)
AND EOIT.TEMPLATE_ID = IT.TEMPLATE_ID (+)
AND EOIT.DEFAULT_FLAG(+) = 'Y'
AND L.LOOKUP_CODE (+) = CG.ITEM_CREATION_ALLOWED_FLAG
AND L.LOOKUP_TYPE (+) = 'EGO_EF_ENABLED_FLAG'
AND L.LANGUAGE(+) = USERENV('LANG')

Columns