Product: | IGC - Contract Commitment |
---|---|
Description: | |
Implementation/DBA Data: | APPS.IGC_CC_PERIODS_V |
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'