37:
38: -- Get fact physical name
39:
40: select distinct fact_name into fact_short_name
41: from edw_sec_fact_info_t
42: where fact_long_name = fact_table_name;
43:
44: -- Get object owner
45:
122:
123: -- Get fact physical name
124:
125: select distinct fact_name into fact_short_name
126: from edw_sec_fact_info_t
127: where fact_long_name = fact_table_name;
128:
129: -- Get object owner
130:
213:
214: -- Get fact physical name
215:
216: select distinct fact_name into fact_short_name
217: from edw_sec_fact_info_t
218: where fact_long_name = fact_table_name;
219:
220: -- Get object owner
221:
298:
299: -- Get fact physical name
300:
301: select distinct fact_name into fact_short_name
302: from edw_sec_fact_info_t
303: where fact_long_name = fact_table_name;
304:
305:
306: -- Get object owner