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

TABLE: WSH.WSH_CC_RESPONSE_HEADERS

Object Details
Object Name: WSH_CC_RESPONSE_HEADERS
Object Type: TABLE
Owner: WSH
FND Design Data: TableWSH.WSH_CC_RESPONSE_HEADERS
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_RESPONSE_HEADERS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnORIGINAL_SYSTEM_REFERENCE
ColumnREQUEST_TYPE_CODE
ColumnSERVICE_TYPE_CODE
ColumnREQUEST_DATE
Columns
Name Datatype Length Mandatory Comments
RESPONSE_HEADER_ID NUMBER
Yes Primary Key for the Table
ORIGINAL_SYSTEM_REFERENCE NUMBER

Reference number for the Orde_Header_id(OM), and load_id(Transportation Exchange)
MASTER_ORGANIZATION_ID NUMBER

For Exchange this field contains Operator_id
ORGANIZATION_ID NUMBER

Organization Identifier
REQUEST_TYPE_CODE VARCHAR2 (240)
Request Type Code - references WSH_CC_REQUEST_SETUPS.REQUEST_TYPE_CODE
REQUEST_VERSION VARCHAR2 (240)
Request Version - references WSH_CC_REQUEST_SETUPS.REQUEST_TYPE_VERSION
SERVICE_TYPE_CODE VARCHAR2 (240)
Service Type Code - references WSH_CC_SERVICE_SETUPS.SERVICE_TYPE_CODE
SERVICE_VERSION VARCHAR2 (10)
Service Version - references WSH_CC_SERVICE_SETUPS.SERVICE_VERSION
CALLING_APPLICATION_ID NUMBER

Calling Application Identifier
APPLICATIONS_USER_ID NUMBER

Application User identifier references WSH_CC_USER_SETUPS.APPLICATION_USER_ID
FTE_CC_API_SETUP_ID NUMBER

Not in Use Currently
REQUEST_DATE DATE

Date of the Request
RESPONSE_DATE DATE

Date of the Response
SUBSCRIBER_ID VARCHAR2 (35)
Subscriber Identifier provided by Clear cross
OUTPUT_FORMAT VARCHAR2 (1)
Request Output Format references - WSH_CC_REQUEST_SETUPS.REQUEST_OUTPUT_TYPE
INCLUDE_REQUEST VARCHAR2 (1)
Currently Not in Use
QUERY_ID NUMBER

Identifier returned along with the response. Actual Source depends on the Request.
COMMENTS VARCHAR2 (240)
Descriptive Comments
SERVICE_THRESHOLD VARCHAR2 (240)
Factor governing the sensitivity of the ECE Adapter
COUNTRY_MATCH_FLAG VARCHAR2 (1)
Indicates if the ECE Adapter requires country match for Denied Party Check.
RED_FLAG VARCHAR2 (1)
Indicates if the ECE Adapter will run the Red Flag Check on all parties in the request
ERROR_CODE VARCHAR2 (35)
Error Code
ERROR_TEXT VARCHAR2 (2000)
Error text
TRANSACTION_CONTROL_ID NUMBER
Yes Foreign key to WSH_CC_TRANS_CONTROL.TRANSACTION_CONTROL_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
ORIGINAL_SYSTEM_LINE_REFERENCE NUMBER

Reference Line Number eg line_id for OM
Query Text

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


SELECT RESPONSE_HEADER_ID
,      ORIGINAL_SYSTEM_REFERENCE
,      MASTER_ORGANIZATION_ID
,      ORGANIZATION_ID
,      REQUEST_TYPE_CODE
,      REQUEST_VERSION
,      SERVICE_TYPE_CODE
,      SERVICE_VERSION
,      CALLING_APPLICATION_ID
,      APPLICATIONS_USER_ID
,      FTE_CC_API_SETUP_ID
,      REQUEST_DATE
,      RESPONSE_DATE
,      SUBSCRIBER_ID
,      OUTPUT_FORMAT
,      INCLUDE_REQUEST
,      QUERY_ID
,      COMMENTS
,      SERVICE_THRESHOLD
,      COUNTRY_MATCH_FLAG
,      RED_FLAG
,      ERROR_CODE
,      ERROR_TEXT
,      TRANSACTION_CONTROL_ID
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      ORIGINAL_SYSTEM_LINE_REFERENCE
FROM WSH.WSH_CC_RESPONSE_HEADERS;

Dependencies

[top of page]

WSH.WSH_CC_RESPONSE_HEADERS does not reference any database object

WSH.WSH_CC_RESPONSE_HEADERS is referenced by following:

SchemaWSH
ViewWSH_CC_RESPONSE_HEADERS#