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_RSG_PMV_REPORT_PKG dependencies on BIS_RS_RUN_HISTORY

Line 306: bis_rs_run_history r

302: ,Max(completion_date-start_date) max_run_time
303: ,avg(completion_date- start_date) avg_run_time
304: ,R.REQUEST_SET_TYPE rstype
305: from
306: bis_rs_run_history r
307: where
308: r.phase_code =''C'' AND (STATUS_CODE=''G''
309: or STATUS_CODE=''C'') ';
310:

Line 318: bis_rs_run_history r, bis_rs_names_v v

314:
315: l_sql_stmt:= l_sql_stmt || '(Select request_set_id,request_set_type
316: ,count(r.request_set_id) Num_runs
317: from
318: bis_rs_run_history r, bis_rs_names_v v
319: where
320: r.phase_code =''C''
321: AND v.id = r.request_set_id
322: AND r.STATUS_CODE<>''X'' ';

Line 340: from bis_rs_run_history WHERE PHASE_CODE=''C'' AND (STATUS_CODE=''C''

336: Latestreq.request_set_id rsid,
337: Latestreq.request_set_type rstype from bis_obj_refresh_history o,
338: bis_rs_prog_run_history p,
339: (select max(request_id) maxid, request_set_id,request_set_type
340: from bis_rs_run_history WHERE PHASE_CODE=''C'' AND (STATUS_CODE=''C''
341: OR STATUS_CODE =''G'')
342: group by request_set_id,request_set_type) Latestreq
343: where
344: o.prog_request_id = p.request_id

Line 435: from BIS_RS_RUN_HISTORY B, FND_REQUEST_SETS_VL F

431: BIS_RSG_PMV_REPORT_PKG.duration_str(completion_date - start_date) AS BIS_RS_DURATION,
432: BIS_RSG_PMV_REPORT_PKG.get_meaning(STATUS_CODE,PHASE_CODE) AS BIS_RS_STATUS,
433: ''pFunctionName=BIS_BIA_RSG_SUB_REQS_PGE&VIEW_BY_NAME=VIEW_BY_ID&pParamIds=Y'' BISREPORTURL
434: ,BIS_RSG_PMV_REPORT_PKG.returnLogUrl( B.request_id,2) BISLOGFILEURL
435: from BIS_RS_RUN_HISTORY B, FND_REQUEST_SETS_VL F
436: where F.request_set_id = B.request_set_id
437: AND PHASE_CODE = ''C'' and STATUS_CODE <>''X'' ';
438:
439:

Line 656: from bis_rs_run_history R,fnd_request_sets_vl F

652: '(select R.request_id rid,F.user_request_set_name rname,
653: R.start_date started,
654: BIS_RSG_PMV_REPORT_PKG.Duration_str(R.completion_date-R.start_date) dur,
655: STATUS_CODE status, R.completion_text LOG_MESSAGE, '' '' url
656: from bis_rs_run_history R,fnd_request_sets_vl F
657: where F.request_set_id = R.request_set_id AND R.PHASE_CODE=''C'' ' ||
658: l_type_cond ||l_setid_cond ||l_runid_cond1
659: ||' union
660: select B.request_id rid, F.user_stage_name rname,

Line 665: bis_rs_stage_run_history B, fnd_request_set_stages_vl F,bis_rs_run_history R

661: B.start_date started,
662: BIS_RSG_PMV_REPORT_PKG.Duration_str(B.completion_date-B.start_date) dur,
663: B.STATUS_CODE status,B.completion_text LOG_MESSAGE,'' '' url
664: from
665: bis_rs_stage_run_history B, fnd_request_set_stages_vl F,bis_rs_run_history R
666: where F.request_set_stage_id = B.stage_id
667: and R.request_id = B.set_request_id AND R.PHASE_CODE=''C'' '
668: ||l_type_cond||l_setid_cond||l_runid_cond2||l_stage_cond1||l_prog_cond2
669: ||' union

Line 679: bis_rs_run_history R,bis_rs_stage_run_history S,

675: ''pFunctionName=BIS_BIA_RSG_REQ_DETAILS_PGE&BIS_RS_SUB_REQS_ID=BIS_RS_SUB_REQS_ID&BISRSSTAGE=''||B.stage_request_id||''&BISRSPROG=''||B.program_id||''&pParamIds=Y''
676: ) url
677: from
678: bis_rs_prog_run_history B, fnd_concurrent_programs_vl F,
679: bis_rs_run_history R,bis_rs_stage_run_history S,
680: (select distinct prog_request_id prid, 1 num_obj from bis_obj_refresh_history
681: union select request_id prid,0 num_obj from bis_rs_prog_run_history where request_id not
682: in(select prog_request_id from bis_obj_refresh_history)) count_obj
683: where F.concurrent_program_id = B.program_id

Line 803: from bis_obj_refresh_history O,bis_rs_prog_run_history P,bis_rs_run_history R,

799: decode(O.OBJECT_TYPE,''MV_LOG'',NULL,''BSC_CUSTOM_KPI'',NULL,'||''''||
800: 'pFunctionName=BIS_BIA_RSG_DEPENDENCIES_ALONE'
801: ||'&requestType=RSGReport&ObjType=''||o.object_type||''&ObjName=BIS_REQUEST_OBJECT_NAME''
802: ) BISREPORTURL
803: from bis_obj_refresh_history O,bis_rs_prog_run_history P,bis_rs_run_history R,
804: bis_rs_stage_run_history S
805: where O.prog_request_id = P.request_id
806: AND R.REQUEST_ID = S.SET_REQUEST_ID
807: AND S.REQUEST_ID = P.STAGE_REQUEST_ID

Line 950: from bis_rs_run_history WHERE PHASE_CODE=''C'' AND (STATUS_CODE=''C''

946: ||'&requestType=RSGReport&ObjType=''||o.object_type||''&ObjName=BIS_REQUEST_OBJECT_NAME''
947: ) BISREPORTURL
948: from BIS_OBJ_REFRESH_HISTORY O,
949: (select max(request_id) maxid, request_set_id rsid,request_set_type rstype
950: from bis_rs_run_history WHERE PHASE_CODE=''C'' AND (STATUS_CODE=''C''
951: OR STATUS_CODE =''G'')
952: group by request_set_id,request_set_type) Latestreq,
953: bis_rs_prog_run_history P, bis_rs_stage_run_history S,
954: (select TABLESPACE_NAME, sum(BYTES) BYTES from dba_data_files

Line 1133: from bis_rs_run_history WHERE PHASE_CODE='C' AND (STATUS_CODE='C'

1129: Latest_run_id Number;
1130:
1131: cursor get_latest_run (rsid NUMBER) is
1132: select max(request_id) maxid
1133: from bis_rs_run_history WHERE PHASE_CODE='C' AND (STATUS_CODE='C'
1134: OR STATUS_CODE ='G') and request_set_id= rsid
1135: group by request_set_id,request_set_type;
1136:
1137:

Line 1158: (select r.request_set_id from bis_rs_run_history r, bis_rs_prog_run_history p,

1154:
1155: ret_val Number;
1156: cursor check_rsid (rsid NUMBER) is
1157: select 1 from dual where exists
1158: (select r.request_set_id from bis_rs_run_history r, bis_rs_prog_run_history p,
1159: bis_obj_refresh_history o
1160: where
1161: r.phase_code ='C' AND (r.STATUS_CODE='C' OR r.STATUS_CODE ='G')
1162: and p.set_request_id=r.Request_id