[Home] [Help] [Dependency Information]
Object Name: | WSH_DD_TXNS |
---|---|
Object Type: | TABLE |
Owner: | WSH |
Subobject Name: | |
Status: | VALID |
The table WSH_DD_TXNS is used to capture the transaction information like date, status and quantities upon setting the status to 'Released to Warehouse' and 'Backordered' only if the DBI is installed. The information is used to generate the Daily Business Intelligence Reports.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
WSH_DD_TXNS_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | DELIVERY_DETAIL_ID |
WSH_DD_TXNS_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | RELEASED_STATUS |
WSH_DD_TXNS_N3 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | DD_TXN_DATE |
WSH_DD_TXNS_U1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | DD_TXN_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
DD_TXN_ID | NUMBER | Yes | Sequence Number for Record Insertion | |
DD_TXN_DATE | DATE | Yes | Time when record was inserted | |
DELIVERY_DETAIL_ID | NUMBER | Yes | Identifies the delivery line | |
RELEASED_STATUS | VARCHAR2 | (1) | Yes | Pick Release Status |
REQUESTED_QUANTITY | NUMBER | Yes | Shipping quantity for customer | |
REQUESTED_QUANTITY_UOM | VARCHAR2 | (3) | Yes | Unit of measure for requested quantity |
REQUESTED_QUANTITY2 | NUMBER | Dual requested quantity | ||
REQUESTED_QUANTITY_UOM2 | VARCHAR2 | (3) | Unit of Measure for dual requested quantity | |
PICKED_QUANTITY | NUMBER | Picked Quantity | ||
PICKED_QUANTITY2 | NUMBER | Secondary Picked Quantity | ||
ATTRIBUTE_CATEGORY | VARCHAR2 | (150) | Descriptive flexfields structure | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfields structure | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfields structure | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfields structure | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfields structure | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfields structure | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfields structure | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfields structure | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfields structure | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfields structure | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfields structure | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfields structure | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfields structure | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfields structure | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfields structure | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfields structure | |
CREATED_BY | NUMBER | Standard Who column | ||
CREATION_DATE | DATE | Standard Who column | ||
LAST_UPDATED_BY | NUMBER | Standard Who column | ||
LAST_UPDATE_DATE | DATE | Standard Who column | ||
LAST_UPDATE_LOGIN | NUMBER | Standard Who column |
Cut, paste (and edit) the following text to query this object:
SELECT DD_TXN_ID
, DD_TXN_DATE
, DELIVERY_DETAIL_ID
, RELEASED_STATUS
, REQUESTED_QUANTITY
, REQUESTED_QUANTITY_UOM
, REQUESTED_QUANTITY2
, REQUESTED_QUANTITY_UOM2
, PICKED_QUANTITY
, PICKED_QUANTITY2
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
FROM WSH.WSH_DD_TXNS;
WSH.WSH_DD_TXNS does not reference any database object
WSH.WSH_DD_TXNS is referenced by following:
|
|
|