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.

[Home] [Help]

View: PA_FINPLAN_VIEW_BY_COMP_V

Product:	PA - Projects
Description:	The pa_finplan_view_by_comp_v view store the forecast amounts by period for one amount types.
Implementation/DBA Data:	APPS.PA_FINPLAN_VIEW_BY_COMP_V

View Text

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

Columns

Name
AMOUNT_SUBTYPE_NAME
AMOUNT_SUBTYPE_CODE
AMOUNT_SUBTYPE_ID
PRECEDING_PERIODS_AMOUNT
SUCCEEDING_PERIODS_AMOUNT
PERIOD1
PERIOD2
PERIOD3
PERIOD4
PERIOD5
PERIOD6
PERIOD7
PERIOD8
PERIOD9
PERIOD10
PERIOD11
PERIOD12
PERIOD13
TOTAL_PA
TOTAL