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_FINPLAN_VIEW_BY_COMP_V

Source

View Text - Preformatted


SELECT Amount_Subtype_Name, Amount_Subtype_Code, Amount_Subtype_Id, nvl(PRECEDING_PERIODS_AMOUNT,0), nvl(SUCCEEDING_PERIODS_AMOUNT,0), nvl(period1,0), nvl(period2,0), nvl(period3,0), nvl(period4,0), nvl(period5,0), nvl(period6,0), nvl(period7,0), nvl(period8,0), nvl(period9,0), nvl(period10,0), nvl(period11,0), nvl(period12,0), nvl(period13,0), nvl(Total_PA,0), nvl(Total,0) from pa_fp_view_by_comp_v WHERE Amount_Subtype_Code NOT IN ('CAPACITY','UTILIZATION_HOURS') order by Amount_Subtype_Id

View Text - HTML Formatted

SELECT AMOUNT_SUBTYPE_NAME
, AMOUNT_SUBTYPE_CODE
, AMOUNT_SUBTYPE_ID
, NVL(PRECEDING_PERIODS_AMOUNT
, 0)
, NVL(SUCCEEDING_PERIODS_AMOUNT
, 0)
, NVL(PERIOD1
, 0)
, NVL(PERIOD2
, 0)
, NVL(PERIOD3
, 0)
, NVL(PERIOD4
, 0)
, NVL(PERIOD5
, 0)
, NVL(PERIOD6
, 0)
, NVL(PERIOD7
, 0)
, NVL(PERIOD8
, 0)
, NVL(PERIOD9
, 0)
, NVL(PERIOD10
, 0)
, NVL(PERIOD11
, 0)
, NVL(PERIOD12
, 0)
, NVL(PERIOD13
, 0)
, NVL(TOTAL_PA
, 0)
, NVL(TOTAL
, 0)
FROM PA_FP_VIEW_BY_COMP_V
WHERE AMOUNT_SUBTYPE_CODE NOT IN ('CAPACITY'
, 'UTILIZATION_HOURS') ORDER BY AMOUNT_SUBTYPE_ID