APPS.FLM_MMM_CALCULATION dependencies on FLM_MMM_OP_ITEMS

Line 901: INSERT INTO flm_mmm_op_items (

897: op_seq_rec.elapsed_time
898: );
899: END IF;
900:
901: INSERT INTO flm_mmm_op_items (
902: plan_id,
903: organization_id,
904: assembly_item_id,
905: line_id,

Line 976: flm_mmm_op_items it

972: it.operation_type,
973: nvl(line.hours_per_day,1)/
974: nvl(sum(it.process_volume), 1) operation_takt
975: FROM flm_mmm_lines line,
976: flm_mmm_op_items it
977: WHERE line.plan_id = i_plan_id
978: AND line.organization_id = i_organization_id
979: AND line.calculation_operation_type = it.operation_type --bug 5725595
980: AND it.plan_id = i_plan_id

Line 1113: FROM flm_mmm_op_items

1109: elapsed_weighted_time
1110: INTO l_machine_wt,
1111: l_labor_wt,
1112: l_elapsed_wt
1113: FROM flm_mmm_op_items
1114: WHERE plan_id = i_plan_id
1115: AND organization_id = i_organization_id
1116: AND standard_operation_id = op_rec.standard_operation_id
1117: GROUP BY standard_operation_id;

Line 1182: flm_mmm_op_items it,

1178: it.process_volume,
1179: sum(bor.usage_rate_or_amount * nvl(muc.conversion_rate, 0) /
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,

Line 2286: FROM flm_mmm_op_items it,

2282: SELECT sum(nvl(bos.total_process_efficiency, 0) * nvl(it.process_volume, 0) ),
2283: sum(nvl(it.process_volume, 0))
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

Line 2350: -- FLM_MMM_OP_ITEMS

2346: AND organization_id = i_organization_id
2347: AND operation_type = i_calc_op_type;
2348: END IF;
2349:
2350: -- FLM_MMM_OP_ITEMS
2351: DELETE FROM flm_mmm_op_items
2352: WHERE plan_id = i_plan_id
2353: AND organization_id = i_organization_id
2354: AND operation_type = i_calc_op_type;

Line 2351: DELETE FROM flm_mmm_op_items

2347: AND operation_type = i_calc_op_type;
2348: END IF;
2349:
2350: -- FLM_MMM_OP_ITEMS
2351: DELETE FROM flm_mmm_op_items
2352: WHERE plan_id = i_plan_id
2353: AND organization_id = i_organization_id
2354: AND operation_type = i_calc_op_type;
2355: