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

VIEW: APPS.MST_PQ_LOAD_DETAILS_V

Object Details
Object Name: MST_PQ_LOAD_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 Primary key
PLAN_NAME VARCHAR2 (10) Yes Why not simple plan_code?
TRIP_ID NUMBER
Yes Primary key for table
TRIP_NUMBER NUMBER

Trip number with in plan
MODE_OF_TRANSPORT VARCHAR2 (30)
Truck, LTL, Ocean, Parcel etc
CARRIER_ID NUMBER

Vendor providing (trip) service
CUSTOMER_ID NUMBER

ID of Customer(s) for the Material Transported in the trip.
SUPPLIER_ID NUMBER

ID of Supplier(s) for the Material Transported in the trip.
CARRIER_NAME VARCHAR2 (30) Yes Name of Carrier for the trip.
CUSTOMER_NAME VARCHAR2 (80)
Name of Customer(s) for the Material Transported in the trip.
SUPPLIER_NAME VARCHAR2 (80)
Name of Supplier(s) for the Material Transported in the trip.
FACILITY_ID NUMBER
Yes ID of Origin/Destination Facility for the Trip/Stop/Delivery.
FACILITY VARCHAR2 (60) Yes Name of Origin/Destination Facility for the Trip/Stop/Delivery.
ORIGIN_LOCATION_ID NUMBER

Origin location ID of Trip
DESTINATION_LOCATION_ID NUMBER

Destination location ID of Trip
ORIGIN_FACILITY_ID NUMBER
Yes Origin Facility ID of Trip
ORIGIN_FACILITY VARCHAR2 (60) Yes Origin Facility Description of Trip
ORIGIN_CITY VARCHAR2 (120)
Origin City of Trip
ORIGIN_STATE VARCHAR2 (120)
Origin State of Trip
ORIGIN_ZIP VARCHAR2 (60)
Origin Postal Code of Trip
ORIGIN_COUNTRY VARCHAR2 (120)
Origin Country of Trip
DESTINATION_FACILITY_ID NUMBER
Yes Destination Facility ID of Trip
DESTINATION_FACILITY VARCHAR2 (60) Yes Destination Facility of Trip
DESTINATION_CITY VARCHAR2 (120)
Destination City of Trip
DESTINATION_STATE VARCHAR2 (120)
Destination State of Trip
DESTINATION_ZIP VARCHAR2 (60)
Destination Postal Code of Trip
DESTINATION_COUNTRY VARCHAR2 (120)
Destination Country of Trip
DAYS_LEFT NUMBER

Days Left of Trip's Departure.
HOURS_LEFT NUMBER

Hours Left of Trip's Departure.
TOTAL_COST NUMBER

Total Cost of the trip.
TOTAL_WEIGHT NUMBER

Weight Transported by the Trip.
TOTAL_CUBE NUMBER

CubeTransported by the Trip.
TOTAL_UTILIZATION NUMBER

Percentage Utilization of Vehicle Capacity in the Trip.
CIRCUITY NUMBER

Circuity of the Trip.
CONTINUOUS_MOVE_ID NUMBER

ID of Continuous Move for the trip.
CHANGED_BY_USER NUMBER

Flag to indicate Where edited manually. 1=> Yes, 2=>No.
CURRENCY_UOM VARCHAR2 (3)
Currency for Trip's total cost.
Query Text

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


SELECT PLAN_ID
,      PLAN_NAME
,      TRIP_ID
,      TRIP_NUMBER
,      MODE_OF_TRANSPORT
,      CARRIER_ID
,      CUSTOMER_ID
,      SUPPLIER_ID
,      CARRIER_NAME
,      CUSTOMER_NAME
,      SUPPLIER_NAME
,      FACILITY_ID
,      FACILITY
,      ORIGIN_LOCATION_ID
,      DESTINATION_LOCATION_ID
,      ORIGIN_FACILITY_ID
,      ORIGIN_FACILITY
,      ORIGIN_CITY
,      ORIGIN_STATE
,      ORIGIN_ZIP
,      ORIGIN_COUNTRY
,      DESTINATION_FACILITY_ID
,      DESTINATION_FACILITY
,      DESTINATION_CITY
,      DESTINATION_STATE
,      DESTINATION_ZIP
,      DESTINATION_COUNTRY
,      DAYS_LEFT
,      HOURS_LEFT
,      TOTAL_COST
,      TOTAL_WEIGHT
,      TOTAL_CUBE
,      TOTAL_UTILIZATION
,      CIRCUITY
,      CONTINUOUS_MOVE_ID
,      CHANGED_BY_USER
,      CURRENCY_UOM
FROM APPS.MST_PQ_LOAD_DETAILS_V;

Dependencies

[top of page]

APPS.MST_PQ_LOAD_DETAILS_V references the following:

SchemaAPPS
SynonymFTE_LOCATION_PARAMETERS
SynonymMST_DELIVERIES
SynonymMST_DELIVERY_LEGS
SynonymMST_PLANS
SynonymMST_TRIPS
SynonymMST_TRIP_STOPS
PL/SQL PackageMST_WB_UTIL - show dependent code
SynonymWSH_CARRIERS
SynonymWSH_LOCATIONS

APPS.MST_PQ_LOAD_DETAILS_V is not referenced by any database object