VIEW: APPS.PA_TERMS_LOV_V

Source

View Text - Preformatted

SELECT at.agreement_type, at.revenue_limit_flag, at.term_id, rt.name FROM pa_agreement_types at, ra_terms rt WHERE at.term_id = rt.term_id(+) and trunc(sysdate) between trunc(at.start_date_active) and trunc(nvl(at.end_date_active,sysdate) )

View Text - HTML Formatted

SELECT AT.AGREEMENT_TYPE
, AT.REVENUE_LIMIT_FLAG
, AT.TERM_ID
, RT.NAME
FROM PA_AGREEMENT_TYPES AT
, RA_TERMS RT
WHERE AT.TERM_ID = RT.TERM_ID(+)
AND TRUNC(SYSDATE) BETWEEN TRUNC(AT.START_DATE_ACTIVE)
AND TRUNC(NVL(AT.END_DATE_ACTIVE
, SYSDATE) )