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_ASC

Object Details

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

Customer relationships are defined in this table. There are three types of relationships that can be defined: Bill-To/Ship-To, Corporate and Sold-To/Ship-To. The CUST_ID is either the Bill-To, Corporate or Sold-To customer. The ASSOCCUST_ID is either the Ship-To customer (for Bill-To and Sold-To relationships) or any type of customer for the Corporate relationship. The ASSOC_TYPE is 1 for Bill-To/Ship-To Relationship, 2 for Sold-To/Ship-To and 10 for Corporate.
Records may be created and updated in this table in OPM, but some are created when customer information is transferred from Oracle Receivables. See the description under the OPM table OP_CUST_MST_INT.

Storage Details

Tablespace:	APPS_TS_SEED
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
OP_CUST_ASCI1	NORMAL	NONUNIQUE	APPS_TS_SEED	ASSOCCUST_ID CUST_ID

Columns

Name	Datatype	Length	Mandatory	Comments
CUST_ID	NUMBER	(15)	Yes	Parent customer of the association. Can be either the bill-to customer, sold-to customer or a parent organization to which another customer belongs. Fk to op_cust_mst.
ASSOC_TYPE	NUMBER	(5)	Yes	Type of association among customers. Valid values are: 1 = bill-to and ship-to association, 2 = sold-to and ship-to association, or 10 = corporate association
ASSOCCUST_ID	NUMBER	(15)	Yes	The customer id of the associated customer, either the ship-to customer (related to the bill-to) or the subsidiary organization (related to a parent organization). Fk to op_cust_mst.
CREATION_DATE	DATE		Yes	Standard who column
LAST_UPDATE_DATE	DATE		Yes	Standard who column
CREATED_BY	NUMBER	(15)	Yes	Standard who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column
DELETE_MARK	NUMBER	(5)	Yes	Standard: 0=Active record (default); 1=Marked for (logical) deletion.
TRANS_CNT	NUMBER	(10)		Not currently used
TEXT_CODE	NUMBER	(10)		ID which joins any rows of text in this table to the Text Table for this Module
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
OPM_CUST_ID	NUMBER	(10)		Used by OM users only. Stores customer id to op_cust_mst (OPM customer table) for historical purposes.
OPM_ASSOCCUST_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 CUST_ID
,      ASSOC_TYPE
,      ASSOCCUST_ID
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      CREATED_BY
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      DELETE_MARK
,      TRANS_CNT
,      TEXT_CODE
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      REQUEST_ID
,      OPM_CUST_ID
,      OPM_ASSOCCUST_ID
FROM GML.OP_CUST_ASC;

Dependencies

[top of page]

GML.OP_CUST_ASC does not reference any database object

GML.OP_CUST_ASC is referenced by following:

APPS: OP_CUST_ASC