APPS.BIS_SUBMIT_REQUESTSET dependencies on FND_CONCURRENT_REQUESTS

Line 206: fnd_concurrent_requests aa,

202: max(aa.actual_completion_date) latest_date,
203: aa.program_application_id,
204: aa.concurrent_program_id
205: from
206: fnd_concurrent_requests aa,
207: ( select distinct
208: b.application_id application_id,
209: b.CONCURRENT_PROGRAM_ID concurrent_program_id
210: from

Line 234: fnd_concurrent_requests aa,

230: max(aa.actual_completion_date) latest_time
231: -- aa.program_application_id program_application_id,
232: -- aa.concurrent_program_id concurrent_program_id
233: from
234: fnd_concurrent_requests aa,
235: fnd_concurrent_programs bb
236: where bb.concurrent_program_name='BIS_MV_REFRESH'
237: and bb.application_id=191
238: and aa.program_application_id=bb.application_id

Line 266: fnd_concurrent_requests aa,

262: max(aa.actual_completion_date) latest_time
263: -- aa.program_application_id program_application_id,
264: -- aa.concurrent_program_id concurrent_program_id
265: from
266: fnd_concurrent_requests aa,
267: fnd_concurrent_programs bb
268: where bb.concurrent_program_name='BSC_REFRESH_SUMMARY_IND'
269: and bb.application_id=271
270: and aa.program_application_id=bb.application_id

Line 799: fnd_concurrent_requests aa,

795: cursor c_kpi_refresh_date(indicator_id number) is
796: Select
797: max(aa.actual_completion_date) last_refresh_date
798: from
799: fnd_concurrent_requests aa,
800: fnd_concurrent_programs bb
801: where bb.concurrent_program_name='BSC_REFRESH_SUMMARY_IND'
802: and bb.application_id=271
803: and aa.program_application_id=bb.application_id

Line 830: from fnd_concurrent_requests

826: ----fixing bug 4053299
827: ---remove the condition parent_request_id=-1 for
828: cursor request_set_id is
829: select to_number(argument2), to_number(argument1)
830: from fnd_concurrent_requests
831: ----where parent_request_id=-1
832: where request_id=p_request_id;
833:
834:

Line 979: fnd_concurrent_requests c

975: select distinct a.object_name, a.object_type,a.object_owner
976: from
977: bis_request_set_objects a,
978: fnd_request_sets b,
979: fnd_concurrent_requests c
980: where a.request_set_name=b.request_set_name
981: and a.SET_APP_ID=b.application_id
982: and b.request_set_id=to_number(c.argument2)
983: and b.application_id=to_number(c.argument1)

Line 1193: FROM BIS_RS_RUN_HISTORY HISTORY, BIS_REQUEST_SET_OBJECTS OBJECTS, FND_CONCURRENT_REQUESTS FND

1189: l_return_flag VARCHAR2(1);
1190: l_start_time DATE;
1191: CURSOR c_dashboards_rs IS
1192: SELECT 'Y', START_DATE
1193: FROM BIS_RS_RUN_HISTORY HISTORY, BIS_REQUEST_SET_OBJECTS OBJECTS, FND_CONCURRENT_REQUESTS FND
1194: WHERE OBJECTS.object_name = p_obj_name
1195: AND OBJECTS.object_type = p_obj_type
1196: AND BIS_BIA_RSG_PSTATE.get_refresh_mode(OBJECTS.REQUEST_SET_NAME) <> 'ANAL'
1197: AND OBJECTS.request_set_name = HISTORY.request_set_name

Line 1223: ) RS, BIS_RS_RUN_HISTORY HISTORY, FND_CONCURRENT_REQUESTS FND

1219: SELECT request_set_name
1220: FROM bis_request_set_objects
1221: WHERE object_name = p_obj_name
1222: AND object_type IN ('REPORT','PORTLET')
1223: ) RS, BIS_RS_RUN_HISTORY HISTORY, FND_CONCURRENT_REQUESTS FND
1224: WHERE BIS_BIA_RSG_PSTATE.get_refresh_mode(RS.REQUEST_SET_NAME) <> 'ANAL'
1225: AND RS.REQUEST_SET_NAME = HISTORY.REQUEST_SET_NAME AND HISTORY.PHASE_CODE = 'R'
1226: AND HISTORY.REQUEST_ID = FND.REQUEST_ID AND FND.STATUS_CODE <> 'X'
1227: ORDER BY START_DATE;