[Home] [Help]
129: ------------------------
130: -- Standard Types --
131: ------------------------
132: DEF_OBJECT_ID FEM_OBJECT_CATALOG_B.OBJECT_ID%TYPE;
133: DEF_OBJ_DEF_ID FEM_OBJECT_DEFINITION_B.OBJECT_DEFINITION_ID%TYPE;
134: DEF_OBJECT_NAME FEM_OBJECT_CATALOG_VL.OBJECT_NAME%TYPE;
135: DEF_FOLDER_NAME FEM_FOLDERS_VL.FOLDER_NAME%TYPE;
136:
137: ------------------------
308: ||',d.table_name as FACT_TABLE_NAME'
309: ||' from'
310: ||' fem_cond_components a'
311: ||',fem_object_catalog_b b'
312: ||',fem_object_definition_b c1'
313: ||',fem_cond_data_cmp_tables d'
314: ||' where'
315: ||' a.condition_obj_def_id = :Cond_Obj_Def_ID '
316: ||' and b.object_id = a.cond_component_obj_id'
329: ||',d.table_name as FACT_TABLE_NAME'
330: ||' from'
331: ||' fem_cond_components a'
332: ||',fem_object_catalog_b b'
333: ||',fem_object_definition_b c1'
334: ||',fem_cond_data_cmp_tables d'
335: ||' where'
336: ||' a.condition_obj_def_id = :Cond_Obj_Def_ID '
337: ||' and b.object_id = a.cond_component_obj_id'
350: ||' c1.object_type_code AS COMPONENT_TYPE_CODE,'
351: ||' NULL AS FACT_TABLE_NAME'
352: ||' FROM fem_cond_components a,'
353: ||' fem_object_catalog_b c,'
354: ||' fem_object_definition_b d,'
355: ||' fem_object_catalog_b c1,'
356: ||' fem_object_definition_b d1'
357: ||' where a.condition_obj_def_id = :condition_obj_def_id'
358: ||' and a.condition_obj_def_id = d.object_definition_id'
352: ||' FROM fem_cond_components a,'
353: ||' fem_object_catalog_b c,'
354: ||' fem_object_definition_b d,'
355: ||' fem_object_catalog_b c1,'
356: ||' fem_object_definition_b d1'
357: ||' where a.condition_obj_def_id = :condition_obj_def_id'
358: ||' and a.condition_obj_def_id = d.object_definition_id'
359: ||' and c.object_id = d.object_id'
360: ||' and a.cond_component_obj_id = c1.object_id'