APPS.BIS_SUBMIT_REQUESTSET dependencies on BIS_OBJ_DEPENDENCY

Line 140: bis_obj_dependency

136: depend_object_type,
137: depend_object_owner,
138: enabled_flag
139: from
140: bis_obj_dependency
141: where enabled_flag='Y') obj
142: where depend_object_type='REPORT'
143: start with
144: obj.object_type ='PORTLET'

Line 381: bis_obj_dependency

377: depend_object_type,
378: depend_object_owner,
379: enabled_flag
380: from
381: bis_obj_dependency
382: where enabled_flag='Y')obj
383: start with obj.object_type =p_object_type and obj.object_name=p_object_name
384: connect by prior obj.DEPEND_OBJECT_NAME=obj.object_name
385: and prior obj.DEPEND_OBJECT_TYPE=obj.object_type

Line 583: bis_obj_dependency

579: depend_object_type,
580: depend_object_owner,
581: enabled_flag
582: from
583: bis_obj_dependency
584: where enabled_flag='Y') obj
585: where depend_object_type in ('REPORT','PORTLET')
586: start with
587: obj.object_type ='PAGE'

Line 1005: bis_obj_dependency

1001: depend_object_type,
1002: depend_object_owner,
1003: enabled_flag
1004: from
1005: bis_obj_dependency
1006: where enabled_flag='Y') obj
1007: start with
1008: obj.object_type =p_obj_type
1009: and obj.object_name=p_obj_name

Line 1210: FROM bis_obj_dependency obj

1206: SELECT request_set_name --request set for dashboard that has this report
1207: FROM bis_request_set_objects
1208: WHERE object_name IN (
1209: SELECT DISTINCT obj.OBJECT_NAME
1210: FROM bis_obj_dependency obj
1211: WHERE object_type IN ('PAGE') AND enabled_flag='Y'
1212: START WITH obj.depend_object_type IN ('REPORT','PORTLET')
1213: AND obj.depend_object_name= p_obj_name
1214: CONNECT BY PRIOR obj.OBJECT_NAME=obj.depend_object_name