View: PA_PERIODS_V

Product:	PA - Projects
Description:	10Sc Only
Implementation/DBA Data:	APPS.PA_PERIODS_V

View Text

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

Columns