Thursday, September 04, 2008

This query can give you details of all attribute mapping


SELECT qas.request_type_code
, qas.attribute_sourcing_level
, qas.seeded_sourcing_type
, qas.user_sourcing_type
, qas.seeded_value_string
, qas.user_value_string
, qs.segment_id
, qs.segment_code
, qs.segment_mapping_column
, qas.enabled_flag
FROM qp_attribute_sourcing qas
, qp_segments_v qs
where qas.segment_id = qs.segment_id (+)

No comments:

Post a Comment