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 NULL MODEL_ID
, NULL ATTRIBUTENAME
, NULL ATTRIBUTENAMEID
, NULL OBJECTID
, NULL COMPONENT_ID
, COMPS.BILL_SEQUENCE_ID
, COMPS.COMPONENT_SEQUENCE_ID
, NULL 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