View: IGCFV_CC_PERIODS

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

View Text

SELECT '_LA:CC_PERIOD_STATUS:FND_LOOKUPS:IGC_CC_PERIOD_STATUS:MEANING' "_LA:PERIOD_STATUS"
, ORU.NAME ORGANIZATION_NAME
, CCP.PERIOD_NAME PERIOD_NAME
, CCP.PERIOD_SET_NAME PERIOD_SET_NAME
, CCP.ORG_ID ORGANIZATION_ID
, CCP.LAST_UPDATE_DATE LAST_UPDATE_DATE
, CCP.LAST_UPDATED_BY LAST_UPDATED_BY
, CCP.CREATION_DATE CREATION_DATE
, CCP.CREATED_BY CREATED_BY
FROM IGC_CC_PERIODS CCP
, HR_ALL_ORGANIZATION_UNITS ORU
, GL_PERIODS GL_PERIODS
WHERE CCP.ORG_ID=ORU.ORGANIZATION_ID
AND CCP.PERIOD_NAME=GL_PERIODS.PERIOD_NAME
AND '_SEC:CCP.ORG_ID' IS NOT NULL WITH READ ONLY

Columns