[Home] [Help]
View: BIL_DIMV_PERIODS
| Product: | BIL - Sales Intelligence (Obsolete) |
|---|
| Description: | Accounting periods view |
|---|
| Implementation/DBA Data: |
Not implemented in this database
|
|---|
View Text
SELECT PER.PERIOD_SET_NAME
, PER.PERIOD_NAME
, PER.PERIOD_TYPE
, PER.PERIOD_NUM
, PER.QUARTER_NUM
, PER.PERIOD_YEAR
, PER.START_DATE
, PER.END_DATE
, PER.DESCRIPTION
, PER.ADJUSTMENT_PERIOD_FLAG
FROM GL_PERIODS PER
WHERE PER.PERIOD_SET_NAME = JTF_BIS_UTIL.PROFILEVALUE('CRMBIS:PERIOD_SET_NAME')
AND PER.PERIOD_TYPE IN ( JTF_BIS_UTIL.PROFILEVALUE('CRMBIS:PERIOD_TYPE')
, 'QUARTER'
, 'YEAR')
AND PER.ADJUSTMENT_PERIOD_FLAG = 'N' WITH READ ONLY
Columns
| Name |
| PERIOD_SET_NAME_PK |
| PERIOD_NAME_PK |
| PERIOD_TYPE |
| PERIOD_NUM |
| QUARTER_NUM |
| PERIOD_YEAR |
| START_DATE |
| END_DATE |
| DESCRIPTION |
| ADJUSTMENT_PERIOD_FLAG |