MSS_CAMPAIGN_ATTR_VALUES_V

Details

• Schema: FUSION

• Object owner: MSS

• Object type: VIEW

Columns

Name
CAMPAIGN_ID ORGANIZATION_ID ATTRIBUTE_ID ATTRIBUTE_CODE ATTRIBUTE_VALUE_ID DESCRIPTIVE_FLEXFIELD_CODE FLEXFIELD_CONTEXT_CODE SEGMENT_CODE COLUMN_NAME VALUE_SET_ID ATTRIBUTE_VALUE_CODE

Query

SQL_Statement

select c.CAMPAIGN_ID, c.ORGANIZATION_ID, casv.ATTRIBUTE_ID, a.ATTRIBUTE_CODE, casv.ATTRIBUTE_VALUE_ID, a.DESCRIPTIVE_FLEXFIELD_CODE, a.FLEXFIELD_CONTEXT_CODE, a.SEGMENT_CODE, seg.COLUMN_NAME, a.VALUE_SET_ID, av.ATTRIBUTE_VALUE_CODE from mss_campaigns c join mss_campaign_attribute_sets cas on c.CAMPAIGN_ATTRIBUTE_SET_ID = cas.CAMPAIGN_ATTRIBUTE_SET_ID join mss_campaign_attr_set_values casv on cas.CAMPAIGN_ATTRIBUTE_SET_ID = casv.CAMPAIGN_ATTRIBUTE_SET_ID join mss_org_attributes a on c.ORGANIZATION_ID = a.ORGANIZATION_ID and casv.ATTRIBUTE_ID = a.ATTRIBUTE_ID join fnd_df_segments_b seg on a.DESCRIPTIVE_FLEXFIELD_CODE = seg.DESCRIPTIVE_FLEXFIELD_CODE and a.FLEXFIELD_CONTEXT_CODE = seg.CONTEXT_CODE and a.SEGMENT_CODE = seg.SEGMENT_CODE join mss_org_attribute_values av on a.ORGANIZATION_ID = av.ORGANIZATION_ID and a.ATTRIBUTE_ID = av.ATTRIBUTE_ID and casv.ATTRIBUTE_VALUE_ID = av.ATTRIBUTE_VALUE_ID