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.GML_INVALID_CUSTOMERS

Object Details

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

Table contains customer records that failed to synch from Oracle Receivables to OPM.

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
GML_INVALID_CUSTOMERS_N1	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	OF_SITE_USE_ID OF_SITE_USE_CODE CO_CODE

Columns

Name	Datatype	Length	Comments
CUST_NO	VARCHAR2	(32)	Customer number of failed customer
CO_CODE	VARCHAR2	(4)	OPM Company Code
OF_CUST_ID	NUMBER	(15)	Reference to Oracle Receivable's customer id.
OF_SITE_USE_ID	NUMBER	(15)	Reference to Oracle Receivable's site use id.
OF_SITE_USE_CODE	VARCHAR2	(30)	Reference to Oracle Receivable's site use code

Query Text

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


SELECT CUST_NO
,      CO_CODE
,      OF_CUST_ID
,      OF_SITE_USE_ID
,      OF_SITE_USE_CODE
FROM GML.GML_INVALID_CUSTOMERS;

Dependencies

[top of page]

GML.GML_INVALID_CUSTOMERS does not reference any database object

GML.GML_INVALID_CUSTOMERS is referenced by following:

APPS: GML_INVALID_CUSTOMERS