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


VIEW: APPS.MST_DELIVERY_LINES_V

Object Details
Object Name: MST_DELIVERY_LINES_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 FK to PLAN_ID of MST_PLANS
DELIVERY_ID NUMBER
Yes Unique Identifier for the Delivery. FK to DELIVERY_ID of MST_DELIVERIES.
DELIVERY_DETAIL_ID NUMBER

Unique identifer for Delivery line. FK to DELIVERY_DETAIL_ID of MST_DELIVERY_DETAILS.
DELIVERY_NUMBER NUMBER

Unique Delivery Number in a Plan.
SOURCE_LINE_NUMBER VARCHAR2 (150)
User visible line number in source system
TRIP_ID NUMBER

FK to TRIP_ID of MST_TRIPS.
SOURCE_CODE VARCHAR2 (30) Yes OE/WIP/PO
SOURCE_HEADER_NUMBER VARCHAR2 (150)
The user visible identifier for the header, ex. Order number
TP_REFER_HEADER_NUMBER VARCHAR2 (50)
Customer PO Number, Supplier Sales Order Line Number or Shipper's Sales Order reference to return
REFERENCE_SOURCE_TYPE VARCHAR2 (240)
Source type of the reference order SO, PO etc
SHIP_FROM_LOCATION_ID NUMBER
Yes Delivery Origin Location. FK to WSH_LOCATION_ID of WSH_LOCATIONS.
SHIP_TO_LOCATION_ID NUMBER

Delivery Destination Location. FK to WSH_LOCATION_ID of WSH_LOCATIONS.
PICK_UP_STOP_ID NUMBER
Yes Pick-up stop identifier for the Delivery Leg. FK to STOP_ID of MST_TRIP_STOPS.
DROP_OFF_STOP_ID NUMBER
Yes Drop-off stop identifier for the Delivery Leg. FK to STOP_ID of MST_TRIP_STOPS.
ORIGIN_COMPANY VARCHAR2 (80)
Company Name of Origin Facility of the Delivery.
ORIGIN_FACILITY_ID NUMBER
Yes ID of Origin Facility of the Delivery.
ORIGIN_FACILITY VARCHAR2 (60) Yes Name of Origin Facility of the Delivery.
ORIGIN_DESCRIPTION VARCHAR2 (250)
Description of Origin Facility of the Delivery.
ORIGIN_CITY VARCHAR2 (120)
Origin City of the Delivery.
ORIGIN_STATE VARCHAR2 (120)
Origin State of the Delivery.
ORIGIN_ZIP VARCHAR2 (60)
Origin Postal Code of the Delivery.
ORIGIN_COUNTRY VARCHAR2 (120)
Origin Country of the Delivery.
DESTINATION_COMPANY VARCHAR2 (80)
Company Name of Destination Facility of the Delivery.
DESTINATION_FACILITY_ID NUMBER
Yes ID of Destination Facility of the Delivery.
DESTINATION_FACILITY VARCHAR2 (60) Yes Name of Destination Facility of the Delivery.
DESTINATION_DESCRIPTION VARCHAR2 (250)
Description of Destination Facility of the Delivery.
DESTINATION_CITY VARCHAR2 (120)
Destination City of the Delivery.
DESTINATION_STATE VARCHAR2 (120)
Destination State of the Delivery.
DESTINATION_ZIP VARCHAR2 (60)
Destination Postal Code of the Delivery.
DESTINATION_COUNTRY VARCHAR2 (120)
Destination Country of the Delivery.
INVENTORY_ITEM_ID NUMBER

ID of Item in the Delivery.
ITEM_NAME VARCHAR2 (40)
Name of Item in the Delivery.
ITEM_DESCRIPTION VARCHAR2 (240)
Description of Item in the Delivery.
EARLIEST_PICKUP_DATE_TIME VARCHAR2 (80)
Early Pickup date of the Delivery.
LATEST_PICKUP_DATE_TIME VARCHAR2 (80)
Latest Pickup date of the Delivery.
EARLIEST_ACCEPTABLE_DATE_TIME VARCHAR2 (80)
Early Acceptable date at destination of the Delivery.
LATEST_ACCEPTABLE_DATE_TIME VARCHAR2 (80)
Latest Acceptable date at Destination of the Delivery.
EARLY_PICKUP_DATE_HIDDEN DATE

Hidden Field for Early Pickup date.
LATEST_PICKUP_DATE_HIDDEN DATE

Hidden Field for Latest Pickup date.
EARLY_ACCEPTABLE_DATE_HIDDEN DATE

Hidden Field for Early Acceptable date.
LATEST_ACCEPTABLE_DATE_HIDDEN DATE

Hidden Field for Latest Acceptable date.
WEIGHT NUMBER

Weight related to Delivery.
CUBE NUMBER

Cube related to Delivery.
PALLETS NUMBER

Pallets related to Delivery.
PIECES NUMBER
Yes Pieces related to Delivery.
WEIGHT_UOM VARCHAR2 (3)
Unit of Measure for Weight.
VOLUME_UOM VARCHAR2 (3)
Unit of Measure for Volume.
Query Text

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


SELECT PLAN_ID
,      DELIVERY_ID
,      DELIVERY_DETAIL_ID
,      DELIVERY_NUMBER
,      SOURCE_LINE_NUMBER
,      TRIP_ID
,      SOURCE_CODE
,      SOURCE_HEADER_NUMBER
,      TP_REFER_HEADER_NUMBER
,      REFERENCE_SOURCE_TYPE
,      SHIP_FROM_LOCATION_ID
,      SHIP_TO_LOCATION_ID
,      PICK_UP_STOP_ID
,      DROP_OFF_STOP_ID
,      ORIGIN_COMPANY
,      ORIGIN_FACILITY_ID
,      ORIGIN_FACILITY
,      ORIGIN_DESCRIPTION
,      ORIGIN_CITY
,      ORIGIN_STATE
,      ORIGIN_ZIP
,      ORIGIN_COUNTRY
,      DESTINATION_COMPANY
,      DESTINATION_FACILITY_ID
,      DESTINATION_FACILITY
,      DESTINATION_DESCRIPTION
,      DESTINATION_CITY
,      DESTINATION_STATE
,      DESTINATION_ZIP
,      DESTINATION_COUNTRY
,      INVENTORY_ITEM_ID
,      ITEM_NAME
,      ITEM_DESCRIPTION
,      EARLIEST_PICKUP_DATE_TIME
,      LATEST_PICKUP_DATE_TIME
,      EARLIEST_ACCEPTABLE_DATE_TIME
,      LATEST_ACCEPTABLE_DATE_TIME
,      EARLY_PICKUP_DATE_HIDDEN
,      LATEST_PICKUP_DATE_HIDDEN
,      EARLY_ACCEPTABLE_DATE_HIDDEN
,      LATEST_ACCEPTABLE_DATE_HIDDEN
,      WEIGHT
,      CUBE
,      PALLETS
,      PIECES
,      WEIGHT_UOM
,      VOLUME_UOM
FROM APPS.MST_DELIVERY_LINES_V;

Dependencies

[top of page]

APPS.MST_DELIVERY_LINES_V references the following:

SchemaAPPS
SynonymFTE_LOCATION_PARAMETERS
SynonymMST_DELIVERIES
SynonymMST_DELIVERY_ASSIGNMENTS
SynonymMST_DELIVERY_DETAILS
SynonymMST_DELIVERY_LEGS
PL/SQL PackageMST_GEOCODING - show dependent code
SynonymMST_PLANS
PL/SQL PackageMST_WB_UTIL - show dependent code
SynonymMTL_SYSTEM_ITEMS_KFV
SynonymMTL_SYSTEM_ITEMS_TL
SynonymWSH_LOCATIONS

APPS.MST_DELIVERY_LINES_V is not referenced by any database object