1. Tables and Views for Sales and Fusion Service
  2. CN_PERIOD_STATUSES_V

CN_PERIOD_STATUSES_V

Details

  • Schema: FUSION

  • Object owner: CN

  • Object type: VIEW

Columns

Name

PERIOD_ID

QUARTER_NUMBER

PERIOD_NAME

PERIOD_STATUS

PROCESSING_STATUS_CODE

ORG_ID

PERIOD_YEAR

PERIOD_NUMBER

FORECAST_FLAG

CALENDAR_ID

START_DATE

END_DATE

PERIOD_TYPE

PERIOD_TYPE_ID

Query

SQL_Statement

SELECT

cpb.period_id,

cpit.interval_number quarter_number,

cpt.period_name,

cps.period_status,

cps.PROCESSING_STATUS_CODE,

cps.org_id,

cpb.period_year,

cpb.period_number,

cps.forecast_flag,

cpb.calendar_id,

cpb.start_date,

cpb.end_date,

cnpt.period_type,

cnpt.period_type_id

FROM

cn_periods_b cpb,

cn_periods_tl cpt,

cn_prd_statuses_all cps,

cn_calendars_b ccb,

cn_period_types_vl cnpt,

cn_cal_per_int_types_all cpit

WHERE

cps.period_id = cpb.period_id

AND cpb.period_id = cpt.period_id

AND cps.calendar_id = cpb.calendar_id

AND cpb.calendar_id = ccb.calendar_id

AND ccb.period_type_id = cnpt.period_type_id

AND cpb.calendar_id = cpt.calendar_id

AND cpt.LANGUAGE = USERENV('LANG')

AND cps.period_id = cpit.cal_period_id

AND cps.org_id = cpit.org_id

AND cpit.interval_type_id = -1001