View: EDW_CDI_DIM_MISSING_KEYS_S

Product:	BIS - Applications BIS
Description:	EDW_CDI_DIM_MISSING_KEYS_S
Implementation/DBA Data:	APPS.EDW_CDI_DIM_MISSING_KEYS_S

View Text

SELECT EDW_CDI_DIM_MISSING_KEYS.DIM_ID
, EDW_CDI_DIM_MISSING_KEYS.FACT_ID
, EDW_CDI_DIM_MISSING_KEYS.KEY_VALUE
, EDW_CDI_DIM_MISSING_KEYS.NUMBER_KEY_VALUE
, EDW_CDI_DIM_MISSING_KEYS.INSTANCE
, EDW_CDI_DIM_MISSING_KEYS.MISSING_DATE
, EDW_TIME_MONTH_LTC.MONTH_PK_KEY MONTH_FK
, EDW_TIME_YEAR_LTC.YEAR_PK_KEY YEAR_FK
FROM EDW_CDI_DIM_MISSING_KEYS
, EDW_TIME_MONTH_LTC
, EDW_TIME_YEAR_LTC
, EDW_TIME_HALF_MONTH_LTC
, EDW_TIME_DAY_LTC
, EDW_TIME_QTR_LTC
, EDW_TIME_HALF_YEAR_LTC
WHERE EDW_TIME_DAY_LTC.DAY_PK_KEY=EDW_CDI_DIM_MISSING_KEYS.MISSING_DATE
AND EDW_TIME_DAY_LTC.HALF_MONTH_FK_KEY=EDW_TIME_HALF_MONTH_LTC.HALF_MONTH_PK_KEY
AND EDW_TIME_HALF_MONTH_LTC.MONTH_FK_KEY=EDW_TIME_MONTH_LTC.MONTH_PK_KEY
AND EDW_TIME_MONTH_LTC.QTR_FK_KEY=EDW_TIME_QTR_LTC.QTR_PK_KEY
AND EDW_TIME_QTR_LTC.HALF_YEAR_FK_KEY=EDW_TIME_HALF_YEAR_LTC.HALF_YEAR_PK_KEY
AND EDW_TIME_HALF_YEAR_LTC.YEAR_FK_KEY=EDW_TIME_YEAR_LTC.YEAR_PK_KEY

Columns