VIEW: CS.CS_ORDERS_INTERFACE_ALL#

Source

View Text - Preformatted

select ORDER_INTERFACE_ID ORDER_INTERFACE_ID, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, TRANSACTION_CODE TRANSACTION_CODE, LINE_ID LINE_ID, HEADER_ID HEADER_ID, CONCURRENT_PROCESS_ID CONCURRENT_PROCESS_ID, RETURN_CP_ID RETURN_CP_ID, RETURN_QUANTITY RETURN_QUANTITY, CANCEL_CP_ID CANCEL_CP_ID, CANCEL_QUANTITY CANCEL_QUANTITY, SERVICE_ITEM_FLAG SERVICE_ITEM_FLAG, CP_SERVICE_ID CP_SERVICE_ID, CUSTOMER_PRODUCT_ID CUSTOMER_PRODUCT_ID, SHIPPED_QUANTITY SHIPPED_QUANTITY, SHIPPED_DATE SHIPPED_DATE, SHIP_TO_SITE_USE_ID SHIP_TO_SITE_USE_ID, PICKING_HEADER_ID PICKING_HEADER_ID, DELIVERED_FLAG DELIVERED_FLAG, MASS_RENEW_TXN_TEMP_ID MASS_RENEW_TXN_TEMP_ID, ORG_ID ORG_ID, SERIAL_NUMBER SERIAL_NUMBER, LOT_NUMBER LOT_NUMBER, REVISION REVISION, LINE_DETAIL_ID LINE_DETAIL_ID, INCLUDED_ITEM_FLAG INCLUDED_ITEM_FLAG, ERROR_FLAG ERROR_FLAG, SKIP_FLAG SKIP_FLAG, ERROR_SKIP_REASON ERROR_SKIP_REASON from "CS"."CS_ORDERS_INTERFACE_ALL"

View Text - HTML Formatted

SELECT ORDER_INTERFACE_ID ORDER_INTERFACE_ID
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, TRANSACTION_CODE TRANSACTION_CODE
, LINE_ID LINE_ID
, HEADER_ID HEADER_ID
, CONCURRENT_PROCESS_ID CONCURRENT_PROCESS_ID
, RETURN_CP_ID RETURN_CP_ID
, RETURN_QUANTITY RETURN_QUANTITY
, CANCEL_CP_ID CANCEL_CP_ID
, CANCEL_QUANTITY CANCEL_QUANTITY
, SERVICE_ITEM_FLAG SERVICE_ITEM_FLAG
, CP_SERVICE_ID CP_SERVICE_ID
, CUSTOMER_PRODUCT_ID CUSTOMER_PRODUCT_ID
, SHIPPED_QUANTITY SHIPPED_QUANTITY
, SHIPPED_DATE SHIPPED_DATE
, SHIP_TO_SITE_USE_ID SHIP_TO_SITE_USE_ID
, PICKING_HEADER_ID PICKING_HEADER_ID
, DELIVERED_FLAG DELIVERED_FLAG
, MASS_RENEW_TXN_TEMP_ID MASS_RENEW_TXN_TEMP_ID
, ORG_ID ORG_ID
, SERIAL_NUMBER SERIAL_NUMBER
, LOT_NUMBER LOT_NUMBER
, REVISION REVISION
, LINE_DETAIL_ID LINE_DETAIL_ID
, INCLUDED_ITEM_FLAG INCLUDED_ITEM_FLAG
, ERROR_FLAG ERROR_FLAG
, SKIP_FLAG SKIP_FLAG
, ERROR_SKIP_REASON ERROR_SKIP_REASON
FROM "CS"."CS_ORDERS_INTERFACE_ALL"