VIEW: APPS.FEM_DATA_LOCATIONS

Source

View Text - Preformatted

SELECT ledger_id, cal_period_id, dataset_code, source_system_code, table_name, MAX(balance_type_code) balance_type_code, DECODE(1,max(avg_balances),'Y','N') avg_balances_flag, MAX(load_status) KEEP (DENSE_RANK FIRST ORDER BY last_update_date DESC) load_status, MAX(last_update_date) last_update_date FROM fem_dl_dimensions GROUP BY ledger_id,cal_period_id,dataset_code,source_system_code,table_name

View Text - HTML Formatted

SELECT LEDGER_ID
, CAL_PERIOD_ID
, DATASET_CODE
, SOURCE_SYSTEM_CODE
, TABLE_NAME
, MAX(BALANCE_TYPE_CODE) BALANCE_TYPE_CODE
, DECODE(1
, MAX(AVG_BALANCES)
, 'Y'
, 'N') AVG_BALANCES_FLAG
, MAX(LOAD_STATUS) KEEP (DENSE_RANK FIRST ORDER BY LAST_UPDATE_DATE DESC) LOAD_STATUS
, MAX(LAST_UPDATE_DATE) LAST_UPDATE_DATE
FROM FEM_DL_DIMENSIONS GROUP BY LEDGER_ID
, CAL_PERIOD_ID
, DATASET_CODE
, SOURCE_SYSTEM_CODE
, TABLE_NAME