DBA Data[Home] [Help]

APPS.BIS_BIA_RSG_PSTATE dependencies on BIS_OBJ_DEPENDENCY

Line 138: from bis_obj_dependency obj

134: select request_set_name from (select request_set_name --request set for dashboard that has this report
135: from bis_request_set_objects
136: where object_name in (
137: select Distinct obj.OBJECT_NAME
138: from bis_obj_dependency obj
139: where object_type in ('PAGE') and enabled_flag='Y'
140: start with
141: obj.depend_object_type ='REPORT'
142: and obj.depend_object_name=l_report_name

Line 378: from bis_obj_dependency obj where object_type in (''PAGE'') and enabled_flag=''Y''

374: FROM BIS_RS_RUN_HISTORY HISTORY WHERE
375: HISTORY.REQUEST_SET_NAME IN
376: (select request_set_name RS_NAME from (select request_set_name --request set for dashboard that has this report
377: from bis_request_set_objects where object_name in ( select Distinct obj.OBJECT_NAME
378: from bis_obj_dependency obj where object_type in (''PAGE'') and enabled_flag=''Y''
379: start with obj.depend_object_type =''REPORT'' and obj.depend_object_name=:CONTENT_NAME
380: connect by prior obj.OBJECT_NAME=obj.depend_object_name and
381: prior obj.OBJECT_TYPE=obj.depend_object_TYPE) and object_type =''PAGE'' union -- request set for report directly
382: select request_set_name RS_NAME from bis_request_set_objects

Line 401: from bis_obj_dependency obj where object_type in (''PAGE'') and enabled_flag=''Y''

397: WHERE
398: HISTORY.REQUEST_SET_NAME IN
399: (select request_set_name RS_NAME from (select request_set_name --request set for dashboard that has this report
400: from bis_request_set_objects where object_name in ( select Distinct obj.OBJECT_NAME
401: from bis_obj_dependency obj where object_type in (''PAGE'') and enabled_flag=''Y''
402: start with obj.depend_object_type =''REPORT'' and obj.depend_object_name=:CONTENT_NAME
403: connect by prior obj.OBJECT_NAME=obj.depend_object_name and
404: prior obj.OBJECT_TYPE=obj.depend_object_TYPE) and object_type =''PAGE'' union -- request set for report directly
405: select request_set_name RS_NAME from bis_request_set_objects

Line 424: from bis_obj_dependency obj where object_type in (''PAGE'') and enabled_flag=''Y''

420: FND_REQUEST_SETS FND
421: where
422: OBJECTS.REQUEST_SET_NAME in(select request_set_name RS_NAME from (select request_set_name --request set for dashboard that has this report
423: from bis_request_set_objects where object_name in ( select Distinct obj.OBJECT_NAME
424: from bis_obj_dependency obj where object_type in (''PAGE'') and enabled_flag=''Y''
425: start with obj.depend_object_type =''REPORT'' and obj.depend_object_name=:CONTENT_NAME
426: connect by prior obj.OBJECT_NAME=obj.depend_object_name and
427: prior obj.OBJECT_TYPE=obj.depend_object_TYPE) and object_type =''PAGE'' union -- request set for report directly
428: select request_set_name RS_NAME from bis_request_set_objects