VIEW: APPS.ISC_MSC_BIS_QUARTERS_V

Source

View Text - Preformatted

SELECT DISTINCT sr_instance_id||'-'|| organization_id||'-'||period_year||'-'||quarter_num ID, 'Quarter '||quarter_num||', '||period_year VALUE, 'Accounting' PERIOD_SET_NAME, 'QTR '||quarter_num||period_year PERIOD_NAME, quarter_start_date START_DATE, (SELECT MAX(A.END_DATE) 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.QUARTER_NUM = B.QUARTER_NUM) 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||'-'||QUARTER_NUM ID
, 'QUARTER '||QUARTER_NUM||'
, '||PERIOD_YEAR VALUE
, 'ACCOUNTING' PERIOD_SET_NAME
, 'QTR '||QUARTER_NUM||PERIOD_YEAR PERIOD_NAME
, QUARTER_START_DATE START_DATE
, (SELECT MAX(A.END_DATE) 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.QUARTER_NUM = B.QUARTER_NUM) END_DATE
, PERIOD_YEAR
, SR_INSTANCE_ID||'-'||ORGANIZATION_ID ORGANIZATION_ID
, 'ORGANIZATION' ORGANIZATION_TYPE
FROM MSC_BIS_PERIODS B
WHERE PERIOD_SET_NAME = 'ACCOUNTING'