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_CALC_OP_TIMES_PK dependencies on BOM_OPERATION_SEQUENCES

Line 12: FROM bom_operation_sequences

8: arg_routing_sequence_id IN NUMBER) IS
9:
10: CURSOR Events_cur IS
11: SELECT operation_sequence_id
12: FROM bom_operation_sequences
13: WHERE routing_sequence_id = arg_routing_sequence_id
14: AND operation_type = 1
15: AND NVL(eco_for_production,2) = 2
16: AND NVL(disable_date, TRUNC(sysdate)+1) > TRUNC(sysdate);

Line 20: FROM bom_operation_sequences

16: AND NVL(disable_date, TRUNC(sysdate)+1) > TRUNC(sysdate);
17:
18: CURSOR Processes_cur IS
19: SELECT operation_sequence_id
20: FROM bom_operation_sequences
21: WHERE routing_sequence_id = arg_routing_sequence_id
22: AND NVL(eco_for_production,2) = 2
23: AND operation_type = 2;
24:

Line 27: FROM bom_operation_sequences

23: AND operation_type = 2;
24:
25: CURSOR Line_ops_cur IS
26: SELECT operation_sequence_id
27: FROM bom_operation_sequences
28: WHERE routing_sequence_id = arg_routing_sequence_id
29: AND NVL(eco_for_production,2) = 2
30: AND operation_type = 3;
31:

Line 34: FROM bom_operation_sequences

30: AND operation_type = 3;
31:
32: CURSOR All_Events_cur(v_seq_id NUMBER) IS
33: SELECT operation_sequence_id, operation_seq_num
34: FROM bom_operation_sequences
35: WHERE operation_type = 1
36: AND (line_op_seq_id = v_seq_id OR process_op_seq_id = v_seq_id)
37: AND routing_sequence_id = arg_routing_sequence_id
38: AND effectivity_date <= sysdate

Line 104: FROM bom_operation_sequences bos,

100: con.conversion_rate)/
101: DECODE(NVL(br.default_basis_type, 1) , 2, lot_qty,
102: 1, 1)), 0))/NVL(hour_conv, 1)
103: INTO var_machine_time
104: FROM bom_operation_sequences bos,
105: bom_operation_resources bor,
106: bom_department_resources bdr2,
107: bom_department_resources bdr1,
108: bom_resources br,

Line 137: FROM bom_operation_sequences bos,

133: con.conversion_rate)/
134: DECODE(NVL(br.default_basis_type, 1), 2, lot_qty,
135: 1, 1)), 0))/NVL(hour_conv, 1)
136: INTO var_labor_time
137: FROM bom_operation_sequences bos,
138: bom_operation_resources bor,
139: bom_department_resources bdr2,
140: bom_department_resources bdr1,
141: bom_resources br,

Line 169: FROM bom_operation_sequences bos,

165: con.conversion_rate)/
166: DECODE(NVL(br.default_basis_type, 1), 2, lot_qty,
167: 1, 1)), 0))/NVL(hour_conv, 1)
168: INTO var_elapsed_time
169: FROM bom_operation_sequences bos,
170: bom_operation_resources bor,
171: bom_department_resources bdr2,
172: bom_department_resources bdr1,
173: bom_resources br,

Line 195: UPDATE bom_operation_sequences

191: null;
192: END;
193:
194:
195: UPDATE bom_operation_sequences
196: SET machine_time_calc = NVL(var_machine_time, 0),
197: labor_time_calc = NVL(var_labor_time, 0),
198: total_time_calc = NVL(var_elapsed_time, 0)
199: WHERE operation_sequence_id = event_seq_id;

Line 229: FROM bom_operation_sequences

225: BEGIN
226: SELECT SUM(NVL(machine_time_calc, 0)), SUM(NVL(labor_time_calc, 0)),
227: SUM(NVL(total_time_calc, 0))
228: INTO var_machine_time, var_labor_time, var_elapsed_time
229: FROM bom_operation_sequences
230: WHERE operation_type = 1
231: AND process_op_seq_id = process_seq_id
232: AND nvl(disable_date, sysdate + 1) > sysdate -- BUG #2836627
233: AND routing_sequence_id = arg_routing_sequence_id;

Line 248: FROM bom_operation_sequences

244: FOR All_Events_cur_rec IN All_Events_cur(process_seq_id) LOOP
245:
246: SELECT machine_time_calc, labor_time_calc, total_time_calc
247: INTO v_machine_time, v_labor_time, v_elapsed_time
248: FROM bom_operation_sequences
249: WHERE operation_sequence_id = All_Events_cur_rec.operation_sequence_id;
250:
251: -- chk to see if process is associated with a non-OC component
252: -- if it is then, skip the chk OC loop

Line 362: UPDATE bom_operation_sequences

358: var_labor_time := avg_labor_time;
359: var_elapsed_time := avg_elapsed_time;
360: END IF;
361:
362: UPDATE bom_operation_sequences
363: SET machine_time_calc = NVL(var_machine_time, 0),
364: labor_time_calc = NVL(var_labor_time, 0),
365: total_time_calc = NVL(var_elapsed_time, 0)
366: WHERE operation_sequence_id = process_seq_id;

Line 384: FROM bom_operation_sequences

380: BEGIN
381: SELECT SUM(NVL(machine_time_calc, 0)), SUM(NVL(labor_time_calc, 0)),
382: SUM(NVL(total_time_calc, 0))
383: INTO var_machine_time, var_labor_time, var_elapsed_time
384: FROM bom_operation_sequences
385: WHERE operation_type = 1
386: AND line_op_seq_id = lineop_seq_id
387: AND nvl(disable_date, sysdate + 1) > sysdate -- BUG #2836627
388: AND routing_sequence_id = arg_routing_sequence_id;

Line 404: FROM bom_operation_sequences

400: FOR All_Events_cur_rec IN All_Events_cur(lineop_seq_id) LOOP
401:
402: SELECT machine_time_calc, labor_time_calc, total_time_calc
403: INTO v_machine_time, v_labor_time, v_elapsed_time
404: FROM bom_operation_sequences
405: WHERE operation_sequence_id = All_Events_cur_rec.operation_sequence_id;
406:
407: -- chk to see if event is associated with a non-OC component
408: -- (or maybe not associated at all)

Line 515: UPDATE bom_operation_sequences

511: var_labor_time := avg_labor_time;
512: var_elapsed_time := avg_elapsed_time;
513: END IF;
514:
515: UPDATE bom_operation_sequences
516: SET machine_time_calc = NVL(var_machine_time, 0),
517: labor_time_calc = NVL(var_labor_time, 0),
518: total_time_calc = NVL(var_elapsed_time, 0)
519: WHERE operation_sequence_id = lineop_seq_id;