View: BOM_CAD_COMPONENT_ATTR_V

Product:	BOM - Bills of Material
Description:	Bom Cad Components Attributes and Values
Implementation/DBA Data:	APPS.BOM_CAD_COMPONENT_ATTR_V

View Text

SELECT ATTR.MODEL_ID
, ATTR.ATTRIBUTENAME
, ATTR.ATTRIBUTENAMEID
, OBJ.OBJECTID
, OBJ.COMPONENT_ID
, COMPS.BILL_SEQUENCE_ID
, COMPS.COMPONENT_SEQUENCE_ID
, DECODE(ATTR.ATTRIBUTETYPE
, 1
, TO_CHAR(BYTEVAL)
, 2
, TO_CHAR(BYTEVAL)
, 3
, TO_CHAR(SHORTVAL)
, 4
, TO_CHAR(SHORTVAL)
, 5
, TO_CHAR(INTVAL)
, 6
, TO_CHAR(INTVAL)
, 7
, TO_CHAR(INT64VAL)
, 8
, TO_CHAR(INT64VAL)
, 9
, TO_CHAR(FLOATVAL)
, 10
, TO_CHAR(DOUBLEVAL)
, 13
, TO_CHAR(STRINGVAL)
, 14
, TO_CHAR(STRINGVAL)
, 15
, TO_CHAR(DATEVAL) ) ATTRIBUTEVALUE
FROM BOM_COMPONENTS_B COMPS
, DDD_MODEL_OBJECTS OBJ
, DDD_MODEL_ATTRIBUTE_NAMES ATTR
, DDD_MODEL_ATTRIBUTE_VALUES VALS
WHERE COMPS.OBJ_NAME = 'DDD_CADVIEW'
AND OBJ.COMPONENT_ID = COMPS.PK1_VALUE
AND OBJ.MODEL_ID = ATTR.MODEL_ID
AND OBJ.MODEL_ID = VALS.MODEL_ID(+)
AND OBJ.OBJECTID = VALS.OBJECTID(+)
AND ATTR.ATTRIBUTENAMEID = VALS.ATTRIBUTENAMEID

Columns