Oracle eBS經驗分享

Carrier Setup

Where to maintain {service level}

Find Lookup Code from Shipping Execution applicaiton.

• Lookup Code : WSH_SERVICE_LEVELS
• Meaning :　Carrier Service Levels

-- Oracle Install setting --

SELECT *
  FROM FND_LOOKUP_VALUES LV
WHERE LANGUAGE = USERENV ('LANG')
   AND VIEW_APPLICATION_ID = 665
   AND SECURITY_GROUP_ID = 0
   AND lookup_type = 'WSH_SERVICE_LEVELS'
   AND created_by = 2;

Lookup Code : WSH_MODE_OF_TRANSPORT

Lookup Code : SHIP_METHOD