VIEW: APPS.BOM_CAD_COMPONENT_ATTR_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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