Optimization fractional component did not write back,

The reason is that loc_id processing data is wrong, not factory data, but 6900 and so on

SELECTMO. Productionordid mo_id, IT. ITEM, IT. bom_id, IT. Qtyallocated*fp_get_convrate (TM. ITEM_ID, TM. Udf_meins, NVL (TU. Qty_uom, TM. Udf_meins)) qtyallocated, SUBSTR ( Case                              whenMO. loc_id= '2021'  ThenNVL (TU. loc_id, IIS. LOC_ID) whenTRIM (IIS. Proc_type)||TRIM (IIS. Sp_proc_type)inch('E71') Then '2029'                             ELSENVL (IT. location_id, (SELECTx.loc_id fromIn_item_site XWHEREx.item_id=IT. ITEM andx.site_id=                                                   Case                                                      whenTRIM (IIS. Proc_type)||TRIM (IIS. Sp_proc_type)=                                                             'E70'                                                      Then                                                        '2023'                                                     ELSEMO. loc_idEND                                            andROWNUM= 1))                          END,                          1,                          4) loc_id, NVL (TU. Qty_uom, TM. Udf_meins) Qtyuom, IT. LOCATION_ID, Case  whenLENGTH (IT. LOCATION_ID)=9 ORLENGTH (IT. LOCATION_ID)=7  ThenIT. location_idELSESUBSTR (IT. Location_id,length (IT. LOCATION_ID)-8,4)                            ENDKKA, NVL (( Case  whenLENGTH (IT. LOCATION_ID)=9 ORLENGTH (IT. LOCATION_ID)=7  ThenIT. location_idELSESUBSTR (IT. Location_id,length (IT. LOCATION_ID)-8,4)                                    END ) ,                                                                       (SELECTx.loc_id fromIn_item_site XWHEREx.item_id=IT. ITEM andx.site_id=                                                   Case                                                      whenTRIM (IIS. Proc_type)||TRIM (IIS. Sp_proc_type)=                                                             'E70'                                                      Then                                                        --' + '                                                        '2023'                                                     ELSEMO. loc_idEND                                            andROWNUM= 1)) AA fromout_mo MO, Temp_item_uom TU, In_item TM, In_item_si TE IIS, (SELECTNVL (Tms.combine_mo, MI. Rootid) Rootid, MI. parent_id, MI. bom_id, MI. site_id, MI. ITEM, MI. LOCATION_ID,SUM(MI.) Qtyallocated*(NVL (TMS. Qtyordered/Tms. Orig_qty,1)) qtyallocated fromtemp_mo_split TMS, Temp_mo_item MIWHERETms. MO_ID (+)=MI. RootidGROUP  byNVL (Tms.combine_mo, MI. Rootid), MI. parent_id, MI. bom_id, MI. site_id, MI. ITEM, MI. location_id) ITWHEREMO. Productionordid=IT. Rootid andIT. site_id=TU. SITE_ID (+)                        andIT. parent_id=TU. PARENT_ID (+)                        andIT. ITEM=TU. ITEM_ID (+)                        andIT. ITEM=TM. ITEM_ID andMO. loc_id=IIS. site_id andSmi item_id=IIS. ITEM_ID andMO. Productionordid='5000179906/480_1-mfg0001'                      --and IT. Item= ' 000000102001002018 '                        andIT. location_id is  not NULL                      --and IT. location_id not like ' 20% '

View Code

Optimization fractional component did not write back,