View: PA_PROJECTS_PROBABILITY_V

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

View Text

SELECT PPM.PROBABILITY_PERCENTAGE
, PPM.DESCRIPTION
, PPM.PROBABILITY_MEMBER_ID
, PPT.PROJECT_TYPE
FROM PA_PROBABILITY_MEMBERS PPM
, PA_PROJECT_TYPES PPT
WHERE PPM.PROBABILITY_LIST_ID = PPT.PROBABILITY_LIST_ID
AND TRUNC(SYSDATE) BETWEEN PPM.START_DATE_ACTIVE
AND NVL(PPM.END_DATE_ACTIVE
, TRUNC(SYSDATE))

Columns