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,
109: mtl_uom_conversions con
110: -- WHERE bor.schedule_flag <> 2
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,
109: mtl_uom_conversions con
110: -- WHERE bor.schedule_flag <> 2
111: WHERE bor.resource_id = br.resource_id
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,
142: mtl_uom_conversions con
143: -- WHERE bor.schedule_flag <> 2
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,
142: mtl_uom_conversions con
143: -- WHERE bor.schedule_flag <> 2
144: WHERE bor.resource_id = br.resource_id
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,
174: mtl_uom_conversions con
175: WHERE bor.schedule_flag <> 2
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,
174: mtl_uom_conversions con
175: WHERE bor.schedule_flag <> 2
176: AND bor.resource_id = br.resource_id