EBS 發運WSH模組表清單
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