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

VIEW: APPS.MST_ORG_FACILITY_DETAILS_V

Object Details
Object Name: MST_ORG_FACILITY_DETAILS_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
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 Facility Location.
LOCATION_SOURCE_CODE VARCHAR2 (3) Yes Source code for Location.
COMPANY VARCHAR2 (80)
Company Name for the Facility.
ADDRESS VARCHAR2 (240)
Facility Address.
ADDRESS2 VARCHAR2 (240)
Facility Address Line2.
ADDRESS3 VARCHAR2 (240)
Facility Address Line3.
ADDRESS4 VARCHAR2 (240)
Facility Address Line4.
CITY VARCHAR2 (120)
Facility City.
STATE VARCHAR2 (120)
Facility State.
COUNTY VARCHAR2 (120)
Facility County.
COUNTRY VARCHAR2 (120)
Facility Country.
PROVINCE VARCHAR2 (120)
Facility Province.
POSTAL_CODE VARCHAR2 (60)
Facility Postal Code.
CONTACT VARCHAR2 (4000)
Facility Contact.
PHONE VARCHAR2 (4000)
Facility Phone.
FACILITY_ID NUMBER
Yes ID of Org. Facility.
FACILITY_CODE VARCHAR2 (60) Yes Name of Org. Facility.
FACILITY_DESCRIPTION VARCHAR2 (250)
Description of Org. 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.
COUNT_ALL_TL NUMBER

Count of TLs touching the facility.
COUNT_ALL_LTL NUMBER

Count of LTLs touching the facility.
COUNT_ALL_PARCEL NUMBER

Count of Parcels touching the facility.
COUNT_LOAD_TL NUMBER

Count of TLs touching the facility, involved in Loading.
COUNT_LOAD_LTL NUMBER

Count of LTLs touching the facility, involved in Loading.
COUNT_LOAD_PARCEL NUMBER

Count of Parcels touching the facility, involved in Loading.
COST_LOAD_TL NUMBER

Cost of TLs touching the facility, involved in Loading.
COST_LOAD_LTL NUMBER

Cost of LTLs touching the facility, involved in Loading.
COST_LOAD_PARCEL NUMBER

Cost of Parcels touching the facility, involved in Loading.
WEIGHT_LOAD_TL NUMBER

Weight of TLs touching the facility, involved in Loading.
WEIGHT_LOAD_LTL NUMBER

Weight of LTLs touching the facility, involved in Loading.
WEIGHT_LOAD_PARCEL NUMBER

Weight of Parcels touching the facility, involved in Loading.
CUBE_LOAD_TL NUMBER

Cube of TLs touching the facility, involved in Loading.
CUBE_LOAD_LTL NUMBER

Cube of LTLs touching the facility, involved in Loading.
CUBE_LOAD_PARCEL NUMBER

Cube of Parcels touching the facility, involved in Loading.
PALLETS_LOAD_TL NUMBER

Count of Pallets of TLs touching the facility, involved in Loading.
PALLETS_LOAD_LTL NUMBER

Count of Pallets of TLs touching the facility, involved in Loading.
PALLETS_LOAD_PARCEL NUMBER

Count of Pallets of TLs touching the facility, involved in Loading.
PIECES_LOAD_TL NUMBER

Count of Pieces in TLs touching the facility, involved in Loading.
PIECES_LOAD_LTL NUMBER

Count of Pieces in LTLs touching the facility, involved in Loading.
PIECES_LOAD_PARCEL NUMBER

Count of Pieces in Parcels touching the facility, involved in Loading.
ORDERS_LOAD_TL NUMBER

Count of Orders in TLs touching the facility, involved in Loading.
ORDERS_LOAD_LTL NUMBER

Count of Orders in LTLs touching the facility, involved in Loading.
ORDERS_LOAD_PARCEL NUMBER

Count of Orders in Parcels touching the facility, involved in Loading.
COUNT_UNLOAD_TL NUMBER

Count of TLs touching the facility, involved in Unloading.
COUNT_UNLOAD_LTL NUMBER

Count of LTLs touching the facility, involved in Unloading.
COUNT_UNLOAD_PARCEL NUMBER

Count of Parcels touching the facility, involved in Unloading.
COST_UNLOAD_TL NUMBER

Cost of TLs touching the facility, involved in Unloading.
COST_UNLOAD_LTL NUMBER

Cost of TLs touching the facility, involved in Unloading.
COST_UNLOAD_PARCEL NUMBER

Cost of TLs touching the facility, involved in Unloading.
WEIGHT_UNLOAD_TL NUMBER

Weight of TLs touching the facility, involved in Unloading.
WEIGHT_UNLOAD_LTL NUMBER

Weight of LTLs touching the facility, involved in Unloading.
WEIGHT_UNLOAD_PARCEL NUMBER

Weight of Parcels touching the facility, involved in Unloading.
CUBE_UNLOAD_TL NUMBER

Cube of TLs touching the facility, involved in Unloading.
CUBE_UNLOAD_LTL NUMBER

Cube of LTLs touching the facility, involved in Unloading.
CUBE_UNLOAD_PARCEL NUMBER

Cube of Parcels touching the facility, involved in Unloading.
PALLETS_UNLOAD_TL NUMBER

Count of Pallets of TLs touching the facility, involved in Unloading.
PALLETS_UNLOAD_LTL NUMBER

Count of Pallets of LTLs touching the facility, involved in Unloading.
PALLETS_UNLOAD_PARCEL NUMBER

Count of Pallets of Parcels touching the facility, involved in Unloading.
PIECES_UNLOAD_TL NUMBER

Count of Pieces in TLs touching the facility, involved in Unloading.
PIECES_UNLOAD_LTL NUMBER

Count of Pieces in LTLs touching the facility, involved in Unloading.
PIECES_UNLOAD_PARCEL NUMBER

Count of Pieces in Parcels touching the facility, involved in Unloading.
ORDERS_UNLOAD_TL NUMBER

Count of Orders in TLs touching the facility, involved in Unloading.
ORDERS_UNLOAD_LTL NUMBER

Count of Orders in LTLs touching the facility, involved in Unloading.
ORDERS_UNLOAD_PARCEL NUMBER

Count of Orders in Parcels touching the facility, involved in Unloading.
TOTAL_ORDERS NUMBER

Count of Orders touching the facility.
Query Text

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


SELECT 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
,      CURRENCY_UOM
,      WEIGHT_UOM
,      VOLUME_UOM
,      COUNT_ALL_TL
,      COUNT_ALL_LTL
,      COUNT_ALL_PARCEL
,      COUNT_LOAD_TL
,      COUNT_LOAD_LTL
,      COUNT_LOAD_PARCEL
,      COST_LOAD_TL
,      COST_LOAD_LTL
,      COST_LOAD_PARCEL
,      WEIGHT_LOAD_TL
,      WEIGHT_LOAD_LTL
,      WEIGHT_LOAD_PARCEL
,      CUBE_LOAD_TL
,      CUBE_LOAD_LTL
,      CUBE_LOAD_PARCEL
,      PALLETS_LOAD_TL
,      PALLETS_LOAD_LTL
,      PALLETS_LOAD_PARCEL
,      PIECES_LOAD_TL
,      PIECES_LOAD_LTL
,      PIECES_LOAD_PARCEL
,      ORDERS_LOAD_TL
,      ORDERS_LOAD_LTL
,      ORDERS_LOAD_PARCEL
,      COUNT_UNLOAD_TL
,      COUNT_UNLOAD_LTL
,      COUNT_UNLOAD_PARCEL
,      COST_UNLOAD_TL
,      COST_UNLOAD_LTL
,      COST_UNLOAD_PARCEL
,      WEIGHT_UNLOAD_TL
,      WEIGHT_UNLOAD_LTL
,      WEIGHT_UNLOAD_PARCEL
,      CUBE_UNLOAD_TL
,      CUBE_UNLOAD_LTL
,      CUBE_UNLOAD_PARCEL
,      PALLETS_UNLOAD_TL
,      PALLETS_UNLOAD_LTL
,      PALLETS_UNLOAD_PARCEL
,      PIECES_UNLOAD_TL
,      PIECES_UNLOAD_LTL
,      PIECES_UNLOAD_PARCEL
,      ORDERS_UNLOAD_TL
,      ORDERS_UNLOAD_LTL
,      ORDERS_UNLOAD_PARCEL
,      TOTAL_ORDERS
FROM APPS.MST_ORG_FACILITY_DETAILS_V;

Dependencies

[top of page]

APPS.MST_ORG_FACILITY_DETAILS_V references the following:

SchemaAPPS
SynonymFTE_LOCATION_PARAMETERS
PL/SQL PackageMST_AGG_PKG - show dependent code
SynonymMST_PLANS
PL/SQL PackageMST_WB_UTIL - show dependent code
SynonymWSH_LOCATIONS
SynonymWSH_LOCATION_OWNERS

APPS.MST_ORG_FACILITY_DETAILS_V is not referenced by any database object