DBA Data[Home] [Help]

APPS.BOM_CALC_OP_TIMES_PK dependencies on BOM_OPERATION_RESOURCES

Line 105: bom_operation_resources bor,

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,
109: mtl_uom_conversions con

Line 138: bom_operation_resources bor,

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,
142: mtl_uom_conversions con

Line 170: bom_operation_resources bor,

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,
174: mtl_uom_conversions con