2458: config routing, the operation_seq_num will be
2459: set to 1.
2460: +--------------------------------------------------------------*/
2461: lStmtNum := 130;
2462: xTableName := 'BOM_INVENTORY_COMPS_INTERFACE';
2463:
2464: update bom_inventory_comps_interface ci
2465: set ci.operation_seq_num = 1
2466: where not exists
2460: +--------------------------------------------------------------*/
2461: lStmtNum := 130;
2462: xTableName := 'BOM_INVENTORY_COMPS_INTERFACE';
2463:
2464: update bom_inventory_comps_interface ci
2465: set ci.operation_seq_num = 1
2466: where not exists
2467: (select 'op seq exists in config routing'
2468: from
3019: where organization_id = pOrgId
3020: and alternate_routing_designator is null
3021: and assembly_item_id in
3022: ( select component_item_id
3023: from bom_inventory_comps_interface
3024: where bom_item_type =2
3025: and bill_sequence_id = pCfgBillId
3026: )
3027: and serialization_start_op in