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_SEQUENCES

Line 76: from bom_operation_sequences

72: start with to_op_seq_id = c_line_op_id
73: and transition_type <> 3;
74: cursor all_prior_line_ops2 IS
75: select operation_sequence_id, operation_seq_num
76: from bom_operation_sequences
77: where routing_sequence_id = l_rtg_seq_id
78: and operation_seq_num < p_curr_line_op
79: and operation_type = 3
80: and nvl(eco_for_production,2) = 2

Line 82: from bom_operation_sequences

78: and operation_seq_num < p_curr_line_op
79: and operation_type = 3
80: and nvl(eco_for_production,2) = 2
81: and exists (select null
82: from bom_operation_sequences
83: where routing_sequence_id = l_rtg_seq_id
84: and operation_seq_num = p_curr_line_op
85: and nvl(eco_for_production,2) = 2
86: and operation_type = 3);

Line 101: from bom_operation_sequences

97:
98: if check_network_exists(l_rtg_seq_id) then
99: select operation_sequence_id
100: into l_op_seq_id
101: from bom_operation_sequences
102: where routing_sequence_id = l_rtg_seq_id
103: and operation_type = 3
104: and nvl(eco_for_production,2) = 2
105: and operation_seq_num = p_curr_line_op;

Line 110: from bom_operation_sequences

106:
107: FOR all_prior_line_op_rec IN all_prior_line_ops(l_op_seq_id) LOOP
108: select operation_seq_num
109: into l_op_seq_num
110: from bom_operation_sequences
111: where operation_sequence_id =
112: all_prior_line_op_rec.operation_sequence_id;
113:
114: if (NOT find_line_op (l_op_seq_num, x_Op_Tbl)) then

Line 167: from bom_operation_sequences

163: and transition_type NOT IN (1, 3);
164:
165: cursor primary_prior_line_ops2 IS
166: select operation_sequence_id, operation_seq_num
167: from bom_operation_sequences
168: where routing_sequence_id = l_rtg_seq_id
169: and operation_seq_num < p_curr_line_op
170: and operation_type = 3
171: and nvl(eco_for_production,2) = 2

Line 173: from bom_operation_sequences

169: and operation_seq_num < p_curr_line_op
170: and operation_type = 3
171: and nvl(eco_for_production,2) = 2
172: and exists (select null
173: from bom_operation_sequences
174: where routing_sequence_id = l_rtg_seq_id
175: and operation_seq_num = p_curr_line_op
176: and nvl(eco_for_production,2) = 2
177: and operation_type = 3);

Line 193: from bom_operation_sequences

189: if check_network_exists(l_rtg_seq_id) then
190: BEGIN
191: select operation_sequence_id
192: into l_op_seq_id
193: from bom_operation_sequences
194: where routing_sequence_id = l_rtg_seq_id
195: and operation_type = 3
196: and operation_seq_num = p_curr_line_op;
197:

Line 208: from bom_operation_sequences

204:
205: FOR primary_line_op_rec IN primary_prior_line_ops(l_op_seq_id) LOOP
206: select operation_seq_num
207: into l_op_seq_num
208: from bom_operation_sequences
209: where operation_sequence_id =
210: primary_line_op_rec.operation_sequence_id;
211: If (NOT find_line_op(l_op_seq_num, x_Op_Tbl)) then
212: x_Op_Tbl(i).operation_sequence_id :=

Line 222: from bom_operation_sequences

218: EXCEPTION WHEN NO_DATA_FOUND THEN
219: FOR alt_line_op_rec IN alt_prior_line_ops(l_op_seq_id) LOOP
220: select operation_seq_num
221: into l_op_seq_num
222: from bom_operation_sequences
223: where operation_sequence_id =
224: alt_line_op_rec.operation_sequence_id;
225:
226: if (NOT find_line_op(l_op_seq_num, x_Op_Tbl)) then

Line 239: from bom_operation_sequences

235: primary_prior_line_ops(l_last_alt_line_op)
236: LOOP
237: select operation_seq_num
238: into l_op_seq_num
239: from bom_operation_sequences
240: where operation_sequence_id =
241: primary_line_op_rec.operation_sequence_id;
242: if (NOT find_line_op(l_op_seq_num, x_Op_Tbl)) then
243: x_Op_Tbl(i).operation_seq_num := l_op_seq_num;

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 317: from bom_operation_sequences

313: and bos3.routing_sequence_id = l_rtg_seq_id
314: and net.from_op_seq_id = bos3.operation_sequence_id );
315: cursor all_line_ops2 IS
316: select operation_sequence_id, operation_seq_num
317: from bom_operation_sequences
318: where routing_sequence_id = l_rtg_seq_id
319: and nvl(eco_for_production,2) = 2
320: and operation_type = 3;
321:

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 405: from bom_operation_sequences

401: and net.from_op_seq_id = bos3.operation_sequence_id );
402:
403: cursor all_primary_line_ops2 IS
404: select operation_sequence_id, operation_seq_num
405: from bom_operation_sequences
406: where routing_sequence_id = l_rtg_seq_id
407: and nvl(eco_for_production,2) = 2
408: and operation_type = 3;
409:

Line 458: from bom_operation_sequences

454: start with from_op_seq_id = c_line_op_id
455: and transition_type <> 3;
456: cursor all_next_line_ops2 IS
457: select operation_sequence_id, operation_seq_num
458: from bom_operation_sequences
459: where routing_sequence_id = l_rtg_seq_id
460: and operation_seq_num > p_curr_line_op
461: and nvl(eco_for_production,2) = 2
462: and operation_type = 3

Line 464: from bom_operation_sequences

460: and operation_seq_num > p_curr_line_op
461: and nvl(eco_for_production,2) = 2
462: and operation_type = 3
463: and exists (select null
464: from bom_operation_sequences
465: where routing_sequence_id = l_rtg_seq_id
466: and operation_seq_num = p_curr_line_op
467: and operation_type = 3);
468:

Line 482: from bom_operation_sequences

478:
479: if check_network_exists(l_rtg_seq_id) then
480: select operation_sequence_id
481: into l_op_seq_id
482: from bom_operation_sequences
483: where routing_sequence_id = l_rtg_seq_id
484: and operation_type = 3
485: and operation_seq_num = p_curr_line_op;
486:

Line 490: from bom_operation_sequences

486:
487: FOR all_next_line_op_rec IN all_next_line_ops(l_op_seq_id) LOOP
488: select operation_seq_num
489: into l_op_seq_num
490: from bom_operation_sequences
491: where operation_sequence_id =
492: all_next_line_op_rec.operation_sequence_id;
493: if (NOT find_line_op (l_op_seq_num, x_Op_Tbl)) then
494: x_Op_Tbl(i).operation_sequence_id :=

Line 564: from bom_operation_sequences

560: else
561: BEGIN
562: select MIN(operation_seq_num)
563: into next_line_op
564: from bom_operation_sequences
565: where routing_sequence_id = l_rtg_seq_id
566: and operation_type = 3
567: and nvl(eco_for_production,2) = 2
568: and operation_seq_num > p_curr_line_op

Line 570: from bom_operation_sequences

566: and operation_type = 3
567: and nvl(eco_for_production,2) = 2
568: and operation_seq_num > p_curr_line_op
569: and exists (select null
570: from bom_operation_sequences
571: where routing_sequence_id = l_rtg_seq_id
572: and operation_type = 3
573: and operation_seq_num = p_curr_line_op);
574:

Line 632: from bom_operation_sequences

628: select 1
629: into l_last_op
630: from dual
631: where not exists (select null
632: from bom_operation_sequences
633: where routing_sequence_id = l_rtg_seq_id
634: and operation_type = 3
635: and nvl(eco_for_production,2) = 2
636: and operation_seq_num > p_curr_line_op)

Line 638: from bom_operation_sequences

634: and operation_type = 3
635: and nvl(eco_for_production,2) = 2
636: and operation_seq_num > p_curr_line_op)
637: and exists (select null
638: from bom_operation_sequences
639: where routing_sequence_id = l_rtg_seq_id
640: and operation_type = 3
641: and operation_seq_num = p_curr_line_op);
642: