Product: | PA - Projects |
---|---|
Description: | - Retrofitted |
Implementation/DBA Data: | APPS.PA_ADW_PERIODS_B_V |
SELECT GLP.PERIOD_NAME || '-'||GLB.SET_OF_BOOKS_ID PA_PERIOD_KEY
, GLP.PERIOD_NAME PA_PERIOD
, GLP.START_DATE PA_PERIO_START_DATE
, GLP.END_DATE PA_PERIO_END_DATE
, GLP2.PERIOD_NAME GL_PERIOD
, GLP2.START_DATE GL_PERIO_START_DATE
, GLP2.END_DATE GL_PERIO_END_DATE
, 'Q' || GLP2.QUARTER_NUM || '-' || GLP2.PERIOD_YEAR FINANCIAL_QUARTER
, GLP2.PERIOD_YEAR FINANCIAL_YEAR
, PL.MEANING
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
FROM GL_PERIODS GLP
, GL_PERIODS GLP2
, GL_SETS_OF_BOOKS GLB
, PA_LOOKUPS PL
WHERE GLP.PERIOD_SET_NAME = GLB.PERIOD_SET_NAME
AND GLP2.PERIOD_SET_NAME = GLB.PERIOD_SET_NAME
AND GLP2.PERIOD_TYPE = GLB.ACCOUNTED_PERIOD_TYPE
AND GLP.END_DATE BETWEEN GLP2.START_DATE
AND GLP2.END_DATE
AND GLP.ADJUSTMENT_PERIOD_FLAG = 'N'
AND GLP2.ADJUSTMENT_PERIOD_FLAG = 'N'
AND (GLB.SET_OF_BOOKS_ID
, GLP.PERIOD_TYPE) IN (SELECT SET_OF_BOOKS_ID
, PA_PERIOD_TYPE
FROM PA_IMPLEMENTATIONS )
AND PL.LOOKUP_TYPE = 'ADW DIM LEVEL NAME'
AND PL.LOOKUP_CODE = 'ALL_FINANCIAL_YEARS'