My Oracle Support Banner

What Is The Relationship And Joins Between The Tables That Show Address And Contact Information In The Freight Carrier Form? (Doc ID 2817730.1)

Last updated on MARCH 15, 2022

Applies to:

Oracle Shipping Execution - Version 12.2.4 and later
Information in this document applies to any platform.

Goal

In setting up freight carriers, the following questions were asked:
Navigation path:
OM Superuser -> Main Menu -> Setup -> Shipping -> Freight Carriers, Cost Types -> Freight Carriers


1) What is the relationship between the below tables that show the freight carrier information?

WSH_CARRIERS wc
WSH_CARRIER_SERVICES wcs
WSH_ORG_CARRIER_SERVICES wocs
WSH_CARRIER_SHIP_METHODS wcsm
MTL_PARAMETERS mp
HZ_PARTIES hp
FND_LOOKUP_VALUES_VL fl


2) What are the joins that facilitate the showing of the address and contact information for the freight carriers?




3) Which table does the freight carrier contact information reside in as shown on this screen?


Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.