FP_PR2SAP for semi-finished products except packaging and semi-finished products the Outlook period for 7 days is changed to 40 day

 --semi-finished products except packaging, semi-finished material Outlook period 7 days changed to 40 day      INSERT  intoout_pr (pr_id, ITEM, supplier_id, due_date                          Time, QTY, proc_group_id, PROC_GROUP_DESCR,                          site_id, loc_id, Qtyuom, Planneddeldate)SELECT MAX(PR. ORDERID), PR. ITEM, SUBSTR (PR. Recommendedsupid,6), TRUNC (PR. Poreleasedate),SUM(PR. qtyplanned), IT. proc_group_id, IT. PROC_GROUP_DESCR, IT. site_id, SI. location_id, SI. Qty_uom,PR. Planneddeldate fromAbppmgr. Procurementplan PR, In_item_site IT, In_supplier_item SIWHEREPR. ITEM=IT. ITEM_ID andIT. site_id=SUBSTR (PR. Recommendedsupid,1,4)                   andSI. item_id=IT. ITEM_ID andSI. supplier_id=PR. Recommendedsupid andSI. udf_item_type_id= '0'                   andTo_char (TRUNC (PR. Poreleasedate),'YYYY-MM-DD')>=To_char (V_currentdate,'YYYY-MM-DD')                   and (                       --alter by LXF on 20161213 Change 7To_char (TRUNC (PR. Poreleasedate),'YYYY-MM-DD')<=To_char (v_currentdate+DECODE (V_day,1, +,2, +),'YYYY-MM-DD'))                   andPR. ORDERID like '%proc%'                  --Add chip family_id Material group 4041902 with material code 701*, 702*                   and( not EXISTS                                  (SELECT NULL                                      fromIn_item IIWHEREIT. item_id=II. ITEM_ID andIi. family_idinch                                                 ('104001000',                                                  '104001001',                                                  '104002000',                                                  '104002001',                                                  '104003000',                                                  '104005000',                                                  '104004000',                                                  '104006000',                                                  '104007000',                                                  '104008000',                                                  '104009000',                                                  '104010000',                                                  '104013000',                                                  '104014000',                                                  '403019001',                                                  '404001000',                                                  '404002000',                                                  '404003000',                                                  '404002001',                                                  '404004000',                                                  '404005000',                                                  '404006000',                                                  '404008000',                                                  '404007000',                                                  '405001000',                                                  '404009000',                                                  '103040000'))                        andSUBSTR (PR. ITEM,1,9) not inch                              ('000000701','000000702'))                   andSUBSTR (PR. Recommendedsupid,instr (PR. Recommendedsupid,'_')+5) not inch                   ( SELECT DISTINCTsupplier_id fromSap_supplier_minqty)GROUP  byPR. ITEM, SUBSTR (PR. Recommendedsupid,6), TRUNC (PR. poreleasedate), IT. proc_group_id, IT. PROC_GROUP_DESCR, IT. site_id, SI. location_id, SI. Qty_uom, PR. Planneddeldate;

 DELETE  fromOUT_PR PRWHERE(To_char (TRUNC) (PR. Due_datetime),'YYYY-MM-DD')>                             --alter by LXF on 20161219 change 7 days to50 daysTo_char (v_currentdate+DECODE (V_day,1, +,2, +),'YYYY-MM-DD')

FP_PR2SAP for semi-finished products except packaging and semi-finished products the Outlook period for 7 days is changed to 40 day