eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.CE_RX_AGING_BUCKETS_V

Source

View Text - Preformatted


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

View Text - HTML Formatted

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