DBA Data[Home] [Help] [Dependency Information]

TABLE: WSH.WSH_SHIPMENT_BATCHES

Object Details
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


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
WSH_SHIPMENT_BATCHES_U1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnBATCH_ID
WSH_SHIPMENT_BATCHES_U2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnNAME
Columns
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
Query Text

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;

Dependencies

[top of page]

WSH.WSH_SHIPMENT_BATCHES does not reference any database object

WSH.WSH_SHIPMENT_BATCHES is referenced by following:

SchemaWSH
ViewWSH_SHIPMENT_BATCHES#