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

VIEW: APPS.MST_CUSTOMER_FACILITIES_V

Object Details
Object Name: MST_CUSTOMER_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
CUSTOMER_ID NUMBER (15) Yes ID of the Customer. FK to cust_ACCOUNT_ID of HZ_CUST_ACCOUNTS.
PLAN_ID NUMBER
Yes FK to PLAN_ID of MST_PLANS.
COMPILE_DESIGNATOR VARCHAR2 (10) Yes Plan Name.
DESCRIPTION VARCHAR2 (50)
Plan Description.
WSH_LOCATION_ID NUMBER
Yes ID of location Related to Customer Facility.
LOCATION_SOURCE_CODE VARCHAR2 (3) Yes Source of Location Related to Customer Facility.
COMPANY VARCHAR2 (80)
Company Name for Customer Facility.
ADDRESS VARCHAR2 (240)
Address of Customer Facility.
ADDRESS2 VARCHAR2 (240)
Address Line2 of Customer Facility.
ADDRESS3 VARCHAR2 (240)
Address Line3 of Customer Facility.
ADDRESS4 VARCHAR2 (240)
Address Line4 of Customer Facility.
CITY VARCHAR2 (120)
City of Customer Facility.
STATE VARCHAR2 (120)
State of Customer Facility.
COUNTY VARCHAR2 (120)
County of Customer Facility.
COUNTRY VARCHAR2 (120)
Country of Customer Facility.
PROVINCE VARCHAR2 (120)
Province of Customer Facility.
POSTAL_CODE VARCHAR2 (60)
Postal Code of Customer Facility.
CONTACT VARCHAR2 (4000)
Contact of Customer Facility.
PHONE VARCHAR2 (4000)
Phone Number of Customer Facility.
FACILITY_ID NUMBER
Yes ID of Customer Facility.
FACILITY_CODE VARCHAR2 (60) Yes Name of Customer Facility.
FACILITY_DESCRIPTION VARCHAR2 (250)
Description of Customer Facility.
DIRECT_TLS NUMBER

Count of Direct TLs to Customer Facility.
MULTI_STOP_TLS NUMBER

Count of Multi-stop TLs to Customer Facility.
LTLS NUMBER

Count of LTLs to Customer Facility.
PARCELS NUMBER

Count of Parcels to Customer Facility.
TOTAL_COST NUMBER

Cost related to Customer Facility.
TOTAL_WEIGHT NUMBER

Weight related to Customer Facility.
TOTAL_CUBE NUMBER

Cube related to Customer Facility.
TOTAL_PALLETS NUMBER

Pallets related to Customer Facility.
TOTAL_PIECES NUMBER

Pieces related to Customer Facility.
TOTAL_ORDERS NUMBER

Orders related to Customer 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 CUSTOMER_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_CUSTOMER_FACILITIES_V;

Dependencies

[top of page]

APPS.MST_CUSTOMER_FACILITIES_V references the following:

SchemaAPPS
SynonymFTE_LOCATION_PARAMETERS
SynonymHZ_CUST_ACCOUNTS
SynonymHZ_CUST_ACCT_SITES_ALL
SynonymHZ_PARTY_SITES
PL/SQL PackageMST_AGG_PKG - show dependent code
SynonymMST_DELIVERIES
SynonymMST_DELIVERY_LEGS
SynonymMST_PLANS
SynonymMST_TRIP_STOPS
PL/SQL PackageMST_WB_UTIL - show dependent code
SynonymWSH_LOCATIONS
SynonymWSH_LOCATION_OWNERS

APPS.MST_CUSTOMER_FACILITIES_V is not referenced by any database object