MSC_PROJ_TASK_RELATIONSHIPS_V

Details

• Schema: FUSION

• Object owner: MSC

• Object type: VIEW

Columns

Name
RELATIONSHIP_ID PROJECT_ATTRIBUTE_ID PROJECT_VALUE PROJECT_SRC_VALUE_ID PROJECT_DEST_VALUE_ID TASK_ATTRIBUTE_ID TASK_VALUE TASK_SRC_VALUE_ID TASK_DEST_VALUE_ID

Query

SQL_Statement

SELECT projtaskrelation.relationship_id, project.attribute_id project_attribute_id, project_val.attribute_value project_value, project_val.attribute_src_value_id project_src_value_id, project_val.attribute_dest_value_id project_dest_value_id, task.attribute_id task_attribute_id, task_val.attribute_value task_value, task_val.attribute_src_value_id task_src_value_id, task_val.attribute_dest_value_id task_dest_value_id FROM msc_attributes_b project, msc_attribute_values project_val, msc_attributes_b task, msc_attribute_values task_val, msc_attr_val_relationships projtaskrelation WHERE project.attribute_number = 1 AND task.attribute_number = 2 AND project_val.plan_id = -1 AND project_val.attribute_number = project.attribute_number AND project_val.attribute_id = project.attribute_id AND task_val.plan_id = -1 AND task_val.attribute_number = task.attribute_number AND task_val.attribute_id = task.attribute_id AND projtaskrelation.plan_id = -1 AND projtaskrelation.attribute_set_id = project.attribute_set_id AND projtaskrelation.attribute_set_id = task.attribute_set_id AND projtaskrelation.attribute1_val_id = project_val.attribute_dest_value_id AND projtaskrelation.attribute2_val_id = task_val.attribute_dest_value_id