ATK_KRH_HIERARCHY_INTRSCT_L_VL

Details

• Schema: FUSION

• Object owner: ATK

• Object type: VIEW

Columns

Name
CHILD_ITEM_ID PARENT_ITEM_ID NAME CHILD_HIERARCHY_TYPE LANGUAGE ICON_FILE_NAME TOPIC_RELEASES TOPIC_COUNT TOPIC_COUNT_FAQ

Query

SQL_Statement

SELECT b.item_id child_item_id, i.parent_item_id parent_item_id, t.name, b.HIERARCHY_TYPE Child_HIERARCHY_TYPE , t.language, b.icon_file_name, b.topic_releases, i.topic_count, i.topic_count_faq FROM atk_krh_hierarchy_items b, atk_krh_hierarchy_items_tl t, atk_krh_hierarchy_intersection i WHERE b.item_id = i.child_item_id AND b.item_id = t.item_id UNION SELECT b.item_id child_item_id, b.HIERARCHY_TYPE parent_item_id, t.name, b.HIERARCHY_TYPE Child_HIERARCHY_TYPE , t.language, b.icon_file_name, b.topic_releases, b.topic_count, b.topic_count_faq FROM atk_krh_hierarchy_items b, atk_krh_hierarchy_items_tl t WHERE b.item_id not in (SELECT c.child_item_id FROM atk_krh_hierarchy_intersection c) AND b.item_id = t.item_id UNION SELECT b.item_id child_item_id, b.HIERARCHY_TYPE parent_item_id, t.name, b.HIERARCHY_TYPE Child_HIERARCHY_TYPE , t.language, b.icon_file_name, b.topic_releases, b.topic_count, b.topic_count_faq FROM atk_krh_hierarchy_items b, atk_krh_hierarchy_items_tl t WHERE b.item_id = t.item_id AND b.HIERARCHY_TYPE = 'OUR'