[Home] [Help]
574: (SELECT
575: sys_connect_by_path(BUSINESS_OBJECT_CODE, '/') node_path,
576: LEVEL lvl, CONNECT_BY_ISLEAF isleaf,
577: BUSINESS_OBJECT_CODE bo_code, CHILD_BO_CODE,ENTITY_NAME, root_node_flag
578: FROM hz_bus_obj_definitions
579: START WITH BUSINESS_OBJECT_CODE = c_p_bo_code AND
580: user_mandated_flag = 'Y'
581: CONNECT BY PRIOR CHILD_BO_CODE = BUSINESS_OBJECT_CODE AND
582: user_mandated_flag = 'Y'