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_GT

Object Details

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

Temporary Table Details

MST.MST_RELEASE_TEMP_GT is a global temporary table. The current session is able see data that it placed in the table but other sessions cannot. Data in the table is temporary. It has a data duration of SYS$TRANSACTION. Data is removed at the end of this period.

Storage Details

Tablespace:
PCT Free:	10
PCT Used:	40

Columns

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

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
,      GROSS_WEIGHT
,      NET_WEIGHT
,      WEIGHT_UOM
,      VOLUME
,      VOLUME_UOM
,      CURRENCY_UOM
,      ORGANIZATION_ID
,      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
,      SHIPMENT_DIRECTION
,      SUPPLIER_ID
,      PARTY_ID
FROM MST.MST_RELEASE_TEMP_GT;

Dependencies

[top of page]

MST.MST_RELEASE_TEMP_GT does not reference any database object

MST.MST_RELEASE_TEMP_GT is referenced by following:

APPS: MST_RELEASE_TEMP_GT