SELECT sr_instance_id||'-'||organization_id||'-'||period_name ID, period_name VALUE, 'Accounting' PERIOD_SET_NAME, period_name, start_date, end_date, period_year, sr_instance_id||'-'||organization_id ORGANIZATION_ID, 'ORGANIZATION' ORGANIZATION_TYPE FROM msc_bis_periods WHERE period_set_name = 'Accounting'
SELECT SR_INSTANCE_ID||'-'||ORGANIZATION_ID||'-'||PERIOD_NAME ID
, PERIOD_NAME VALUE
, 'ACCOUNTING' PERIOD_SET_NAME
, PERIOD_NAME
, START_DATE
, END_DATE
, PERIOD_YEAR
, SR_INSTANCE_ID||'-'||ORGANIZATION_ID ORGANIZATION_ID
, 'ORGANIZATION' ORGANIZATION_TYPE
FROM MSC_BIS_PERIODS
WHERE PERIOD_SET_NAME = 'ACCOUNTING'
|
|
|