[Home] [Help]
333: -- MUST BE MEMBERS OF THE GIVEN FAMILY.
334:
335: CURSOR c1 IS
336: SELECT distinct bso.operation_code OC, bso.sequence_num SN
337: FROM bom_standard_operations bso,
338: bom_operation_sequences bos,
339: bom_operational_routings bor
340: WHERE bor.mixed_model_map_flag = 1
341: AND bor.line_id = p_line_id
356:
357: -- SAME AS C1, EXCEPT ORDER BY IS DIFFERENT
358: CURSOR c2 IS
359: SELECT distinct bso.operation_code OC, bso.sequence_num SN
360: FROM bom_standard_operations bso,
361: bom_operation_sequences bos,
362: bom_operational_routings bor
363: WHERE bor.mixed_model_map_flag = 1
364: AND bor.line_id = p_line_id
1741: br.resource_type,
1742: p_org_id,
1743: l_res_detail_table(l_index).resource_needed
1744: from cst_activities ca,
1745: bom_standard_operations bso,
1746: bom_resources br
1747: where ca.activity_id = l_res_detail_table(l_index).activity_id
1748: and bso.standard_operation_id = l_res_detail_table(l_index).standard_operation_id
1749: and br.resource_id = l_res_detail_table(l_index).resource_id;
1770: bso.operation_code,
1771: br.resource_type,
1772: p_org_id,
1773: l_res_detail_table(l_index).resource_needed
1774: from bom_standard_operations bso,
1775: bom_resources br
1776: where bso.standard_operation_id = l_res_detail_table(l_index).standard_operation_id
1777: and br.resource_id = l_res_detail_table(l_index).resource_id;
1778: end if;
2104: ((1 + nvl((p_boost_percent * .01), 0)) *
2105: nvl((1/(avg(decode(nvl(reverse_cumulative_yield, 1),0,1,nvl(reverse_cumulative_yield,1))))),1) *
2106: nvl(avg(nvl((net_planning_percent * .01), 1)),1) * l_demand)
2107: process_volume
2108: FROM bom_standard_operations bso,
2109: bom_operation_sequences bos,
2110: bom_operational_routings bor
2111: WHERE bor.assembly_item_id = c1rec.AII
2112: AND bor.mixed_model_map_flag = 1