VIEW: APPS.PA_PERIODS_V

Source

View Text - Preformatted

SELECT PAP.ROWID ROW_ID , PAP.PERIOD_NAME , PAP.GL_PERIOD_NAME , PAP.CURRENT_PA_PERIOD_FLAG , PAP.START_DATE , PAP.END_DATE , PAP.STATUS , PAL.MEANING , PAP.LAST_UPDATE_DATE , PAP.LAST_UPDATED_BY , PAP.CREATION_DATE , PAP.CREATED_BY , PAP.LAST_UPDATE_LOGIN , GLP.START_DATE , GLP.END_DATE , GLP.QUARTER_NUM , GLP.PERIOD_YEAR , PAIMP.SET_OF_BOOKS_ID , PAP.ORG_ID FROM PA_PERIODS_ALL PAP, GL_PERIODS GLP, PA_IMPLEMENTATIONS PAIMP, GL_LEDGERS GLL, PA_LOOKUPS PAL WHERE PAP.GL_PERIOD_NAME = GLP.PERIOD_NAME AND GLP.PERIOD_SET_NAME = GLL.PERIOD_SET_NAME AND GLL.LEDGER_ID = PAIMP.SET_OF_BOOKS_ID AND GLP.ADJUSTMENT_PERIOD_FLAG = 'N' AND PAL.LOOKUP_TYPE = 'CLOSING STATUS' AND PAL.LOOKUP_CODE = PAP.STATUS AND PAIMP.ORG_ID = PAP.ORG_ID

View Text - HTML Formatted

SELECT PAP.ROWID ROW_ID
, PAP.PERIOD_NAME
, PAP.GL_PERIOD_NAME
, PAP.CURRENT_PA_PERIOD_FLAG
, PAP.START_DATE
, PAP.END_DATE
, PAP.STATUS
, PAL.MEANING
, PAP.LAST_UPDATE_DATE
, PAP.LAST_UPDATED_BY
, PAP.CREATION_DATE
, PAP.CREATED_BY
, PAP.LAST_UPDATE_LOGIN
, GLP.START_DATE
, GLP.END_DATE
, GLP.QUARTER_NUM
, GLP.PERIOD_YEAR
, PAIMP.SET_OF_BOOKS_ID
, PAP.ORG_ID
FROM PA_PERIODS_ALL PAP
, GL_PERIODS GLP
, PA_IMPLEMENTATIONS PAIMP
, GL_LEDGERS GLL
, PA_LOOKUPS PAL
WHERE PAP.GL_PERIOD_NAME = GLP.PERIOD_NAME
AND GLP.PERIOD_SET_NAME = GLL.PERIOD_SET_NAME
AND GLL.LEDGER_ID = PAIMP.SET_OF_BOOKS_ID
AND GLP.ADJUSTMENT_PERIOD_FLAG = 'N'
AND PAL.LOOKUP_TYPE = 'CLOSING STATUS'
AND PAL.LOOKUP_CODE = PAP.STATUS
AND PAIMP.ORG_ID = PAP.ORG_ID