View: PA_REP_RES_SCHHRS_GL_V

Product:	PA - Projects
Description:	PA_REP_RES_SCHHRS_GL_V is a view that shows scheduled resource hours for a gl period
Implementation/DBA Data:	APPS.PA_REP_RES_SCHHRS_GL_V

View Text

SELECT SUM(DECODE(PFI.PROVISIONAL_FLAG
, 'N'
, PFI.ITEM_QUANTITY
, 0))
, SUM(DECODE(PFI.PROVISIONAL_FLAG
, 'Y'
, PFI.ITEM_QUANTITY
, 0))
, PFI.PVDR_GL_PERIOD_NAME
, PFI.PVDR_PERIOD_SET_NAME
, PFI.RESOURCE_ID
FROM PA_FORECAST_ITEMS PFI
WHERE PFI.FORECAST_ITEM_TYPE = 'A'
AND PFI.DELETE_FLAG = 'N' GROUP BY PFI.PVDR_GL_PERIOD_NAME
, PFI.PVDR_PERIOD_SET_NAME
, PFI.RESOURCE_ID

Columns