[Home] [Help]
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
Name |
ASSIGNMENT_ID |
X1 |
Y1_SEQ |
X1_SEQ |
PROJECT_ID |
Y1 |
Y1_IMAGE |
Y1_LEFTATTRIBUTE1 |
Y1_LEFTATTRIBUTE2 |
Y1_LEFTATTRIBUTE3 |
Y1_RIGHTATTRIBUTE1 |
VALUE |