VIEW: APPS.PMI_GL_TIME_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'