DBA Data[Home] [Help]

APPS.ONT_ACTIVITY_SUM_ORDER_PURGE dependencies on FND_TM_EVENTS

Line 107: -- FND_TM_EVENTS

103:
104: fnd_conc_summarizer.insert_row(l_temp_name, to_char(l_count));
105:
106: --
107: -- FND_TM_EVENTS
108: -- The Transaction Management Events Count
109: --
110:
111: l_temp_name := fnd_message.get_string('FND', 'FND_TM_EVENTS');

Line 111: l_temp_name := fnd_message.get_string('FND', 'FND_TM_EVENTS');

107: -- FND_TM_EVENTS
108: -- The Transaction Management Events Count
109: --
110:
111: l_temp_name := fnd_message.get_string('FND', 'FND_TM_EVENTS');
112:
113: SELECT COUNT (*)
114: INTO l_count
115: FROM fnd_tm_events

Line 115: FROM fnd_tm_events

111: l_temp_name := fnd_message.get_string('FND', 'FND_TM_EVENTS');
112:
113: SELECT COUNT (*)
114: INTO l_count
115: FROM fnd_tm_events
116: WHERE TIMESTAMP < SYSDATE - 1
117: AND (program_application_id, concurrent_program_id) IN
118: (SELECT application_id, concurrent_program_id
119: FROM fnd_concurrent_programs