[Home] [Help]
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
Name |
CONFIRMED_HOURS |
PROVISIONAL_HOURS |
GL_PERIOD |
GL_PERIOD_SET_NAME |
RESOURCE_ID |