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

VIEW: WSH.WSH_SHIPMENT_BATCHES#

Object Details
Object Name: WSH_SHIPMENT_BATCHES#
Object Type: VIEW
Owner: WSH
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
BATCH_ID NUMBER
Yes
NAME VARCHAR2 (30) Yes
ORG_ID NUMBER
Yes
CURRENCY_CODE VARCHAR2 (15)
CUSTOMER_ID NUMBER

ORGANIZATION_ID NUMBER
Yes
SHIP_FROM_LOCATION_ID NUMBER
Yes
SHIP_TO_SITE_USE_ID NUMBER
Yes
INVOICE_TO_SITE_USE_ID NUMBER

DELIVER_TO_SITE_USE_ID NUMBER

SHIP_TO_CONTACT_ID NUMBER

INVOICE_TO_CONTACT_ID NUMBER

DELIVER_TO_CONTACT_ID NUMBER

SHIP_METHOD_CODE VARCHAR2 (30)
FREIGHT_TERMS_CODE VARCHAR2 (30)
FOB_CODE VARCHAR2 (30)
PENDING_REQUEST_FLAG VARCHAR2 (1)
CREATION_DATE DATE
Yes
CREATED_BY NUMBER
Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER
Yes
LAST_UPDATE_LOGIN NUMBER

REQUEST_ID NUMBER

PROGRAM_APPLICATION_ID NUMBER

PROGRAM_ID NUMBER

PROGRAM_UPDATE_DATE 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# references the following:

SchemaWSH
TableWSH_SHIPMENT_BATCHES
WSH.WSH_SHIPMENT_BATCHES# is referenced by following:

SchemaAPPS
SynonymWSH_SHIPMENT_BATCHES