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: WMS.WMS_WP_LINES_GTMP

Object Details

Object Name:	WMS_WP_LINES_GTMP
Object Type:	TABLE
Owner:	WMS
FND Design Data:	WMS.WMS_WP_LINES_GTMP
Subobject Name:
Status:	VALID

Temporary Table Details

WMS.WMS_WP_LINES_GTMP 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$SESSION. Data is removed at the end of this period.

Storage Details

Tablespace:
PCT Free:	10
PCT Used:	40

Columns

Name	Datatype	Length
DELIVER_TO	VARCHAR2	(200)
DELIVERY	VARCHAR2	(200)
EXCEPTION_ID	VARCHAR2	(100)
ITEM	VARCHAR2	(200)
LINE_STATUS	VARCHAR2	(50)
LINE_PROGRESS	VARCHAR2	(100)
ORDER_NUMBER	VARCHAR2	(100)
SOURCE_LINE_NUMBER	VARCHAR2	(50)
REQUESTED_QTY	NUMBER
PLANNED_FILL_RATE	NUMBER
RELEASE_FILL_RATE	NUMBER
PICK_FILL_RATE	NUMBER
SHIP_TO	VARCHAR2	(200)
SHIPPED_QTY	NUMBER
DATE_SCHEDULED	DATE
BATCH	NUMBER
CARRIER	VARCHAR2	(200)
CONTACT	VARCHAR2	(200)
CUSTOMER_MODEL_SERIAL_NUMBER	VARCHAR2	(50)
DATE_REQUESTED	DATE
DELIVER_TO_CONTACT	VARCHAR2	(200)
DELIVER_TO_CUSTOMER	VARCHAR2	(200)
DELIVERED_QTY	NUMBER
EARLIEST_DELIVERY_DATE	DATE
EARLIEST_SHIP_DATE	DATE
FOB	VARCHAR2	(100)
FREIGHT_TERMS	VARCHAR2	(100)
GRADE	VARCHAR2	(100)
GROSS_WEIGHT	NUMBER
HAZARD_CLASS	NUMBER
IGNORE_FOR_PLANNING	VARCHAR2	(10)
INSPECTION_STATUS	VARCHAR2	(50)
INTERMEDIATE_SHIP_TO	VARCHAR2	(200)
INTERMEDIATE_SHIP_TO_CONTACT	VARCHAR2	(200)
ITEM_DESCRIPTION	VARCHAR2	(240)
LATEST_DELIVERY_DATE	DATE
LOADING_SEQUENCE	NUMBER
LOCATOR	VARCHAR2	(40)
LOT	VARCHAR2	(100)
MAX_LOAD_WEIGHT	NUMBER
MAX_VOLUME	NUMBER
MIN_FILL_PERCENT	NUMBER
MODE_OF_TRANSPORT	VARCHAR2	(200)
NET_WEIGHT	NUMBER
ORDER_TYPE	VARCHAR2	(150)
ORG_NAME	VARCHAR2	(100)
PACKING_INSTRUCTIONS	VARCHAR2	(300)
REQUESTED_QTY_UOM	VARCHAR2	(3)
REVISION	VARCHAR2	(3)
SEAL_CODE	VARCHAR2	(30)
SECONDARY_DELIVERED_QTY	NUMBER
SECONDARY_REQUESTED_QTY	NUMBER
SECONDARY_REQUESTED_QTY_UOM	VARCHAR2	(3)
SECONDARY_SHIPPED_QTY	NUMBER
SECONDARY_SRC_REQ_QTY	NUMBER
SECONDARY_SRC_REQ_QTY_UOM	VARCHAR2	(3)
SERVICE_LEVEL	VARCHAR2	(100)
SHIP_METHOD	VARCHAR2	(100)
SHIP_MODEL_COMPLETE	VARCHAR2	(100)
SHIP_SET	NUMBER
SHIP_TO_CONTACT	VARCHAR2	(200)
SHIP_TO_CUSTOMER	VARCHAR2	(200)
SHIPMENT_PRIORITY	VARCHAR2	(100)
SHIPPING_INSTRUCTIONS	VARCHAR2	(2000)
SOURCE_REQUESTED_QTY	NUMBER
SOURCE_REQUESTED_QTY_UOM	VARCHAR2	(3)
TARE_WEIGHT	NUMBER
TASK_NUMBER	NUMBER
TRACKING_NUMBER	NUMBER
UNIT_NUMBER	NUMBER
VOLUME	NUMBER
VOLUME_UOM	VARCHAR2	(3)
WEIGHT_UOM	VARCHAR2	(3)
CUSTOMER	VARCHAR2	(200)
PROJECT	NUMBER
CUSTOMER_CLASS	VARCHAR2	(200)
TRIP	NUMBER
REMOVE_FROM_WAVE_FLAG	VARCHAR2	(1)
WAVE_FIRMED_FLAG	VARCHAR2	(1)
MESSAGE	VARCHAR2	(4000)

Query Text

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


SELECT DELIVER_TO
,      DELIVERY
,      EXCEPTION_ID
,      ITEM
,      LINE_STATUS
,      LINE_PROGRESS
,      ORDER_NUMBER
,      SOURCE_LINE_NUMBER
,      REQUESTED_QTY
,      PLANNED_FILL_RATE
,      RELEASE_FILL_RATE
,      PICK_FILL_RATE
,      SHIP_TO
,      SHIPPED_QTY
,      DATE_SCHEDULED
,      BATCH
,      CARRIER
,      CONTACT
,      CUSTOMER_MODEL_SERIAL_NUMBER
,      DATE_REQUESTED
,      DELIVER_TO_CONTACT
,      DELIVER_TO_CUSTOMER
,      DELIVERED_QTY
,      EARLIEST_DELIVERY_DATE
,      EARLIEST_SHIP_DATE
,      FOB
,      FREIGHT_TERMS
,      GRADE
,      GROSS_WEIGHT
,      HAZARD_CLASS
,      IGNORE_FOR_PLANNING
,      INSPECTION_STATUS
,      INTERMEDIATE_SHIP_TO
,      INTERMEDIATE_SHIP_TO_CONTACT
,      ITEM_DESCRIPTION
,      LATEST_DELIVERY_DATE
,      LOADING_SEQUENCE
,      LOCATOR
,      LOT
,      MAX_LOAD_WEIGHT
,      MAX_VOLUME
,      MIN_FILL_PERCENT
,      MODE_OF_TRANSPORT
,      NET_WEIGHT
,      ORDER_TYPE
,      ORG_NAME
,      PACKING_INSTRUCTIONS
,      REQUESTED_QTY_UOM
,      REVISION
,      SEAL_CODE
,      SECONDARY_DELIVERED_QTY
,      SECONDARY_REQUESTED_QTY
,      SECONDARY_REQUESTED_QTY_UOM
,      SECONDARY_SHIPPED_QTY
,      SECONDARY_SRC_REQ_QTY
,      SECONDARY_SRC_REQ_QTY_UOM
,      SERVICE_LEVEL
,      SHIP_METHOD
,      SHIP_MODEL_COMPLETE
,      SHIP_SET
,      SHIP_TO_CONTACT
,      SHIP_TO_CUSTOMER
,      SHIPMENT_PRIORITY
,      SHIPPING_INSTRUCTIONS
,      SOURCE_REQUESTED_QTY
,      SOURCE_REQUESTED_QTY_UOM
,      TARE_WEIGHT
,      TASK_NUMBER
,      TRACKING_NUMBER
,      UNIT_NUMBER
,      VOLUME
,      VOLUME_UOM
,      WEIGHT_UOM
,      CUSTOMER
,      PROJECT
,      CUSTOMER_CLASS
,      TRIP
,      REMOVE_FROM_WAVE_FLAG
,      WAVE_FIRMED_FLAG
,      MESSAGE
FROM WMS.WMS_WP_LINES_GTMP;

Dependencies

[top of page]

WMS.WMS_WP_LINES_GTMP does not reference any database object

WMS.WMS_WP_LINES_GTMP is referenced by following:

APPS: WMS_WP_LINES_GTMP