[Home] [Help] [Dependency Information]

TABLE: WSH.WSH_ITM_REQUEST_CONTROL

Object Details

Object Name:	WSH_ITM_REQUEST_CONTROL
Object Type:	TABLE
Owner:	WSH
FND Design Data:	WSH.WSH_ITM_REQUEST_CONTROL
Subobject Name:
Status:	VALID

This table acts as the Request Interface table. For submitting a request the Integrating Application has to populate the Request Interface tables. Every rorw in this table constitutes a new request. The Inregrating application can use the Transaction_control_id to check the status of the request. The status of the request is indicated by the process_flag. Process_flag: 0 - Unprocessed; 1 - processed with success; 2 - processed with errors; 3 - Overriden by the integrating Application (internal flag codes: -1 Picked up by the poller, -2 picked up by the poller and tasks added to the queue, 4- History Record).
If a request is processed, the response header_id in this table points to the appropriate row in table WSH_ITM_RESPONSE_HEADERS which contains the response for the submitted request.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
WSHITM_REQUEST_CONTROL_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	REQUEST_CONTROL_ID
WSHITM_REQUEST_CONTROL_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PROCESS_FLAG ONLINE_FLAG
WSHITM_REQUEST_CONTROL_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	APPLICATION_ID ORIGINAL_SYSTEM_REFERENCE ORIGINAL_SYSTEM_LINE_REFERENCE
WSHITM_REQUEST_CONTROL_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	REQUEST_SET_ID

Columns

Query Text

Cut, paste (and edit) the following text to query this object:

SELECT REQUEST_CONTROL_ID
,      REQUEST_SET_ID
,      APPLICATION_ID
,      MASTER_ORGANIZATION_ID
,      ORGANIZATION_ID
,      APPLICATION_USER_ID
,      SERVICE_TYPE_CODE
,      TRANSACTION_DATE
,      SHIP_FROM_COUNTRY_CODE
,      SHIP_TO_COUNTRY_CODE
,      ORIGINAL_SYSTEM_REFERENCE
,      ORIGINAL_SYSTEM_LINE_REFERENCE
,      PROCESS_FLAG
,      RESPONSE_HEADER_ID
,      DEBUG_FLAG
,      ONLINE_FLAG
,      ATTRIBUTE1_NAME
,      ATTRIBUTE2_NAME
,      ATTRIBUTE3_NAME
,      ATTRIBUTE4_NAME
,      ATTRIBUTE5_NAME
,      ATTRIBUTE6_NAME
,      ATTRIBUTE7_NAME
,      ATTRIBUTE8_NAME
,      ATTRIBUTE9_NAME
,      ATTRIBUTE10_NAME
,      ATTRIBUTE11_NAME
,      ATTRIBUTE12_NAME
,      ATTRIBUTE13_NAME
,      ATTRIBUTE14_NAME
,      ATTRIBUTE15_NAME
,      ATTRIBUTE1_VALUE
,      ATTRIBUTE2_VALUE
,      ATTRIBUTE3_VALUE
,      ATTRIBUTE4_VALUE
,      ATTRIBUTE5_VALUE
,      ATTRIBUTE6_VALUE
,      ATTRIBUTE7_VALUE
,      ATTRIBUTE8_VALUE
,      ATTRIBUTE9_VALUE
,      ATTRIBUTE10_VALUE
,      ATTRIBUTE11_VALUE
,      ATTRIBUTE12_VALUE
,      ATTRIBUTE13_VALUE
,      ATTRIBUTE14_VALUE
,      ATTRIBUTE15_VALUE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      LANGUAGE_CODE
,      TRIGGERING_POINT
,      ORDER_NUMBER
,      ORDER_TYPE
,      OPERATING_UNIT
,      CUST_PO_NUM
,      TRANSACTIONAL_CURR_CODE
,      CONVERSION_TYPE_CODE
,      CONVERSION_RATE
,      ORDERED_DATE
,      SHIPPING_METHOD_CODE
,      REQUEST_DATE
,      FREIGHT_TERMS_CODE
,      PAYMENT_NAME
,      PAYMENT_TERM_ID
,      ORDERED_QUANTITY
,      LINE_NUMBER
,      UNIT_LIST_PRICE
,      UNIT_SELLING_PRICE
,      ORGANIZATION_CODE
,      ORDERED_QUANTITY_UOM
,      ORDER_LINE_NUMBER
,      TOP_MODEL_LINE_ID
,      SPLIT_FROM_LINE_ID
,      LINK_TO_LINE_ID
,      ATO_LINE_ID
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
FROM WSH.WSH_ITM_REQUEST_CONTROL;

Dependencies

[top of page]

WSH.WSH_ITM_REQUEST_CONTROL does not reference any database object

WSH.WSH_ITM_REQUEST_CONTROL is referenced by following:

APPS

WSH_ITM_REQUEST_CONTROL