[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | MST_R_MAS_CARR_TL_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 for which report is generated | |
| OWNER_TYPE | NUMBER | origin facility owner | ||
| FACILITY_ID | NUMBER | Yes | origin facility of the TL | |
| DEST_FACILITY_ID | NUMBER | destination facility of the TL | ||
| ORGANIZATION_ID | NUMBER | org_id | ||
| CUSTOMER_ID | NUMBER | customer whose deliveries are transported by the TL | ||
| SUPPLIER_ID | NUMBER | supplier whose deliveries are transported by the TL | ||
| TRIP_START_DATE | DATE | start date/time of the TL | ||
| CARRIER_ID | NUMBER | carrier of the TL | ||
| FREIGHT_CODE | VARCHAR2 | (30) | Yes | carrier ame |
| SERVICE_LEVEL | VARCHAR2 | (30) | service level of the carrier | |
| TRIP_NUMBER | NUMBER | trip number in the plan | ||
| STOP_SEQ_NUM | NUMBER | Yes | ||
| VEHICLE_TYPE | VARCHAR2 | (40) | equipment type of the vehicle | |
| TOTAL_TRIP_DISTANCE | NUMBER | total distance covered by the TL | ||
| TOTAL_WEIGHT | NUMBER | total weight of all the deliveries transported by the TL | ||
| TOTAL_VOLUME | NUMBER | total volume of all the deliveries transported by the TL | ||
| TOTAL_PIECES | NUMBER | total number of pieces in all the deliveries transported by the TL | ||
| TOTAL_PICKUP_STOPS_COUNT | NUMBER | count of stops where atleast one delivery is picked up on the TL | ||
| TOTAL_DELIVERY_STOPS_COUNT | NUMBER | count of stops where atleast one delivery is dropped off from the TL | ||
| CURRENCY_UOM | VARCHAR2 | (3) | UOM of currency | |
| TOTAL_LOAD_UNLOAD_COST | NUMBER | pool (handling) cost of the TL | ||
| POOL_COST_STR | VARCHAR2 | (4000) | pool cost with UOM attached | |
| TOTAL_COST | NUMBER | transportation + accessorial + handling + layover + load/unload + stop cost of the TL | ||
| TOTAL_COST_STR | VARCHAR2 | (4000) | total cost with UOM | |
| TOTAL_BASIC_TRANSPORT_COST | NUMBER | mileage cost (transportation cost) of the TL | ||
| MLG_COST_STR | VARCHAR2 | (4000) | mileage cost with UOM | |
| TOTAL_STOP_COST | NUMBER | stop cost of the TL | ||
| STOP_COST_STR | VARCHAR2 | (4000) | stop cost with UOM | |
| TOTAL_ACCESSORIAL_COST | NUMBER | accessorial + load/unload cost of the TL | ||
| ACCESSORIAL_COST_STR | VARCHAR2 | (4000) | accessorial cost with UOM | |
| CONTINUOUS_MOVE_ID | NUMBER | |||
| CONTINUOUS_MOVE_SEQUENCE | NUMBER | |||
| NO_OF_TRIPS_IN_CM | NUMBER | number of trips in a continuous move | ||
| STOP_TYPE_INDICATOR | VARCHAR2 | (1) | loading / unloading stop (if the delivery leg's stop is a pickup stop then its loading else it is unloading stop) | |
| ORIGIN_LOCATION_ID | NUMBER | TL's origin location | ||
| DESTINATION_LOCATION_ID | NUMBER | TL's destination location | ||
| LOC_CODE | VARCHAR2 | (60) | TL stop (origin/intermidiate/destination) | |
| LOC_NAME | VARCHAR2 | (80) | stop location company name | |
| LOC_ADDRESS | VARCHAR2 | (240) | stop location street address | |
| LOC_CITY | VARCHAR2 | (120) | stop location city | |
| LOC_STATE | VARCHAR2 | (120) | stop location state | |
| LOC_POSTAL_CODE | VARCHAR2 | (60) | stop location postal code | |
| LOC_COUNTRY | VARCHAR2 | (120) | stop location country | |
| LOC_CONTACT_NAME | VARCHAR2 | (4000) | stop location's contact person name | |
| LOC_CONTACT_PHONE_NUM | VARCHAR2 | (4000) | stop location's contact phone number | |
| PLAN_ARRIVAL_DATE | VARCHAR2 | (20) | planned arrival date/time of the TL at a given stop | |
| PLAN_DEPARTURE_DATE | VARCHAR2 | (20) | planned departure date/time of a TL from a given stop | |
| EARLIEST_ALLOW_DATE | VARCHAR2 | (20) | earliest allowable arrival date. This will be earliest of the latest acceptable date of all those deliveries which are dropped off on the given stop | |
| LATEST_ALLOW_DATE | VARCHAR2 | (20) | latest allowable departure date. This will be the maximum of all the earliest pickup date of all those deliveries which are picked up from the given stop | |
| UNLOAD_PIECES | NUMBER | sum of number of pieces in all those deliveries which are dropped off on the given stop | ||
| UNLOAD_WEIGHT | NUMBER | sum of weights of all those deliveries which are dropped off on the given stop | ||
| UNLOAD_VOLUME | NUMBER | sum of volumes of all those deliveries which are dropped off on the given stop | ||
| UNLOAD_COST | NUMBER | Total cost of all deliveries that are dropped off at the given stop | ||
| UNLOAD_TIME | VARCHAR2 | (20) | Total time in unloading at the given stop | |
| LOAD_PIECES | NUMBER | sum of number of pieces in all those deliveries which are picked up from the given stop | ||
| LOAD_WEIGHT | NUMBER | sum of weights of all those deliveries which are picked up from the given stop | ||
| LOAD_VOLUME | NUMBER | sum of volumes of all those deliveries which are picked up from the given stop | ||
| LOAD_COST | NUMBER | Total cost of all deliveries that are picked up from the given stop | ||
| LOAD_TIME | VARCHAR2 | (20) | Total time in loading at the given stop | |
| DRIVE_DISTANCE | NUMBER | Distance from the last stop to the given stop | ||
| DRIVE_TIME | VARCHAR2 | (20) | Time taken from the last stop to the given stop | |
| DRIVE_MLG_CHG | NUMBER | Cost incurred from the last stop to the given stop | ||
| WAIT_TIME | VARCHAR2 | (12) | Wait Time at the given stop | |
| LAYOVER_CHG | NUMBER | |||
| STOP_CHG | NUMBER | |||
| INTERNAL_ORDER_REF_NUMBER | VARCHAR2 | (50) | Customer PO Number, Supplier Sales Order Line Number or Shipper's Sales Ordere reference to return line | |
| EXTERNAL_ORDER_REF_NUMBER | VARCHAR2 | (150) | The user visible identifier for the header, ex. Order Number | |
| LOAD_UNLOAD_INDICATOR | VARCHAR2 | (1) | 'L' -> Loading; 'U' -> Unloading | |
| POOL_SUB_BOL | NUMBER | Trip Number within plan | ||
| POOL_ORIGIN_DEST_LOC_ID | VARCHAR2 | (4000) | Location Code of the stop if pooling occurs at the given stop | |
| POOL_ORIGIN_DEST_LOC_COMP_NAME | VARCHAR2 | (4000) | Facility Name if pooling occurs at the given stop | |
| POOL_ORIGIN_DEST_LOC_ADDRESS | VARCHAR2 | (4000) | Facility Address if pooling occurs at the given stop | |
| POOL_ORIGIN_DEST_LOC_CITY | VARCHAR2 | (4000) | Facility City if pooling occurs at the given stop | |
| POOL_ORIGIN_DEST_LOC_STATE | VARCHAR2 | (4000) | Facility State if pooling occurs at the given stop | |
| POOL_ORIGIN_DEST_LOC_ZIP | VARCHAR2 | (4000) | Facility Postal Code if pooling occurs at the given stop | |
| POOL_COLLEC_HANDL_COST | NUMBER | Cost associated with the pooling at the given stop | ||
| POOL_CARRIER_ID | NUMBER | Previous Carrier ID |
Cut, paste (and edit) the following text to query this object:
SELECT PLAN_ID
, OWNER_TYPE
, FACILITY_ID
, DEST_FACILITY_ID
, ORGANIZATION_ID
, CUSTOMER_ID
, SUPPLIER_ID
, TRIP_START_DATE
, CARRIER_ID
, FREIGHT_CODE
, SERVICE_LEVEL
, TRIP_NUMBER
, STOP_SEQ_NUM
, VEHICLE_TYPE
, TOTAL_TRIP_DISTANCE
, TOTAL_WEIGHT
, TOTAL_VOLUME
, TOTAL_PIECES
, TOTAL_PICKUP_STOPS_COUNT
, TOTAL_DELIVERY_STOPS_COUNT
, CURRENCY_UOM
, TOTAL_LOAD_UNLOAD_COST
, POOL_COST_STR
, TOTAL_COST
, TOTAL_COST_STR
, TOTAL_BASIC_TRANSPORT_COST
, MLG_COST_STR
, TOTAL_STOP_COST
, STOP_COST_STR
, TOTAL_ACCESSORIAL_COST
, ACCESSORIAL_COST_STR
, CONTINUOUS_MOVE_ID
, CONTINUOUS_MOVE_SEQUENCE
, NO_OF_TRIPS_IN_CM
, STOP_TYPE_INDICATOR
, ORIGIN_LOCATION_ID
, DESTINATION_LOCATION_ID
, LOC_CODE
, LOC_NAME
, LOC_ADDRESS
, LOC_CITY
, LOC_STATE
, LOC_POSTAL_CODE
, LOC_COUNTRY
, LOC_CONTACT_NAME
, LOC_CONTACT_PHONE_NUM
, PLAN_ARRIVAL_DATE
, PLAN_DEPARTURE_DATE
, EARLIEST_ALLOW_DATE
, LATEST_ALLOW_DATE
, UNLOAD_PIECES
, UNLOAD_WEIGHT
, UNLOAD_VOLUME
, UNLOAD_COST
, UNLOAD_TIME
, LOAD_PIECES
, LOAD_WEIGHT
, LOAD_VOLUME
, LOAD_COST
, LOAD_TIME
, DRIVE_DISTANCE
, DRIVE_TIME
, DRIVE_MLG_CHG
, WAIT_TIME
, LAYOVER_CHG
, STOP_CHG
, INTERNAL_ORDER_REF_NUMBER
, EXTERNAL_ORDER_REF_NUMBER
, LOAD_UNLOAD_INDICATOR
, POOL_SUB_BOL
, POOL_ORIGIN_DEST_LOC_ID
, POOL_ORIGIN_DEST_LOC_COMP_NAME
, POOL_ORIGIN_DEST_LOC_ADDRESS
, POOL_ORIGIN_DEST_LOC_CITY
, POOL_ORIGIN_DEST_LOC_STATE
, POOL_ORIGIN_DEST_LOC_ZIP
, POOL_COLLEC_HANDL_COST
, POOL_CARRIER_ID
FROM APPS.MST_R_MAS_CARR_TL_V;
APPS
FTE_LOCATION_PARAMETERS
FTE_VEHICLE_TYPES
MST_DELIVERIES
MST_DELIVERY_ASSIGNMENTS
MST_DELIVERY_DETAILS
MST_DELIVERY_LEGS
MST_PLANS
MST_REPORTS_PKG
- show dependent code
MST_TRIPS
MST_TRIP_STOPS
MST_WB_UTIL
- show dependent code
MTL_SYSTEM_ITEMS_KFV
WSH_CARRIERS
WSH_CARRIER_SERVICES
WSH_LOCATIONS
WSH_LOCATION_OWNERS
APPS.MST_R_MAS_CARR_TL_V is not referenced by any database object
|
|
|
|