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_CREATE_REQUESTSET dependencies on FND_REQUEST_SET_STAGES

Line 535: fnd_request_set_stages c,

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
539: where a.request_set_id=b.request_set_id

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 584: fnd_request_set_stages c,

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
588: and a.request_set_id=c.request_set_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 1110: fnd_request_set_stages b,

1106: select
1107: max(b.display_sequence)
1108: from
1109: fnd_request_sets a,
1110: fnd_request_set_stages b,
1111: fnd_application c
1112: where a.request_set_id=b.request_set_id
1113: and a.application_id=b.set_application_id
1114: and a.application_id=c.application_id

Line 1453: fnd_request_set_stages c

1449: c.display_sequence
1450: from
1451: fnd_request_sets a,
1452: fnd_application b,
1453: fnd_request_set_stages c
1454: where
1455: a.application_id=b.application_id
1456: and b.application_short_name=p_setapp
1457: and a.application_id=c.SET_APPLICATION_ID

Line 1581: fnd_request_set_stages b,

1577: b.stage_name,
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

Line 1826: fnd_request_set_stages b,

1822: select
1823: min(b.display_sequence)
1824: from
1825: fnd_request_sets a,
1826: fnd_request_set_stages b,
1827: fnd_application c
1828: where a.request_set_id=b.request_set_id
1829: and a.application_id=b.set_application_id
1830: and a.application_id=c.application_id

Line 2749: fnd_request_set_stages c

2745: c.display_sequence
2746: from
2747: fnd_request_sets a,
2748: fnd_application b,
2749: fnd_request_set_stages c
2750: where
2751: a.application_id=b.application_id
2752: and b.application_short_name=p_setapp
2753: and a.application_id=c.SET_APPLICATION_ID

Line 2763: fnd_request_set_stages b,

2759: select
2760: max(b.display_sequence)
2761: from
2762: fnd_request_sets a,
2763: fnd_request_set_stages b,
2764: fnd_application c
2765: where a.request_set_id=b.request_set_id
2766: and a.application_id=b.set_application_id
2767: and a.application_id=c.application_id

Line 2776: fnd_request_set_stages b,

2772: select
2773: min(b.display_sequence)
2774: from
2775: fnd_request_sets a,
2776: fnd_request_set_stages b,
2777: fnd_application c
2778: where a.request_set_id=b.request_set_id
2779: and a.application_id=b.set_application_id
2780: and a.application_id=c.application_id

Line 4311: from fnd_request_sets r ,fnd_request_set_stages s,

4307: report_stage_name varchar2(200);
4308: cursor c_stages
4309: is
4310: select s.STAGE_NAME
4311: from fnd_request_sets r ,fnd_request_set_stages s,
4312: fnd_application app
4313: where r.REQUEST_SET_ID= s.REQUEST_SET_ID
4314: and r.application_id = s.set_Application_id
4315: and r.REQUEST_SET_NAME = p_set_name

Line 4446: FROM BIS_RS_STAGE_RUN_HISTORY bis, FND_REQUEST_SET_STAGES_VL fnd

4442: WHERE bis.set_request_id = l_root_request_id AND bis.status_code ='E'
4443: AND bis.prog_app_id = fnd.application_id AND bis.program_id = fnd.concurrent_program_id
4444: UNION
4445: SELECT request_id, user_stage_name NAME, 'STAGE' TYPE
4446: FROM BIS_RS_STAGE_RUN_HISTORY bis, FND_REQUEST_SET_STAGES_VL fnd
4447: WHERE set_request_id = l_root_request_id AND status_code ='E'
4448: AND bis.set_app_id = fnd.set_application_id AND bis.request_set_id = fnd.request_set_id
4449: AND bis.stage_id = fnd.request_set_stage_id ;
4450: