Product: | PMI - Process Manufacturing Intelligence (Obsolete) |
---|---|
Description: | View to get GL Calendar Period, Quarter and Year level data from GL Periods |
Implementation/DBA Data: | APPS.PMI_GL_TIME_V |
SELECT SOB.NAME SET_OF_BOOKS_NAME
, YR.PERIOD_NAME YEAR_NAME
, YR.START_DATE YEAR_START_DATE
, YR.END_DATE YEAR_END_DATE
, QTR.PERIOD_NAME QUARTER_NAME
, QTR.START_DATE QUARTER_START_DATE
, QTR.END_DATE QUARTER_END_DATE
, PRD.PERIOD_SET_NAME PERIOD_SET_NAME
, PRD.PERIOD_NAME PERIOD_NAME
, PRD.START_DATE PERIOD_START_DATE
, PRD.END_DATE PERIOD_END_DATE
, PRD.PERIOD_NUM
, PRD.QUARTER_NUM
, PRD.PERIOD_YEAR
, PRD.PERIOD_SET_NAME||'+' ||YR.PERIOD_NAME YEAR_ID
, PRD.PERIOD_SET_NAME||'+' ||QTR.PERIOD_NAME QUARTER_ID
, PRD.PERIOD_SET_NAME||'+' ||PRD.PERIOD_NAME PERIOD_ID
FROM GL_PERIODS PRD
, GL_PERIODS QTR
, GL_PERIODS YR
, GL_SETS_OF_BOOKS SOB
WHERE PRD.PERIOD_SET_NAME = QTR.PERIOD_SET_NAME
AND PRD.PERIOD_YEAR = QTR.PERIOD_YEAR
AND PRD.QUARTER_NUM = QTR.PERIOD_NUM
AND QTR.PERIOD_TYPE = 'QUARTER'
AND QTR.PERIOD_YEAR = YR.PERIOD_YEAR
AND QTR.PERIOD_SET_NAME = YR.PERIOD_SET_NAME
AND YR.PERIOD_TYPE = 'YEAR'
AND SOB.PERIOD_SET_NAME = PRD.PERIOD_SET_NAME
AND SOB.ACCOUNTED_PERIOD_TYPE =PRD.PERIOD_TYPE
AND PRD.ADJUSTMENT_PERIOD_FLAG <> 'Y'
AND QTR.ADJUSTMENT_PERIOD_FLAG <> 'Y'
AND YR.ADJUSTMENT_PERIOD_FLAG <> 'Y'