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 AUGUST 21, 2023

Applies to:

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

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