View: CE_RX_AGING_BUCKETS_V

Product:	CE - Cash Management
Description:	- Retrofitted
Implementation/DBA Data:	APPS.CE_RX_AGING_BUCKETS_V

View Text

SELECT CF.FORECAST_ID
, CF.NAME
, GPS.PERIOD_NAME
, GPE.PERIOD_NAME
, CFC.DEVELOPER_COLUMN_NUM
FROM GL_PERIODS GPS
, GL_PERIODS GPE
, GL_PERIODS GLP
, GL_PERIOD_TYPES GPT
, CE_FORECAST_COLUMNS CFC
, CE_FORECAST_HEADERS CFH
, CE_FORECASTS CF
WHERE GPS.PERIOD_NUM = DECODE (GREATEST(GLP.PERIOD_NUM + CFC.DAYS_FROM -1
, GPT.NUMBER_PER_FISCAL_YEAR)
, GPT.NUMBER_PER_FISCAL_YEAR
, GLP.PERIOD_NUM + CFC.DAYS_FROM -1
, MOD(GLP.PERIOD_NUM + CFC.DAYS_FROM -1
, GPT.NUMBER_PER_FISCAL_YEAR))
AND GPE.PERIOD_NUM = DECODE (GREATEST(GLP.PERIOD_NUM + CFC.DAYS_TO -1
, GPT.NUMBER_PER_FISCAL_YEAR)
, GPT.NUMBER_PER_FISCAL_YEAR
, GLP.PERIOD_NUM + CFC.DAYS_TO -1
, MOD(GLP.PERIOD_NUM + CFC.DAYS_TO -1
, GPT.NUMBER_PER_FISCAL_YEAR))
AND GPS.PERIOD_YEAR = DECODE(MOD (GLP.PERIOD_NUM + CFC.DAYS_FROM-1
, GPT.NUMBER_PER_FISCAL_YEAR)
, 0
, GLP.PERIOD_YEAR + FLOOR((GLP.PERIOD_NUM + CFC.DAYS_FROM-1)/GPT.NUMBER_PER_FISCAL_YEAR) -1
, GLP.PERIOD_YEAR + FLOOR((GLP.PERIOD_NUM + CFC.DAYS_FROM-1)/GPT.NUMBER_PER_FISCAL_YEAR))
AND GPE.PERIOD_YEAR = DECODE(MOD (GLP.PERIOD_NUM + CFC.DAYS_TO-1
, GPT.NUMBER_PER_FISCAL_YEAR)
, 0
, GLP.PERIOD_YEAR + FLOOR((GLP.PERIOD_NUM + CFC.DAYS_TO-1)/GPT.NUMBER_PER_FISCAL_YEAR) -1
, GLP.PERIOD_YEAR + FLOOR((GLP.PERIOD_NUM + CFC.DAYS_TO-1)/GPT.NUMBER_PER_FISCAL_YEAR))
AND GPT.PERIOD_TYPE = GLP.PERIOD_TYPE
AND GPS.PERIOD_TYPE = GPE.PERIOD_TYPE
AND GPS.PERIOD_SET_NAME = GLP.PERIOD_SET_NAME
AND GPE.PERIOD_SET_NAME = GLP.PERIOD_SET_NAME
AND GLP.PERIOD_TYPE = GPS.PERIOD_TYPE
AND GLP.PERIOD_SET_NAME = CF.PERIOD_SET_NAME
AND GLP.PERIOD_NAME = CF.START_PERIOD
AND CFC.FORECAST_HEADER_ID = CFH.FORECAST_HEADER_ID
AND NVL(CFH.AGING_TYPE
, 'D') = 'A'
AND CFH.FORECAST_HEADER_ID = CF.FORECAST_HEADER_ID UNION ALL SELECT CF.FORECAST_ID
, CF.NAME
, TO_CHAR((CF.START_DATE + CFC.DAYS_FROM-1)
, 'MM/DD')
, TO_CHAR((CF.START_DATE + NVL(CFC.DAYS_TO-1
, CFC.DAYS_FROM-1))
, 'MM/DD')
, CFC.DEVELOPER_COLUMN_NUM /*9*/
FROM CE_FORECAST_COLUMNS CFC
, CE_FORECAST_HEADERS CFH
, CE_FORECASTS CF
WHERE CFC.FORECAST_HEADER_ID = CFH.FORECAST_HEADER_ID
AND NVL(CFH.AGING_TYPE
, 'D') = 'D'
AND CFH.FORECAST_HEADER_ID = CF.FORECAST_HEADER_ID

Columns