PJO_PERIODS_V

Details

• Schema: FUSION

• Object owner: PJO

• Object type: VIEW

Columns

Name
PERIOD_TYPE PERIOD_SET_NAME PROJECT_ID PROJECT_ORG_ID PROJECT_START_DATE PROJECT_END_DATE CALENDAR_TYPE PERIOD_NAME PERIOD_NUM PERIOD_START_DATE PERIOD_END_DATE QUARTER_NAME QUARTER_NUM QUARTER_START_DATE QUARTER_END_DATE PERIOD_YEAR YEAR_START_DATE YEAR_END_DATE

Query

SQL_Statement

select per.period_type period_type, per.period_set_name period_set_name, proj.project_id project_id, proj.org_id project_org_id, proj.start_date project_start_date, proj.completion_date project_end_date, CalendarType.invert CALENDAR_TYPE, per.period_name PERIOD_NAME, per.PERIOD_NUM, per.start_date PERIOD_START_DATE, per.end_date PERIOD_END_DATE, 'Q'||per.QUARTER_NUM||'-'||per.PERIOD_YEAR QUARTER_NAME, QUARTER_NUM, per.quarter_start_date, ADD_MONTHS(per.quarter_start_date,3)-1 QUARTER_END_DATE, PERIOD_YEAR, per.year_start_date, ADD_MONTHS(per.year_start_date,12)-1 YEAR_END_DATE from gl_periods per, fun_all_business_units_v bu, gl_ledger_le_v led, pjf_projects_all_vl proj, pjf_bu_impl_all impl, ( select 'P' invert from dual union select 'G' invert from dual) CalendarType where proj.org_id=impl.org_id and per.adjustment_period_flag='N' and (per.start_date >= proj.start_date or proj.start_date between per.start_date and per.end_date) /* and per.end_date between proj.start_date and nvl(proj.completion_date,ADD_MONTHS(sysdate,12)-1) */ and bu.bu_id=proj.org_id and bu.primary_ledger_id=led.ledger_id and bu.legal_entity_id = led.legal_entity_id and decode(CalendarType.invert,'P',impl.pa_period_type,'G',led.accounted_period_type) =per.period_type and decode(CalendarType.invert,'P',impl.period_set_name,'G',led.period_set_name) =per.period_set_name and proj.project_category IN ('FINANCIAL', 'FIN_EXEC')