View: PA_AGREEMENT_TYPE_LOV_V

Product:	PA - Projects
Description:
Implementation/DBA Data:	APPS.PA_AGREEMENT_TYPE_LOV_V

View Text

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) )

Columns