FND Design Data [Home] [Help]

View: OKL_PERIOD_STATUSES_UV

Product: OKL - Lease and Finance Management
Description:
Implementation/DBA Data: ViewAPPS.OKL_PERIOD_STATUSES_UV
View Text

SELECT GPS.ROWID ROW_ID
, GPS.APPLICATION_ID APPLICATION_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
, OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('CLOSING_STATUS'
, GPS.CLOSING_STATUS
, 101
, 101) 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_PERIOD_STATUSES GPS
WHERE APPLICATION_ID = 540
AND LEDGER_ID = OKL_ACCOUNTING_UTIL.GET_SET_OF_BOOKS_ID
AND NVL(ADJUSTMENT_PERIOD_FLAG
, 'N') = 'N'

Columns

Name
ROW_ID
APPLICATION_ID
SET_OF_BOOKS_ID
PERIOD_NAME
LAST_UPDATE_DATE
LAST_UPDATED_BY
CLOSING_STATUS
SHOW_STATUS
START_DATE
END_DATE
PERIOD_TYPE
PERIOD_YEAR
PERIOD_NUM
CREATION_DATE
CREATED_BY
LAST_UPDATE_LOGIN
ATTRIBUTE1
ATTRIBUTE2
ATTRIBUTE3
ATTRIBUTE4
ATTRIBUTE5
CONTEXT
QUARTER_NUM
ADJUSTMENT_PERIOD_FLAG