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.OTA_DELEGATE_BOOKING_API dependencies on OTA_EVALUATIONS

Line 30: from ota_evaluations evt_eval,

26:
27: Cursor c_eval_info is
28: select decode(nvl(evt_eval.eval_mandatory_flag,'N'), 'Y', 'Y',
29: decode(act_eval.evaluation_id,null,'N',decode(nvl(act_eval.eval_mandatory_flag,'N'),'Y','Y','N'))) flag --bug 7184369
30: from ota_evaluations evt_eval,
31: ota_evaluations act_eval,
32: ota_events evt
33: where evt_eval.object_id(+) = evt.event_id
34: and evt_eval.object_type(+) = 'E' --Bug10637605

Line 31: ota_evaluations act_eval,

27: Cursor c_eval_info is
28: select decode(nvl(evt_eval.eval_mandatory_flag,'N'), 'Y', 'Y',
29: decode(act_eval.evaluation_id,null,'N',decode(nvl(act_eval.eval_mandatory_flag,'N'),'Y','Y','N'))) flag --bug 7184369
30: from ota_evaluations evt_eval,
31: ota_evaluations act_eval,
32: ota_events evt
33: where evt_eval.object_id(+) = evt.event_id
34: and evt_eval.object_type(+) = 'E' --Bug10637605
35: and act_eval.object_id(+) = evt.activity_version_id

Line 290: from ota_evaluations evt_eval,

286: IS
287: Cursor c_eval_info is
288: select decode(nvl(evt_eval.eval_mandatory_flag,'N'), 'Y', 'Y',
289: decode(act_eval.evaluation_id,null,'N',decode(nvl(act_eval.eval_mandatory_flag,'N'),'Y','Y','N'))) flag --bug 7184369,6935364,7174996
290: from ota_evaluations evt_eval,
291: ota_evaluations act_eval,
292: ota_events evt
293: where evt_eval.object_id(+) = evt.event_id
294: and evt_eval.object_type(+) = 'E' --Bug 10637605

Line 291: ota_evaluations act_eval,

287: Cursor c_eval_info is
288: select decode(nvl(evt_eval.eval_mandatory_flag,'N'), 'Y', 'Y',
289: decode(act_eval.evaluation_id,null,'N',decode(nvl(act_eval.eval_mandatory_flag,'N'),'Y','Y','N'))) flag --bug 7184369,6935364,7174996
290: from ota_evaluations evt_eval,
291: ota_evaluations act_eval,
292: ota_events evt
293: where evt_eval.object_id(+) = evt.event_id
294: and evt_eval.object_type(+) = 'E' --Bug 10637605
295: and act_eval.object_id(+) = evt.activity_version_id

Line 574: from ota_evaluations evt_eval,

570: --Bug 6683076
571: Cursor c_eval_info is
572: select decode(nvl(evt_eval.eval_mandatory_flag,'N'), 'Y', 'Y',
573: decode(act_eval.evaluation_id,null,'N',decode(nvl(act_eval.eval_mandatory_flag,'N'),'Y','Y','N'))) flag --bug 7184369,6935364,7174996
574: from ota_evaluations evt_eval,
575: ota_evaluations act_eval,
576: ota_events evt
577: where evt_eval.object_id(+) = evt.event_id
578: and evt_eval.object_type(+) = 'E' --Bug10637605

Line 575: ota_evaluations act_eval,

571: Cursor c_eval_info is
572: select decode(nvl(evt_eval.eval_mandatory_flag,'N'), 'Y', 'Y',
573: decode(act_eval.evaluation_id,null,'N',decode(nvl(act_eval.eval_mandatory_flag,'N'),'Y','Y','N'))) flag --bug 7184369,6935364,7174996
574: from ota_evaluations evt_eval,
575: ota_evaluations act_eval,
576: ota_events evt
577: where evt_eval.object_id(+) = evt.event_id
578: and evt_eval.object_type(+) = 'E' --Bug10637605
579: and act_eval.object_id(+) = evt.activity_version_id

Line 1296: from ota_evaluations evt_eval,

1292:
1293: Cursor c_eval_info is
1294: select decode(nvl(evt_eval.eval_mandatory_flag,'N'), 'Y', 'Y',
1295: decode(act_eval.evaluation_id,null,'N',decode(nvl(act_eval.eval_mandatory_flag,'N'),'Y','Y','N'))) flag --bug 7184369
1296: from ota_evaluations evt_eval,
1297: ota_evaluations act_eval,
1298: ota_events evt
1299: where evt_eval.object_id(+) = evt.event_id
1300: and evt_eval.object_type(+) = 'E' --Bug10637605

Line 1297: ota_evaluations act_eval,

1293: Cursor c_eval_info is
1294: select decode(nvl(evt_eval.eval_mandatory_flag,'N'), 'Y', 'Y',
1295: decode(act_eval.evaluation_id,null,'N',decode(nvl(act_eval.eval_mandatory_flag,'N'),'Y','Y','N'))) flag --bug 7184369
1296: from ota_evaluations evt_eval,
1297: ota_evaluations act_eval,
1298: ota_events evt
1299: where evt_eval.object_id(+) = evt.event_id
1300: and evt_eval.object_type(+) = 'E' --Bug10637605
1301: and act_eval.object_id(+) = evt.activity_version_id

Line 1887: from ota_evaluations evt_eval,

1883: Cursor c_eval_info is
1884: select evt_eval.evaluation_id evt_eval_id,decode(nvl(evt_eval.eval_mandatory_flag,'N'), 'Y', 'Y',
1885: decode(act_eval.evaluation_id,null,'N',decode(nvl(act_eval.eval_mandatory_flag,'N'),'Y','Y','N'))) flag, --bug 7184369,6935364,7174996
1886: act_eval.evaluation_id act_eval_id
1887: from ota_evaluations evt_eval,
1888: ota_evaluations act_eval,
1889: ota_events evt
1890: where evt_eval.object_id(+) = evt.event_id
1891: and evt_eval.object_type(+) = 'E' --Bug10637605

Line 1888: ota_evaluations act_eval,

1884: select evt_eval.evaluation_id evt_eval_id,decode(nvl(evt_eval.eval_mandatory_flag,'N'), 'Y', 'Y',
1885: decode(act_eval.evaluation_id,null,'N',decode(nvl(act_eval.eval_mandatory_flag,'N'),'Y','Y','N'))) flag, --bug 7184369,6935364,7174996
1886: act_eval.evaluation_id act_eval_id
1887: from ota_evaluations evt_eval,
1888: ota_evaluations act_eval,
1889: ota_events evt
1890: where evt_eval.object_id(+) = evt.event_id
1891: and evt_eval.object_type(+) = 'E' --Bug10637605
1892: and act_eval.object_id(+) = evt.activity_version_id