[Home] [Help]
View: BOM_STRUCT_ATTR_GRP_ASSOCS_V
View Text
SELECT EOAGAV.CLASSIFICATION_CODE STRUCTURE_TYPE_ID
, BSTB.PARENT_STRUCTURE_TYPE_ID
, BSTB.STRUCTURE_TYPE_NAME
, EOAGAV.ATTR_GROUP_NAME
, EOAGAV.ATTR_GROUP_TYPE
, EOAGAV.ATTR_GROUP_ID
, EOAGAV.ATTR_GROUP_DESCRIPTION
, EOAGAV.ATTR_GROUP_DISP_NAME
, EOAGAV.OBJECT_NAME
, EOAGAV.APPLICATION_ID
FROM EGO_OBJ_ATTR_GRP_ASSOCS_V EOAGAV
, BOM_STRUCTURE_TYPES_B BSTB
WHERE EOAGAV.CLASSIFICATION_CODE = TO_CHAR(BSTB.STRUCTURE_TYPE_ID)
AND EOAGAV.APPLICATION_ID = 702
Columns
Name |
STRUCTURE_TYPE_ID |
PARENT_STRUCTURE_TYPE_ID |
STRUCTURE_TYPE_NAME |
ATTR_GROUP_NAME |
ATTR_GROUP_TYPE |
ATTR_GROUP_ID |
ATTR_GROUP_DESCRIPTION |
ATTR_GROUP_DISP_NAME |
OBJECT_NAME |
APPLICATION_ID |