DBA Data[Home] [Help]

APPS.BOM_CALC_OP_TIMES_PK dependencies on BOM_DEPARTMENT_RESOURCES

Line 106: bom_department_resources bdr2,

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

Line 107: bom_department_resources bdr1,

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

Line 139: bom_department_resources bdr2,

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

Line 140: bom_department_resources bdr1,

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

Line 171: bom_department_resources bdr2,

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

Line 172: bom_department_resources bdr1,

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