VIEW: APPS.CZ_EXV_APC_PROPERTIES

Source

View Text - Preformatted

SELECT attrgrps.attr_group_id,assocs.classification_code AS item_catalog_group_id,attrs."ATTR_ID",attrs."APPLICATION_ID",attrs."ATTR_GROUP_TYPE",attrs."ATTR_GROUP_NAME",attrs."ATTR_NAME",attrs."ATTR_DISPLAY_NAME",attrs."DESCRIPTION",attrs."DATABASE_COLUMN",attrs."DATA_TYPE_CODE",attrs."SEQUENCE",attrs."UNIQUE_KEY_FLAG",attrs."DEFAULT_VALUE",attrs."INFO_1",attrs."UOM_CLASS",attrs."CONTROL_LEVEL",attrs."VALUE_SET_ID",attrs."VALUE_SET_NAME",attrs."FORMAT_CODE",attrs."MAXIMUM_SIZE",attrs."VALIDATION_CODE",attrs."LONGLIST_FLAG",attrs."ENABLED_FLAG",attrs."ENABLED_MEANING",attrs."REQUIRED_FLAG",attrs."REQUIRED_MEANING",attrs."SEARCH_FLAG",attrs."SEARCH_MEANING",attrs."DISPLAY_CODE",attrs."DISPLAY_MEANING",attrs."ATTRIBUTE_CODE",attrs."VIEW_IN_HIERARCHY_CODE",attrs."EDIT_IN_HIERARCHY_CODE",attrs."CUSTOMIZATION_LEVEL",attrs."MINIMUM_VALUE",attrs."MAXIMUM_VALUE",attrs."VALIDATION_CODE_VS" FROM EGO_ATTR_GROUPS_V attrgrps ,EGO_ATTRS_V  attrs ,EGO_OBJ_AG_ASSOCS_B  assocs ,EGO_ITMATTR_APPL_USGS_B  usgs ,FND_OBJECTS objs WHERE objs.OBJ_NAME = 'EGO_ITEM' AND objs.OBJECT_ID = assocs.OBJECT_ID AND assocs.ATTR_GROUP_ID = attrgrps.ATTR_GROUP_ID AND attrgrps.ATTR_GROUP_TYPE = attrs.ATTR_GROUP_TYPE AND attrgrps.ATTR_GROUP_NAME = attrs.ATTR_GROUP_NAME AND attrs.APPLICATION_ID = 431 AND attrgrps.APPLICATION_ID = 431 AND usgs.ATTR_ID = attrs.ATTR_ID AND usgs.ENABLED_FLAG = 'Y' AND usgs.APPLICATION_ID = 708 AND attrgrps.attr_group_type='EGO_ITEMMGMT_GROUP' AND  assocs.DATA_LEVEL='ITEM_LEVEL' AND attrs.ENABLED_FLAG='Y' 

View Text - HTML Formatted

SELECT ATTRGRPS.ATTR_GROUP_ID
, ASSOCS.CLASSIFICATION_CODE AS ITEM_CATALOG_GROUP_ID
, ATTRS."ATTR_ID"
, ATTRS."APPLICATION_ID"
, ATTRS."ATTR_GROUP_TYPE"
, ATTRS."ATTR_GROUP_NAME"
, ATTRS."ATTR_NAME"
, ATTRS."ATTR_DISPLAY_NAME"
, ATTRS."DESCRIPTION"
, ATTRS."DATABASE_COLUMN"
, ATTRS."DATA_TYPE_CODE"
, ATTRS."SEQUENCE"
, ATTRS."UNIQUE_KEY_FLAG"
, ATTRS."DEFAULT_VALUE"
, ATTRS."INFO_1"
, ATTRS."UOM_CLASS"
, ATTRS."CONTROL_LEVEL"
, ATTRS."VALUE_SET_ID"
, ATTRS."VALUE_SET_NAME"
, ATTRS."FORMAT_CODE"
, ATTRS."MAXIMUM_SIZE"
, ATTRS."VALIDATION_CODE"
, ATTRS."LONGLIST_FLAG"
, ATTRS."ENABLED_FLAG"
, ATTRS."ENABLED_MEANING"
, ATTRS."REQUIRED_FLAG"
, ATTRS."REQUIRED_MEANING"
, ATTRS."SEARCH_FLAG"
, ATTRS."SEARCH_MEANING"
, ATTRS."DISPLAY_CODE"
, ATTRS."DISPLAY_MEANING"
, ATTRS."ATTRIBUTE_CODE"
, ATTRS."VIEW_IN_HIERARCHY_CODE"
, ATTRS."EDIT_IN_HIERARCHY_CODE"
, ATTRS."CUSTOMIZATION_LEVEL"
, ATTRS."MINIMUM_VALUE"
, ATTRS."MAXIMUM_VALUE"
, ATTRS."VALIDATION_CODE_VS"
FROM EGO_ATTR_GROUPS_V ATTRGRPS
, EGO_ATTRS_V ATTRS
, EGO_OBJ_AG_ASSOCS_B ASSOCS
, EGO_ITMATTR_APPL_USGS_B USGS
, FND_OBJECTS OBJS
WHERE OBJS.OBJ_NAME = 'EGO_ITEM'
AND OBJS.OBJECT_ID = ASSOCS.OBJECT_ID
AND ASSOCS.ATTR_GROUP_ID = ATTRGRPS.ATTR_GROUP_ID
AND ATTRGRPS.ATTR_GROUP_TYPE = ATTRS.ATTR_GROUP_TYPE
AND ATTRGRPS.ATTR_GROUP_NAME = ATTRS.ATTR_GROUP_NAME
AND ATTRS.APPLICATION_ID = 431
AND ATTRGRPS.APPLICATION_ID = 431
AND USGS.ATTR_ID = ATTRS.ATTR_ID
AND USGS.ENABLED_FLAG = 'Y'
AND USGS.APPLICATION_ID = 708
AND ATTRGRPS.ATTR_GROUP_TYPE='EGO_ITEMMGMT_GROUP'
AND ASSOCS.DATA_LEVEL='ITEM_LEVEL'
AND ATTRS.ENABLED_FLAG='Y'