VIEW: APPS.PA_REP_RES_SCHHRS_WK_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'