List of Pricing Attributes

SELECT qps.segment_level
     , qps.seeded_sourcing_method
     , qps.user_sourcing_method
     , qps.used_in_setup
     , qsb.segment_code
     , qsb.seeded_flag
     , qsb.seeded_precedence
     , qsb.user_precedence
     , qsb.segment_mapping_column
     , qpc.prc_context_code
     , qpc.prc_context_type
     , qps.sourcing_status
     , qps.lov_enabled
     , qps.limits_enabled
     , qps.last_update_date
     , qps.last_updated_by
  FROM qp_pte_segments qps
     , qp_segments_b   qsb
     , qp_prc_contexts_b  qpc
 WHERE qps.segment_id = qsb.segment_id
   AND qps.used_in_setup = 'Y'
   AND qpc.prc_contexT_id = qsb.prc_context_id
   AND qps.pte_code = 'ORDFUL'
 ORDER BY qpc.prc_context_type
        , qpc.prc_context_code
        , qsb.segment_mapping_column