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: GML.OP_CUST_CON

Object Details

Object Name:	OP_CUST_CON
Object Type:	TABLE
Owner:	GML
FND Design Data:	GML.OP_CUST_CON
Subobject Name:
Status:	VALID

This table contains customer contact information. A customer may have any number of contacts. This information is entered in Oracle Receivables in Customer Maintenance and then a separate data synchronization program creates records in this table. The ACCEPT_ORDR_IND in this table may be updated in OPM, since this column only exists in OPM and does not have a corresponding column in Oracle Receivables.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
OP_CUST_CON_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	CONTACT_ID
OP_CUST_CON_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CUST_ID

Columns

Name	Datatype	Length	Mandatory	Comments
CONTACT_ID	NUMBER	(10)	Yes	Surrogate key to uniquely identify each contact record.
CONTACT_TYPE	VARCHAR2	(8)		User-defined, unvalidated field to allow identification of contact, i.e., ap, purchasing, exec, etc.
CONTACT_PHONE	VARCHAR2	(20)		Phone number of contact
CONTACT_FAX	VARCHAR2	(20)		Fax number of contact
EMAIL_ADDRESS	VARCHAR2	(70)		Email address/string for contact.
ADDR_ID	NUMBER	(10)		Pointer to sy_addr_mst to store address of contact, if different from customer master address.
ACCEPT_ORDR_IND	NUMBER	(5)	Yes	Indicates if orders can be accepted by this contact. This flag will be used to validate the contact name entered on a sales order. Value of 1 means that orders can be accepted from this contact; value of 0 means that order can not be acce
CONTACT_NAME	VARCHAR2	(50)	Yes	Name of contact.
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column
CREATED_BY	NUMBER	(15)	Yes	Standard who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column
CREATION_DATE	DATE		Yes	Standard who column
LAST_UPDATE_DATE	DATE		Yes	Standard who column
TRANS_CNT	NUMBER	(10)		Not currently used
DELETE_MARK	NUMBER	(5)	Yes	0 means active; 1 means "deleted".
CUST_ID	NUMBER	(15)	Yes	Surrogate key for customer master record.
TEXT_CODE	NUMBER	(10)		ID which joins any rows of text in this table to the Text Table for this Module
OF_CONTACT_ID	NUMBER			Contact from an Oracle AR customer
PROGRAM_APPLICATION_ID	NUMBER	(15)		Concurrent who column
PROGRAM_ID	NUMBER	(15)		Concurrent who column
PROGRAM_UPDATE_DATE	DATE			Concurrent who column
REQUEST_ID	NUMBER	(15)		Concurrent who column
ATTRIBUTE1	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE2	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE3	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE4	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE5	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE6	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE7	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE8	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE9	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE10	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE11	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE12	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE13	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE14	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE15	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE16	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE17	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE18	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE19	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE20	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE21	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE22	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE23	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE24	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE25	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE26	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE27	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE28	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE29	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE30	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive flexfield segment
OPM_CUST_ID	NUMBER	(10)		Used by OM users only. Stores customer id to op_cust_mst (OPM customer table) for historical purposes.

Query Text

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


SELECT CONTACT_ID
,      CONTACT_TYPE
,      CONTACT_PHONE
,      CONTACT_FAX
,      EMAIL_ADDRESS
,      ADDR_ID
,      ACCEPT_ORDR_IND
,      CONTACT_NAME
,      LAST_UPDATED_BY
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      TRANS_CNT
,      DELETE_MARK
,      CUST_ID
,      TEXT_CODE
,      OF_CONTACT_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      REQUEST_ID
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      ATTRIBUTE21
,      ATTRIBUTE22
,      ATTRIBUTE23
,      ATTRIBUTE24
,      ATTRIBUTE25
,      ATTRIBUTE26
,      ATTRIBUTE27
,      ATTRIBUTE28
,      ATTRIBUTE29
,      ATTRIBUTE30
,      ATTRIBUTE_CATEGORY
,      OPM_CUST_ID
FROM GML.OP_CUST_CON;

Dependencies

[top of page]

GML.OP_CUST_CON does not reference any database object

GML.OP_CUST_CON is referenced by following:

APPS: OP_CUST_CON