APPS.FEM_CONDITIONS_API dependencies on FEM_OBJECT_CATALOG_B

Line 132: DEF_OBJECT_ID FEM_OBJECT_CATALOG_B.OBJECT_ID%TYPE;

128:
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:

Line 311: ||',fem_object_catalog_b b'

307: ||',b.object_type_code as COMPONENT_TYPE_CODE'
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 '

Line 332: ||',fem_object_catalog_b b'

328: ||',b.object_type_code as COMPONENT_TYPE_CODE'
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 '

Line 353: ||' fem_object_catalog_b c,'

349: ||' d1.object_definition_id AS COMPONENT_OBJ_DEF_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'

Line 355: ||' fem_object_catalog_b c1,'

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'
359: ||' and c.object_id = d.object_id'