[Home] [Help]
211: SELECT bopr.resource_id id , bosv.department_id dept_id
212: FROM bom_operation_resources bopr,
213: bom_resources br,
214: bom_operation_sequences_v bosv,
215: bom_operational_routings bor
216: WHERE bopr.operation_sequence_id= bosv.operation_sequence_id
217: AND bopr.resource_id = br.resource_id
218: AND br.resource_type = p_resource_type
219: AND bor.mixed_model_map_flag = 1
228: SELECT bopr.resource_id id , bosv.department_id dept_id
229: FROM bom_operation_resources bopr,
230: bom_resources br,
231: bom_operation_sequences_v bosv,
232: bom_operational_routings bor
233: WHERE bopr.operation_sequence_id= bosv.operation_sequence_id
234: AND bopr.resource_id = br.resource_id
235: AND br.resource_type = p_resource_type
236: AND bor.mixed_model_map_flag = 1
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
342: AND bor.organization_id = p_org_id
343: AND bor.common_routing_sequence_id = bos.routing_sequence_id
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
365: AND bor.organization_id = p_org_id
366: AND bor.common_routing_sequence_id = bos.routing_sequence_id
713: AND SL1.ITEM_TYPE_CODE in ('STANDARD', 'CONFIG', 'INCLUDED', 'OPTION')
714: AND OE_INSTALL.GET_ACTIVE_PRODUCT = 'ONT'
715: AND wl.organization_id = sl1.ship_from_org_id
716: AND wl.line_id in (select line_id
717: from bom_operational_routings bor2
718: where bor2.assembly_item_id = sl1.inventory_item_id
719: and bor2.organization_id = sl1.ship_from_org_id
720: and bor2.cfm_routing_flag = 1)
721: AND SL1.SHIPPED_QUANTITY is NULL
781: AND RSI1.BOM_ITEM_TYPE = 4
782: AND (RSI1.IN_SOURCE_PLAN = 2 OR RSI1.IN_SOURCE_PLAN IS NULL)
783: AND wl.organization_id = MR1.ORGANIZATION_ID
784: AND wl.line_id in (select line_id
785: from bom_operational_routings bor2
786: where bor2.assembly_item_id = MR1.INVENTORY_ITEM_ID
787: and bor2.organization_id = MR1.ORGANIZATION_ID
788: and bor2.cfm_routing_flag = 1)
789: )
1464:
1465: -- Cursor to Get Assembly Items
1466: CURSOR GetProducts IS
1467: SELECT assembly_item_id item_id
1468: FROM bom_operational_routings bor
1469: WHERE mixed_model_map_flag = 1
1470: AND line_id = p_line_id
1471: AND organization_id = p_org_id
1472: AND (p_family_item_id is null
1490: decode(bos1.reverse_cumulative_yield, '', 1,
1491: '0', 1, bos1.reverse_cumulative_yield)) resource_needed
1492: from bom_operation_resources bor,
1493: bom_resources br,
1494: bom_operational_routings brtg,
1495: bom_operation_sequences bos1,
1496: bom_operation_sequences bos2,
1497: mtl_uom_conversions con
1498: where brtg.line_id = p_line_id
1603: select bos.standard_operation_id op,
1604: bos.reverse_cumulative_yield yld,
1605: bos.net_planning_percent pct
1606: from bom_operation_sequences bos,
1607: bom_operational_routings bor
1608: where bor.assembly_item_id = l_assy_id
1609: and bor.mixed_model_map_flag = 1
1610: and bor.common_routing_sequence_id = bos.routing_sequence_id
1611: and bos.operation_type = p_operation_type;
1830: x_err_text OUT NOCOPY VARCHAR2) IS
1831:
1832: CURSOR GetProducts IS
1833: SELECT assembly_item_id AII
1834: FROM bom_operational_routings bor
1835: WHERE mixed_model_map_flag = 1
1836: AND line_id = p_line_id
1837: AND organization_id = p_org_id
1838: AND (p_family_item_id is null
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
2113: AND bor.organization_id = p_org_id
2114: AND bor.line_id = p_line_id