eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.PA_FCST_PROJ_DTL_V

Source

View Text - Preformatted


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

View Text - HTML Formatted

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