[Home] [Help]
468: -- Also find the highest priority among the routings
469: -- ---------------------------------------------------
470: SELECT min(bor.priority), count(*)
471: INTO l_highest_priority, l_num_routings
472: FROM bom_operational_routings bor
473: WHERE bor.organization_id = p_organization_id
474: AND bor.assembly_item_id = p_assembly_item_id
475: AND bor.cfm_routing_flag = 1
476: AND bor.line_id = p_line_id;
499:
500:
501: SELECT 'Condition Satisfied'
502: INTO l_dummy
503: FROM bom_operational_routings bor
504: WHERE bor.organization_id = p_organization_id
505: AND bor.assembly_item_id = p_assembly_item_id
506: AND bor.line_id = p_line_id
507: AND bor.cfm_routing_flag = 1
742: -- (if its a kanban item) stored (hopefully) in mtl_kanban_pull_sequences
743: -- table. The catch here is that for a production kind of source type in
744: -- in the replenishment chain we specify a line for the source. We want
745: -- this to be the line that's specified in the CFM routing with priority = 1
746: -- so we end up joining bom_operational_routings table also.
747:
748: mrp_kanban_plan_pk.g_stmt_num := 60;
749: IF mrp_kanban_plan_pk.g_debug THEN
750: mrp_kanban_plan_pk.g_log_message := 'Debug Statement Number : '
1279: SET (mllc.operation_yield,mllc.net_planning_percent) =
1280: (SELECT min(bos.reverse_cumulative_yield),
1281: min(bos.net_planning_percent)
1282: FROM bom_operation_sequences bos,
1283: bom_operational_routings bor,
1284: bom_inventory_components mrp_bic,
1285: bom_bill_of_materials bbom
1286: WHERE bbom.assembly_item_id = mllc.assembly_item_id
1287: AND bbom.organization_id = mllc.organization_id