[Home] [Help]
View: OKX_GL_PERIODS_ORG_V
View Text
SELECT ORU.ORGANIZATION_ID
, ORU.NAME
, GPD.PERIOD_SET_NAME
, GPD.PERIOD_NAME
, GPD.START_DATE
, GPD.END_DATE
, GPD.PERIOD_TYPE
, GPD.PERIOD_YEAR
, GPD.PERIOD_NUM
, GPD.QUARTER_NUM
FROM GL_PERIODS GPD
, GL_SETS_OF_BOOKS_11I SOB
, HR_ALL_ORGANIZATION_UNITS ORU
, HR_ORGANIZATION_INFORMATION ORI
WHERE GPD.PERIOD_SET_NAME = SOB.PERIOD_SET_NAME
AND GPD.PERIOD_TYPE = SOB.ACCOUNTED_PERIOD_TYPE
AND SOB.SET_OF_BOOKS_ID = ORI.ORG_INFORMATION3
AND ORI.ORG_INFORMATION_CONTEXT = 'OPERATING UNIT INFORMATION'
AND ORI.ORGANIZATION_ID = ORU.ORGANIZATION_ID
Columns
| Name |
| ORGANIZATION_ID |
| ORGANIZATION_NAME |
| PERIOD_SET_NAME |
| PERIOD_NAME |
| START_DATE |
| END_DATE |
| PERIOD_TYPE |
| PERIOD_YEAR |
| PERIOD_NUM |
| QUARTER_NUM |
APPS.OKX_GL_PERIODS_ORG_V