[Home] [Help] [Dependency Information]
Object Name: | MST_DELIVERIES |
---|---|
Object Type: | TABLE |
Owner: | MST |
Subobject Name: | |
Status: | VALID |
This is the entity that stores consolidated delivery line details and/or packages that belong to same source and destination location
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
MST_DELIVERIES_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
PLAN_ID
DELIVERY_ID |
MST_DELIVERIES_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
PLAN_ID
ORGANIZATION_ID |
MST_DELIVERIES_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
PLAN_ID
CUSTOMER_ID |
MST_DELIVERIES_N4 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
PLAN_ID
CARRIER_ID SERVICE_LEVEL |
MST_DELIVERIES_N5 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
PLAN_ID
PICKUP_LOCATION_ID |
MST_DELIVERIES_N6 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
PLAN_ID
DROPOFF_LOCATION_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
DELIVERY_ID | NUMBER | Yes | Primary key | |
SR_DELIVERY_ID | NUMBER | This column stores the source delivery id | ||
PLAN_ID | NUMBER | Yes | FK to MST_PLANS | |
DELIVERY_NUMBER | NUMBER | TP Delivery Number | ||
DESCRIPTION | VARCHAR2 | (240) | Description of delivery | |
PLANNED_FLAG | NUMBER | Yes | 1 => Firm Delivery, 2 => Not Firmed | |
EARLIEST_PICKUP_DATE | DATE | Date on which this delivery is to be first picked up. Derived from mst_delivery_details | ||
LATEST_PICKUP_DATE | DATE | Latest date on which this delivery can be picked up. Derived from delivery details. | ||
EARLIEST_ACCEPTABLE_DATE | DATE | Earliest date on which delivery needs to be delivered. Derived from delivery details. | ||
LATEST_ACCEPTABLE_DATE | DATE | Latest date on which delivery needs to be delivered. Derived from delivery details. | ||
PICKUP_DATE | DATE | For firm delivery in TE, user can specify at what date this delivery need to be picked up. Or this can be populated by deliveries created by TP. | ||
DROPOFF_DATE | DATE | For firm delivery in TE, user can specify at what date this delivery need to be picked up. Or this can be populated by deliveries created by TP. | ||
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. | |
CARRIER_ID | NUMBER | Freight carrier | ||
SERVICE_LEVEL | VARCHAR2 | (30) | Service Level eg., D2D, 2 days, Overnight etc., | |
MODE_OF_TRANSPORT | VARCHAR2 | (30) | 1 TRUCK, 2 LTL, 3 PARCEL, 4 AIR | |
DIRECT_COST | NUMBER | Cost of delivery if it is sent directly. | ||
GROSS_WEIGHT | NUMBER | Gross weight | ||
NET_WEIGHT | NUMBER | Net weight | ||
VOLUME | NUMBER | Volume | ||
NUMBER_OF_PALLETS | NUMBER | Number of pallets required for this delivery | ||
NUMBER_OF_PIECES | NUMBER | Denormalize : number of packages and loose pieces | ||
CUSTOMER_ID | NUMBER | Foreign key to hz_cust_accounts | ||
ORGANIZATION_ID | NUMBER | SHIP_FROM_ORG_ID | ||
DESTINATION_ORGANIZATION_ID | NUMBER | Ship to organization id for internal inbound/outbound | ||
SUPPLIER_ID | NUMBER | Ship from supplier or ship to supplier for return to supplier or shipment from supplier case. | ||
RELEASE_ERROR_MSG | VARCHAR2 | (30) | Message to capture any errors during release | |
LOCKED_FOR_IMPACT | NUMBER | 1 - locked by user's action, 2 - not locked | ||
OUT_OF_SCOPE | NUMBER | 1 => Out of scope delivery | ||
PRESERVE_GROUPING_FLAG | NUMBER | 1 => preserve group, 2 => not group firm | ||
SHIPMENT_DIRECTION | NUMBER | I Inbound, O Outbound, D Dropship. Not displayed on UI. | ||
STATUS_CODE | NUMBER | 1 Open, 2 Confirmed, 3 In Transit, 4 Closed, 5 Shipment Requested | ||
KNOWN_TE_FIRM_STATUS | NUMBER | This column stores the known TE firming status | ||
CREATED_BY | NUMBER | (15) | Yes | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
CREATION_DATE | DATE | Yes | Standard who column - date when this row was created. | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column - date when a user last updated this row. | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). |
Cut, paste (and edit) the following text to query this object:
SELECT DELIVERY_ID
, SR_DELIVERY_ID
, PLAN_ID
, DELIVERY_NUMBER
, DESCRIPTION
, PLANNED_FLAG
, EARLIEST_PICKUP_DATE
, LATEST_PICKUP_DATE
, EARLIEST_ACCEPTABLE_DATE
, LATEST_ACCEPTABLE_DATE
, PICKUP_DATE
, DROPOFF_DATE
, PICKUP_LOCATION_ID
, DROPOFF_LOCATION_ID
, CARRIER_ID
, SERVICE_LEVEL
, MODE_OF_TRANSPORT
, DIRECT_COST
, GROSS_WEIGHT
, NET_WEIGHT
, VOLUME
, NUMBER_OF_PALLETS
, NUMBER_OF_PIECES
, CUSTOMER_ID
, ORGANIZATION_ID
, DESTINATION_ORGANIZATION_ID
, SUPPLIER_ID
, RELEASE_ERROR_MSG
, LOCKED_FOR_IMPACT
, OUT_OF_SCOPE
, PRESERVE_GROUPING_FLAG
, SHIPMENT_DIRECTION
, STATUS_CODE
, KNOWN_TE_FIRM_STATUS
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
FROM MST.MST_DELIVERIES;
MST.MST_DELIVERIES does not reference any database object
MST.MST_DELIVERIES is referenced by following:
|
|
|