VIEW: APPS.EDW_CDI_DIM_MISSING_KEYS_S

Source

View Text - Preformatted

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

View Text - HTML Formatted

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