View: IGC_CC_PERIODS_V

Product:	IGC - Contract Commitment
Description:
Implementation/DBA Data:	APPS.IGC_CC_PERIODS_V

View Text

SELECT CCP.ROWID ROW_ID
, CCP.ORG_ID
, CCP.PERIOD_SET_NAME
, CCP.PERIOD_NAME
, GLP.PERIOD_NUM
, GLP.PERIOD_YEAR
, GLP.START_DATE
, GLP.END_DATE
, CCP.CC_PERIOD_STATUS
, LKP.MEANING
, CCP.LAST_UPDATE_DATE
, CCP.LAST_UPDATED_BY
, CCP.LAST_UPDATE_LOGIN
, CCP.CREATION_DATE
, CCP.CREATED_BY FROM IGC_CC_PERIODS CCP
, GL_PERIODS GLP
, FND_LOOKUPS LKP WHERE CCP.PERIOD_SET_NAME = GLP.PERIOD_SET_NAME AND CCP.PERIOD_NAME = GLP.PERIOD_NAME
AND CCP.CC_PERIOD_STATUS = LKP.LOOKUP_CODE (+)
AND LKP.LOOKUP_TYPE (+) = 'IGC_CC_PERIOD_STATUS'

Columns