VIEW: APPS.CN_PERIODS_ALL_V

Source

View Text - Preformatted

SELECT gl.application_id, gl.set_of_books_id, gl.period_name, gl.last_update_date, gl.last_updated_by, gl.closing_status, gl.start_date, gl.end_date, gl.period_type, gl.period_year, gl.period_num, gl.quarter_num, gl.adjustment_period_flag, gl.creation_date, gl.created_by, gl.last_update_login, gl.attribute1, gl.attribute2, gl.attribute3, gl.attribute4, gl.attribute5, gl.context, cn.period_id, cn.period_type_id, cn.period_status, cn.processing_status_code, cn.freeze_flag, lk.meaning, cn.forecast_flag FROM GL_PERIOD_STATUSES GL,CN_PERIOD_STATUSES CN,CN_REPOSITORIES RP,GL_LOOKUPS LK WHERE gl.period_name = cn.period_name(+) AND gl.application_id = 283 AND rp.application_id = 283 AND gl.set_of_books_id = rp.set_of_books_id AND gl.adjustment_period_flag = 'N' AND lk.lookup_type = 'CLOSING_STATUS' AND lk.lookup_code = gl.closing_status

View Text - HTML Formatted

SELECT GL.APPLICATION_ID
, GL.SET_OF_BOOKS_ID
, GL.PERIOD_NAME
, GL.LAST_UPDATE_DATE
, GL.LAST_UPDATED_BY
, GL.CLOSING_STATUS
, GL.START_DATE
, GL.END_DATE
, GL.PERIOD_TYPE
, GL.PERIOD_YEAR
, GL.PERIOD_NUM
, GL.QUARTER_NUM
, GL.ADJUSTMENT_PERIOD_FLAG
, GL.CREATION_DATE
, GL.CREATED_BY
, GL.LAST_UPDATE_LOGIN
, GL.ATTRIBUTE1
, GL.ATTRIBUTE2
, GL.ATTRIBUTE3
, GL.ATTRIBUTE4
, GL.ATTRIBUTE5
, GL.CONTEXT
, CN.PERIOD_ID
, CN.PERIOD_TYPE_ID
, CN.PERIOD_STATUS
, CN.PROCESSING_STATUS_CODE
, CN.FREEZE_FLAG
, LK.MEANING
, CN.FORECAST_FLAG
FROM GL_PERIOD_STATUSES GL
, CN_PERIOD_STATUSES CN
, CN_REPOSITORIES RP
, GL_LOOKUPS LK
WHERE GL.PERIOD_NAME = CN.PERIOD_NAME(+)
AND GL.APPLICATION_ID = 283
AND RP.APPLICATION_ID = 283
AND GL.SET_OF_BOOKS_ID = RP.SET_OF_BOOKS_ID
AND GL.ADJUSTMENT_PERIOD_FLAG = 'N'
AND LK.LOOKUP_TYPE = 'CLOSING_STATUS'
AND LK.LOOKUP_CODE = GL.CLOSING_STATUS