PJF_P_PERIODS_ALL_V

Details

• Schema: FUSION

• Object owner: PJF

• Object type: VIEW

Columns

Name
PERIOD_NAME START_DATE END_DATE STATUS GL_PERIOD_NAME PERIOD_NUM ORG_ID PRIMARY_LEDGER_ID PA_PERIOD_TYPE PERIOD_SET_NAME CREATION_DATE CREATED_BY LAST_UPDATE_DATE LAST_UPDATED_BY

Query

SQL_Statement

SELECT period_name, start_date, end_date, closing_status status, period_name gl_period_name, period_num, org_id, ledger.ORG_INFORMATION3 primary_ledger_id, bu.pa_period_type, bu.period_set_name, gps.creation_date, gps.created_by, gps.last_update_date, gps.last_updated_by FROM gl_period_statuses gps, pjf_bu_impl_all bu, HR_ORGANIZATION_INFORMATION_X ledger WHERE ledger.ORGANIZATION_ID = bu.org_id AND ledger.ORG_INFORMATION_CONTEXT = 'FUN_BUSINESS_UNIT' AND ledger.ORG_INFORMATION3 = gps.ledger_id AND gps.application_id = 10037 AND gps.adjustment_period_flag = 'N' AND bu.same_pa_gl_period = 'Y' UNION ALL SELECT paper.period_name, paper.start_date, paper.end_date, paper.status, paper.gl_period_name, paper.period_num, paper.org_id, ledger.ORG_INFORMATION3 PRIMARY_LEDGER_ID, bu.pa_period_type, bu.period_set_name, paper.creation_date, paper.created_by, paper.last_update_date, paper.last_updated_by FROM pjf_periods_all paper, pjf_bu_impl_all bu, HR_ORGANIZATION_INFORMATION_X ledger WHERE bu.same_pa_gl_period = 'N' AND bu.org_id = paper.org_id AND ledger.ORGANIZATION_ID = bu.org_id AND ledger.ORG_INFORMATION_CONTEXT = 'FUN_BUSINESS_UNIT'