WSH_CARRIER_SITES - Unable to get data.
I am trying to get the data from the table - WSH_CARRIER_SITES, but I can't find any data in the table.
When I query the freight carriers using the Purchasing Resp> Setup> Purchasing > Freight Carriers ( WSHFXCSM) , I find the data for the Freight Carriers and the contact details at the site level.
I looked at the last executed System query and found it as below:
SELECT ROWID,SUPPLIER_SITE_ID,CARRIER_ID,CARRIER_SITE_ID,CREATION_DATE,CREATED_BY,LAST_UPDATE_DATE,LAST_UPDATED_BY,LAST_UPDATE_LOGIN,EMAIL_ADDRESS,AUTO_ACCEPT_LOAD_TENDER,TENDER_WAIT_TIME