[Home] [Help] [Dependency Information]
Object Name: | MST_R_FREIGHT_HEADER_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 |
---|---|---|---|---|
PLAN_ID | NUMBER | Yes | Plan ID | |
FACILITY_ID | NUMBER | Yes | Facility ID | |
CUST_SUPP_COMP_NAME | VARCHAR2 | (4000) | Customer/Supplier Company Name | |
TP_DEPARTMENT_NAME | VARCHAR2 | (4000) | Transportation Planning Department Name (Must be set properly in profile) | |
TP_CONTACT_NAME | VARCHAR2 | (4000) | Transportation Planning Contact Name | |
TP_CONTACT_PHONE_NUM | VARCHAR2 | (4000) | Transportation Planning Contact Phone Number | |
TP_CONTACT_EMAIL_ID | VARCHAR2 | (4000) | Transportation Planning Contact EMail Address | |
HOST_COMP_NAME | VARCHAR2 | (4000) | Host Company Name | |
HOST_COMP_CONTACT_NAME | VARCHAR2 | (4000) | Host Company Contact Name | |
HOST_COMP_CONTACT_PHONE | VARCHAR2 | (4000) | Host Company Contact Phone Number | |
HOST_COMP_CONTACT_EMAIL | VARCHAR2 | (4000) | Host Copmany Contact EMail Address | |
FACILITY_NAME | VARCHAR2 | (60) | Yes | Facility Name |
PLAN_NAME | VARCHAR2 | (10) | Yes | Plan Name |
REPORT_DATE | DATE | Reported Date | ||
PLAN_START_DATE | DATE | Yes | Plan Start Date | |
PLAN_COMPLETION_DATE | DATE | Yes | Plan Completion Date | |
TL_MOVEMENTS | NUMBER | Total Truck Movements ( Both Loading and Unloading ) | ||
LTL_MOVEMENTS | NUMBER | Total LTL Movements ( Both Loading and Unloading ) | ||
PARCEL_MOVEMENTS | NUMBER | Total Parcel Movements ( Both Loading and Unloading ) | ||
UNLOAD_TL_PIECES | NUMBER | Number of pieces being unloaded ( TL ) | ||
UNLOAD_LTL_PIECES | NUMBER | Number of pieces being unloaded ( LTL ) | ||
UNLOAD_PARCEL_PIECES | NUMBER | Number of pieces being unloaded ( Parcel ) | ||
UNLOAD_TL_WEIGHT | NUMBER | Gross weight being unloaded ( TL ) | ||
UNLOAD_LTL_WEIGHT | NUMBER | Gross weight being unloaded ( LTL ) | ||
UNLOAD_PARCEL_WEIGHT | NUMBER | Gross weight being unloaded ( Parcel ) | ||
UNLOAD_TL_CUBE | NUMBER | Unloaded Volume ( TL ) | ||
UNLOAD_LTL_CUBE | NUMBER | Unloaded Volume ( LTL ) | ||
UNLOAD_PARCEL_CUBE | NUMBER | Unloaded Volume ( Parcel ) | ||
LOAD_TL_PIECES | NUMBER | Number of pieces being loaded ( TL ) | ||
LOAD_LTL_PIECES | NUMBER | Number of pieces being loaded ( LTL ) | ||
LOAD_PARCEL_PIECES | NUMBER | Number of pieces being loaded ( Parcel ) | ||
LOAD_TL_WEIGHT | NUMBER | Gross weight being loaded ( TL ) | ||
LOAD_LTL_WEIGHT | NUMBER | Gross weight being loaded ( LTL ) | ||
LOAD_PARCEL_WEIGHT | NUMBER | Gross weight being loaded ( Parcel ) | ||
LOAD_TL_CUBE | NUMBER | Loaded Volume ( TL ) | ||
LOAD_LTL_CUBE | NUMBER | Loaded Volume ( LTL ) | ||
LOAD_PARCEL_CUBE | NUMBER | Loaded Volume ( Parcel ) | ||
TOTAL_PIECES | NUMBER | Total number of pieces ( Both loading and unloading ) | ||
TOTAL_WEIGHT | NUMBER | Gross Weight ( Both loading and unloading ) | ||
TOTAL_CUBE | NUMBER | Volume ( Both loading and unloading ) |
Cut, paste (and edit) the following text to query this object:
SELECT PLAN_ID
, FACILITY_ID
, CUST_SUPP_COMP_NAME
, TP_DEPARTMENT_NAME
, TP_CONTACT_NAME
, TP_CONTACT_PHONE_NUM
, TP_CONTACT_EMAIL_ID
, HOST_COMP_NAME
, HOST_COMP_CONTACT_NAME
, HOST_COMP_CONTACT_PHONE
, HOST_COMP_CONTACT_EMAIL
, FACILITY_NAME
, PLAN_NAME
, REPORT_DATE
, PLAN_START_DATE
, PLAN_COMPLETION_DATE
, TL_MOVEMENTS
, LTL_MOVEMENTS
, PARCEL_MOVEMENTS
, UNLOAD_TL_PIECES
, UNLOAD_LTL_PIECES
, UNLOAD_PARCEL_PIECES
, UNLOAD_TL_WEIGHT
, UNLOAD_LTL_WEIGHT
, UNLOAD_PARCEL_WEIGHT
, UNLOAD_TL_CUBE
, UNLOAD_LTL_CUBE
, UNLOAD_PARCEL_CUBE
, LOAD_TL_PIECES
, LOAD_LTL_PIECES
, LOAD_PARCEL_PIECES
, LOAD_TL_WEIGHT
, LOAD_LTL_WEIGHT
, LOAD_PARCEL_WEIGHT
, LOAD_TL_CUBE
, LOAD_LTL_CUBE
, LOAD_PARCEL_CUBE
, TOTAL_PIECES
, TOTAL_WEIGHT
, TOTAL_CUBE
FROM APPS.MST_R_FREIGHT_HEADER_V;
APPS.MST_R_FREIGHT_HEADER_V is not referenced by any database object
|
|
|