eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: EC.ECE_TP_HEADERS

Object Details

Object Name:	ECE_TP_HEADERS
Object Type:	TABLE
Owner:	EC
FND Design Data:	EC.ECE_TP_HEADERS
Subobject Name:
Status:	VALID

ECE_TP_HEADERS contains information about trading partner addresses.
You need one row for each unique trading partner address site. Each row
contains the trading partner code, description, and two reference fields
for additional trading partner descriptions.

In addition, each row contains EDI contact information including name,
job title, general address information, email address, telephone number,
and fax number. This information identifies the person to contact at the
trading partner location for EDI issues.

TP_HEADER_ID is the unique system-generated primary key that is
invisible to the user. TP_CODE is the user-defined identifier for the
trading partner. TP_GROUP_ID is a foreign key associated with
ECE_TP_GROUP.

Each ECE_TP_HEADERS row is associated with one row in ECE_TP_GROUP.
There is a one-to-many relationship between ECE_TP_GROUP and
ECE_TP_HEADERS.

TP_HEADER_ID is a foreign key to PO_VENDOR_SITES,
RA_ADDRESSES, AP_BANK_BRANCHES, and HR_LOCATIONS which contain,
respectively, the supplier site, customer site, bank branch, and other
general address entities. The tables in Oracle Applications for
PO_VENDOR_SITE, RA_ADDRESSES, AP_BANK_BRANCHES, and
HR_LOCATIONS each contain a column for the location code stored in
ECE_TP_LOCATION_CODE.

Define trading partners using the Trading Partner form. Define trading partner
contact information in the Contacts tabbed region of that form.

ORG_ID is reserved to support functionality planned for a future
release.

Storage Details

Tablespace:	APPS_TS_SEED
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
ECE_TP_HEADERS_U1	NORMAL	UNIQUE	APPS_TS_SEED	TP_HEADER_ID
ECE_TP_HEADERS_U2	NORMAL	UNIQUE	APPS_TS_SEED	TP_CODE TP_GROUP_ID

Columns

Name	Datatype	Length	Mandatory	Comments
TP_GROUP_ID	NUMBER			Trading Partner Group ID
TP_HEADER_ID	NUMBER		Yes	Trading Partner Header ID
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER		Yes	Standard Who column
CREATION_DATE	DATE		Yes	Standard Who column
CREATED_BY	NUMBER		Yes	Standard Who column
TP_CODE	VARCHAR2	(35)	Yes	Trading Partner Code
ORG_ID	NUMBER			Organization ID
TP_DESCRIPTION	VARCHAR2	(240)		Trading Partner Description
TP_REFERENCE_EXT1	VARCHAR2	(240)		Trading Partner Reference 1 (Ext)
TP_REFERENCE_EXT2	VARCHAR2	(240)		Trading Partner Reference 2 (Ext)
TP_CONTACT_NAME	VARCHAR2	(50)		Trading Partner Contact Name
TP_CONTACT_JOB_TITLE	VARCHAR2	(50)		Trading Partner Contact Job Title
ADDRESS1	VARCHAR2	(240)		Trading Partner Contact Address 1
ADDRESS2	VARCHAR2	(240)		Trading Partner Contact Address 2
ADDRESS3	VARCHAR2	(240)		Trading Partner Contact Address 3
ADDRESS4	VARCHAR2	(240)		Trading Partner Contact Address 4
CITY	VARCHAR2	(60)		Trading Partner Contact City
STATE	VARCHAR2	(60)		Trading Partner Contact State
PROVINCE	VARCHAR2	(60)		Trading Partner Contact Province
COUNTRY	VARCHAR2	(60)		Trading Partner Contact Country
POSTAL_CODE	VARCHAR2	(60)		Trading Partner Contact Postal Code
PHONE	VARCHAR2	(35)		Trading Partner Contact Phone
FAX	VARCHAR2	(35)		Trading Partner Contact Fax
EMAIL	VARCHAR2	(50)		Trading Partner Contact Email
LAST_UPDATE_LOGIN	NUMBER			Standard Who column
ATTRIBUTE_CATEGORY	VARCHAR2	(150)		Descriptive Flexfield
ATTRIBUTE1	VARCHAR2	(150)		Descriptive Flexfield Segment 1
ATTRIBUTE2	VARCHAR2	(150)		Descriptive Flexfield Segment 2
ATTRIBUTE3	VARCHAR2	(150)		Descriptive Flexfield Segment 3
ATTRIBUTE4	VARCHAR2	(150)		Descriptive Flexfield Segment 4
ATTRIBUTE5	VARCHAR2	(150)		Descriptive Flexfield Segment 5
ATTRIBUTE6	VARCHAR2	(150)		Descriptive Flexfield Segment 6
ATTRIBUTE7	VARCHAR2	(150)		Descriptive Flexfield Segment 7
ATTRIBUTE8	VARCHAR2	(150)		Descriptive Flexfield Segment 8
ATTRIBUTE9	VARCHAR2	(150)		Descriptive Flexfield Segment 9
ATTRIBUTE10	VARCHAR2	(150)		Descriptive Flexfield Segment 10
ATTRIBUTE11	VARCHAR2	(150)		Descriptive Flexfield Segment 11
ATTRIBUTE12	VARCHAR2	(150)		Descriptive Flexfield Segment 12
ATTRIBUTE13	VARCHAR2	(150)		Descriptive Flexfield Segment 13
ATTRIBUTE14	VARCHAR2	(150)		Descriptive Flexfield Segment 14
ATTRIBUTE15	VARCHAR2	(150)		Descriptive Flexfield Segment 15
REQUEST_ID	NUMBER			Standard Who column
PROGRAM_APPLICATION_ID	NUMBER			Standard Who column
PROGRAM_ID	NUMBER			Standard Who column
PROGRAM_UPDATE_DATE	DATE			Standard Who column

Query Text

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


SELECT TP_GROUP_ID
,      TP_HEADER_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      TP_CODE
,      ORG_ID
,      TP_DESCRIPTION
,      TP_REFERENCE_EXT1
,      TP_REFERENCE_EXT2
,      TP_CONTACT_NAME
,      TP_CONTACT_JOB_TITLE
,      ADDRESS1
,      ADDRESS2
,      ADDRESS3
,      ADDRESS4
,      CITY
,      STATE
,      PROVINCE
,      COUNTRY
,      POSTAL_CODE
,      PHONE
,      FAX
,      EMAIL
,      LAST_UPDATE_LOGIN
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
FROM EC.ECE_TP_HEADERS;

Dependencies

[top of page]

EC.ECE_TP_HEADERS does not reference any database object

EC.ECE_TP_HEADERS is referenced by following:

APPS: ECE_TP_HEADERS