VIEW: APPS.CN_PERIODS

Source

View Text - Preformatted

SELECT gl.application_id , gl.set_of_books_id , gl.period_name , 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.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 , gl.creation_date ,gl.created_by ,gl.last_update_date ,gl.last_updated_by ,gl.last_update_login ,cn.org_id FROM GL_LOOKUPS LK, GL_PERIOD_STATUSES GL, CN_PERIOD_STATUSES CN, CN_REPOSITORIES_ALL RP 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 AND cn.org_id = rp.org_id AND cn.period_id IS NOT NULL

View Text - HTML Formatted

SELECT GL.APPLICATION_ID
, GL.SET_OF_BOOKS_ID
, GL.PERIOD_NAME
, 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.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
, GL.CREATION_DATE
, GL.CREATED_BY
, GL.LAST_UPDATE_DATE
, GL.LAST_UPDATED_BY
, GL.LAST_UPDATE_LOGIN
, CN.ORG_ID
FROM GL_LOOKUPS LK
, GL_PERIOD_STATUSES GL
, CN_PERIOD_STATUSES CN
, CN_REPOSITORIES_ALL RP
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
AND CN.ORG_ID = RP.ORG_ID
AND CN.PERIOD_ID IS NOT NULL