Tuesday, May 27, 2014

Oracle Advance Pricing Queries-2

--for each context and code combinations there are attributes and mapped to derive functionality
select *
  from qp_segments_b b,
       qp_segments_tl t
 where b.prc_context_id=100008
   and b.segment_mapping_column in ('QUALIFIER_ATTRIBUTE35','QUALIFIER_ATTRIBUTE32')
   and b.segment_id=t.segment_id
   and t.language = USERENV ('LANG');

No comments:

Post a Comment