APPS.BIS_CREATE_REQUESTSET dependencies on FND_REQUEST_SET_PROGRAMS

Line 534: fnd_request_set_programs b,

530: c.stage_name,
531: b.sequence
532: from
533: fnd_request_sets a,
534: fnd_request_set_programs b,
535: fnd_request_set_stages c,
536: fnd_concurrent_programs d,
537: fnd_application e,
538: fnd_application f

Line 550: -- added to pickup indexes on FND_REQUEST_SET_STAGES and FND_REQUEST_SET_PROGRAMS

546: and a.request_set_name=p_set_name
547: and d.concurrent_program_name=p_process_name
548: and e.application_short_name=p_set_app
549: and f.application_short_name=p_process_app
550: -- added to pickup indexes on FND_REQUEST_SET_STAGES and FND_REQUEST_SET_PROGRAMS
551: -- bug3143536
552: and c.set_application_id = a.application_id
553: and b.request_set_id = c.request_set_id
554: and a.application_id = b.set_application_id;

Line 583: fnd_request_set_programs b,

579: select
580: max(b.sequence) max_prog_seq
581: from
582: fnd_request_sets a,
583: fnd_request_set_programs b,
584: fnd_request_set_stages c,
585: fnd_application d
586: where a.request_set_id=b.request_set_id
587: and b.request_set_stage_id=c.request_set_stage_id

Line 593: -- added to pickup indexes on FND_REQUEST_SET_STAGES and FND_REQUEST_SET_PROGRAMS

589: and a.application_id=d.application_id
590: and d.application_short_name=p_set_app
591: and a.request_set_name=p_set_name
592: and c.stage_name=p_stage_name
593: -- added to pickup indexes on FND_REQUEST_SET_STAGES and FND_REQUEST_SET_PROGRAMS
594: -- bug3143536
595: and c.set_application_id = a.application_id
596: and b.request_set_id = c.request_set_id
597: and a.application_id = b.set_application_id

Line 1548: fnd_request_set_programs

1544: from dual
1545: where exists
1546: (select request_set_program_id
1547: from
1548: fnd_request_set_programs
1549: where set_application_id=p_setapp_id
1550: and request_set_id=p_set_id
1551: and request_set_stage_id=p_set_stage_id);
1552: l_dummy varchar2(1);

Line 1582: fnd_request_set_programs c,

1578: c.sequence
1579: from
1580: fnd_request_sets a,
1581: fnd_request_set_stages b,
1582: fnd_request_set_programs c,
1583: fnd_request_set_program_args d,
1584: fnd_application e
1585: where a.request_set_id=b.request_set_id
1586: and a.application_id=b.set_application_id

Line 2511: fnd_request_set_programs a,

2507: select distinct
2508: 'REPORT' object_type,
2509: c.default_value object_name
2510: from
2511: fnd_request_set_programs a,
2512: fnd_request_set_program_args c
2513: where a.set_application_id=p_set_app_id
2514: and a.request_set_id=p_set_id
2515: and a.request_set_stage_id=p_stage_id

Line 2801: fnd_request_set_programs a,

2797: select distinct
2798: c.object_type,
2799: c.object_name
2800: from
2801: fnd_request_set_programs a,
2802: fnd_concurrent_programs b,
2803: bis_obj_prog_linkages c,
2804: BIS_BIA_RSG_STAGE_OBJECTS d
2805: where a.set_application_id=p_set_app_id

Line 2822: fnd_request_set_programs a,

2818: select distinct
2819: 'MV' object_type,
2820: c.default_value object_name
2821: from
2822: fnd_request_set_programs a,
2823: fnd_request_set_program_args c
2824: where a.set_application_id=p_set_app_id
2825: and a.request_set_id=p_set_id
2826: and a.request_set_stage_id=p_stage_id

Line 2840: fnd_request_set_programs a,

2836: is
2837: select
2838: distinct d.CUSTOM_API custom_api
2839: from
2840: fnd_request_set_programs a,
2841: fnd_concurrent_programs b,
2842: bis_obj_prog_linkages c,
2843: bis_obj_properties d
2844: where a.set_application_id=p_set_app_id