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

VIEW: WSH.WSH_DOCUMENT_INSTANCES#

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

[View Source]

Columns
Name Datatype Length Mandatory Comments
DOCUMENT_INSTANCE_ID NUMBER
Yes
ENTITY_NAME VARCHAR2 (50) Yes
ENTITY_ID NUMBER
Yes
DOCUMENT_TYPE VARCHAR2 (30) Yes
SEQUENCE_NUMBER VARCHAR2 (50) Yes
STATUS VARCHAR2 (30)
FINAL_PRINT_DATE DATE

DOC_SEQUENCE_CATEGORY_ID NUMBER

ATTRIBUTE_CATEGORY VARCHAR2 (150)
ATTRIBUTE1 VARCHAR2 (150)
ATTRIBUTE2 VARCHAR2 (150)
ATTRIBUTE3 VARCHAR2 (150)
ATTRIBUTE4 VARCHAR2 (150)
ATTRIBUTE5 VARCHAR2 (150)
ATTRIBUTE6 VARCHAR2 (150)
ATTRIBUTE7 VARCHAR2 (150)
ATTRIBUTE8 VARCHAR2 (150)
ATTRIBUTE9 VARCHAR2 (150)
ATTRIBUTE10 VARCHAR2 (150)
ATTRIBUTE11 VARCHAR2 (150)
ATTRIBUTE12 VARCHAR2 (150)
ATTRIBUTE13 VARCHAR2 (150)
ATTRIBUTE14 VARCHAR2 (150)
ATTRIBUTE15 VARCHAR2 (150)
CREATION_DATE DATE
Yes
CREATED_BY NUMBER
Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER
Yes
LAST_UPDATE_LOGIN NUMBER

PROGRAM_APPLICATION_ID NUMBER

PROGRAM_ID NUMBER

PROGRAM_UPDATE_DATE DATE

REQUEST_ID NUMBER

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

SchemaWSH
TableWSH_DOCUMENT_INSTANCES
WSH.WSH_DOCUMENT_INSTANCES# is referenced by following:

SchemaAPPS
SynonymWSH_DOCUMENT_INSTANCES