EBS: 发运(WSH)表清单

EBS 发运WSH模块表清单 

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 220 221 222 223 224 225 226 227 228 229 230 231 232 233 234 235 236 237 238 239 240 241 242 243 244 245 246 247 248 249 250 251 252 253 254 255 256 257 258 259 260 261 262 263 264 265 266 267 268 269 270 271 272 273 274 275 276 277 278 279 280 281 282 283 284 285 286 287 288 289 290 291 292 293 294 295 296 297 298 299 300 301 302 303 304 305 306 307 308 309 310 311 312 313 314 315 316 317

SELECT * FROM WSH.WSH_ACTIVITY_GROUPS   SELECT * FROM WSH.WSH_CALENDAR_ASSIGNMENTS   -- -- N:OM>>设置>>发运>>承运人，成本类型>>承运人 SELECT * FROM  APPS.WSH_CARRIERS_V WC  WHERE CARRIER_ID = 800774   -- N:OM>>设置>>发运>>承运人，成本类型>>承运人 SELECT * FROM WSH.WSH_CARRIERS WC  WHERE CARRIER_ID = 800774   -- N:OM>>设置>>发运>>承运人，成本类型>>承运人 之 服务。 SELECT * FROM WSH.WSH_CARRIER_SERVICES  WHERE CARRIER_ID = 800774    -- N:OM>>设置>>发运>>承运人，成本类型>>承运人 之 发运方法 SELECT * FROM WSH.WSH_CARRIER_SHIP_METHODS  WHERE  CARRIER_ID = 800774   -- N:OM>>设置>>发运>>承运人，成本类型>>承运人 之 地点 SELECT * FROM WSH.WSH_CARRIER_SITES   -- N:OM>>设置>>发运>>承运人，成本类型>>承运人 之 运输工具类型 SELECT * FROM WSH.WSH_CARRIER_VEHICLE_TYPES   SELECT * FROM WSH.WSH_CC_ADAPTER_STATUS   SELECT * FROM WSH.WSH_CC_DENIED_PARTIES   SELECT * FROM WSH.WSH_CC_PARAMETER_SETUPS_B   SELECT * FROM WSH.WSH_CC_PARAMETER_SETUPS_TL   SELECT * FROM WSH.WSH_CC_REQUEST_SETUPS   SELECT * FROM WSH.WSH_CC_RESPONSE_HEADERS   SELECT * FROM WSH.WSH_CC_RESPONSE_LINES   SELECT * FROM WSH.WSH_CC_SERVICE_SETUPS   SELECT * FROM WSH.WSH_CC_TRANS_CONTROL   SELECT * FROM WSH.WSH_CC_TRANS_HEADERS   SELECT * FROM WSH.WSH_CC_TRANS_LINES   SELECT * FROM WSH.WSH_CC_USER_SETUPS   SELECT * FROM WSH.WSH_CONSOL_BATCHES   SELECT * FROM WSH.WSH_CONSOL_GROUPING_RULES   SELECT * FROM WSH.WSH_CONSTRAINT_DLEG_TMP   SELECT * FROM WSH.WSH_CONTAINER_ITEMS   SELECT * FROM WSH.WSH_CUSTOMIZED_ACTIVITY_MSGS   SELECT * FROM WSH.WSH_DD_TXNS   -- N:OM>>发运>>事务处理 SELECT * FROM WSH.WSH_DELIVERY_ASSIGNMENTS   -- N:OM>>发运>>事务处理 SELECT * FROM WSH.WSH_DELIVERY_DETAILS   SELECT * FROM WSH.WSH_DELIVERY_LEGS   SELECT * FROM WSH.WSH_DELIVERY_LEG_ACTIVITIES   SELECT * FROM WSH.WSH_DELIVERY_LEG_DETAILS   SELECT * FROM WSH.WSH_DEL_ASSGN_INTERFACE   SELECT * FROM WSH.WSH_DEL_DETAILS_INTERFACE   SELECT * FROM WSH.WSH_DEL_LEGS_INTERFACE   SELECT * FROM WSH.WSH_DEL_WV_UPGRADE_TMP   SELECT * FROM WSH.WSH_DETAIL_SSHIPUNITS   SELECT * FROM WSH.WSH_DOCUMENT_INSTANCES   --N:OM>>设置>>发运>>文档>>单据类别。 SELECT * FROM WSH.WSH_DOC_SEQUENCE_CATEGORIES   --N:OM>>设置>>发运>>文档>>单据类别。 SELECT * FROM  apps.wsh_doc_sequence_categories_v   -- 发运例外 SELECT * FROM WSH.WSH_EXCEPTIONS   SELECT * FROM WSH.WSH_EXCEPTION_DEFINITIONS_B   SELECT * FROM WSH.WSH_EXCEPTION_DEFINITIONS_TL   SELECT * FROM WSH.WSH_FOLDER_CUSTOM_ACTIONS   SELECT * FROM WSH.WSH_FOLDER_EXTENSIONS   --N: OM>>设置>>发运>>承运人>>承运人,成本类型>>运费成本类型。 SELECT * FROM WSH.WSH_FREIGHT_COSTS   SELECT * FROM WSH.WSH_FREIGHT_COSTS_EFC   SELECT * FROM WSH.WSH_FREIGHT_COSTS_INTERFACE   --N: OM>>设置>>发运>>承运人>>承运人,成本类型>>运费成本类型。 SELECT * FROM WSH.WSH_FREIGHT_COST_TYPES WFCT  WHERE WFCT.NAME LIKE 'OTM Freight Cost'   SELECT * FROM  APPS.wsh_freight_cost_types_v   SELECT * FROM WSH.WSH_FTE_COMP_CLASSES   SELECT * FROM WSH.WSH_FTE_COMP_CONSTRAINTS   -- N:OM>>设置>>发运>>全局参数 SELECT * FROM WSH.WSH_GLOBAL_PARAMETERS   -- N:OM>>设置>>发运>>权限和职责定义>>权限 SELECT * FROM WSH.WSH_GRANTS WG   SELECT * FROM  APPS.wsh_grants_v WG   SELECT * FROM WSH.WSH_GTC_RESPONSE_RULES   SELECT * FROM WSH.WSH_INBOUND_DEL_LINES_TEMP   SELECT * FROM WSH.WSH_INBOUND_TXN_HISTORY   -- 发运接口错误信息表 SELECT * FROM WSH.WSH_INTERFACE_ERRORS   SELECT * FROM WSH.WSH_ITM_ADAPTER_STATUS   SELECT * FROM WSH.WSH_ITM_DENIED_PARTIES   SELECT * FROM WSH.WSH_ITM_ITEMS   SELECT * FROM WSH.WSH_ITM_PARAMETER_SETUPS_B   SELECT * FROM WSH.WSH_ITM_PARAMETER_SETUPS_TL   SELECT * FROM WSH.WSH_ITM_PARTIES   SELECT * FROM WSH.WSH_ITM_PARTY_CONTACTS   SELECT * FROM WSH.WSH_ITM_REQUEST_CONTROL   SELECT * FROM WSH.WSH_ITM_RESPONSE_HEADERS   SELECT * FROM WSH.WSH_ITM_RESPONSE_LINES   SELECT * FROM WSH.WSH_ITM_RESPONSE_RULES   SELECT * FROM WSH.WSH_ITM_SERIAL_NUMBERS   SELECT * FROM WSH.WSH_ITM_SERVICE_PARAMETERS   SELECT * FROM WSH.WSH_ITM_SERVICE_PREFERENCES   SELECT * FROM WSH.WSH_ITM_USER_SETUPS   SELECT * FROM WSH.WSH_ITM_VENDORS   SELECT * FROM WSH.WSH_ITM_VENDOR_PARAMETERS   SELECT * FROM WSH.WSH_ITM_VENDOR_SERVICES   SELECT * FROM WSH.WSH_ITM_VENDOR_STYLESHEETS   SELECT * FROM WSH.WSH_LOCATIONS   SELECT * FROM WSH.WSH_LOCATION_DATA_EXT   SELECT * FROM WSH.WSH_LOCATION_OWNERS   SELECT * FROM WSH.WSH_LPN_PURGE_TMP   SELECT * FROM WSH.WSH_MESSAGE_ATTACHMENT   -- N:OM>>发运>>事务处理 -- 挑库发运交货表 SELECT * FROM WSH.WSH_NEW_DELIVERIES WND   -- 挑库发运交货接口表 SELECT * FROM WSH.WSH_NEW_DEL_INTERFACE   SELECT * FROM WSH.WSH_ORG_CARRIER_SERVICES   SELECT * FROM WSH.WSH_ORG_CARRIER_SITES   SELECT * FROM WSH.WSH_OTM_LOCATIONS_GTMP   SELECT * FROM WSH.WSH_OTM_LOC_CONTACTS_GTMP   SELECT * FROM WSH.WSH_OTM_SYNC_REF_DATA   SELECT * FROM WSH.WSH_OTM_SYNC_REF_DATA_LOG   -- -- N:OM>>发运>>事务处理 SELECT * FROM WSH.WSH_PICKING_BATCHES   -- N:OM>>设置>>发运>>挑库>>定义发放规则表单 -- 挑库规则 SELECT * FROM WSH.WSH_PICKING_RULES   -- N:OM>>设置>>发运>>挑库>>定义挑库单分组规则 -- 挑库组规则 SELECT * FROM WSH.WSH_PICK_GROUPING_RULES   -- N:OM>>设置>>发运>>挑库>>定义发放序列规则 -- 挑库序号规则 SELECT * FROM WSH.WSH_PICK_SEQUENCE_RULES   SELECT * FROM WSH.WSH_PR_HEADER_HOLDS   SELECT * FROM WSH.WSH_PR_WORKERS WPW  WHERE WPW.ORGANIZATION_ID = 101   SELECT * FROM WSH.WSH_QUERY_ASSIGNMENTS   -- N:OM>>设置>>发运>>区域和地区>>区域和地区 SELECT * FROM WSH.WSH_REGIONS   SELECT * FROM WSH.WSH_REGIONS_GLOBAL   SELECT * FROM WSH.WSH_REGIONS_GLOBAL_DATA   -- N:OM>>设置>>发运>>区域和地区>>区域接口 SELECT * FROM WSH.WSH_REGIONS_INTERFACE   SELECT * FROM WSH.WSH_REGIONS_TL   SELECT * FROM WSH.WSH_REGIONS_TL_INTERFACE   SELECT * FROM WSH.WSH_REGION_LOCATIONS   SELECT * FROM WSH.WSH_REPORT_PRINTERS   -- -- N:OM>>设置>>发运>>区域和地区>>中转时间 之 发运方法 SELECT * FROM  APPS.MTL_INTERORG_SHIP_METHODS   --N: OM>>设置>>发运>>文档>>单据集 -- 单据集 SELECT * FROM WSH.WSH_REPORT_SETS   --N: OM>>设置>>发运>>文档>>单据集 -- 单据集 之单据行 SELECT * FROM WSH.WSH_REPORT_SET_LINES   -- 发运规则 -- N:OM>>设置>>发运>>权限和职责定义>>定义职责 SELECT * FROM WSH.WSH_ROLES WR  where WR.NAME LIKE '一键式发运权限'   SELECT * FROM WSH.WSH_ROLE_PRIVILEGES WRP  WHERE WRP.ROLE_ID = 24   SELECT * FROM WSH.WSH_SAVED_QUERIES_B   SELECT * FROM APPS.wsh_lookups  WHERE MEANING LIKE '延交' -- '自动创建交货'   SELECT * FROM WSH.WSH_SAVED_QUERIES_TL   SELECT * FROM WSH.WSH_SERIAL_NUMBERS   SELECT * FROM WSH.WSH_SHIPMENT_BATCHES   -- N：OM>>设置>>发运>>发运参数 SELECT * FROM WSH.WSH_SHIPPING_PARAMETERS   SELECT * FROM WSH.WSH_SHIPPING_PARAMETER_VALUES   -- -- N：OM>>设置>>发运>>全局参数 SELECT * FROM  WSH.WSH_GLOBAL_PARAMETERS   -- N：OM>>设置>>发运>>发运确认规则 -- 发运确认规则 SELECT * FROM WSH.WSH_SHIP_CONFIRM_RULES   SELECT * FROM WSH.WSH_TMP   SELECT * FROM WSH.WSH_TMS_BATCHES   SELECT * FROM WSH.WSH_TMS_SUB_BATCHES   SELECT * FROM WSH.WSH_TRANSACTIONS_HISTORY   SELECT * FROM WSH.WSH_TRIPS   SELECT * FROM WSH.WSH_TRIPS_INTERFACE   SELECT * FROM WSH.WSH_TRIP_STOPS   SELECT * FROM WSH.WSH_TRIP_STOPS_INTERFACE   SELECT * FROM WSH.WSH_UPGRADE_LOG   SELECT * FROM WSH.WSH_UPGRADE_PLD_TMP   SELECT * FROM WSH.WSH_UPGRADE_SITE_TMP   SELECT * FROM WSH.WSH_UPGRADE_TMP   SELECT * FROM WSH.WSH_WMS_SYNC_TMP   SELECT * FROM WSH.WSH_ZONE_REGIONS