[Home] [Help]
134: IS
135: SELECT gcr.child_entity_id,
136: feb.entity_display_code child_entity_display_code,
137: fea.dim_attribute_varchar_member child_entity_type_code
138: FROM gcs_cons_relationships gcr,
139: fem_entities_b feb,
140: fem_entities_attr fea
141: WHERE gcr.hierarchy_id = p_hierarchy_id
142: AND gcr.parent_entity_id = p_entity_id