eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: MST.MST_RELEASE_TEMP

Object Details

Object Name:	MST_RELEASE_TEMP
Object Type:	TABLE
Owner:	MST
Subobject Name:
Status:	VALID

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
MST_RELEASE_TEMP_N1	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	RELEASE_ID TRIP_ID

Columns

Name	Datatype	Length	Comments
RELEASE_ID	NUMBER		It is derived from mst_release_seq. It differentiates the records of different release session. One release session will have one release_id.
GROUP_ID	NUMBER		It represent the group of trip data submitted in one bunch. Either all be successfully released or all will be failed.
PLAN_ID	NUMBER		It indicate the plan to which current record belong to
TRIP_ID	NUMBER		It is trip_id of trips in mst_trips. If it is NOT NULL then current reocrd belong to trip otherwise it belong to delivery or stop or anything else.
TRIP_NUMBER	NUMBER		It is trip_number of trips in mst_trips corresponding to the trip_id of current record.
PLANNED_FLAG	NUMBER		Firm Status of trip or delivery or continuous move whichever is applicable to current record
RELEASE_STATUS	NUMBER		Release Status of trip or continuous move whichever is applicable to current record
TRIP_START_DATE	DATE		It is trip_start_date of trips in mst_trips corresponding to the trip_id of current record.
CM_ID_OF_TRIP	NUMBER		It is continuous_move_id of trip in mst_trips corresponding to the trip_id of current record.
CONTINUOUS_MOVE_ID	NUMBER		It is continuous_move_id of continuous Move in mst_cm_trips. Record belongs to a continuous move if it is NOT NULL
DELIVERY_ID	NUMBER		It is delivery_id of delivery in mst_deliveries. Record belongs to a delivery if it is NOT NULL
OUT_OF_SCOPE	NUMBER		Out of scope flag of trip or delivery or continuous move whichever is applicable to current record
TRIP_PROCESS_FLAG	NUMBER		It i sused in TP release processing while searching making group of related trips.
SELECTED_TRIPS	NUMBER		1 - Release initiated with these trips, NULL - means trips identified as related trip of original trip whose release initiated
TRIP_ID_IFACE	NUMBER		wsh_trips_interface.trip_interface_id
CONTINUOUS_MOVE_ID_IFACE	NUMBER		fte_moves_interface.move_interface_id
DELIVERY_ID_IFACE	NUMBER		wsh_new_del_interface.delivery_interface_id
STOP_ID_IFACE	NUMBER		wsh_trip_stops_interface.stop_interface_id
CONTINUOUS_MOVE_SEQUENCE	NUMBER		It is continuous_move_sequence of trip in mst_trips corresponding to the trip_id of current record.
SR_CM_TRIP_ID	NUMBER		It is sr_cm_trip_id of continuous move in mst_cm_trips corresponding to the continuous_move_id of current record.
SR_TRIP_ID	NUMBER		It is sr_trip_id of trip in mst_trips corresponding to the trip_id of current record.
STOP_ID	NUMBER		It is stop_id of stop in mst_trip_stops. Record belong to a stop if it is NOT NULL
SR_DELIVERY_ID	NUMBER		It is sr_delivery_id of delivery in mst_deliveries corresponding to the delivery_id of current record.
DELIVERY_DETAIL_ID_IFACE	NUMBER		wsh_del_details_interface.delivery_detail_interface_id
DELIVERY_DETAIL_ID	NUMBER		It is delivery_detail_id of delivery line in mst_delivery_details. Record belong to delivery line if it is NOT NULL
SR_DELIVERY_DETAIL_ID	NUMBER		It is sr_delivery_detail_id of delivery line in mst_delivery_details corresponding to the delivery_detail_id of current record.
SR_DELIVERY_ASSIGNMENT_ID	NUMBER		It is sr_delivery_assignment_id of delivery assignment in mst_delivery_assignments corresponding to the delivery_detail_id of current record.
SR_STOP_ID	NUMBER		It is sr_stop_id of stop in mst_trip_stops corresponding to the stop_id of current record.
STATUS_CODE	NUMBER		It is status_code of delivery in mst_deliveries corresponding to the delivery_id of current record.
PICKUP_DATE	DATE		It is pickup_date of delivery in mst_deliveries corresponding to the delivery_id of current record.
DROPOFF_DATE	DATE		It is dropoff_date of delivery in mst_deliveries corresponding to the delivery_id of current record.
PICKUP_LOCATION_ID	NUMBER		It is pickup_location_id of delivery in mst_deliveries corresponding to the delivery_id of current record.
DROPOFF_LOCATION_ID	NUMBER		It is dropoff_location_id of delivery in mst_deliveries corresponding to the delivery_id of current record.
CUSTOMER_ID	NUMBER		It is customer_id of delivery/delivery line in mst_deliveries/mst_delivery_details corresponding to the delivery_id/delivery_detail_id of current record as applicable
SUPPLIER_ID	NUMBER		It is supplier_id of delivery/delivery line in mst_deliveries/mst_delivery_details corresponding to the delivery_id/delivery_detail_id of current record as applicable
PARTY_ID	NUMBER		It is party_id of delivery line in mst_deliveries/mst_delivery_details corresponding to the delivery_detail_id of current record
GROSS_WEIGHT	NUMBER		It is gross_weight of delivery/delivery line in mst_deliveries/mst_delivery_details corresponding to the delivery_id/delivery_detail_id of current record as applicable
NET_WEIGHT	NUMBER		It is net_weight of delivery/delivery line in mst_deliveries/mst_delivery_details corresponding to the delivery_id/delivery_detail_id of current record as applicable
WEIGHT_UOM	VARCHAR2	(3)	It is weight_uom of current plan in mst_plans
VOLUME	NUMBER		It is volume of delivery/delivery line in mst_deliveries/mst_delivery_details corresponding to the delivery_id/delivery_detail_id of current record as applicable
VOLUME_UOM	VARCHAR2	(3)	It is volume_uom of current plan in mst_plans
CURRENCY_UOM	VARCHAR2	(3)	It is currency_uom of current plan in mst_plans
ORGANIZATION_ID	NUMBER		It is organization_id of delivery/delivery line in mst_deliveries/mst_delivery_details corresponding to the delivery_id/delivery_detail_id of current record as applicable
SHIPMENT_DIRECTION	VARCHAR2	(30)	It is shipment_direction of delivery in mst_deliveries/mst_delivery_details corresponding to the delivery_id of current record
DELIVERY_NUMBER	NUMBER		It is delivery_number of delivery in mst_deliveries/mst_delivery_details corresponding to the delivery_id of current record
COMPILE_DESIGNATOR	VARCHAR2	(10)	It is compile_designator of plan in mst_dplans corresponding to the plan_id of current record
EARLIEST_PICKUP_DATE	DATE		It is earliest_pickup_date of delivery/delivery line in mst_deliveries/mst_delivery_details corresponding to the delivery_id/delivery_detail_id of current record as applicable
LATEST_PICKUP_DATE	DATE		It is latest_pickup_date of delivery/delivery line in mst_deliveries/mst_delivery_details corresponding to the delivery_id/delivery_detail_id of current record as applicable
EARLIEST_ACCEPTABLE_DATE	DATE		It is earliest_acceptable_date of delivery/delivery line in mst_deliveries/mst_delivery_details corresponding to the delivery_id/delivery_detail_id of current record as applicable
LATEST_ACCEPTABLE_DATE	DATE		It is latest_acceptable_date of delivery/delivery line in mst_deliveries/mst_delivery_details corresponding to the delivery_id/delivery_detail_id of current record as applicable
INVENTORY_ITEM_ID	NUMBER		It is inventory_item_id of delivery line in mst_delivery_details corresponding to the delivery_detail_id of current record.
CARRIER_ID	NUMBER		It is carrier_id of trip in mst_trips corresponding to the trip_id of current record.
SHIP_METHOD_CODE	VARCHAR2	(30)	It is ship_method_code of trip in mst_trips corresponding to the trip_id of current record.
MODE_OF_TRANSPORT	VARCHAR2	(30)	It is mode_of_transport of trip in mst_trips corresponding to the trip_id of current record.
LOAD_TENDER_STATUS	NUMBER		It is load_tender_status of trip in mst_trips corresponding to the trip_id of current record.
LANE_ID	NUMBER		It is lane_id of trip in mst_trips corresponding to the trip_id of current record.
SERVICE_LEVEL	VARCHAR2	(30)	It is service_level_id of trip in mst_trips corresponding to the trip_id of current record.
CM_TRIP_NUMBER	NUMBER		It is cm_trip_number of continuous move in mst_cm_trips corresponding to the continuous_move_id of current record.
STOP_LOCATION_ID	NUMBER		It is stop_location_id of stop in mst_trip_stops corresponding to the stop_id of current record.
STOP_SEQUENCE_NUMBER	NUMBER		It is stop_sequence_number of stop in mst_trip_stops corresponding to the stop_id of current record.
PLANNED_ARRIVAL_DATE	DATE		It is planned_arrival_date of stop in mst_trip_stops corresponding to the stop_id of current record.
PLANNED_DEPARTURE_DATE	DATE		It is planned_departure_date of stop in mst_trip_stops corresponding to the stop_id of current record.
DEPARTURE_GROSS_WEIGHT	NUMBER		It is departure_gross_weight of stop in mst_trip_stops corresponding to the stop_id of current record.
DEPARTURE_NET_WEIGHT	NUMBER		It is departure_net_weight of stop in mst_trip_stops corresponding to the stop_id of current record.
DEPARTURE_VOLUME	NUMBER		It is departure_volume of stop in mst_trip_stops corresponding to the stop_id of current record.
DEPARTURE_FILL_PERCENT	NUMBER		It is depature_fill_percent stop_location_id of stop in mst_trip_stops corresponding to the stop_id of current record.
WKEND_LAYOVER_STOPS	NUMBER		It is wkend_layover_stops of stop in mst_trip_stops corresponding to the stop_id of current record.
WKDAY_LAYOVER_STOPS	NUMBER		It is wkday_layover_stops of stop in mst_trip_stops corresponding to the stop_id of current record.
DISTANCE_TO_NEXT_STOP	NUMBER		It is distance_to_next_stop of stop in mst_trip_stops corresponding to the stop_id of current record.
PLN_LOADING_START_TIME	DATE		It is pln_loading_start_time stop_location_id of stop in mst_trip_stops corresponding to the stop_id of current record.
PLN_LOADING_END_TIME	DATE		It is pln_loading_end_time of stop in mst_trip_stops corresponding to the stop_id of current record.
PLN_UNLOADING_START_TIME	DATE		It is pln_unloading_start_time of stop in mst_trip_stops corresponding to the stop_id of current record.
PLN_UNLOADING_END_TIME	DATE		It is pln_unloading_end_time of stop in mst_trip_stops corresponding to the stop_id of current record.
SOURCE_CODE	VARCHAR2	(30)	It is source_code of delivery line in mst_delivery_details corresponding to the delivery_detail_id of current record.
SHIP_FROM_LOCATION_ID	NUMBER		It is ship_from_location_id of delivery line in mst_delivery_details corresponding to the delivery_detail_id of current record.
SHIP_TO_LOCATION_ID	NUMBER		It is ship_to_location_id of delivery line in mst_delivery_details corresponding to the delivery_detail_id of current record.
REQUESTED_QUANTITY	NUMBER		It is requested_quantity of delivery line in mst_delivery_details corresponding to the delivery_detail_id of current record.
SOURCE_HEADER_NUMBER	VARCHAR2	(150)	It is source_header_number of delivery line in mst_delivery_details corresponding to the delivery_detail_id of current record.
SHIP_SET_ID	NUMBER		It is ship_set_id of delivery line in mst_delivery_details corresponding to the delivery_detail_id of current record.
ARRIVAL_SET_ID	NUMBER		It is arrival_set_id of delivery line in mst_delivery_details corresponding to the delivery_detail_id of current record.
ORG_ID	NUMBER		Organization identifier
CONTAINER_FLAG	NUMBER		It is container_flag of delivery line in mst_delivery_details corresponding to the delivery_detail_id of current record.
SOURCE_LINE_NUMBER	VARCHAR2	(150)	It is source_line_number of delivery line in mst_delivery_details corresponding to the delivery_detail_id of current record.
SPLIT_FROM_DELIVERY_DETAIL_ID	NUMBER		It is split_from_delivery_detail_id of delivery line in mst_delivery_details corresponding to the delivery_detail_id of current record.
LINE_DIRECTION	NUMBER		It is line_direction of delivery line in mst_delivery_details corresponding to the delivery_detail_id of current record.
PO_SHIPMENT_NUMBER	NUMBER		It is po_shipment_number of delivery line in mst_delivery_details corresponding to the delivery_detail_id of current record.
PO_SHIPMENT_LINE_NUMBER	NUMBER		It is po_shipment_line_number of delivery line in mst_delivery_details corresponding to the delivery_detail_id of current record.
SRC_REQUESTED_QUANTITY_UOM	VARCHAR2	(3)	It is src_requested_quantity_uom of delivery line in mst_delivery_details corresponding to the delivery_detail_id of current record.
SRC_REQUESTED_QUANTITY	NUMBER		It is src_requested_quantity of delivery line in mst_delivery_details corresponding to the delivery_detail_id of current record.

Query Text

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


SELECT RELEASE_ID
,      GROUP_ID
,      PLAN_ID
,      TRIP_ID
,      TRIP_NUMBER
,      PLANNED_FLAG
,      RELEASE_STATUS
,      TRIP_START_DATE
,      CM_ID_OF_TRIP
,      CONTINUOUS_MOVE_ID
,      DELIVERY_ID
,      OUT_OF_SCOPE
,      TRIP_PROCESS_FLAG
,      SELECTED_TRIPS
,      TRIP_ID_IFACE
,      CONTINUOUS_MOVE_ID_IFACE
,      DELIVERY_ID_IFACE
,      STOP_ID_IFACE
,      CONTINUOUS_MOVE_SEQUENCE
,      SR_CM_TRIP_ID
,      SR_TRIP_ID
,      STOP_ID
,      SR_DELIVERY_ID
,      DELIVERY_DETAIL_ID_IFACE
,      DELIVERY_DETAIL_ID
,      SR_DELIVERY_DETAIL_ID
,      SR_DELIVERY_ASSIGNMENT_ID
,      SR_STOP_ID
,      STATUS_CODE
,      PICKUP_DATE
,      DROPOFF_DATE
,      PICKUP_LOCATION_ID
,      DROPOFF_LOCATION_ID
,      CUSTOMER_ID
,      SUPPLIER_ID
,      PARTY_ID
,      GROSS_WEIGHT
,      NET_WEIGHT
,      WEIGHT_UOM
,      VOLUME
,      VOLUME_UOM
,      CURRENCY_UOM
,      ORGANIZATION_ID
,      SHIPMENT_DIRECTION
,      DELIVERY_NUMBER
,      COMPILE_DESIGNATOR
,      EARLIEST_PICKUP_DATE
,      LATEST_PICKUP_DATE
,      EARLIEST_ACCEPTABLE_DATE
,      LATEST_ACCEPTABLE_DATE
,      INVENTORY_ITEM_ID
,      CARRIER_ID
,      SHIP_METHOD_CODE
,      MODE_OF_TRANSPORT
,      LOAD_TENDER_STATUS
,      LANE_ID
,      SERVICE_LEVEL
,      CM_TRIP_NUMBER
,      STOP_LOCATION_ID
,      STOP_SEQUENCE_NUMBER
,      PLANNED_ARRIVAL_DATE
,      PLANNED_DEPARTURE_DATE
,      DEPARTURE_GROSS_WEIGHT
,      DEPARTURE_NET_WEIGHT
,      DEPARTURE_VOLUME
,      DEPARTURE_FILL_PERCENT
,      WKEND_LAYOVER_STOPS
,      WKDAY_LAYOVER_STOPS
,      DISTANCE_TO_NEXT_STOP
,      PLN_LOADING_START_TIME
,      PLN_LOADING_END_TIME
,      PLN_UNLOADING_START_TIME
,      PLN_UNLOADING_END_TIME
,      SOURCE_CODE
,      SHIP_FROM_LOCATION_ID
,      SHIP_TO_LOCATION_ID
,      REQUESTED_QUANTITY
,      SOURCE_HEADER_NUMBER
,      SHIP_SET_ID
,      ARRIVAL_SET_ID
,      ORG_ID
,      CONTAINER_FLAG
,      SOURCE_LINE_NUMBER
,      SPLIT_FROM_DELIVERY_DETAIL_ID
,      LINE_DIRECTION
,      PO_SHIPMENT_NUMBER
,      PO_SHIPMENT_LINE_NUMBER
,      SRC_REQUESTED_QUANTITY_UOM
,      SRC_REQUESTED_QUANTITY
FROM MST.MST_RELEASE_TEMP;

Dependencies

[top of page]

MST.MST_RELEASE_TEMP does not reference any database object

MST.MST_RELEASE_TEMP is referenced by following:

APPS: MST_RELEASE_TEMP