[Home] [Help]
View: PA_REP_RES_SCHHRS_WK_V
Product: | PA - Projects |
Description: | PA_REP_RES_SCHHRS_WK_V is a view that shows the scheduled resource hours for a global week |
Implementation/DBA Data: |
APPS.PA_REP_RES_SCHHRS_WK_V
|
View Text
SELECT PRPV.PERIOD_YEAR
, PRPV.MON_OR_QTR
, PFI.GLOBAL_EXP_PERIOD_END_DATE
, PFI.ITEM_DATE
, DECODE(PFI.PROVISIONAL_FLAG
, 'N'
, PFI.ITEM_QUANTITY
, 0)
, DECODE(PFI.PROVISIONAL_FLAG
, 'Y'
, PFI.ITEM_QUANTITY
, 0)
, PFI.RESOURCE_ID
FROM PA_FORECAST_ITEMS PFI
, PA_REP_PERIODS_V PRPV
WHERE PFI.FORECAST_ITEM_TYPE = 'A'
AND PFI.DELETE_FLAG = 'N'
AND PRPV.GE_WEEK_DT = PFI.GLOBAL_EXP_PERIOD_END_DATE
AND PRPV.PERIOD_TYPE = 'GE'
Columns
Name |
YEAR |
MONTH |
GLOBAL_WEEK |
ITEM_DATE |
CONFIRMED_HOURS |
PROVISIONAL_HOURS |
RESOURCE_ID |