[Home] [Help] [Dependency Information]
Object Name: | MST_AP_SUMMARY_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 | Identifier for plan to which record belong | |
MODE_OF_TRANSPORT | VARCHAR2 | (30) | Mode of transport of trip in current record (PARCEL) | |
COMPILE_DESIGNATOR | VARCHAR2 | (10) | Yes | Plan name |
DESCRIPTION | VARCHAR2 | (50) | Plan description | |
NUMBER_OF_LOADS | NUMBER | Number of parcel in plan | ||
TOTAL_PARCEL_WEIGHT | NUMBER | Total Parcel weight in plan | ||
WEIGHT_UOM | VARCHAR2 | (3) | Unit of measurement considered for weight in current plan | |
TOTAL_PARCEL_VOLUME | NUMBER | Total Parcel volume in plan | ||
VOLUME_UOM | VARCHAR2 | (3) | Unit of measurement considered for volume in current plan | |
TOTAL_PARCEL_PALLETS | NUMBER | Total Parcel pallets in plan | ||
TOTAL_PARCEL_PIECES | NUMBER | Total Parcel pieces in plan | ||
TOTAL_PARCEL_ORDERS | NUMBER | Total Parcel orders() in plan | ||
MINIMUM_CHARGES | NUMBER | Total basic transport cost of the trip (Parcel) in the plan | ||
MINIMUM_CHARGES_UOM | VARCHAR2 | (3) | Global currency UOM defined in global parameters | |
ACCESSORIAL_CHARGES | NUMBER | Total accessorial cost of the trip (Parcel) in the plan | ||
ACCESSORIAL_CHARGES_UOM | VARCHAR2 | (3) | Global currency UOM defined in global parameters | |
TOTAL_CHARGES_UOM | VARCHAR2 | (3) | Global currency UOM defined in global parameters |
Cut, paste (and edit) the following text to query this object:
SELECT PLAN_ID
, MODE_OF_TRANSPORT
, COMPILE_DESIGNATOR
, DESCRIPTION
, NUMBER_OF_LOADS
, TOTAL_PARCEL_WEIGHT
, WEIGHT_UOM
, TOTAL_PARCEL_VOLUME
, VOLUME_UOM
, TOTAL_PARCEL_PALLETS
, TOTAL_PARCEL_PIECES
, TOTAL_PARCEL_ORDERS
, MINIMUM_CHARGES
, MINIMUM_CHARGES_UOM
, ACCESSORIAL_CHARGES
, ACCESSORIAL_CHARGES_UOM
, TOTAL_CHARGES_UOM
FROM APPS.MST_AP_SUMMARY_V;
APPS.MST_AP_SUMMARY_V is not referenced by any database object
|
|
|