[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

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