[Home] [Help] [Dependency Information]
Object Name: | MST_UD_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 | |
COMPILE_DESIGNATOR | VARCHAR2 | (10) | Yes | Plan name |
DESCRIPTION | VARCHAR2 | (50) | Plan description | |
DELIVERY_ID | NUMBER | Yes | Id of this delivery | |
DELIVERY_NUMBER | NUMBER | TP Delivery Number | ||
PICKUP_LOCATION_ID | NUMBER | Yes | Initial pick-up location of delivery. Foreign key to wsh_locations. | |
DROPOFF_LOCATION_ID | NUMBER | Yes | Final drop-off location of delivery. Foreign key to wsh_locations. | |
ORIGIN_COMPANY | VARCHAR2 | (80) | Owner company name of facility from where delivery will be shipped | |
ORIGIN_FACILITY | VARCHAR2 | (60) | Yes | Name of facility from where delivery will be shipped |
ORIGIN_FACILITY_DESC | VARCHAR2 | (250) | Description of facility from where delivery will be shipped | |
ORIGIN_CITY | VARCHAR2 | (120) | City of facility from where delivery will be shipped | |
ORIGIN_STATE | VARCHAR2 | (120) | State of facility from where delivery will be shipped | |
ORIGIN_ZIP | VARCHAR2 | (60) | Zip of facility from where delivery will be shipped | |
ORIGIN_COUNTRY | VARCHAR2 | (120) | Country of facility from where delivery will be shipped | |
DESTINATION_COMPANY | VARCHAR2 | (80) | Owner company name of facility to where delivery will be shipped | |
DESTINATION_FACILITY | VARCHAR2 | (60) | Yes | Name of facility to where delivery will be shipped |
DESTINATION_FACILITY_DESC | VARCHAR2 | (250) | Description of facility to where delivery will be shipped | |
DESTINATION_CITY | VARCHAR2 | (120) | City of facility to where delivery will be shipped | |
DESTINATION_STATE | VARCHAR2 | (120) | State of facility to where delivery will be shipped | |
DESTINATION_ZIP | VARCHAR2 | (60) | Zip of facility to where delivery will be shipped | |
DESTINATION_COUNTRY | VARCHAR2 | (120) | Country of facility to where delivery will be shipped | |
GROSS_WEIGHT | NUMBER | Gross weight of this delivery | ||
WEIGHT_UOM | VARCHAR2 | (3) | Weight UOM as considered in the plan | |
VOLUME | NUMBER | Volume of this delivery | ||
VOLUME_UOM | VARCHAR2 | (3) | Volume UOM as considered in the plan | |
NUMBER_OF_PALLETS | NUMBER | Number of pallets in this delivery | ||
NUMBER_OF_PIECES | NUMBER | Number of pieces in this delivery | ||
PLANNED_FLAG | VARCHAR2 | (80) | Yes | Translated string of Firm Status of delivery for display at UI |
EARLIEST_PICKUP_DATE | VARCHAR2 | (40) | Earliest pickup date of delivery in timezone local to the facility from where it will be shipped | |
EARLIEST_PICKUP_DATE_ZONE | VARCHAR2 | (20) | Timezone of facility from where delivery will be shipped | |
LATEST_PICKUP_DATE | VARCHAR2 | (40) | Latest pickup date of delivery in timezone local to the facility from where it will be shipped | |
LATEST_PICKUP_DATE_ZONE | VARCHAR2 | (20) | Timezone of facility from where delivery will be shipped | |
EARLIEST_ACCEPTABLE_DATE | VARCHAR2 | (40) | Earliest dropoff date of delivery in timezone local to the facility to where it will be shipped | |
EARLIEST_ACCEPTABLE_DATE_ZONE | VARCHAR2 | (20) | Timezone of facility to where delivery will be shipped | |
LATEST_ACCEPTABLE_DATE | VARCHAR2 | (40) | Latest dropoff date of delivery in timezone local to the facility to where it will be shipped | |
LATEST_ACCEPTABLE_DATE_ZONE | VARCHAR2 | (20) | Timezone of facility to where delivery will be shipped |
Cut, paste (and edit) the following text to query this object:
SELECT PLAN_ID
, COMPILE_DESIGNATOR
, DESCRIPTION
, DELIVERY_ID
, DELIVERY_NUMBER
, PICKUP_LOCATION_ID
, DROPOFF_LOCATION_ID
, ORIGIN_COMPANY
, ORIGIN_FACILITY
, ORIGIN_FACILITY_DESC
, ORIGIN_CITY
, ORIGIN_STATE
, ORIGIN_ZIP
, ORIGIN_COUNTRY
, DESTINATION_COMPANY
, DESTINATION_FACILITY
, DESTINATION_FACILITY_DESC
, DESTINATION_CITY
, DESTINATION_STATE
, DESTINATION_ZIP
, DESTINATION_COUNTRY
, GROSS_WEIGHT
, WEIGHT_UOM
, VOLUME
, VOLUME_UOM
, NUMBER_OF_PALLETS
, NUMBER_OF_PIECES
, PLANNED_FLAG
, EARLIEST_PICKUP_DATE
, EARLIEST_PICKUP_DATE_ZONE
, LATEST_PICKUP_DATE
, LATEST_PICKUP_DATE_ZONE
, EARLIEST_ACCEPTABLE_DATE
, EARLIEST_ACCEPTABLE_DATE_ZONE
, LATEST_ACCEPTABLE_DATE
, LATEST_ACCEPTABLE_DATE_ZONE
FROM APPS.MST_UD_SUMMARY_V;
APPS.MST_UD_SUMMARY_V is not referenced by any database object
|
|
|