eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: WSH.WSH_DOCUMENT_INSTANCES

Object Details

Object Name:	WSH_DOCUMENT_INSTANCES
Object Type:	TABLE
Owner:	WSH
FND Design Data:	WSH.WSH_DOCUMENT_INSTANCES
Subobject Name:
Status:	VALID

WSH_DOCUMENT_INSTANCES has document instances for shipping documents such as Bill of Lading and Packing Slip.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
WSH_DOCUMENT_INSTANCES_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	DOCUMENT_INSTANCE_ID
WSH_DOCUMENT_INSTANCES_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ENTITY_NAME ENTITY_ID DOCUMENT_TYPE STATUS
WSH_DOCUMENT_INSTANCES_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	POD_FLAG
WSH_DOCUMENT_INSTANCES_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SEQUENCE_NUMBER

Columns

Name	Datatype	Length	Mandatory	Comments
DOCUMENT_INSTANCE_ID	NUMBER		Yes	Primary Key for the table
ENTITY_NAME	VARCHAR2	(50)	Yes	Name of the entity the document is based on. E.g. WSH_DELIVERY_LEGS
ENTITY_ID	NUMBER		Yes	Primary key value of the entity in ENTITY_NAME
DOCUMENT_TYPE	VARCHAR2	(30)	Yes	Type of the document - References FND_LOOKUPS.LOOKUP_CODE
SEQUENCE_NUMBER	VARCHAR2	(50)	Yes	Number identifying the document
STATUS	VARCHAR2	(30)		Status of the document
FINAL_PRINT_DATE	DATE			Date the final version of the report was printed
DOC_SEQUENCE_CATEGORY_ID	NUMBER			Sequence category that this document is based on - References WSH_DOC_SEQUENCE_CATEGORIES.DOC_SEQUENCE_CATEGORY_ID
ATTRIBUTE_CATEGORY	VARCHAR2	(150)		Descriptive Flexfield
ATTRIBUTE1	VARCHAR2	(150)		Descriptive Flexfield
ATTRIBUTE2	VARCHAR2	(150)		Descriptive Flexfield
ATTRIBUTE3	VARCHAR2	(150)		Descriptive Flexfield
ATTRIBUTE4	VARCHAR2	(150)		Descriptive Flexfield
ATTRIBUTE5	VARCHAR2	(150)		Descriptive Flexfield
ATTRIBUTE6	VARCHAR2	(150)		Descriptive Flexfield
ATTRIBUTE7	VARCHAR2	(150)		Descriptive Flexfield
ATTRIBUTE8	VARCHAR2	(150)		Descriptive Flexfield
ATTRIBUTE9	VARCHAR2	(150)		Descriptive Flexfield
ATTRIBUTE10	VARCHAR2	(150)		Descriptive Flexfield
ATTRIBUTE11	VARCHAR2	(150)		Descriptive Flexfield
ATTRIBUTE12	VARCHAR2	(150)		Descriptive Flexfield
ATTRIBUTE13	VARCHAR2	(150)		Descriptive Flexfield
ATTRIBUTE14	VARCHAR2	(150)		Descriptive Flexfield
ATTRIBUTE15	VARCHAR2	(150)		Descriptive Flexfield
CREATION_DATE	DATE		Yes	Standard Who column
CREATED_BY	NUMBER		Yes	Standard Who column
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER		Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER			Standard Who column
PROGRAM_APPLICATION_ID	NUMBER			Standard Who column
PROGRAM_ID	NUMBER			Standard Who column
PROGRAM_UPDATE_DATE	DATE			Standard Who column
REQUEST_ID	NUMBER			Standard Who column
POD_FLAG	VARCHAR2	(1)
POD_BY	VARCHAR2	(150)
POD_DATE	DATE
REASON_OF_TRANSPORT	VARCHAR2	(30)
DESCRIPTION	VARCHAR2	(150)
COD_AMOUNT	NUMBER
COD_CURRENCY_CODE	VARCHAR2	(15)
COD_REMIT_TO	VARCHAR2	(150)
COD_CHARGE_PAID_BY	VARCHAR2	(150)
PROBLEM_CONTACT_REFERENCE	VARCHAR2	(500)
BILL_FREIGHT_TO	VARCHAR2	(1000)
CARRIED_BY	VARCHAR2	(150)
PORT_OF_LOADING	VARCHAR2	(150)
PORT_OF_DISCHARGE	VARCHAR2	(150)
BOOKING_OFFICE	VARCHAR2	(50)
BOOKING_NUMBER	VARCHAR2	(30)
SERVICE_CONTRACT	VARCHAR2	(30)
SHIPPER_EXPORT_REF	VARCHAR2	(30)
CARRIER_EXPORT_REF	VARCHAR2	(30)
BOL_NOTIFY_PARTY	VARCHAR2	(30)
SUPPLIER_CODE	VARCHAR2	(30)
AETC_NUMBER	VARCHAR2	(30)
SHIPPER_SIGNED_BY	VARCHAR2	(150)
SHIPPER_DATE	DATE
CARRIER_SIGNED_BY	VARCHAR2	(150)
CARRIER_DATE	DATE
BOL_ISSUE_OFFICE	VARCHAR2	(150)
BOL_ISSUED_BY	VARCHAR2	(150)
BOL_DATE_ISSUED	DATE
SHIPPER_HM_BY	VARCHAR2	(150)
SHIPPER_HM_DATE	DATE
CARRIER_HM_BY	VARCHAR2	(150)
CARRIER_HM_DATE	DATE
EXPECTED_POD_DATE	DATE

Query Text

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


SELECT DOCUMENT_INSTANCE_ID
,      ENTITY_NAME
,      ENTITY_ID
,      DOCUMENT_TYPE
,      SEQUENCE_NUMBER
,      STATUS
,      FINAL_PRINT_DATE
,      DOC_SEQUENCE_CATEGORY_ID
,      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
,      POD_FLAG
,      POD_BY
,      POD_DATE
,      REASON_OF_TRANSPORT
,      DESCRIPTION
,      COD_AMOUNT
,      COD_CURRENCY_CODE
,      COD_REMIT_TO
,      COD_CHARGE_PAID_BY
,      PROBLEM_CONTACT_REFERENCE
,      BILL_FREIGHT_TO
,      CARRIED_BY
,      PORT_OF_LOADING
,      PORT_OF_DISCHARGE
,      BOOKING_OFFICE
,      BOOKING_NUMBER
,      SERVICE_CONTRACT
,      SHIPPER_EXPORT_REF
,      CARRIER_EXPORT_REF
,      BOL_NOTIFY_PARTY
,      SUPPLIER_CODE
,      AETC_NUMBER
,      SHIPPER_SIGNED_BY
,      SHIPPER_DATE
,      CARRIER_SIGNED_BY
,      CARRIER_DATE
,      BOL_ISSUE_OFFICE
,      BOL_ISSUED_BY
,      BOL_DATE_ISSUED
,      SHIPPER_HM_BY
,      SHIPPER_HM_DATE
,      CARRIER_HM_BY
,      CARRIER_HM_DATE
,      EXPECTED_POD_DATE
FROM WSH.WSH_DOCUMENT_INSTANCES;

Dependencies

[top of page]

WSH.WSH_DOCUMENT_INSTANCES does not reference any database object

WSH.WSH_DOCUMENT_INSTANCES is referenced by following:

APPS: WSH_DOCUMENT_INSTANCES