PJF_P_PERIOD_ALL_DETAILS_V

Details

• Schema: FUSION

• Object owner: PJF

• Object type: VIEW

Columns

Name
PERIOD_NAME PA_START_DATE PA_END_DATE STATUS STATUS_MEANING GL_PERIOD_NAME GL_START_DATE GL_END_DATE PERIOD_SET_NAME PA_PERIOD_TYPE PA_PERIOD_NUM PERIOD_NUM QUARTER_NUM PERIOD_YEAR LEDGER_ID ORG_ID FUTURE_ENTERABLE_PERIODS_LIMIT

Query

SQL_Statement

Select paper.period_name, paper.start_date pa_start_date, paper.end_date pa_end_date, paper.status, lookup.meaning status_meaning, paper.gl_period_name, glper.start_date gl_start_date, glper.end_date gl_end_date, bu.period_set_name, bu.pa_period_type, paper.period_num pa_period_num, glper.period_num, glper.quarter_num, glper.period_year, bu.primary_ledger_id ledger_id, paper.org_id, glb.future_enterable_periods_limit from pjf_p_periods_all_v paper, pjf_bu_impl_all_v bu, gl_ledgers glb, gl_periods glper, pjf_lookups lookup where paper.org_id = bu.org_id and glb.ledger_id = bu.primary_ledger_id and glb.accounted_period_type = glper.period_type and glper.period_set_name = glb.period_set_name and glper.period_name = paper.gl_period_name and glper.adjustment_period_flag = 'N' and lookup.lookup_type = 'PJF_CLOSING_STATUS' and lookup.lookup_code = paper.status