DBA Data[Home] [Help]

APPS.FLM_MMM_CALCULATION dependencies on BOM_OPERATION_SEQUENCES

Line 833: bom_operation_sequences bos

829: bos.labor_time_calc labor_time,
830: bos.total_time_calc elapsed_time,
831: bor.line_id line_id
832: FROM bom_operational_routings bor,
833: bom_operation_sequences bos
834: WHERE bor.assembly_item_id = i_assembly_item_id
835: AND bor.organization_id = i_organization_id
836: AND bor.cfm_routing_flag = 1
837: AND bor.mixed_model_map_flag = 1

Line 1184: bom_operation_sequences bos1,

1180: nvl(l_hour_conv, 1)) resource_usage
1181: FROM flm_mmm_operations op,
1182: flm_mmm_op_items it,
1183: bom_operational_routings brtg,
1184: bom_operation_sequences bos1,
1185: bom_operation_sequences bos2,
1186: bom_operation_resources bor,
1187: bom_resources br,
1188: mtl_uom_conversions muc

Line 1185: bom_operation_sequences bos2,

1181: FROM flm_mmm_operations op,
1182: flm_mmm_op_items it,
1183: bom_operational_routings brtg,
1184: bom_operation_sequences bos1,
1185: bom_operation_sequences bos2,
1186: bom_operation_resources bor,
1187: bom_resources br,
1188: mtl_uom_conversions muc
1189: WHERE op.plan_id = i_plan_id

Line 2288: bom_operation_sequences bos

2284: INTO l_weighted_process_efficiency,
2285: l_operation_process_volume
2286: FROM flm_mmm_op_items it,
2287: bom_operational_routings bor,
2288: bom_operation_sequences bos
2289: WHERE it.plan_id = i_plan_id
2290: AND it.organization_id = i_organization_id
2291: AND it.operation_type = i_calc_op_type
2292: AND it.line_id = operation_rec.line_id