View: CST_PAC_PERIODS_V

Product:	BOM - Bills of Material
Description:	Stores information about open and closed periods
Implementation/DBA Data:	APPS.CST_PAC_PERIODS_V

View Text

SELECT CPP.ROWID ROW_ID
, 'PAC_PERIOD' REC_TYPE
, CPP.LEGAL_ENTITY LEGAL_ENTITY
, CPP.COST_TYPE_ID COST_TYPE_ID
, CPP.PAC_PERIOD_ID PAC_PERIOD_ID
, NULL PERIOD_TYPE
, CPP.PERIOD_SET_NAME PERIOD_SET_NAME
, ML.LOOKUP_CODE STATUS_CODE
, ML.MEANING STATUS
, CPP.PERIOD_NAME PERIOD_NAME
, CPP.PERIOD_NUM PERIOD_NUM
, CPP.PERIOD_YEAR PERIOD_YEAR
, CPP.PERIOD_START_DATE START_DATE
, CPP.PERIOD_END_DATE END_DATE
, CPP.PERIOD_CLOSE_DATE CLOSE_DATE
, CPP.LAST_UPDATE_DATE LAST_UPDATE_DATE
, CPP.LAST_UPDATED_BY LAST_UPDATED_BY
, CPP.CREATION_DATE CREATION_DATE
, CPP.CREATED_BY CREATED_BY
, CPP.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM CST_PAC_PERIODS CPP
, MFG_LOOKUPS ML
WHERE ML.LOOKUP_TYPE(+) = 'CST_PAC_PERIOD_STATUS'
AND ML.ENABLED_FLAG(+) = 'Y'
AND ML.LOOKUP_CODE(+) = DECODE(NVL(CPP.PERIOD_CLOSE_DATE
, SYSDATE)
, CPP.PERIOD_CLOSE_DATE
, DECODE(CPP.OPEN_FLAG
, 'N'
, 4
, 'Y'
, 3
, 'P'
, 1
, 3)
, 2 ) UNION SELECT GP.ROWID ROW_ID
, 'GL_PERIOD' REC_TYPE
, 0 LEGAL_ENTITY
, 0 COST_TYPE_ID
, 0 PAC_PERIOD_ID
, GP.PERIOD_TYPE PERIOD_TYPE
, GP.PERIOD_SET_NAME PERIOD_SET_NAME
, ML.LOOKUP_CODE STATUS_CODE
, ML.MEANING STATUS
, GP.PERIOD_NAME PERIOD_NAME
, GP.PERIOD_NUM PERIOD_NUMBER
, GP.PERIOD_YEAR PERIOD_YEAR
, GP.START_DATE START_DATE
, GP.END_DATE END_DATE
, TO_DATE(NULL) CLOSE_DATE
, GP.LAST_UPDATE_DATE LAST_UPDATE_DATE
, GP.LAST_UPDATED_BY LAST_UPDATED_BY
, GP.CREATION_DATE CREATION_DATE
, GP.CREATED_BY CREATED_BY
, GP.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM GL_PERIODS GP
, MFG_LOOKUPS ML
WHERE ( GP.ADJUSTMENT_PERIOD_FLAG = 'N')
AND ML.LOOKUP_TYPE(+) = 'CST_PAC_PERIOD_STATUS'
AND ML.ENABLED_FLAG(+) = 'Y'
AND ML.LOOKUP_CODE (+) = 5

Columns