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