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_PERIODS_COPY_V

Source

View Text - Preformatted


SELECT GLP.PERIOD_NAME , GLP.START_DATE , GLP.END_DATE , GLP2.PERIOD_NAME , GLB.SET_OF_BOOKS_ID , IMP.ORG_ID FROM GL_PERIODS GLP2, GL_PERIODS GLP, GL_SETS_OF_BOOKS GLB, PA_IMPLEMENTATIONS IMP WHERE GLB.SET_OF_BOOKS_ID = IMP.SET_OF_BOOKS_ID AND GLP.PERIOD_SET_NAME = IMP.PERIOD_SET_NAME AND GLB.PERIOD_SET_NAME = GLP2.PERIOD_SET_NAME AND GLP.PERIOD_TYPE = IMP.PA_PERIOD_TYPE 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 NOT EXISTS ( SELECT NULL FROM PA_PERIODS WHERE PERIOD_NAME = GLP.PERIOD_NAME )

View Text - HTML Formatted

SELECT GLP.PERIOD_NAME
, GLP.START_DATE
, GLP.END_DATE
, GLP2.PERIOD_NAME
, GLB.SET_OF_BOOKS_ID
, IMP.ORG_ID
FROM GL_PERIODS GLP2
, GL_PERIODS GLP
, GL_SETS_OF_BOOKS GLB
, PA_IMPLEMENTATIONS IMP
WHERE GLB.SET_OF_BOOKS_ID = IMP.SET_OF_BOOKS_ID
AND GLP.PERIOD_SET_NAME = IMP.PERIOD_SET_NAME
AND GLB.PERIOD_SET_NAME = GLP2.PERIOD_SET_NAME
AND GLP.PERIOD_TYPE = IMP.PA_PERIOD_TYPE
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 NOT EXISTS ( SELECT NULL
FROM PA_PERIODS
WHERE PERIOD_NAME = GLP.PERIOD_NAME )