View: PA_FCST_PROJ_INFO_V

Product:	PA - Projects
Description:	PA_FCST_PROJ_INFO_V is a view that shows project information
Implementation/DBA Data:	APPS.PA_FCST_PROJ_INFO_V

View Text

SELECT P1.PROJECT_ID AS PROJECT_ID
, P1.PROJFUNC_CURRENCY_CODE AS PROJECT_CURRENCY
, P1.NAME AS PROJECT_NAME
, P1.SEGMENT1 AS PROJECT_NUM
, P2.PROBABILITY_PERCENTAGE AS PROB_PER
FROM PA_PROJECTS_ALL P1
, PA_PROBABILITY_MEMBERS P2
WHERE P1.PROBABILITY_MEMBER_ID = P2.PROBABILITY_MEMBER_ID(+)

Columns