PJC_ALLOC_PERIODS_V

Details

• Schema: FUSION

• Object owner: PJC

• Object type: VIEW

Columns

Name
PERIOD_TYPE PERIOD_NAME START_DATE END_DATE ORG_ID

Query

SQL_Statement

SELECT 'PA' period_type , period_name , start_date , end_date , org_id FROM pjf_p_periods_all_v WHERE status <> 'N' UNION SELECT 'GL' period_type ,B.period_name ,b.start_date ,b. end_date ,c.org_id FROM gl_period_statuses b, pjf_bu_impl_all_v c WHERE b.adjustment_period_flag = 'N' AND b.ledger_id = c.primary_ledger_id AND b.application_id=Pjf_periods_grp.period_application_id AND b.closing_status <> 'N'