DBA Data[Home] [Help] [Dependency Information]

TABLE: WSH.WSH_CC_TRANS_CONTROL

Object Details
Object Name: WSH_CC_TRANS_CONTROL
Object Type: TABLE
Owner: WSH
FND Design Data: TableWSH.WSH_CC_TRANS_CONTROL
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
WSH_CC_TRANS_CONTROL_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPROCESS_FLAG
WSH_CC_TRANS_CONTROL_T1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnUPGRADED_FLAG
Columns
Name Datatype Length Mandatory Comments
TRANSACTION_CONTROL_ID NUMBER
Yes Primary key of the table
ORG_ID NUMBER

ORG_ID of the source
MASTER_ORGANIZATION_ID NUMBER

Master Organization identifier of the Calling User
ORGANIZATION_ID NUMBER

Organization identifier
APPLICATION_USER_ID NUMBER

Application User Identifier
REQUEST_TYPE_CODE VARCHAR2 (35) Yes Request Type Code - references WSH_CC_REQUEST_SETUPS.REQUEST_TYPE_CODE
REQUEST_VERSION VARCHAR2 (35)
Request Version -references WSH_CC_REQUEST_SETUPS.REQUEST_VERSION
INCLUDE_REQUEST VARCHAR2 (35)
Indicates if the request needs to be included in the response
QUERY_ID NUMBER

For future Use
COMMENTS VARCHAR2 (2000)
Descriptive Comments
SERVICE_TYPE_CODE VARCHAR2 (35) Yes Service Type code - references WSH_CC_SERVICE_SETUPS.SERVICE_TYPE_CODE
SERVICE_VERSION VARCHAR2 (35)
Service Version - Indicates Service Version
SERVICE_THRESHOLD NUMBER

Indicates Service Threshold
COUNTRY_MATCHFLAG VARCHAR2 (35)
Indicates if the Country matching is required
RED_FLAG VARCHAR2 (35)
Indicates if Red Flag check is required
ORIGINAL_SYSTEM_REFERENCE NUMBER

Reference Number eg Order header id for OM
ORIGINAL_SYSTEM_LINE_REFERENCE NUMBER

Reference Line Number eg Order Line id for OM
ERROR_CODE VARCHAR2 (10)
Error Code
ERROR_MESSAGE VARCHAR2 (240)
Error Message
PROCESS_FLAG NUMBER

Process Flag eg 0-Unprocessed, 1-processed with success, 2-processed with errors
CALLING_APPLICATION_ID NUMBER

Calling Application identifier
DEBUG_FLAG VARCHAR2 (1)
Debug Flag to enable the Log Messages
ONLINE_FLAG VARCHAR2 (1)
Indicates if the request is to be processed online.
WF_ITEM_TYPE VARCHAR2 (30)
Workflow Item Type
WF_ACTIVITY VARCHAR2 (240)
Workflow Activity
RESPONSE_HEADER_ID NUMBER

Foreign key references WSH_CC_RESPONSE_HEADERS.RESPONSE_HEADER_ID
CREATION_DATE DATE

Standard Who Columns
CREATED_BY NUMBER

Standard Who Columns
LAST_UPDATED_BY NUMBER

Standard Who Columns
LAST_UPDATE_DATE DATE

Standard Who Columns
LAST_UPDATE_LOGIN NUMBER

Standard Who Columns
UPGRADED_FLAG VARCHAR2 (1)
Query Text

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


SELECT TRANSACTION_CONTROL_ID
,      ORG_ID
,      MASTER_ORGANIZATION_ID
,      ORGANIZATION_ID
,      APPLICATION_USER_ID
,      REQUEST_TYPE_CODE
,      REQUEST_VERSION
,      INCLUDE_REQUEST
,      QUERY_ID
,      COMMENTS
,      SERVICE_TYPE_CODE
,      SERVICE_VERSION
,      SERVICE_THRESHOLD
,      COUNTRY_MATCHFLAG
,      RED_FLAG
,      ORIGINAL_SYSTEM_REFERENCE
,      ORIGINAL_SYSTEM_LINE_REFERENCE
,      ERROR_CODE
,      ERROR_MESSAGE
,      PROCESS_FLAG
,      CALLING_APPLICATION_ID
,      DEBUG_FLAG
,      ONLINE_FLAG
,      WF_ITEM_TYPE
,      WF_ACTIVITY
,      RESPONSE_HEADER_ID
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      UPGRADED_FLAG
FROM WSH.WSH_CC_TRANS_CONTROL;

Dependencies

[top of page]

WSH.WSH_CC_TRANS_CONTROL does not reference any database object

WSH.WSH_CC_TRANS_CONTROL is referenced by following:

SchemaWSH
ViewWSH_CC_TRANS_CONTROL#