View: PA_FCST_PROJ_DTL_V

Product:	PA - Projects
Description:	PA_PROJ_FCST_DTL_V is a view that shows project detail forecasting
Implementation/DBA Data:	APPS.PA_FCST_PROJ_DTL_V

View Text

SELECT ASSIGNMENT_ID
, PERIOD_NAME X1
, DENSE_RANK() OVER (ORDER BY ASSIGNMENT_NAME
, ASSIGNMENT_ID) AS Y1_SEQ
, DENSE_RANK() OVER (PARTITION BY ASSIGNMENT_ID ORDER BY PERIOD_START_DATE ) AS X1_SEQ
, PROJECT_ID PROJECT_ID
, ASSIGNMENT_NAME Y1
, PLAN_PROCESSING_CODE Y1_IMAGE
, TO_CHAR(STD_BILL_RATE
, '999
, 999
, 990.99') Y1_LEFTATTRIBUTE1
, TO_CHAR(AVG_BILL_RATE
, '999
, 999
, 990.99') Y1_LEFTATTRIBUTE2
, TO_CHAR(AVG_DISCOUNT_PERCENTAGE
, '999
, 999
, 990.99') Y1_LEFTATTRIBUTE3
, TO_CHAR(PROJECT_TOTAL
, '999
, 999
, 999
, 999
, 990.99') Y1_RIGHTATTRIBUTE1
, VALUE
FROM PA_FCST_PROJ_PERIODIC_V ORDER BY ASSIGNMENT_ID

Columns