VIEW: APPS.GL_PERIOD_STATUSES_V

Source

View Text - Preformatted

SELECT gps.ROWID ROW_ID, gps.APPLICATION_ID APPLICATION_ID, gps.LEDGER_ID LEDGER_ID, gps.LEDGER_ID SET_OF_BOOKS_ID, gps.PERIOD_NAME PERIOD_NAME, gps.LAST_UPDATE_DATE LAST_UPDATE_DATE, gps.LAST_UPDATED_BY LAST_UPDATED_BY, gps.CLOSING_STATUS CLOSING_STATUS, glps.SHOW_STATUS SHOW_STATUS, gps.START_DATE START_DATE, gps.END_DATE END_DATE, gps.PERIOD_TYPE PERIOD_TYPE, gps.PERIOD_YEAR PERIOD_YEAR, gps.PERIOD_NUM PERIOD_NUM, gps.CREATION_DATE CREATION_DATE, gps.CREATED_BY CREATED_BY, gps.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, gps.ATTRIBUTE1 ATTRIBUTE1, gps.ATTRIBUTE2 ATTRIBUTE2, gps.ATTRIBUTE3 ATTRIBUTE3, gps.ATTRIBUTE4 ATTRIBUTE4, gps.ATTRIBUTE5 ATTRIBUTE5, gps.CONTEXT CONTEXT, gps.QUARTER_NUM QUARTER_NUM, gps.ADJUSTMENT_PERIOD_FLAG ADJUSTMENT_PERIOD_FLAG FROM gl_lookups_period_statuses_v glps, gl_period_statuses gps WHERE gps.closing_status = glps.status_flag

View Text - HTML Formatted

SELECT GPS.ROWID ROW_ID
, GPS.APPLICATION_ID APPLICATION_ID
, GPS.LEDGER_ID LEDGER_ID
, GPS.LEDGER_ID SET_OF_BOOKS_ID
, GPS.PERIOD_NAME PERIOD_NAME
, GPS.LAST_UPDATE_DATE LAST_UPDATE_DATE
, GPS.LAST_UPDATED_BY LAST_UPDATED_BY
, GPS.CLOSING_STATUS CLOSING_STATUS
, GLPS.SHOW_STATUS SHOW_STATUS
, GPS.START_DATE START_DATE
, GPS.END_DATE END_DATE
, GPS.PERIOD_TYPE PERIOD_TYPE
, GPS.PERIOD_YEAR PERIOD_YEAR
, GPS.PERIOD_NUM PERIOD_NUM
, GPS.CREATION_DATE CREATION_DATE
, GPS.CREATED_BY CREATED_BY
, GPS.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, GPS.ATTRIBUTE1 ATTRIBUTE1
, GPS.ATTRIBUTE2 ATTRIBUTE2
, GPS.ATTRIBUTE3 ATTRIBUTE3
, GPS.ATTRIBUTE4 ATTRIBUTE4
, GPS.ATTRIBUTE5 ATTRIBUTE5
, GPS.CONTEXT CONTEXT
, GPS.QUARTER_NUM QUARTER_NUM
, GPS.ADJUSTMENT_PERIOD_FLAG ADJUSTMENT_PERIOD_FLAG
FROM GL_LOOKUPS_PERIOD_STATUSES_V GLPS
, GL_PERIOD_STATUSES GPS
WHERE GPS.CLOSING_STATUS = GLPS.STATUS_FLAG