[Home] [Help] [Dependency Information]
Object Name: | ECX_TP_DETAILS# |
---|---|
Object Type: | VIEW |
Owner: | ECX |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TP_HEADER_ID | NUMBER | Yes | ||
TP_DETAIL_ID | NUMBER | Yes | ||
MAP_ID | NUMBER | Yes | ||
EXT_PROCESS_ID | NUMBER | Yes | ||
CONNECTION_TYPE | VARCHAR2 | (30) | ||
HUB_USER_ID | NUMBER | |||
PROTOCOL_TYPE | VARCHAR2 | (30) | ||
PROTOCOL_ADDRESS | VARCHAR2 | (512) | ||
USERNAME | VARCHAR2 | (512) | ||
PASSWORD | VARCHAR2 | (500) | ||
ROUTING_ID | NUMBER | |||
SOURCE_TP_LOCATION_CODE | VARCHAR2 | (200) | ||
EXTERNAL_TP_LOCATION_CODE | VARCHAR2 | (200) | ||
OMB_SYNC | VARCHAR2 | (1) | ||
CONFIRMATION | NUMBER | (2) | ||
CREATED_BY | NUMBER | Yes | ||
LAST_UPDATED_BY | NUMBER | Yes | ||
CREATION_DATE | DATE | Yes | ||
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATE_LOGIN | NUMBER | |||
HUB_ID | NUMBER |
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#;
|
|
|