APPS.FLM_MMM_CALCULATION dependencies on BOM_OPERATIONAL_ROUTINGS

Line 214: from bom_operational_routings bor2

210: AND SL1.ITEM_TYPE_CODE in ('STANDARD', 'CONFIG', 'INCLUDED', 'OPTION')
211: AND OE_INSTALL.GET_ACTIVE_PRODUCT = 'ONT'
212: AND wl.organization_id = sl1.ship_from_org_id
213: AND wl.line_id in (select line_id
214: from bom_operational_routings bor2
215: where bor2.assembly_item_id = sl1.inventory_item_id
216: and bor2.organization_id = sl1.ship_from_org_id
217: and bor2.cfm_routing_flag = 1)
218: AND SL1.SHIPPED_QUANTITY is NULL

Line 271: from bom_operational_routings bor2

267: AND RSI1.BOM_ITEM_TYPE = 4
268: AND (RSI1.IN_SOURCE_PLAN = 2 OR RSI1.IN_SOURCE_PLAN IS NULL)
269: AND wl.organization_id = MR1.ORGANIZATION_ID
270: AND wl.line_id in (select line_id
271: from bom_operational_routings bor2
272: where bor2.assembly_item_id = MR1.INVENTORY_ITEM_ID
273: and bor2.organization_id = MR1.ORGANIZATION_ID
274: and bor2.cfm_routing_flag = 1)
275: /* cursor specific criteria */

Line 284: FROM bom_operational_routings

280:
281: -- cursor to retrieve line_id for given item_id
282: CURSOR line(i_assembly_item_id IN NUMBER) IS
283: SELECT distinct line_id
284: FROM bom_operational_routings
285: WHERE organization_id = i_organization_id
286: AND assembly_item_id = i_assembly_item_id
287: AND cfm_routing_flag = 1
288: AND mixed_model_map_flag = 1;

Line 832: FROM bom_operational_routings bor,

828: bos.machine_time_calc machine_time,
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

Line 1183: bom_operational_routings brtg,

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,
1187: bom_resources br,

Line 2287: bom_operational_routings bor,

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
2291: AND it.operation_type = i_calc_op_type