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.CCT_CONCURRENT_PUB dependencies on JTF_IH_MEDIA_ITEM_LC_SEGS

Line 149: select milcs_id, start_date_time from jtf_ih_media_item_lc_segs where active = 'Y'

145: l_end_date_time := c1_rec.last_update_date;
146: -- fnd_file.put_line(fnd_file.log,'Media item id is abandoned ' || c1_rec.media_item_id);
147: -- dbms_output.put_line('Media item id is abandoned ' || c1_rec.media_item_id);
148: declare cursor c2 is
149: select milcs_id, start_date_time from jtf_ih_media_item_lc_segs where active = 'Y'
150: and media_id = c1_rec.media_item_id;
151: begin
152: for c2_rec in c2 loop
153: begin

Line 187: select count(*) into l_unclosed_wa_lc_segs from jtf_ih_media_item_lc_segs c

183: else
184: begin
185: -- dbms_output.put_line('Media item id is NOT abandoned ' || c1_rec.media_item_id);
186:
187: select count(*) into l_unclosed_wa_lc_segs from jtf_ih_media_item_lc_segs c
188: where c.end_date_time is null
189: and c.media_id = c1_rec.media_item_id
190: and c.milcs_type_id = CCT_IH_PUB.G_IH_LCS_TYPE_WITH_AGENT;
191:

Line 192: select count(*) into l_total_wa_lc_segs from jtf_ih_media_item_lc_segs c

188: where c.end_date_time is null
189: and c.media_id = c1_rec.media_item_id
190: and c.milcs_type_id = CCT_IH_PUB.G_IH_LCS_TYPE_WITH_AGENT;
191:
192: select count(*) into l_total_wa_lc_segs from jtf_ih_media_item_lc_segs c
193: where c.media_id = c1_rec.media_item_id
194: and c.milcs_type_id = CCT_IH_PUB.G_IH_LCS_TYPE_WITH_AGENT;
195:
196: if ((l_unclosed_wa_lc_segs > 0 ) or (l_total_wa_lc_segs = 0)) then raise no_data_found_ex;

Line 199: select max(c.end_date_time) into l_end_date_time from jtf_ih_media_item_lc_segs c

195:
196: if ((l_unclosed_wa_lc_segs > 0 ) or (l_total_wa_lc_segs = 0)) then raise no_data_found_ex;
197: end if;
198:
199: select max(c.end_date_time) into l_end_date_time from jtf_ih_media_item_lc_segs c
200: where c.media_id = c1_rec.media_item_id and c.milcs_type_id = CCT_IH_PUB.G_IH_LCS_TYPE_WITH_AGENT;
201:
202: -- if sql%notfound then raise no_data_found_ex;
203: -- end if;

Line 207: select max(c.start_date_time) into l_start_date_time from jtf_ih_media_item_lc_segs c

203: -- end if;
204: if l_end_date_time is null then raise no_data_found_ex;
205: end if;
206:
207: select max(c.start_date_time) into l_start_date_time from jtf_ih_media_item_lc_segs c
208: where c.media_id = c1_rec.media_item_id and c.milcs_type_id = CCT_IH_PUB.G_IH_LCS_TYPE_WITH_AGENT;
209:
210: l_in_queue_start_date_time := null;
211:

Line 212: select max(c.start_date_time) into l_in_queue_start_date_time from jtf_ih_media_item_lc_segs c

208: where c.media_id = c1_rec.media_item_id and c.milcs_type_id = CCT_IH_PUB.G_IH_LCS_TYPE_WITH_AGENT;
209:
210: l_in_queue_start_date_time := null;
211:
212: select max(c.start_date_time) into l_in_queue_start_date_time from jtf_ih_media_item_lc_segs c
213: where c.media_id = c1_rec.media_item_id and c.milcs_type_id = CCT_IH_PUB.G_IH_LCS_TYPE_IN_QUEUE;
214:
215: -- if sql%notfound then null;
216: -- end if;

Line 493: select max(c.end_date_time) into l_max_milcs_end_date_time from jtf_ih_media_item_lc_segs c

489:
490: l_duration := 0;
491: l_end_date_time := c1_rec.start_date_time;
492:
493: select max(c.end_date_time) into l_max_milcs_end_date_time from jtf_ih_media_item_lc_segs c
494: where c.media_id = c1_rec.media_id;
495: select max(c.start_date_time) into l_max_milcs_start_date_time from jtf_ih_media_item_lc_segs c
496: where c.media_id = c1_rec.media_id;
497:

Line 495: select max(c.start_date_time) into l_max_milcs_start_date_time from jtf_ih_media_item_lc_segs c

491: l_end_date_time := c1_rec.start_date_time;
492:
493: select max(c.end_date_time) into l_max_milcs_end_date_time from jtf_ih_media_item_lc_segs c
494: where c.media_id = c1_rec.media_id;
495: select max(c.start_date_time) into l_max_milcs_start_date_time from jtf_ih_media_item_lc_segs c
496: where c.media_id = c1_rec.media_id;
497:
498: if (l_max_milcs_end_date_time is not null) then
499: -- dbms_output.put_line('there is at least 1 lcs segment for this media item');

Line 533: select milcs_id, start_date_time from jtf_ih_media_item_lc_segs where active = 'Y'

529:
530: -- fnd_file.put_line(fnd_file.log,'l_duration' || to_char(l_duration));
531: -- dbms_output.put_line('l_duration' || to_char(l_duration));
532: declare cursor c2 is
533: select milcs_id, start_date_time from jtf_ih_media_item_lc_segs where active = 'Y'
534: and media_id = c1_rec.media_id;
535: begin
536: for c2_rec in c2 loop
537: begin