[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | MST_CARRIER_FACILITIES_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| Subobject Name: | |
| Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| CARRIER_ID | NUMBER | FK to CARRIER_ID of WSH_CARRIERS. | ||
| 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 carrier facility. | |
| LOCATION_SOURCE_CODE | VARCHAR2 | (3) | Yes | Source of location related to carrier facility. |
| COMPANY | VARCHAR2 | (80) | Name of Company related to carrier facility. | |
| ADDRESS | VARCHAR2 | (240) | Address of carrier facility. | |
| ADDRESS2 | VARCHAR2 | (240) | Address Line2 of carrier facility. | |
| ADDRESS3 | VARCHAR2 | (240) | Address Line3 of carrier facility. | |
| ADDRESS4 | VARCHAR2 | (240) | Address Line4 of carrier facility. | |
| CITY | VARCHAR2 | (120) | City of carrier facility. | |
| STATE | VARCHAR2 | (120) | State of carrier facility. | |
| COUNTY | VARCHAR2 | (120) | County of carrier facility. | |
| COUNTRY | VARCHAR2 | (120) | Country of carrier facility. | |
| PROVINCE | VARCHAR2 | (120) | Province of carrier facility. | |
| POSTAL_CODE | VARCHAR2 | (60) | Postal Code of carrier facility. | |
| CONTACT | VARCHAR2 | (4000) | Contact for carrier facility. | |
| PHONE | VARCHAR2 | (4000) | Phone Number of carrier facility. | |
| FACILITY_ID | NUMBER | Yes | ID carrier facility. | |
| FACILITY_CODE | VARCHAR2 | (60) | Yes | Name of carrier facility. |
| FACILITY_DESCRIPTION | VARCHAR2 | (250) | Description of carrier facility. | |
| TOTAL_WEIGHT_LOAD | NUMBER | Weight Loaded at carrier facility. | ||
| TOTAL_CUBE_LOAD | NUMBER | Cube Loaded at carrier facility. | ||
| TOTAL_PALLETS_LOAD | NUMBER | Pallets Loaded at carrier facility. | ||
| TOTAL_PIECES_LOAD | NUMBER | Pieces loaded at carrier facility. | ||
| TOTAL_ORDERS_LOAD | NUMBER | Count of orders loaded at carrier facility. | ||
| DIRECT_TLS_LOAD | NUMBER | Count of Direct TLs to carrier facility, involved in loading. | ||
| MULTI_STOP_TLS_LOAD | NUMBER | Count of Multi-stop TLs to carrier facility, involved in loading. | ||
| LTLS_LOAD | NUMBER | Count of LTLs to carrier facility, involved in loading. | ||
| PARCELS_LOAD | NUMBER | Count of Parcels to carrier facility, involved in loading. | ||
| TOTAL_WEIGHT_UNLOAD | NUMBER | Weight Unloaded at Carrier Facility. | ||
| TOTAL_CUBE_UNLOAD | NUMBER | Cube Unloaded at Carrier Facility. | ||
| TOTAL_PALLETS_UNLOAD | NUMBER | Pallets Unloaded at Carrier Facility. | ||
| TOTAL_PIECES_UNLOAD | NUMBER | Pieces Unloaded at Carrier Facility. | ||
| TOTAL_ORDERS_UNLOAD | NUMBER | Count of Orders Unloaded at Carrier Facility. | ||
| DIRECT_TLS_UNLOAD | NUMBER | Count of Direct TLs to carrier facility, involved in Unloading. | ||
| MULTI_STOP_TLS_UNLOAD | NUMBER | Count of Multi-stop TLs to carrier facility, involved in Unloading. | ||
| LTLS_UNLOAD | NUMBER | Count of LTLs to carrier facility, involved in Unloading. | ||
| PARCELS_UNLOAD | NUMBER | Count of Parcels to carrier facility, involved in Unloading. | ||
| WEIGHT_UOM | VARCHAR2 | (3) | Unit of Measure for Weight. | |
| VOLUME_UOM | VARCHAR2 | (3) | Unit of Measure for Volume. |
Cut, paste (and edit) the following text to query this object:
SELECT CARRIER_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
, TOTAL_WEIGHT_LOAD
, TOTAL_CUBE_LOAD
, TOTAL_PALLETS_LOAD
, TOTAL_PIECES_LOAD
, TOTAL_ORDERS_LOAD
, DIRECT_TLS_LOAD
, MULTI_STOP_TLS_LOAD
, LTLS_LOAD
, PARCELS_LOAD
, TOTAL_WEIGHT_UNLOAD
, TOTAL_CUBE_UNLOAD
, TOTAL_PALLETS_UNLOAD
, TOTAL_PIECES_UNLOAD
, TOTAL_ORDERS_UNLOAD
, DIRECT_TLS_UNLOAD
, MULTI_STOP_TLS_UNLOAD
, LTLS_UNLOAD
, PARCELS_UNLOAD
, WEIGHT_UOM
, VOLUME_UOM
FROM APPS.MST_CARRIER_FACILITIES_V;
APPS
FTE_LOCATION_PARAMETERS
MST_AGG_PKG
- show dependent code
MST_PLANS
MST_WB_UTIL
- show dependent code
WSH_LOCATIONS
WSH_LOCATION_OWNERS
APPS.MST_CARRIER_FACILITIES_V is not referenced by any database object
|
|
|
|