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

TABLE: ECX.ECX_TP_DETAILS

Object Details
Object Name: ECX_TP_DETAILS
Object Type: TABLE
Owner: ECX
FND Design Data: TableECX.ECX_TP_DETAILS
Subobject Name:
Status: VALID


This table contains the trading partner detail information


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
ECX_TP_DETAILS_U2 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnTP_DETAIL_ID
ECX_TP_DETAILS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnEXT_PROCESS_ID
ColumnSOURCE_TP_LOCATION_CODE
ECX_TP_DETAILS_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnTP_HEADER_ID
ColumnEXT_PROCESS_ID
Columns
Name Datatype Length Mandatory Comments
TP_HEADER_ID NUMBER
Yes Trading partner Header Identifier
TP_DETAIL_ID NUMBER
Yes Trading partner Detail Identifier
MAP_ID NUMBER
Yes Map Identifier
EXT_PROCESS_ID NUMBER
Yes External transaction Identifier
CONNECTION_TYPE VARCHAR2 (30)
Connection Type
HUB_USER_ID NUMBER

Hub User Identifier
PROTOCOL_TYPE VARCHAR2 (30)
Protocol Type
PROTOCOL_ADDRESS VARCHAR2 (512)
Protocol Address
USERNAME VARCHAR2 (512)
Username
PASSWORD VARCHAR2 (500)
Password
ROUTING_ID NUMBER

Routing id for passthrough transaction
SOURCE_TP_LOCATION_CODE VARCHAR2 (200)
Source trading partner Location Code
EXTERNAL_TP_LOCATION_CODE VARCHAR2 (200)
Target trading partner Location Code
OMB_SYNC VARCHAR2 (1)
No longer Used
CONFIRMATION NUMBER (2)
Confirmation Indicator
CREATED_BY NUMBER
Yes Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATED_BY NUMBER
Yes Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Yes Standard who column - date when this row was created.
LAST_UPDATE_DATE DATE
Yes Standard Who column - date when a user last updated this row.
LAST_UPDATE_LOGIN NUMBER

Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
HUB_ID NUMBER

Hub ID
Query Text

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


SELECT TP_HEADER_ID
,      TP_DETAIL_ID
,      MAP_ID
,      EXT_PROCESS_ID
,      CONNECTION_TYPE
,      HUB_USER_ID
,      PROTOCOL_TYPE
,      PROTOCOL_ADDRESS
,      USERNAME
,      PASSWORD
,      ROUTING_ID
,      SOURCE_TP_LOCATION_CODE
,      EXTERNAL_TP_LOCATION_CODE
,      OMB_SYNC
,      CONFIRMATION
,      CREATED_BY
,      LAST_UPDATED_BY
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      HUB_ID
FROM ECX.ECX_TP_DETAILS;

Dependencies

[top of page]

ECX.ECX_TP_DETAILS does not reference any database object

ECX.ECX_TP_DETAILS is referenced by following:

SchemaECX
ViewECX_TP_DETAILS#