[Home] [Help]
View: OPI_OPM_GL_CALENDAR_V
Product: | OPI - Operations Intelligence (Obsolete) |
Description: | This view gives Oracle General Ledger calendar data for Oracle Process Manufacturing Companies |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT CO_CODE
, PERIOD_TYPE
, PERIOD_YEAR
, QUARTER_NUM
, PERIOD_NUM
, PERIOD_NAME
, START_DATE
, END_DATE
, GL_COST_MTHD
FROM GL_PERIODS GP
, GL_SETS_OF_BOOKS GSB
, GL_PLCY_MST GPM
WHERE GP.PERIOD_SET_NAME =GSB.PERIOD_SET_NAME
AND GSB.NAME=GPM.SET_OF_BOOKS_NAME
AND GP.PERIOD_TYPE=GSB.ACCOUNTED_PERIOD_TYPE
AND GP.ADJUSTMENT_PERIOD_FLAG <>'Y'
Columns
Name |
CO_CODE |
PERIOD_TYPE |
PERIOD_YEAR |
QUARTER_NUM |
PERIOD_NUM |
PERIOD_NAME |
START_DATE |
END_DATE |
GL_COST_MTHD |