TABLE-Z_PSD_LATEST

数据库表和其他表关系及其字段来源

Z_PSD_LATEST

• z_pcdw_ztoemorditem b
  • b.sd_so_num AS so, decode(b.sd_so_item_num,'000000',NULL,b.sd_so_item_num) AS so_line, b.sd_plant AS plant, b.sd_so_num AS hoh_so, b.sd_so_item_num AS hoh_so_line
• Z_SFTP_ODM_PSD_ERROR
• Z_CONF_ACCURACY
• Z_CONF_PARAMETER
• Z_MID_PCDW_ZTOEMORDITEM
• MST_ITEMSITEMASTER_MNB
• Z_CONF_GEO_PSD
• PCDW_PO
• Z_CONF_INHOUSE_PLANT
• Z_MID_PSD_LATEST
• Z_MID_PSD_LATEST_TEMP
• Z_PCDW_LIPC_PSD_RPT
• Z_PSD_HISTORY
• BW_PSD_SO_LATEST
• z_pcdw_po b
  • SET a.so = b.vbeln, a.so_line = b.vbelp, a.create_date = b.aedat_h, a.so_mtm = pkg_base_funcs.get_matnr(b.matnr), a.so_qty = b.menge where sys_created_by = v_full_name;
• z_conf_odm_plant
  • DELETE FROM z_psd_latest WHERE folder_name IN ( SELECT folder_name FROM z_conf_odm_plant WHERE v_time BETWEEN start_time AND end_time AND type IS NULL AND instr(flag, 'ODM') > 0);
• z_sftp_odm_psd a
  • a.version_num, a.odm, substr(a.po,1,10) po, a.po_item AS po_line, a.model AS family, a.qty AS planned_qty, a.order_date, a.input_date,a.plan_input_date, a.fg_date, a.fpsd, a.psd, NULL AS dsp,a.psd AS line_psd, a.psd AS tie_psd, --modify linepsd, change nvl(a.psd, a.fpsd) to a.psd,modify by wangy 20180608 a.MR_DATE AS order_mad, trim(a.reason) AS comments, a.level1_code AS reason_code1, --add a.MR_DATE 20180613 a.level2_code AS reason_code2, pkg_base_funcs.get_matnr(substr(a.mtm,1,18)) AS so_mtm, a.rsd, a.ship_date, a.folder_name, a.z_group, a.brand, a.priority AS so_priority, a.country, a.subgeo, a.geo, a.description, a.re_rsd, a.rsd AS z_rsd, '' AS csd, trim(a.short_pn) AS shortage_part, SYSDATE, v_full_name, a.cancel_ind, a.reasoncode_std, a.po po_l, trim(a.short_pn_desc), trim(a.re_schedule), a.city,a.MATERIAL_STATUS
• z_pcdw_history_so
  • UPDATE z_psd_latest a SET auart = (SELECT auart FROM z_pcdw_history_so b WHERE a.so = b.vbeln AND a.so_line = b.posnr) WHERE auart IS NULL;
• Z_CONF_PSD_SHIPPING_TYPE