PA Agreement Types

Description
Categories: BI Publisher, Financials
Application: Projects
Source: IMP: Agreement Types (XML)
Short Name: PAXRWAGT_XML
DB package: PA_PAXRWAGT_XMLP_PKG
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
Ask a question