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.BOM_RTG_NETWORK_API dependencies on BOM_OPERATION_NETWORKS

Line 47: from bom_operation_networks_v

43: select 1
44: into net_exists
45: from dual
46: where exists (select null
47: from bom_operation_networks_v
48: where routing_sequence_id = p_rtg_sequence_id
49: and operation_type = 3);
50:
51: return (TRUE);

Line 69: from bom_operation_networks

65: l_op_seq_id NUMBER;
66: l_op_seq_num NUMBER;
67: cursor all_prior_line_ops (c_line_op_id NUMBER) IS
68: select from_op_seq_id operation_sequence_id
69: from bom_operation_networks
70: connect by prior from_op_seq_id = to_op_seq_id
71: and transition_type <> 3
72: start with to_op_seq_id = c_line_op_id
73: and transition_type <> 3;

Line 151: from bom_operation_networks

147: l_op_seq_num NUMBER;
148: l_op_seq_id NUMBER;
149: cursor primary_prior_line_ops (c_line_op_id NUMBER) IS
150: select from_op_seq_id operation_sequence_id
151: from bom_operation_networks
152: connect by prior from_op_seq_id = to_op_seq_id
153: and transition_type NOT IN (2, 3)
154: start with to_op_seq_id = c_line_op_id
155: and transition_type NOT IN (2, 3);

Line 159: from bom_operation_networks

155: and transition_type NOT IN (2, 3);
156:
157: cursor alt_prior_line_ops (c_line_op_id NUMBER) IS
158: select from_op_seq_id operation_sequence_id
159: from bom_operation_networks
160: connect by prior from_op_seq_id = to_op_seq_id
161: and transition_type NOT IN (1, 3)
162: start with to_op_seq_id = c_line_op_id
163: and transition_type NOT IN (1, 3);

Line 200: from bom_operation_networks

196: and operation_seq_num = p_curr_line_op;
197:
198: select 1
199: into l_transition_type
200: from bom_operation_networks
201: where to_op_seq_id = l_op_seq_id
202: and transition_type = 1
203: and rownum =1 ;
204:

Line 277: from bom_operation_networks_v

273: I Integer := 1;
274: /*Cursor all_line_ops is
275: select from_seq_num operation_seq_num ,
276: from_op_seq_id operation_sequence_id
277: from bom_operation_networks_v
278: where routing_sequence_id = l_rtg_seq_id
279: and operation_type = 3
280: and transition_type <> 3
281: union

Line 284: from bom_operation_networks_v bonv

280: and transition_type <> 3
281: union
282: select bonv.to_seq_num operation_seq_num,
283: to_op_seq_id operation_sequence_id
284: from bom_operation_networks_v bonv
285: where routing_sequence_id = l_rtg_seq_id
286: and operation_type = 3
287: and not exists (select null
288: from bom_operation_networks_v net

Line 288: from bom_operation_networks_v net

284: from bom_operation_networks_v bonv
285: where routing_sequence_id = l_rtg_seq_id
286: and operation_type = 3
287: and not exists (select null
288: from bom_operation_networks_v net
289: where bonv.to_op_seq_id = net.from_op_seq_id
290: and transition_type <> 3
291: and net.routing_sequence_id = l_rtg_seq_id);
292: */

Line 297: from bom_operation_networks bon1 ,bom_operation_sequences bos1

293: -- Replaced the sql for the cursor above with the one below for better performance BUG 4929600
294: Cursor all_line_ops is
295: select bos1.operation_seq_num operation_seq_num ,
296: bon1.from_op_seq_id operation_sequence_id
297: from bom_operation_networks bon1 ,bom_operation_sequences bos1
298: where bos1.routing_sequence_id = l_rtg_seq_id
299: and bos1.operation_type = 3
300: and bon1.transition_type <> 3
301: and bon1.from_op_seq_id = bos1.operation_sequence_id

Line 305: from bom_operation_networks bon2, bom_operation_sequences bos2

301: and bon1.from_op_seq_id = bos1.operation_sequence_id
302: union
303: select bos2.operation_seq_num operation_seq_num,
304: bon2.to_op_seq_id operation_sequence_id
305: from bom_operation_networks bon2, bom_operation_sequences bos2
306: where bos2.routing_sequence_id = l_rtg_seq_id
307: and bos2.operation_type = 3
308: and bon2.to_op_seq_id = bos2.operation_sequence_id
309: and not exists ( select null

Line 310: from bom_operation_networks net ,bom_operation_sequences bos3

306: where bos2.routing_sequence_id = l_rtg_seq_id
307: and bos2.operation_type = 3
308: and bon2.to_op_seq_id = bos2.operation_sequence_id
309: and not exists ( select null
310: from bom_operation_networks net ,bom_operation_sequences bos3
311: where bon2.to_op_seq_id = net.from_op_seq_id
312: and net.transition_type <> 3
313: and bos3.routing_sequence_id = l_rtg_seq_id
314: and net.from_op_seq_id = bos3.operation_sequence_id );

Line 362: from bom_operation_networks_v

358: I Integer := 1;
359: /*Cursor all_primary_line_ops is
360: select from_seq_num operation_seq_num ,
361: from_op_seq_id operation_sequence_id
362: from bom_operation_networks_v
363: where routing_sequence_id = l_rtg_seq_id
364: and transition_type = 1
365: and operation_type = 3
366: union

Line 369: from bom_operation_networks_v bonv

365: and operation_type = 3
366: union
367: select bonv.to_seq_num operation_seq_num,
368: to_op_seq_id operation_sequence_id
369: from bom_operation_networks_v bonv
370: where routing_sequence_id = l_rtg_seq_id
371: and transition_type = 1
372: and operation_type = 3
373: and not exists (select null

Line 374: from bom_operation_networks_v net

370: where routing_sequence_id = l_rtg_seq_id
371: and transition_type = 1
372: and operation_type = 3
373: and not exists (select null
374: from bom_operation_networks_v net
375: where bonv.to_op_seq_id = net.from_op_seq_id
376: and transition_type <> 3
377: and net.routing_sequence_id = l_rtg_seq_id);
378: */

Line 383: from bom_operation_networks bon1 ,bom_operation_sequences bos1

379: -- Replaced the sql for the cursor above with the one below for better performance BUG 4929600
380: Cursor all_primary_line_ops is
381: select bos1.operation_seq_num operation_seq_num ,
382: bon1.from_op_seq_id operation_sequence_id
383: from bom_operation_networks bon1 ,bom_operation_sequences bos1
384: where bos1.routing_sequence_id = l_rtg_seq_id
385: and bon1.transition_type = 1
386: and bos1.operation_type = 3
387: and bon1.from_op_seq_id = bos1.operation_sequence_id

Line 391: from bom_operation_networks bon2, bom_operation_sequences bos2

387: and bon1.from_op_seq_id = bos1.operation_sequence_id
388: union
389: select bos2.operation_seq_num operation_seq_num,
390: bon2.to_op_seq_id operation_sequence_id
391: from bom_operation_networks bon2, bom_operation_sequences bos2
392: where bos2.routing_sequence_id = l_rtg_seq_id
393: and bon2.transition_type = 1
394: and bos2.operation_type = 3
395: and bon2.to_op_seq_id = bos2.operation_sequence_id

Line 397: from bom_operation_networks net ,bom_operation_sequences bos3

393: and bon2.transition_type = 1
394: and bos2.operation_type = 3
395: and bon2.to_op_seq_id = bos2.operation_sequence_id
396: and not exists ( select null
397: from bom_operation_networks net ,bom_operation_sequences bos3
398: where bon2.to_op_seq_id = net.from_op_seq_id
399: and net.transition_type <> 3
400: and bos3.routing_sequence_id = l_rtg_seq_id
401: and net.from_op_seq_id = bos3.operation_sequence_id );

Line 451: from bom_operation_networks

447: l_op_seq_id NUMBER;
448: l_op_seq_num NUMBER;
449: cursor all_next_line_ops (c_line_op_id NUMBER) IS
450: select to_op_seq_id operation_sequence_id
451: from bom_operation_networks
452: connect by prior to_op_seq_id = from_op_seq_id
453: and transition_type <> 3
454: start with from_op_seq_id = c_line_op_id
455: and transition_type <> 3;

Line 536: from bom_operation_networks_v

532: if check_network_exists(l_rtg_seq_id) then
533: BEGIN
534: select to_seq_num
535: into next_line_op
536: from bom_operation_networks_v
537: where routing_sequence_id = l_rtg_seq_id
538: and operation_type = 3
539: and from_seq_num = p_curr_line_op
540: and transition_type = 1;

Line 548: from bom_operation_networks_v

544: EXCEPTION WHEN NO_DATA_FOUND THEN
545: BEGIN
546: select min(to_seq_num)
547: into next_line_op
548: from bom_operation_networks_v
549: where routing_sequence_id = l_rtg_seq_id
550: and operation_type = 3
551: and from_seq_num = p_curr_line_op
552: and transition_type = 2;

Line 610: from bom_operation_networks_v

606: select 1
607: into l_last_op
608: from dual
609: where not exists (select null
610: from bom_operation_networks_v
611: where from_seq_num = p_curr_line_op
612: and operation_type = 3
613: and transition_type <> 3
614: and routing_sequence_id = l_rtg_seq_id)

Line 616: from bom_operation_networks_v

612: and operation_type = 3
613: and transition_type <> 3
614: and routing_sequence_id = l_rtg_seq_id)
615: and exists (select null
616: from bom_operation_networks_v
617: where to_seq_num = p_curr_line_op
618: and transition_type <> 3
619: and operation_type = 3
620: and routing_sequence_id = l_rtg_seq_id);