PA Agreement Types

SELECT  a.agreement_type
, 	a.description
,                 t.name "terms_default"
,	l.meaning  "revenue_limit_flag"
,	a.start_date_active
,	a.end_date_active
FROM	fnd_lookups l
,                 ra_terms t
,	pa_agreement_types a
WHERE	t.term_id (+) = a.term_id
and     a.revenue_limit_flag = l.lookup_code
and 	l.lookup_type = 'YES_NO'
ORDER BY agreement_type

SELECT a.agreement_type , a.description , t.name "terms_default" , l.meaning "revenue_limit_flag" , a.start_date_active , a.end_date_active FROM fnd_lookups l , ra_terms t , pa_agreement_types a WHERE t.term_id (+) = a.term_id and a.revenue_limit_flag = l.lookup_code and l.lookup_type = 'YES_NO' ORDER BY agreement_type