[Home] [Help] [Dependency Information]

TABLE: WMS.WMS_WSH_WDD_GTEMP

Object Details

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

Temporary Table Details

WMS.WMS_WSH_WDD_GTEMP 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

Indexes

Index	Type	Uniqueness	Tablespace	Column
WMS_WSH_WDD_GTEMP_N1	NORMAL	NONUNIQUE		MOVE_ORDER_LINE_ID

Columns

Query Text

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

SELECT DELIVERY_DETAIL_ID
,      SOURCE_CODE
,      SOURCE_HEADER_ID
,      SOURCE_LINE_ID
,      SOURCE_HEADER_NUMBER
,      SOURCE_HEADER_TYPE_ID
,      SOURCE_HEADER_TYPE_NAME
,      CUST_PO_NUMBER
,      CUSTOMER_ID
,      SOLD_TO_CONTACT_ID
,      INVENTORY_ITEM_ID
,      ITEM_DESCRIPTION
,      SHIP_SET_ID
,      ARRIVAL_SET_ID
,      TOP_MODEL_LINE_ID
,      ATO_LINE_ID
,      HOLD_CODE
,      SHIP_MODEL_COMPLETE_FLAG
,      HAZARD_CLASS_ID
,      COUNTRY_OF_ORIGIN
,      CLASSIFICATION
,      SHIP_FROM_LOCATION_ID
,      ORGANIZATION_ID
,      SHIP_TO_LOCATION_ID
,      SHIP_TO_CONTACT_ID
,      SHIP_TO_SITE_USE_ID
,      DELIVER_TO_LOCATION_ID
,      DELIVER_TO_CONTACT_ID
,      DELIVER_TO_SITE_USE_ID
,      INTMED_SHIP_TO_LOCATION_ID
,      INTMED_SHIP_TO_CONTACT_ID
,      SHIP_TOLERANCE_ABOVE
,      SHIP_TOLERANCE_BELOW
,      SRC_REQUESTED_QUANTITY
,      SRC_REQUESTED_QUANTITY_UOM
,      CANCELLED_QUANTITY
,      REQUESTED_QUANTITY
,      REQUESTED_QUANTITY_UOM
,      SHIPPED_QUANTITY
,      DELIVERED_QUANTITY
,      QUALITY_CONTROL_QUANTITY
,      CYCLE_COUNT_QUANTITY
,      MOVE_ORDER_LINE_ID
,      SUBINVENTORY
,      REVISION
,      LOT_NUMBER
,      RELEASED_STATUS
,      CUSTOMER_REQUESTED_LOT_FLAG
,      SERIAL_NUMBER
,      LOCATOR_ID
,      DATE_REQUESTED
,      DATE_SCHEDULED
,      MASTER_CONTAINER_ITEM_ID
,      DETAIL_CONTAINER_ITEM_ID
,      LOAD_SEQ_NUMBER
,      SHIP_METHOD_CODE
,      CARRIER_ID
,      FREIGHT_TERMS_CODE
,      SHIPMENT_PRIORITY_CODE
,      FOB_CODE
,      CUSTOMER_ITEM_ID
,      DEP_PLAN_REQUIRED_FLAG
,      CUSTOMER_PROD_SEQ
,      CUSTOMER_DOCK_CODE
,      CUSTOMER_PRODUCTION_LINE
,      CUSTOMER_JOB
,      NET_WEIGHT
,      CUST_MODEL_SERIAL_NUMBER
,      WEIGHT_UOM_CODE
,      VOLUME
,      VOLUME_UOM_CODE
,      SHIPPING_INSTRUCTIONS
,      PACKING_INSTRUCTIONS
,      PROJECT_ID
,      TASK_ID
,      ORG_ID
,      OE_INTERFACED_FLAG
,      MVT_STAT_STATUS
,      TRACKING_NUMBER
,      TRANSACTION_TEMP_ID
,      TP_ATTRIBUTE_CATEGORY
,      TP_ATTRIBUTE1
,      TP_ATTRIBUTE2
,      TP_ATTRIBUTE3
,      TP_ATTRIBUTE4
,      TP_ATTRIBUTE5
,      TP_ATTRIBUTE6
,      TP_ATTRIBUTE7
,      TP_ATTRIBUTE8
,      TP_ATTRIBUTE9
,      TP_ATTRIBUTE10
,      TP_ATTRIBUTE11
,      TP_ATTRIBUTE12
,      TP_ATTRIBUTE13
,      TP_ATTRIBUTE14
,      TP_ATTRIBUTE15
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      REQUEST_ID
,      MOVEMENT_ID
,      SPLIT_FROM_DELIVERY_DETAIL_ID
,      INV_INTERFACED_FLAG
,      SOURCE_LINE_NUMBER
,      SEAL_CODE
,      MINIMUM_FILL_PERCENT
,      MAXIMUM_VOLUME
,      MAXIMUM_LOAD_WEIGHT
,      MASTER_SERIAL_NUMBER
,      GROSS_WEIGHT
,      FILL_PERCENT
,      CONTAINER_NAME
,      CONTAINER_TYPE_CODE
,      CONTAINER_FLAG
,      PREFERRED_GRADE
,      SRC_REQUESTED_QUANTITY2
,      SRC_REQUESTED_QUANTITY_UOM2
,      REQUESTED_QUANTITY2
,      SHIPPED_QUANTITY2
,      DELIVERED_QUANTITY2
,      CANCELLED_QUANTITY2
,      QUALITY_CONTROL_QUANTITY2
,      CYCLE_COUNT_QUANTITY2
,      REQUESTED_QUANTITY_UOM2
,      SUBLOT_NUMBER
,      UNIT_PRICE
,      CURRENCY_CODE
,      UNIT_NUMBER
,      FREIGHT_CLASS_CAT_ID
,      COMMODITY_CODE_CAT_ID
,      LPN_ID
,      INSPECTION_FLAG
,      ORIGINAL_SUBINVENTORY
,      PICKABLE_FLAG
,      TO_SERIAL_NUMBER
,      PICKED_QUANTITY
,      PICKED_QUANTITY2
,      RECEIVED_QUANTITY
,      RECEIVED_QUANTITY2
,      SOURCE_LINE_SET_ID
,      BATCH_ID
,      R_MESSAGE_APPL
,      R_MESSAGE_CODE
,      R_MESSAGE_TOKEN
,      R_MESSAGE_TYPE
,      R_MESSAGE_TEXT
,      RETURN_STATUS
FROM WMS.WMS_WSH_WDD_GTEMP;

Dependencies

[top of page]

WMS.WMS_WSH_WDD_GTEMP does not reference any database object

WMS.WMS_WSH_WDD_GTEMP is referenced by following:

APPS

WMS_WSH_WDD_GTEMP