VIEW: WSH.WSH_ITM_REQUEST_CONTROL#

Source

View Text - Preformatted

select REQUEST_CONTROL_ID REQUEST_CONTROL_ID, REQUEST_SET_ID REQUEST_SET_ID, APPLICATION_ID APPLICATION_ID, MASTER_ORGANIZATION_ID MASTER_ORGANIZATION_ID, ORGANIZATION_ID ORGANIZATION_ID, APPLICATION_USER_ID APPLICATION_USER_ID, SERVICE_TYPE_CODE SERVICE_TYPE_CODE, TRANSACTION_DATE TRANSACTION_DATE, SHIP_FROM_COUNTRY_CODE SHIP_FROM_COUNTRY_CODE, SHIP_TO_COUNTRY_CODE SHIP_TO_COUNTRY_CODE, ORIGINAL_SYSTEM_REFERENCE ORIGINAL_SYSTEM_REFERENCE, ORIGINAL_SYSTEM_LINE_REFERENCE ORIGINAL_SYSTEM_LINE_REFERENCE, PROCESS_FLAG PROCESS_FLAG, RESPONSE_HEADER_ID RESPONSE_HEADER_ID, DEBUG_FLAG DEBUG_FLAG, ONLINE_FLAG ONLINE_FLAG, ATTRIBUTE1_NAME ATTRIBUTE1_NAME, ATTRIBUTE2_NAME ATTRIBUTE2_NAME, ATTRIBUTE3_NAME ATTRIBUTE3_NAME, ATTRIBUTE4_NAME ATTRIBUTE4_NAME, ATTRIBUTE5_NAME ATTRIBUTE5_NAME, ATTRIBUTE6_NAME ATTRIBUTE6_NAME, ATTRIBUTE7_NAME ATTRIBUTE7_NAME, ATTRIBUTE8_NAME ATTRIBUTE8_NAME, ATTRIBUTE9_NAME ATTRIBUTE9_NAME, ATTRIBUTE10_NAME ATTRIBUTE10_NAME, ATTRIBUTE11_NAME ATTRIBUTE11_NAME, ATTRIBUTE12_NAME ATTRIBUTE12_NAME, ATTRIBUTE13_NAME ATTRIBUTE13_NAME, ATTRIBUTE14_NAME ATTRIBUTE14_NAME, ATTRIBUTE15_NAME ATTRIBUTE15_NAME, ATTRIBUTE1_VALUE ATTRIBUTE1_VALUE, ATTRIBUTE2_VALUE ATTRIBUTE2_VALUE, ATTRIBUTE3_VALUE ATTRIBUTE3_VALUE, ATTRIBUTE4_VALUE ATTRIBUTE4_VALUE, ATTRIBUTE5_VALUE ATTRIBUTE5_VALUE, ATTRIBUTE6_VALUE ATTRIBUTE6_VALUE, ATTRIBUTE7_VALUE ATTRIBUTE7_VALUE, ATTRIBUTE8_VALUE ATTRIBUTE8_VALUE, ATTRIBUTE9_VALUE ATTRIBUTE9_VALUE, ATTRIBUTE10_VALUE ATTRIBUTE10_VALUE, ATTRIBUTE11_VALUE ATTRIBUTE11_VALUE, ATTRIBUTE12_VALUE ATTRIBUTE12_VALUE, ATTRIBUTE13_VALUE ATTRIBUTE13_VALUE, ATTRIBUTE14_VALUE ATTRIBUTE14_VALUE, ATTRIBUTE15_VALUE ATTRIBUTE15_VALUE, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, LANGUAGE_CODE LANGUAGE_CODE, TRIGGERING_POINT TRIGGERING_POINT, ORDER_NUMBER ORDER_NUMBER, ORDER_TYPE ORDER_TYPE, OPERATING_UNIT OPERATING_UNIT, CUST_PO_NUM CUST_PO_NUM, TRANSACTIONAL_CURR_CODE TRANSACTIONAL_CURR_CODE, CONVERSION_TYPE_CODE CONVERSION_TYPE_CODE, CONVERSION_RATE CONVERSION_RATE, ORDERED_DATE ORDERED_DATE, SHIPPING_METHOD_CODE SHIPPING_METHOD_CODE, REQUEST_DATE REQUEST_DATE, FREIGHT_TERMS_CODE FREIGHT_TERMS_CODE, PAYMENT_NAME PAYMENT_NAME, PAYMENT_TERM_ID PAYMENT_TERM_ID, ORDERED_QUANTITY ORDERED_QUANTITY, LINE_NUMBER LINE_NUMBER, UNIT_LIST_PRICE UNIT_LIST_PRICE, UNIT_SELLING_PRICE UNIT_SELLING_PRICE, ORGANIZATION_CODE ORGANIZATION_CODE, ORDERED_QUANTITY_UOM ORDERED_QUANTITY_UOM, ORDER_LINE_NUMBER ORDER_LINE_NUMBER, TOP_MODEL_LINE_ID TOP_MODEL_LINE_ID, SPLIT_FROM_LINE_ID SPLIT_FROM_LINE_ID, LINK_TO_LINE_ID LINK_TO_LINE_ID, ATO_LINE_ID ATO_LINE_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 from "WSH"."WSH_ITM_REQUEST_CONTROL"

View Text - HTML Formatted

SELECT REQUEST_CONTROL_ID REQUEST_CONTROL_ID
, REQUEST_SET_ID REQUEST_SET_ID
, APPLICATION_ID APPLICATION_ID
, MASTER_ORGANIZATION_ID MASTER_ORGANIZATION_ID
, ORGANIZATION_ID ORGANIZATION_ID
, APPLICATION_USER_ID APPLICATION_USER_ID
, SERVICE_TYPE_CODE SERVICE_TYPE_CODE
, TRANSACTION_DATE TRANSACTION_DATE
, SHIP_FROM_COUNTRY_CODE SHIP_FROM_COUNTRY_CODE
, SHIP_TO_COUNTRY_CODE SHIP_TO_COUNTRY_CODE
, ORIGINAL_SYSTEM_REFERENCE ORIGINAL_SYSTEM_REFERENCE
, ORIGINAL_SYSTEM_LINE_REFERENCE ORIGINAL_SYSTEM_LINE_REFERENCE
, PROCESS_FLAG PROCESS_FLAG
, RESPONSE_HEADER_ID RESPONSE_HEADER_ID
, DEBUG_FLAG DEBUG_FLAG
, ONLINE_FLAG ONLINE_FLAG
, ATTRIBUTE1_NAME ATTRIBUTE1_NAME
, ATTRIBUTE2_NAME ATTRIBUTE2_NAME
, ATTRIBUTE3_NAME ATTRIBUTE3_NAME
, ATTRIBUTE4_NAME ATTRIBUTE4_NAME
, ATTRIBUTE5_NAME ATTRIBUTE5_NAME
, ATTRIBUTE6_NAME ATTRIBUTE6_NAME
, ATTRIBUTE7_NAME ATTRIBUTE7_NAME
, ATTRIBUTE8_NAME ATTRIBUTE8_NAME
, ATTRIBUTE9_NAME ATTRIBUTE9_NAME
, ATTRIBUTE10_NAME ATTRIBUTE10_NAME
, ATTRIBUTE11_NAME ATTRIBUTE11_NAME
, ATTRIBUTE12_NAME ATTRIBUTE12_NAME
, ATTRIBUTE13_NAME ATTRIBUTE13_NAME
, ATTRIBUTE14_NAME ATTRIBUTE14_NAME
, ATTRIBUTE15_NAME ATTRIBUTE15_NAME
, ATTRIBUTE1_VALUE ATTRIBUTE1_VALUE
, ATTRIBUTE2_VALUE ATTRIBUTE2_VALUE
, ATTRIBUTE3_VALUE ATTRIBUTE3_VALUE
, ATTRIBUTE4_VALUE ATTRIBUTE4_VALUE
, ATTRIBUTE5_VALUE ATTRIBUTE5_VALUE
, ATTRIBUTE6_VALUE ATTRIBUTE6_VALUE
, ATTRIBUTE7_VALUE ATTRIBUTE7_VALUE
, ATTRIBUTE8_VALUE ATTRIBUTE8_VALUE
, ATTRIBUTE9_VALUE ATTRIBUTE9_VALUE
, ATTRIBUTE10_VALUE ATTRIBUTE10_VALUE
, ATTRIBUTE11_VALUE ATTRIBUTE11_VALUE
, ATTRIBUTE12_VALUE ATTRIBUTE12_VALUE
, ATTRIBUTE13_VALUE ATTRIBUTE13_VALUE
, ATTRIBUTE14_VALUE ATTRIBUTE14_VALUE
, ATTRIBUTE15_VALUE ATTRIBUTE15_VALUE
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, LANGUAGE_CODE LANGUAGE_CODE
, TRIGGERING_POINT TRIGGERING_POINT
, ORDER_NUMBER ORDER_NUMBER
, ORDER_TYPE ORDER_TYPE
, OPERATING_UNIT OPERATING_UNIT
, CUST_PO_NUM CUST_PO_NUM
, TRANSACTIONAL_CURR_CODE TRANSACTIONAL_CURR_CODE
, CONVERSION_TYPE_CODE CONVERSION_TYPE_CODE
, CONVERSION_RATE CONVERSION_RATE
, ORDERED_DATE ORDERED_DATE
, SHIPPING_METHOD_CODE SHIPPING_METHOD_CODE
, REQUEST_DATE REQUEST_DATE
, FREIGHT_TERMS_CODE FREIGHT_TERMS_CODE
, PAYMENT_NAME PAYMENT_NAME
, PAYMENT_TERM_ID PAYMENT_TERM_ID
, ORDERED_QUANTITY ORDERED_QUANTITY
, LINE_NUMBER LINE_NUMBER
, UNIT_LIST_PRICE UNIT_LIST_PRICE
, UNIT_SELLING_PRICE UNIT_SELLING_PRICE
, ORGANIZATION_CODE ORGANIZATION_CODE
, ORDERED_QUANTITY_UOM ORDERED_QUANTITY_UOM
, ORDER_LINE_NUMBER ORDER_LINE_NUMBER
, TOP_MODEL_LINE_ID TOP_MODEL_LINE_ID
, SPLIT_FROM_LINE_ID SPLIT_FROM_LINE_ID
, LINK_TO_LINE_ID LINK_TO_LINE_ID
, ATO_LINE_ID ATO_LINE_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
FROM "WSH"."WSH_ITM_REQUEST_CONTROL"