VIEW: APPS.ISC_MSC_BIS_YEARS_V

Source

View Text - Preformatted

SELECT DISTINCT sr_instance_id||'-'|| organization_id||'-'||period_year ID, period_year VALUE, 'Accounting' PERIOD_SET_NAME, period_year PERIOD_NAME, year_start_date START_DATE, (SELECT A.END_DATE FROM MSC_BIS_PERIODS A WHERE A.ORGANIZATION_ID = B.ORGANIZATION_ID AND A.SR_INSTANCE_ID = B.SR_INSTANCE_ID AND A.PERIOD_SET_NAME = 'Accounting' AND A.PERIOD_YEAR = B.PERIOD_YEAR AND A.PERIOD_NUM = 12) END_DATE, period_year, sr_instance_id||'-'||organization_id ORGANIZATION_ID, 'ORGANIZATION' ORGANIZATION_TYPE FROM MSC_BIS_PERIODS B WHERE PERIOD_SET_NAME = 'Accounting'

View Text - HTML Formatted

SELECT DISTINCT SR_INSTANCE_ID||'-'|| ORGANIZATION_ID||'-'||PERIOD_YEAR ID
, PERIOD_YEAR VALUE
, 'ACCOUNTING' PERIOD_SET_NAME
, PERIOD_YEAR PERIOD_NAME
, YEAR_START_DATE START_DATE
, (SELECT A.END_DATE
FROM MSC_BIS_PERIODS A
WHERE A.ORGANIZATION_ID = B.ORGANIZATION_ID
AND A.SR_INSTANCE_ID = B.SR_INSTANCE_ID
AND A.PERIOD_SET_NAME = 'ACCOUNTING'
AND A.PERIOD_YEAR = B.PERIOD_YEAR
AND A.PERIOD_NUM = 12) END_DATE
, PERIOD_YEAR
, SR_INSTANCE_ID||'-'||ORGANIZATION_ID ORGANIZATION_ID
, 'ORGANIZATION' ORGANIZATION_TYPE
FROM MSC_BIS_PERIODS B
WHERE PERIOD_SET_NAME = 'ACCOUNTING'