[Home] [Help] [Dependency Information]
Object Name: | WSH_SHIPMENT_BATCHES |
---|---|
Object Type: | TABLE |
Owner: | WSH |
Subobject Name: | |
Status: | VALID |
This table stores Shipment Batch Number created for Delivery Details, its
generated before sending shipment batches to Distributed Warehouse
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
WSH_SHIPMENT_BATCHES_U1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | BATCH_ID |
WSH_SHIPMENT_BATCHES_U2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | NAME |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
BATCH_ID | NUMBER | Yes | Batch Id | |
NAME | VARCHAR2 | (30) | Yes | Name |
ORG_ID | NUMBER | Yes | Org Id | |
CURRENCY_CODE | VARCHAR2 | (15) | Currency Code | |
CUSTOMER_ID | NUMBER | Customer Id | ||
ORGANIZATION_ID | NUMBER | Yes | Organization Id | |
SHIP_FROM_LOCATION_ID | NUMBER | Yes | Ship From Location Id | |
SHIP_TO_SITE_USE_ID | NUMBER | Yes | Ship To Site Use Id | |
INVOICE_TO_SITE_USE_ID | NUMBER | Invoice To Site Use Id | ||
DELIVER_TO_SITE_USE_ID | NUMBER | Deliver To Site Use Id | ||
SHIP_TO_CONTACT_ID | NUMBER | Ship To Contact Id | ||
INVOICE_TO_CONTACT_ID | NUMBER | Invoice To Contact Id | ||
DELIVER_TO_CONTACT_ID | NUMBER | Deliver To Contact Id | ||
SHIP_METHOD_CODE | VARCHAR2 | (30) | Ship Method Code | |
FREIGHT_TERMS_CODE | VARCHAR2 | (30) | Freight Terms Code | |
FOB_CODE | VARCHAR2 | (30) | FOB Code | |
PENDING_REQUEST_FLAG | VARCHAR2 | (1) | Pending Request Flag | |
CREATION_DATE | DATE | Yes | Creation Date | |
CREATED_BY | NUMBER | Yes | Created By | |
LAST_UPDATE_DATE | DATE | Yes | Last Update Date | |
LAST_UPDATED_BY | NUMBER | Yes | Last Update By | |
LAST_UPDATE_LOGIN | NUMBER | Last Update Login | ||
REQUEST_ID | NUMBER | Request Id | ||
PROGRAM_APPLICATION_ID | NUMBER | Program Application Id | ||
PROGRAM_ID | NUMBER | Program Id | ||
PROGRAM_UPDATE_DATE | DATE | Program Update Date |
Cut, paste (and edit) the following text to query this object:
SELECT BATCH_ID
, NAME
, ORG_ID
, CURRENCY_CODE
, CUSTOMER_ID
, ORGANIZATION_ID
, SHIP_FROM_LOCATION_ID
, SHIP_TO_SITE_USE_ID
, INVOICE_TO_SITE_USE_ID
, DELIVER_TO_SITE_USE_ID
, SHIP_TO_CONTACT_ID
, INVOICE_TO_CONTACT_ID
, DELIVER_TO_CONTACT_ID
, SHIP_METHOD_CODE
, FREIGHT_TERMS_CODE
, FOB_CODE
, PENDING_REQUEST_FLAG
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
FROM WSH.WSH_SHIPMENT_BATCHES;
WSH.WSH_SHIPMENT_BATCHES does not reference any database object
WSH.WSH_SHIPMENT_BATCHES is referenced by following:
|
|
|