View: CE_FC_AGING_BUCKETS_V

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

View Text

SELECT GPS.PERIOD_NAME
, /*1*/ GPE.PERIOD_NAME
, /*2*/ TO_CHAR(GPS.START_DATE
, 'J')
, /*3*/ TO_CHAR(GPE.END_DATE
, 'J')
, /*4*/ CFH.FORECAST_HEADER_ID
, /*5*/ CFC.DAYS_FROM
, /*6*/ CFC.DAYS_TO
, /*7*/ CFC.FORECAST_COLUMN_ID
, /*8*/ CFC.DEVELOPER_COLUMN_NUM /*9*/
, GLP.PERIOD_SET_NAME
FROM GL_PERIODS GPS
, GL_PERIODS GPE
, GL_PERIODS GLP
, GL_PERIOD_TYPES GPT
, CE_FORECAST_COLUMNS CFC
, CE_FORECAST_HEADERS CFH
WHERE GPS.PERIOD_NUM = DECODE (GREATEST(GLP.PERIOD_NUM + LEAST(GREATEST(CFC.DAYS_FROM-1
, CEFC_VIEW_CONST.GET_MIN_COL)
, CEFC_VIEW_CONST.GET_MAX_COL)
, GPT.NUMBER_PER_FISCAL_YEAR)
, GPT.NUMBER_PER_FISCAL_YEAR
, GLP.PERIOD_NUM + LEAST(GREATEST(CFC.DAYS_FROM-1
, CEFC_VIEW_CONST.GET_MIN_COL)
, CEFC_VIEW_CONST.GET_MAX_COL)
, MOD(GLP.PERIOD_NUM + LEAST(GREATEST(CFC.DAYS_FROM-1
, CEFC_VIEW_CONST.GET_MIN_COL)
, CEFC_VIEW_CONST.GET_MAX_COL)
, GPT.NUMBER_PER_FISCAL_YEAR)) + DECODE ( SIGN ( DECODE (GREATEST(GLP.PERIOD_NUM + LEAST(GREATEST(CFC.DAYS_FROM-1
, CEFC_VIEW_CONST.GET_MIN_COL)
, CEFC_VIEW_CONST.GET_MAX_COL)
, GPT.NUMBER_PER_FISCAL_YEAR)
, GPT.NUMBER_PER_FISCAL_YEAR
, GLP.PERIOD_NUM + LEAST(GREATEST(CFC.DAYS_FROM-1
, CEFC_VIEW_CONST.GET_MIN_COL)
, CEFC_VIEW_CONST.GET_MAX_COL)
, MOD(GLP.PERIOD_NUM + LEAST(GREATEST(CFC.DAYS_FROM-1
, CEFC_VIEW_CONST.GET_MIN_COL)
, CEFC_VIEW_CONST.GET_MAX_COL)
, GPT.NUMBER_PER_FISCAL_YEAR)))
, 1
, 0
, GPT.NUMBER_PER_FISCAL_YEAR)
AND GPE.PERIOD_NUM = DECODE (GREATEST(GLP.PERIOD_NUM + LEAST(GREATEST(CFC.DAYS_TO-1
, CEFC_VIEW_CONST.GET_MIN_COL)
, CEFC_VIEW_CONST.GET_MAX_COL)
, GPT.NUMBER_PER_FISCAL_YEAR)
, GPT.NUMBER_PER_FISCAL_YEAR
, GLP.PERIOD_NUM + LEAST(GREATEST(CFC.DAYS_TO-1
, CEFC_VIEW_CONST.GET_MIN_COL)
, CEFC_VIEW_CONST.GET_MAX_COL)
, MOD(GLP.PERIOD_NUM + LEAST(GREATEST(CFC.DAYS_TO-1
, CEFC_VIEW_CONST.GET_MIN_COL)
, CEFC_VIEW_CONST.GET_MAX_COL)
, GPT.NUMBER_PER_FISCAL_YEAR)) + DECODE ( SIGN ( DECODE (GREATEST(GLP.PERIOD_NUM + LEAST(GREATEST(CFC.DAYS_TO-1
, CEFC_VIEW_CONST.GET_MIN_COL)
, CEFC_VIEW_CONST.GET_MAX_COL)
, GPT.NUMBER_PER_FISCAL_YEAR)
, GPT.NUMBER_PER_FISCAL_YEAR
, GLP.PERIOD_NUM + LEAST(GREATEST(CFC.DAYS_TO-1
, CEFC_VIEW_CONST.GET_MIN_COL)
, CEFC_VIEW_CONST.GET_MAX_COL)
, MOD(GLP.PERIOD_NUM + LEAST(GREATEST(CFC.DAYS_TO-1
, CEFC_VIEW_CONST.GET_MIN_COL)
, CEFC_VIEW_CONST.GET_MAX_COL)
, GPT.NUMBER_PER_FISCAL_YEAR)))
, 1
, 0
, GPT.NUMBER_PER_FISCAL_YEAR)
AND GPS.PERIOD_YEAR = DECODE(MOD (GLP.PERIOD_NUM + LEAST(GREATEST(CFC.DAYS_FROM-1
, CEFC_VIEW_CONST.GET_MIN_COL)
, CEFC_VIEW_CONST.GET_MAX_COL)
, GPT.NUMBER_PER_FISCAL_YEAR)
, 0
, GLP.PERIOD_YEAR + FLOOR((GLP.PERIOD_NUM + LEAST(GREATEST(CFC.DAYS_FROM-1
, CEFC_VIEW_CONST.GET_MIN_COL)
, CEFC_VIEW_CONST.GET_MAX_COL))/GPT.NUMBER_PER_FISCAL_YEAR) -1
, GLP.PERIOD_YEAR + FLOOR((GLP.PERIOD_NUM + LEAST(GREATEST(CFC.DAYS_FROM-1
, CEFC_VIEW_CONST.GET_MIN_COL)
, CEFC_VIEW_CONST.GET_MAX_COL))/GPT.NUMBER_PER_FISCAL_YEAR))
AND GPE.PERIOD_YEAR = DECODE(MOD (GLP.PERIOD_NUM + LEAST(GREATEST(CFC.DAYS_TO-1
, CEFC_VIEW_CONST.GET_MIN_COL)
, CEFC_VIEW_CONST.GET_MAX_COL)
, GPT.NUMBER_PER_FISCAL_YEAR)
, 0
, GLP.PERIOD_YEAR + FLOOR((GLP.PERIOD_NUM + LEAST(GREATEST(CFC.DAYS_TO-1
, CEFC_VIEW_CONST.GET_MIN_COL)
, CEFC_VIEW_CONST.GET_MAX_COL))/GPT.NUMBER_PER_FISCAL_YEAR) -1
, GLP.PERIOD_YEAR + FLOOR((GLP.PERIOD_NUM + LEAST(GREATEST(CFC.DAYS_TO-1
, CEFC_VIEW_CONST.GET_MIN_COL)
, CEFC_VIEW_CONST.GET_MAX_COL))/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 = CEFC_VIEW_CONST.GET_PERIOD_SET_NAME
AND GLP.PERIOD_NAME = CEFC_VIEW_CONST.GET_START_PERIOD_NAME
AND CFC.FORECAST_HEADER_ID = CFH.FORECAST_HEADER_ID
AND CFH.AGING_TYPE = 'A'
AND CFH.FORECAST_HEADER_ID = CEFC_VIEW_CONST.GET_HEADER_ID UNION ALL SELECT NULL
, /*1*/ NULL
, /*2*/ TO_CHAR((CEFC_VIEW_CONST.GET_START_DATE + LEAST(GREATEST(CFC.DAYS_FROM-1
, CEFC_VIEW_CONST.GET_MIN_COL)
, CEFC_VIEW_CONST.GET_MAX_COL))
, 'J')
, /*3*/ TO_CHAR((CEFC_VIEW_CONST.GET_START_DATE + LEAST(GREATEST(CFC.DAYS_TO-1
, CEFC_VIEW_CONST.GET_MIN_COL)
, CEFC_VIEW_CONST.GET_MAX_COL))
, 'J')
, /*4*/ CFH.FORECAST_HEADER_ID
, /*5*/ CFC.DAYS_FROM
, /*6*/ CFC.DAYS_TO
, /*7*/ CFC.FORECAST_COLUMN_ID
, /*8*/ CFC.DEVELOPER_COLUMN_NUM
, /*9*/ NULL
FROM CE_FORECAST_COLUMNS CFC
, CE_FORECAST_HEADERS CFH
WHERE CFC.FORECAST_HEADER_ID = CFH.FORECAST_HEADER_ID
AND CFH.AGING_TYPE = 'D'
AND CFH.FORECAST_HEADER_ID = CEFC_VIEW_CONST.GET_HEADER_ID

Columns