[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
'SELECT request_set_name bis_request_set_short_name,
user_request_set_name bis_request_set_display_name,
meaning bis_request_refresh_type,
request_set_id bis_request_set_id, request_id bis_request_id,
user_name bis_requestor, bis_request_refresh_time,
TO_CHAR (actual_completion_date,
''DD-MON-YYYY HH24:MI:SS''
) bis_request_last_date
FROM (SELECT DISTINCT s.user_request_set_name, s.request_set_name, s.request_set_id,
c.actual_completion_date
,c.request_id,
u.user_name,
bis_bia_refresh_report.time_interval(c.actual_completion_date
- c.requested_start_date
) bis_request_refresh_time,
RANK () OVER (PARTITION BY s.request_set_id ORDER BY c.actual_completion_date DESC)
pos,
v.meaning
FROM bis_request_set_objects_v o,
fnd_request_sets_vl s,
fnd_concurrent_requests c,
fnd_concurrent_programs p,
fnd_user u,
bis_request_set_options r,
fnd_common_lookups v
WHERE o.object_type = ''PAGE''
AND bis_impl_dev_pkg.get_function_by_page (o.object_name) IS NOT NULL
AND s.application_id = 191
AND s.request_set_name = o.request_set_name
AND p.concurrent_program_id = c.concurrent_program_id
AND p.application_id = 0
AND p.concurrent_program_name = ''FNDRSSUB''
AND c.argument1 = s.application_id
AND c.argument2 = s.request_set_id
AND c.status_code IN (''C'', ''G'', ''R'', ''I'')
AND u.user_id = c.requested_by
AND s.request_set_name = r.request_set_name
AND r.option_name = ''REFRESH_MODE''
AND r.option_value = v.lookup_code
AND v.lookup_type = ''BIS_REFRESH_MODE''
AND s.request_set_name =
DECODE (NVL (&DBI_REQUEST_SET+DBI_REQUEST_SET, ''All''),
''All'', s.request_set_name,
NVL (&DBI_REQUEST_SET+DBI_REQUEST_SET, ''All'')
)
)
WHERE pos = 1
ORDER BY '
|| vorderby;
'SELECT stg.request_set_id BIS_REQUEST_SET_ID,'
|| ''''
|| l_request_set_name
|| ''''
|| 'BIS_REQUEST_SET_NAME,'
|| ''''
|| l_request_id
|| ''''
|| 'BIS_PRIORITY_REQUEST_ID,
stg.request_set_stage_id BIS_REQUEST_SET_STAGE_ID,
stg.user_stage_name BIS_REQUEST_SET_STAGE_NAME,
con.request_id BIS_REQUEST_ID,
bis_bia_refresh_report.time_interval(con.actual_completion_date
- con.requested_start_date
) BIS_REQUEST_REFRESH_TIME
FROM fnd_concurrent_requests con, fnd_request_set_stages_vl stg
WHERE con.priority_request_id = '
|| l_request_id
|| ' AND con.priority_request_id = con.parent_request_id
AND stg.request_set_id = '
|| l_request_set_id
|| 'AND con.argument2 = TO_CHAR (stg.request_set_id)
AND con.argument3 = TO_CHAR (stg.request_set_stage_id) ORDER BY'
|| vorderby;
'SELECT
request_set_stage_id BIS_REQUEST_SET_STAGE_ID
, user_stage_name BIS_REQUEST_SET_STAGE_NAME
, NVL(
(
SELECT fnd_lv.meaning
FROM bis_obj_properties bobjp
, fnd_common_lookups fnd_lv
WHERE bobjp.object_name = m.object_name
AND fnd_lv.lookup_type = ''BIS_OBJECT_TYPE''
AND fnd_lv.lookup_code = bobjp.object_type
)
, (
SELECT meaning
FROM fnd_common_lookups
WHERE lookup_type = ''BIS_OBJECT_TYPE''
AND lookup_code = ''TABLE''
AND m.object_name LIKE ''MLOG$_%''
)
) BIS_REQUEST_OBJECT_TYPE
, object_name BIS_REQUEST_OBJECT_NAME
, request_id BIS_REQUEST_ID
, user_concurrent_program_name BIS_CONCURRENT_DISPLAY_NAME
, BIS_REQUEST_REFRESH_TIME
, display_sequence BIS_REQUEST_STAGE_DISPLAY_SEQ
FROM (
SELECT rset.request_id
, DECODE(cprog.concurrent_program_name, ''FNDGTST'', rset.argument2, brlog.object_name) object_name
, stage.user_stage_name
, stage.request_set_stage_id
, stage.display_sequence
, rset.actual_start_date
, rset.actual_completion_date
, bis_bia_refresh_report.time_interval(rset.actual_completion_date
- rset.actual_start_date
) BIS_REQUEST_REFRESH_TIME
, cprog.user_concurrent_program_name
FROM fnd_concurrent_requests rset
, fnd_concurrent_requests rset_stg
, fnd_concurrent_programs_vl cprog
, fnd_request_set_stages_vl stage
, bis_refresh_log brlog
WHERE rset.priority_request_id = &REQUEST_ID+REQUEST_ID
AND rset.parent_request_id NOT IN (-1, &REQUEST_ID+REQUEST_ID)
AND rset.concurrent_program_id = cprog.concurrent_program_id
AND rset.request_id = brlog.request_id(+)
AND rset.parent_request_id = rset_stg.request_id
AND rset_stg.argument3 = TO_CHAR(stage.request_set_stage_id)
AND rset_stg.priority_request_id = &REQUEST_ID+REQUEST_ID
AND rset.parent_request_id ='
|| l_parent_request_id
|| ') m order by '
|| vorderby;
'SELECT
request_set_stage_id BIS_REQUEST_SET_STAGE_ID
, user_stage_name BIS_REQUEST_SET_STAGE_NAME
, NVL(
(
SELECT fnd_lv.meaning
FROM bis_obj_properties bobjp
, fnd_common_lookups fnd_lv
WHERE bobjp.object_name = m.object_name
AND fnd_lv.lookup_type = ''BIS_OBJECT_TYPE''
AND fnd_lv.lookup_code = bobjp.object_type
)
, (
SELECT meaning
FROM fnd_common_lookups
WHERE lookup_type = ''BIS_OBJECT_TYPE''
AND lookup_code = ''TABLE''
AND m.object_name LIKE ''MLOG$_%''
)
) BIS_REQUEST_OBJECT_TYPE
, object_name BIS_REQUEST_OBJECT_NAME
, request_id BIS_REQUEST_ID
, user_concurrent_program_name BIS_CONCURRENT_DISPLAY_NAME
, BIS_REQUEST_REFRESH_TIME
, display_sequence BIS_REQUEST_STAGE_DISPLAY_SEQ
FROM (
SELECT rset.request_id
, DECODE(cprog.concurrent_program_name, ''FNDGTST'', rset.argument2, brlog.object_name) object_name
, stage.user_stage_name
, stage.request_set_stage_id
, stage.display_sequence
, rset.actual_start_date
, rset.actual_completion_date
, bis_bia_refresh_report.time_interval(rset.actual_completion_date
- rset.actual_start_date
) BIS_REQUEST_REFRESH_TIME
, cprog.user_concurrent_program_name
FROM fnd_concurrent_requests rset
, fnd_concurrent_requests rset_stg
, fnd_concurrent_programs_vl cprog
, fnd_request_set_stages_vl stage
, bis_refresh_log brlog
WHERE rset.priority_request_id = &REQUEST_ID+REQUEST_ID
AND rset.parent_request_id NOT IN (-1, &REQUEST_ID+REQUEST_ID)
AND rset.concurrent_program_id = cprog.concurrent_program_id
AND rset.request_id = brlog.request_id(+)
AND rset.parent_request_id = rset_stg.request_id
AND rset_stg.argument3 = TO_CHAR(stage.request_set_stage_id)
AND rset_stg.priority_request_id = &REQUEST_ID+REQUEST_ID
AND stage.request_set_stage_id in (
DECODE (NVL (&DBI_REQUEST_SET+DBI_REQUEST_STAGE, ''ALL''),
''ALL'', stage.request_set_stage_id,
NVL (&DBI_REQUEST_SET+DBI_REQUEST_STAGE, ''ALL''))
)
) m order by '
|| vorderby;