VIEW: APPS.BOM_CAD_COMPONENT_ATTR_V

Source

View Text - Preformatted

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 */

View Text - HTML Formatted

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 */