Oracle Advance Pricing Queries-1

--There are three contexts types -Pricing,Product and Qualifier
--for each there are context codes

select *
  from qp_prc_contexts_b b,
       qp_prc_contexts_tl t
 where b.prc_context_type='QUALIFIER'
   and b.prc_context_code='ORDER'
   and b.prc_context_id = t.prc_context_id
   and t.language = USERENV ('LANG');