VIEW: MSC.MSC_OUTBOUND_ENTRIES#

Source

View Text - Preformatted

select DOCUMENT_NUMBER DOCUMENT_NUMBER, RESPONSE_NUMBER RESPONSE_NUMBER, PUBLISHER_NAME PUBLISHER_NAME, PUBLISHER_SITE_NAME PUBLISHER_SITE_NAME, CUSTOMER_NAME CUSTOMER_NAME, CUSTOMER_SITE_NAME CUSTOMER_SITE_NAME, SUPPLIER_NAME SUPPLIER_NAME, SUPPLIER_SITE_NAME SUPPLIER_SITE_NAME, SHIP_TO_PARTY_NAME SHIP_TO_PARTY_NAME, SHIP_TO_PARTY_SITE_NAME SHIP_TO_PARTY_SITE_NAME, SHIP_FROM_PARTY_NAME SHIP_FROM_PARTY_NAME, SHIP_FROM_PARTY_SITE_NAME SHIP_FROM_PARTY_SITE_NAME, ITEM_NAME ITEM_NAME, PUBLISHER_ORDER_TYPE PUBLISHER_ORDER_TYPE, REF_HEADER_ID REF_HEADER_ID, QUANTITY QUANTITY, SHIP_DATE SHIP_DATE, RECEIPT_DATE RECEIPT_DATE, KEY_DATE KEY_DATE, BUCKET_TYPE BUCKET_TYPE, UOM_CODE UOM_CODE, DESIGNATOR DESIGNATOR, VERSION VERSION, COMMENTS COMMENTS, SOURCE_LOCATION_CODE SOURCE_LOCATION_CODE, EXTERNAL_LOCATION_CODE EXTERNAL_LOCATION_CODE from "MSC"."MSC_OUTBOUND_ENTRIES"

View Text - HTML Formatted

SELECT DOCUMENT_NUMBER DOCUMENT_NUMBER
, RESPONSE_NUMBER RESPONSE_NUMBER
, PUBLISHER_NAME PUBLISHER_NAME
, PUBLISHER_SITE_NAME PUBLISHER_SITE_NAME
, CUSTOMER_NAME CUSTOMER_NAME
, CUSTOMER_SITE_NAME CUSTOMER_SITE_NAME
, SUPPLIER_NAME SUPPLIER_NAME
, SUPPLIER_SITE_NAME SUPPLIER_SITE_NAME
, SHIP_TO_PARTY_NAME SHIP_TO_PARTY_NAME
, SHIP_TO_PARTY_SITE_NAME SHIP_TO_PARTY_SITE_NAME
, SHIP_FROM_PARTY_NAME SHIP_FROM_PARTY_NAME
, SHIP_FROM_PARTY_SITE_NAME SHIP_FROM_PARTY_SITE_NAME
, ITEM_NAME ITEM_NAME
, PUBLISHER_ORDER_TYPE PUBLISHER_ORDER_TYPE
, REF_HEADER_ID REF_HEADER_ID
, QUANTITY QUANTITY
, SHIP_DATE SHIP_DATE
, RECEIPT_DATE RECEIPT_DATE
, KEY_DATE KEY_DATE
, BUCKET_TYPE BUCKET_TYPE
, UOM_CODE UOM_CODE
, DESIGNATOR DESIGNATOR
, VERSION VERSION
, COMMENTS COMMENTS
, SOURCE_LOCATION_CODE SOURCE_LOCATION_CODE
, EXTERNAL_LOCATION_CODE EXTERNAL_LOCATION_CODE
FROM "MSC"."MSC_OUTBOUND_ENTRIES"