eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.PA_ADW_PERIODS_B_V

Source

View Text - Preformatted


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'

View Text - HTML Formatted

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'