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