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.

[Home] [Help]

APPS.BIS_RSG_PMV_REPORT_PKG dependencies on BIS_OBJ_REFRESH_HISTORY

Line 337: Latestreq.request_set_type rstype from bis_obj_refresh_history o,

333: (select tmp.srid srid, sum(tmp.object_space_usage) space_use,tmp.rsid rsid, tmp.rstype rstype
334: from
335: (select distinct object_name, object_type, object_space_usage,p.set_request_id srid,
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'')

Line 680: (select distinct prog_request_id prid, 1 num_obj from bis_obj_refresh_history

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
684: and F.APPLICATION_ID = B.Prog_app_id

Line 682: in(select prog_request_id from bis_obj_refresh_history)) count_obj

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
684: and F.APPLICATION_ID = B.Prog_app_id
685: and R.request_id=B.set_request_id
686: and S.request_id=B.stage_request_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 948: from BIS_OBJ_REFRESH_HISTORY O,

944: decode(O.OBJECT_TYPE,''MV_LOG'',NULL,''BSC_CUSTOM_KPI'',NULL,'||''''||
945: 'pFunctionName=BIS_BIA_RSG_DEPENDENCIES_ALONE'
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,

Line 1159: bis_obj_refresh_history o

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
1163: and p.request_id = o.prog_request_id and r.request_set_id= rsid);