eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

VIEW: APPS.MST_SUPPLIER_FACILITIES_V

Object Details

Object Name:	MST_SUPPLIER_FACILITIES_V
Object Type:	VIEW
Owner:	APPS
Subobject Name:
Status:	VALID

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
SUPPLIER_ID	NUMBER		Yes	ID of supplier.
PLAN_ID	NUMBER		Yes	Plan ID. FK to PLAN_ID of MST_PLANS.
COMPILE_DESIGNATOR	VARCHAR2	(10)	Yes	Plan name.
DESCRIPTION	VARCHAR2	(50)		Plan description.
WSH_LOCATION_ID	NUMBER		Yes	Location ID for the facility.
LOCATION_SOURCE_CODE	VARCHAR2	(3)	Yes	Source code of the Location.
COMPANY	VARCHAR2	(80)		Name of the Supplier's Company.
ADDRESS	VARCHAR2	(240)		Address of the facility.
ADDRESS2	VARCHAR2	(240)		Address line2 of the facility.
ADDRESS3	VARCHAR2	(240)		Address lione3 of the facility.
ADDRESS4	VARCHAR2	(240)		Address line4 of the facility.
CITY	VARCHAR2	(120)		Supplier Facility City.
STATE	VARCHAR2	(120)		Supplier Facility State.
COUNTY	VARCHAR2	(120)		Supplier Facility County.
COUNTRY	VARCHAR2	(120)		Supplier Facility Country.
PROVINCE	VARCHAR2	(120)		Supplier Facility Province.
POSTAL_CODE	VARCHAR2	(60)		Supplier Facility Postal Code.
CONTACT	VARCHAR2	(4000)		Supplier Facility Contact.
PHONE	VARCHAR2	(4000)		Supplier Facility Phone.
FACILITY_ID	NUMBER		Yes	Supplier Facility ID.
FACILITY_CODE	VARCHAR2	(60)	Yes	Supplier Facility Name.
FACILITY_DESCRIPTION	VARCHAR2	(250)		Supplier Facility Description.
DIRECT_TLS	NUMBER			Count of Direct TL trips.
MULTI_STOP_TLS	NUMBER			Count of Multi-stop TL trips.
LTLS	NUMBER			Count of LTL trips.
PARCELS	NUMBER			Count of Parcel trips.
TOTAL_COST	NUMBER			Cost related to supplier Facility.
TOTAL_WEIGHT	NUMBER			Weight related to supplier Facility.
TOTAL_CUBE	NUMBER			Volume related to supplier Facility.
TOTAL_PALLETS	NUMBER			Pallets related to supplier Facility.
TOTAL_PIECES	NUMBER			Pieces related to supplier Facility.
TOTAL_ORDERS	NUMBER			Orders related to supplier Facility.
CURRENCY_UOM	VARCHAR2	(3)		Unit of Measure for Cost.
WEIGHT_UOM	VARCHAR2	(3)		Unit of Measure for Weight.
VOLUME_UOM	VARCHAR2	(3)		Unit of Measure for Volume.

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT SUPPLIER_ID
,      PLAN_ID
,      COMPILE_DESIGNATOR
,      DESCRIPTION
,      WSH_LOCATION_ID
,      LOCATION_SOURCE_CODE
,      COMPANY
,      ADDRESS
,      ADDRESS2
,      ADDRESS3
,      ADDRESS4
,      CITY
,      STATE
,      COUNTY
,      COUNTRY
,      PROVINCE
,      POSTAL_CODE
,      CONTACT
,      PHONE
,      FACILITY_ID
,      FACILITY_CODE
,      FACILITY_DESCRIPTION
,      DIRECT_TLS
,      MULTI_STOP_TLS
,      LTLS
,      PARCELS
,      TOTAL_COST
,      TOTAL_WEIGHT
,      TOTAL_CUBE
,      TOTAL_PALLETS
,      TOTAL_PIECES
,      TOTAL_ORDERS
,      CURRENCY_UOM
,      WEIGHT_UOM
,      VOLUME_UOM
FROM APPS.MST_SUPPLIER_FACILITIES_V;

Dependencies

[top of page]

APPS.MST_SUPPLIER_FACILITIES_V references the following:

APPS: FTE_LOCATION_PARAMETERS; HZ_PARTIES; HZ_RELATIONSHIPS; MST_AGG_PKG - show dependent code; MST_DELIVERIES; MST_DELIVERY_LEGS; MST_PLANS; MST_TRIP_STOPS; MST_WB_UTIL - show dependent code; PO_VENDORS; WSH_LOCATIONS; WSH_LOCATION_OWNERS

APPS.MST_SUPPLIER_FACILITIES_V is not referenced by any database object