eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BIS_BIA_RSG_PSTATE dependencies on BIS_REQUEST_SET_OBJECTS

Line 135: from bis_request_set_objects

131: Function get_rs_for_content(p_content_name in varchar2,
132: p_content_type in varchar2) return varchar2 is
133: cursor c_rs_for_reports (l_report_name varchar2) is
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'

Line 147: select request_set_name from bis_request_set_objects

143: connect by prior obj.OBJECT_NAME=obj.depend_object_name
144: and prior obj.OBJECT_TYPE=obj.depend_object_TYPE)
145: and object_type ='PAGE'
146: union -- request set for report directly
147: select request_set_name from bis_request_set_objects
148: where object_name =l_report_name and object_type ='REPORT') where
149: BIS_BIA_RSG_PSTATE.get_refresh_mode(REQUEST_SET_NAME) <> 'ANAL';
150:
151: cursor c_rs_for_pages (l_page_name varchar2) is

Line 153: (select request_set_name from bis_request_set_objects

149: BIS_BIA_RSG_PSTATE.get_refresh_mode(REQUEST_SET_NAME) <> 'ANAL';
150:
151: cursor c_rs_for_pages (l_page_name varchar2) is
152: SELECT REQUEST_SET_NAME FROM
153: (select request_set_name from bis_request_set_objects
154: where object_name =l_PAGE_name and object_type ='PAGE') WHERE
155: BIS_BIA_RSG_PSTATE.get_refresh_mode(REQUEST_SET_NAME) <> 'ANAL';
156:
157: l_rs_names varchar2(32767);

Line 290: FROM BIS_RS_RUN_HISTORY HISTORY, BIS_REQUEST_SET_OBJECTS OBJECTS

286: select OBJECTS.OBJECT_NAME,
287: BIS_BIA_RSG_PSTATE.duration(COMPLETION_DATE - START_DATE) Last_Refresh_Duration,
288: bis_submit_requestset.get_last_refreshdate(objects.object_type,null,objects.object_name) Last_Refresh_Time,
289: rank() over(partition by OBJECTS.OBJECT_NAME order by START_DATE desc) rk
290: FROM BIS_RS_RUN_HISTORY HISTORY, BIS_REQUEST_SET_OBJECTS OBJECTS
291: WHERE
292: '|| l_bind ||' AND
293: OBJECTS.OBJECT_TYPE = ''PAGE'' AND
294: BIS_BIA_RSG_PSTATE.get_refresh_mode(OBJECTS.REQUEST_SET_NAME) <> ''ANAL'' AND

Line 307: FROM BIS_RS_RUN_HISTORY HISTORY, BIS_REQUEST_SET_OBJECTS OBJECTS, FND_LOOKUPS LOOKUPS

303: (
304: SELECT OBJECTS.OBJECT_NAME,
305: LOOKUPS.MEANING Current_Status,
306: min(START_DATE) Refresh_Start_Time
307: FROM BIS_RS_RUN_HISTORY HISTORY, BIS_REQUEST_SET_OBJECTS OBJECTS, FND_LOOKUPS LOOKUPS
308: WHERE
309: '|| l_bind ||' AND
310: OBJECTS.OBJECT_TYPE = ''PAGE'' AND
311: BIS_BIA_RSG_PSTATE.get_refresh_mode(OBJECTS.REQUEST_SET_NAME) <>''ANAL'' AND

Line 325: BIS_REQUEST_SET_OBJECTS OBJECTS,

321: SELECT
322: OBJECTS.OBJECT_NAME,
323: min(FND_CONC.REQUESTED_START_DATE) REQUESTED_START_DATE
324: from
325: BIS_REQUEST_SET_OBJECTS OBJECTS,
326: FND_CONCURRENT_REQUESTS FND_CONC,
327: FND_REQUEST_SETS FND
328: where
329: '|| l_bind ||' AND

Line 377: from bis_request_set_objects where object_name in ( select Distinct obj.OBJECT_NAME

373: (select BIS_BIA_RSG_PSTATE.duration(COMPLETION_DATE - START_DATE) Last_Refresh_Duration
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

Line 382: select request_set_name RS_NAME from bis_request_set_objects

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
383: where object_name =:CONTENT_NAME and object_type =''REPORT'')
384: where BIS_BIA_RSG_PSTATE.get_refresh_mode(REQUEST_SET_NAME) != ''ANAL'') AND
385: HISTORY.PHASE_CODE = ''C'' AND
386: (HISTORY.STATUS_CODE = ''C'' OR HISTORY.STATUS_CODE = ''G'')

Line 400: from bis_request_set_objects where object_name in ( select Distinct obj.OBJECT_NAME

396: FROM BIS_RS_RUN_HISTORY HISTORY, FND_LOOKUPS LOOKUPS
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

Line 405: select request_set_name RS_NAME from bis_request_set_objects

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
406: where object_name =:CONTENT_NAME and object_type =''REPORT'')
407: where BIS_BIA_RSG_PSTATE.get_refresh_mode(REQUEST_SET_NAME) != ''ANAL'')AND
408: HISTORY.PHASE_CODE = ''R'' AND
409: HISTORY.PHASE_CODE = LOOKUPS.LOOKUP_CODE AND

Line 418: BIS_REQUEST_SET_OBJECTS OBJECTS,

414: (
415: SELECT ''Dummy'' AS JOIN_COL,
416: min(FND_CONC.REQUESTED_START_DATE) REQUESTED_START_DATE
417: from
418: BIS_REQUEST_SET_OBJECTS OBJECTS,
419: FND_CONCURRENT_REQUESTS FND_CONC,
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

Line 423: from bis_request_set_objects where object_name in ( select Distinct obj.OBJECT_NAME

419: FND_CONCURRENT_REQUESTS FND_CONC,
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

Line 428: select request_set_name RS_NAME from bis_request_set_objects

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
429: where object_name =:CONTENT_NAME and object_type =''REPORT'')
430: where BIS_BIA_RSG_PSTATE.get_refresh_mode(REQUEST_SET_NAME) != ''ANAL'') and
431: OBJECTS.REQUEST_SET_NAME = FND.REQUEST_SET_NAME AND
432: OBJECTS.SET_APP_ID = FND.APPLICATION_ID AND