VIEW: WSH.WSH_DOCUMENT_INSTANCES#

Source

View Text - Preformatted

select DOCUMENT_INSTANCE_ID DOCUMENT_INSTANCE_ID, ENTITY_NAME ENTITY_NAME, ENTITY_ID ENTITY_ID, DOCUMENT_TYPE DOCUMENT_TYPE, SEQUENCE_NUMBER SEQUENCE_NUMBER, STATUS STATUS, FINAL_PRINT_DATE FINAL_PRINT_DATE, DOC_SEQUENCE_CATEGORY_ID DOC_SEQUENCE_CATEGORY_ID, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, REQUEST_ID REQUEST_ID, POD_FLAG POD_FLAG, POD_BY POD_BY, POD_DATE POD_DATE, REASON_OF_TRANSPORT REASON_OF_TRANSPORT, DESCRIPTION DESCRIPTION, COD_AMOUNT COD_AMOUNT, COD_CURRENCY_CODE COD_CURRENCY_CODE, COD_REMIT_TO COD_REMIT_TO, COD_CHARGE_PAID_BY COD_CHARGE_PAID_BY, PROBLEM_CONTACT_REFERENCE PROBLEM_CONTACT_REFERENCE, BILL_FREIGHT_TO BILL_FREIGHT_TO, CARRIED_BY CARRIED_BY, PORT_OF_LOADING PORT_OF_LOADING, PORT_OF_DISCHARGE PORT_OF_DISCHARGE, BOOKING_OFFICE BOOKING_OFFICE, BOOKING_NUMBER BOOKING_NUMBER, SERVICE_CONTRACT SERVICE_CONTRACT, SHIPPER_EXPORT_REF SHIPPER_EXPORT_REF, CARRIER_EXPORT_REF CARRIER_EXPORT_REF, BOL_NOTIFY_PARTY BOL_NOTIFY_PARTY, SUPPLIER_CODE SUPPLIER_CODE, AETC_NUMBER AETC_NUMBER, SHIPPER_SIGNED_BY SHIPPER_SIGNED_BY, SHIPPER_DATE SHIPPER_DATE, CARRIER_SIGNED_BY CARRIER_SIGNED_BY, CARRIER_DATE CARRIER_DATE, BOL_ISSUE_OFFICE BOL_ISSUE_OFFICE, BOL_ISSUED_BY BOL_ISSUED_BY, BOL_DATE_ISSUED BOL_DATE_ISSUED, SHIPPER_HM_BY SHIPPER_HM_BY, SHIPPER_HM_DATE SHIPPER_HM_DATE, CARRIER_HM_BY CARRIER_HM_BY, CARRIER_HM_DATE CARRIER_HM_DATE, EXPECTED_POD_DATE EXPECTED_POD_DATE from "WSH"."WSH_DOCUMENT_INSTANCES"

View Text - HTML Formatted

SELECT DOCUMENT_INSTANCE_ID DOCUMENT_INSTANCE_ID
, ENTITY_NAME ENTITY_NAME
, ENTITY_ID ENTITY_ID
, DOCUMENT_TYPE DOCUMENT_TYPE
, SEQUENCE_NUMBER SEQUENCE_NUMBER
, STATUS STATUS
, FINAL_PRINT_DATE FINAL_PRINT_DATE
, DOC_SEQUENCE_CATEGORY_ID DOC_SEQUENCE_CATEGORY_ID
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, REQUEST_ID REQUEST_ID
, POD_FLAG POD_FLAG
, POD_BY POD_BY
, POD_DATE POD_DATE
, REASON_OF_TRANSPORT REASON_OF_TRANSPORT
, DESCRIPTION DESCRIPTION
, COD_AMOUNT COD_AMOUNT
, COD_CURRENCY_CODE COD_CURRENCY_CODE
, COD_REMIT_TO COD_REMIT_TO
, COD_CHARGE_PAID_BY COD_CHARGE_PAID_BY
, PROBLEM_CONTACT_REFERENCE PROBLEM_CONTACT_REFERENCE
, BILL_FREIGHT_TO BILL_FREIGHT_TO
, CARRIED_BY CARRIED_BY
, PORT_OF_LOADING PORT_OF_LOADING
, PORT_OF_DISCHARGE PORT_OF_DISCHARGE
, BOOKING_OFFICE BOOKING_OFFICE
, BOOKING_NUMBER BOOKING_NUMBER
, SERVICE_CONTRACT SERVICE_CONTRACT
, SHIPPER_EXPORT_REF SHIPPER_EXPORT_REF
, CARRIER_EXPORT_REF CARRIER_EXPORT_REF
, BOL_NOTIFY_PARTY BOL_NOTIFY_PARTY
, SUPPLIER_CODE SUPPLIER_CODE
, AETC_NUMBER AETC_NUMBER
, SHIPPER_SIGNED_BY SHIPPER_SIGNED_BY
, SHIPPER_DATE SHIPPER_DATE
, CARRIER_SIGNED_BY CARRIER_SIGNED_BY
, CARRIER_DATE CARRIER_DATE
, BOL_ISSUE_OFFICE BOL_ISSUE_OFFICE
, BOL_ISSUED_BY BOL_ISSUED_BY
, BOL_DATE_ISSUED BOL_DATE_ISSUED
, SHIPPER_HM_BY SHIPPER_HM_BY
, SHIPPER_HM_DATE SHIPPER_HM_DATE
, CARRIER_HM_BY CARRIER_HM_BY
, CARRIER_HM_DATE CARRIER_HM_DATE
, EXPECTED_POD_DATE EXPECTED_POD_DATE
FROM "WSH"."WSH_DOCUMENT_INSTANCES"