[Home] [Help]
221: b.SUPPLY_LOCATOR_ID,
222: b.SUPPLY_SUBINVENTORY,
223: b.PICK_COMPONENTS,
224: i.BOM_ITEM_TYPE
225: from MTL_SYSTEM_ITEMS i,
226: BOM_INVENTORY_COMPS_INTERFACE b,
227: BOM_BILL_OF_MTLS_INTERFACE b1
228: where b.bill_sequence_id = b1.bill_sequence_id
229: and b1.organization_id = i.organization_id
882: AND NVL(bos4.operation_type,1) = NVL(bos2.operation_type, 1)
883: AND bos1.routing_sequence_id = ( /* find the model routing */
884: select routing_sequence_id
885: from bom_operational_routings bor,
886: mtl_system_items_interface msi
887: where brif.assembly_item_id = msi.inventory_item_id
888: and brif.organization_id = msi.organization_id
889: and bor.assembly_item_id = msi.copy_item_id
890: and bor.organization_id = msi.organization_id
1227: x_to_sequence_id number;
1228:
1229: cursor allconfigs is
1230: select inventory_item_id, organization_id,copy_item_id
1231: from mtl_system_items_interface m
1232: where m.set_id = to_char(to_number(USERENV('SESSIONID')));
1233: BEGIN
1234: status := 1; /* init status */
1235:
1383: where b1.rowid in ( select b.rowid
1384: from BOM_REF_DESGS_INTERFACE b,
1385: BOM_INVENTORY_COMPS_INTERFACE b2,
1386: BOM_BILL_OF_MTLS_INTERFACE b3,
1387: MTL_SYSTEM_ITEMS_INTERFACE m
1388: where b.component_sequence_id = b2.component_sequence_id
1389: and b2.bill_sequence_id = b3.bill_sequence_id
1390: and b3.demand_source_line = m.demand_source_line
1391: and b3.demand_source_type = m.demand_source_type
1400: where b1.rowid in ( select b.rowid
1401: from BOM_SUB_COMPS_INTERFACE b,
1402: BOM_INVENTORY_COMPS_INTERFACE b2,
1403: BOM_BILL_OF_MTLS_INTERFACE b3,
1404: MTL_SYSTEM_ITEMS_INTERFACE m
1405: where b.component_sequence_id = b2.component_sequence_id
1406: and b2.bill_sequence_id = b3.bill_sequence_id
1407: and b3.demand_source_line = m.demand_source_line
1408: and b3.demand_source_type = m.demand_source_type