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 is null or evt_eval.object_type = 'E')

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 is null or evt_eval.object_type = 'E')
35: and act_eval.object_id(+) = evt.activity_version_id

Line 428: from ota_evaluations evt_eval,

424: --Bug 6683076
425: Cursor c_eval_info is
426: select decode(nvl(evt_eval.eval_mandatory_flag,'N'), 'Y', 'Y',
427: decode(act_eval.evaluation_id,null,'N',decode(nvl(act_eval.eval_mandatory_flag,'N'),'Y','Y','N'))) flag --bug 7184369,6935364,7174996
428: from ota_evaluations evt_eval,
429: ota_evaluations act_eval,
430: ota_events evt
431: where evt_eval.object_id(+) = evt.event_id
432: and (evt_eval.object_type is null or evt_eval.object_type = 'E')

Line 429: ota_evaluations act_eval,

425: Cursor c_eval_info is
426: select decode(nvl(evt_eval.eval_mandatory_flag,'N'), 'Y', 'Y',
427: decode(act_eval.evaluation_id,null,'N',decode(nvl(act_eval.eval_mandatory_flag,'N'),'Y','Y','N'))) flag --bug 7184369,6935364,7174996
428: from ota_evaluations evt_eval,
429: ota_evaluations act_eval,
430: ota_events evt
431: where evt_eval.object_id(+) = evt.event_id
432: and (evt_eval.object_type is null or evt_eval.object_type = 'E')
433: and act_eval.object_id(+) = evt.activity_version_id

Line 1137: from ota_evaluations evt_eval,

1133:
1134: Cursor c_eval_info is
1135: select decode(nvl(evt_eval.eval_mandatory_flag,'N'), 'Y', 'Y',
1136: decode(act_eval.evaluation_id,null,'N',decode(nvl(act_eval.eval_mandatory_flag,'N'),'Y','Y','N'))) flag --bug 7184369
1137: from ota_evaluations evt_eval,
1138: ota_evaluations act_eval,
1139: ota_events evt
1140: where evt_eval.object_id(+) = evt.event_id
1141: and (evt_eval.object_type is null or evt_eval.object_type = 'E')

Line 1138: ota_evaluations act_eval,

1134: Cursor c_eval_info is
1135: select decode(nvl(evt_eval.eval_mandatory_flag,'N'), 'Y', 'Y',
1136: decode(act_eval.evaluation_id,null,'N',decode(nvl(act_eval.eval_mandatory_flag,'N'),'Y','Y','N'))) flag --bug 7184369
1137: from ota_evaluations evt_eval,
1138: ota_evaluations act_eval,
1139: ota_events evt
1140: where evt_eval.object_id(+) = evt.event_id
1141: and (evt_eval.object_type is null or evt_eval.object_type = 'E')
1142: and act_eval.object_id(+) = evt.activity_version_id

Line 1717: from ota_evaluations evt_eval,

1713: Cursor c_eval_info is
1714: select evt_eval.evaluation_id evt_eval_id,decode(nvl(evt_eval.eval_mandatory_flag,'N'), 'Y', 'Y',
1715: decode(act_eval.evaluation_id,null,'N',decode(nvl(act_eval.eval_mandatory_flag,'N'),'Y','Y','N'))) flag, --bug 7184369,6935364,7174996
1716: act_eval.evaluation_id act_eval_id
1717: from ota_evaluations evt_eval,
1718: ota_evaluations act_eval,
1719: ota_events evt
1720: where evt_eval.object_id(+) = evt.event_id
1721: and (evt_eval.object_type is null or evt_eval.object_type = 'E')

Line 1718: ota_evaluations act_eval,

1714: select evt_eval.evaluation_id evt_eval_id,decode(nvl(evt_eval.eval_mandatory_flag,'N'), 'Y', 'Y',
1715: decode(act_eval.evaluation_id,null,'N',decode(nvl(act_eval.eval_mandatory_flag,'N'),'Y','Y','N'))) flag, --bug 7184369,6935364,7174996
1716: act_eval.evaluation_id act_eval_id
1717: from ota_evaluations evt_eval,
1718: ota_evaluations act_eval,
1719: ota_events evt
1720: where evt_eval.object_id(+) = evt.event_id
1721: and (evt_eval.object_type is null or evt_eval.object_type = 'E')
1722: and act_eval.object_id(+) = evt.activity_version_id