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_GNRC_ITM

Object Details

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

This table maintains alternate names for items. These alternate names are used only in OPM Order Fulfillment. An alternate name may be a generic name, used by many customers in a specific industry. In this case, the alternate (generic) name is cross-referenced to an OPM item, and the CUST_ID on the record is null. An alternate name may be customer-specific and in that case, the CUST_ID for the customer item will not be null and will equal the id for the customer to whom the alternate name belongs. Generic/customer names may be entered instead of item numbers on an order and the OPM item number is then referenced.

Storage Details

Tablespace:	APPS_TS_SEED
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
OP_GNRC_ITMI1	NORMAL	UNIQUE	APPS_TS_SEED	GENERIC_ITEM CUST_ID VENDOR_ID ITEM_ID
OP_GNRC_ITM_PK	NORMAL	UNIQUE	APPS_TS_SEED	GENERIC_ID

Columns

Name	Datatype	Length	Mandatory	Comments
GENERIC_ID	NUMBER	(10)	Yes	Surrogate key to table
GENERIC_ITEM	VARCHAR2	(32)	Yes	The generic or customer item number. This is the number that the customer uses or is generally used throughout the industry (generic item). This number can be entered in order entry in place of an item number.
GENERIC_DESC	VARCHAR2	(70)	Yes	Description associated with the generic/customer item.
USE_ONORDER	NUMBER	(5)	Yes	Indicates if the generic_desc should be used in place of the item description. Value of 0 means that even if the generic/customer/vendor item is entered, the description from ic_item_mst defaults as the item description. A value of 1 mea
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
TRANS_CNT	NUMBER	(10)		Not currently used
DELETE_MARK	NUMBER	(5)	Yes	Standard: 0=Active record (default); 1=Marked for (logical) deletion.
TEXT_CODE	NUMBER	(10)		ID which joins any rows of text in this table to the Text Table for this Module
CUST_ID	NUMBER	(15)		Customer who uses this item reference. If cust_id is NULL then the generic item is generic. If cust_id is not null, then the generic item is a customer item. Fk to op_cust_ms
VENDOR_ID	NUMBER	(10)		Column used in previous versions of software; not currently supported.
ITEM_ID	NUMBER	(10)	Yes	Item that this generic or customer item references. Fk to ic_item_mst.
OPM_CUST_ID	NUMBER	(10)		Used by OM users only. Stores customer id to op_cust_mst (OPM customer table) for historical purposes.
CO_CODE	VARCHAR2	(4)		Company Code

Query Text

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


SELECT GENERIC_ID
,      GENERIC_ITEM
,      GENERIC_DESC
,      USE_ONORDER
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      CREATED_BY
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      TRANS_CNT
,      DELETE_MARK
,      TEXT_CODE
,      CUST_ID
,      VENDOR_ID
,      ITEM_ID
,      OPM_CUST_ID
,      CO_CODE
FROM GML.OP_GNRC_ITM;

Dependencies

[top of page]

GML.OP_GNRC_ITM does not reference any database object

GML.OP_GNRC_ITM is referenced by following:

APPS: OP_GNRC_ITM