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: EGO.EGO_ITEM_CUST_ATTRS_B

Object Details

Object Name:	EGO_ITEM_CUST_ATTRS_B
Object Type:	TABLE
Owner:	EGO
FND Design Data:	EGO.EGO_ITEM_CUST_ATTRS_B
Subobject Name:
Status:	VALID

Table EGO_ITEM_CUST_ATTRS_B stores the customer specific GDSN atttributes.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
EGO_ITEM_CUST_ATTRS_B_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	EXTENSION_ID
EGO_ITEM_CUST_ATTRS_B_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	INVENTORY_ITEM_ID MASTER_ORGANIZATION_ID

Columns

Name	Datatype	Length	Mandatory	Comments
EXTENSION_ID	NUMBER	(15)	Yes	Unique identifier for the attribute row
INVENTORY_ITEM_ID	NUMBER	(15)	Yes	Inventory item identifier.Foreign key to MTL_SYSTEM_ITEMS_B
CREATED_BY	NUMBER		Yes	User id of Person who created record
CREATION_DATE	DATE		Yes	Date record was created
LAST_UPDATED_BY	NUMBER		Yes	User id of last person modifying the record
LAST_UPDATE_DATE	DATE		Yes	Date record was last modified
LAST_UPDATE_LOGIN	NUMBER			Login of last person who updated record
MASTER_ORGANIZATION_ID	NUMBER	(15)		Foreign key to MTL_SYSTEM_ITEMS_B
PARTY_SITE_ID	NUMBER	(15)		Foreign key to MTL_CUSTOMER_ITEMS (Address_id)
IS_TRADE_ITEM_AN_ORD_UNIT	VARCHAR2	(1)		Is item ordereable
PARTY_RECEIVING_PRIVATE_DATA	VARCHAR2	(35)		Name of Party receiving private data
PUBLICATION_DATE	DATE			Date when gtin hierarchy is published
END_AVAILABILITY_DATE_TIME	DATE			Date when item is no longer available
START_AVAILABILITY_DATE_TIME	DATE			Date when item is available
IS_TRADE_ITEM_A_DESPATCH_UNIT	VARCHAR2	(1)		Is the item a despatch unit
IS_TRADE_ITEM_AN_INVOICE_UNIT	VARCHAR2	(1)		Is the item an invoice unit
MIN_TRADE_ITEM_LIFE_ARR	NUMBER			Minimum life of item from time of arrival
ORDER_QUANTITY_MAX	NUMBER	(9)		Maximum Order Quantity
ORDER_QUANTITY_MIN	NUMBER	(9)		Minimum Order Quantity

Query Text

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


SELECT EXTENSION_ID
,      INVENTORY_ITEM_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      MASTER_ORGANIZATION_ID
,      PARTY_SITE_ID
,      IS_TRADE_ITEM_AN_ORD_UNIT
,      PARTY_RECEIVING_PRIVATE_DATA
,      PUBLICATION_DATE
,      END_AVAILABILITY_DATE_TIME
,      START_AVAILABILITY_DATE_TIME
,      IS_TRADE_ITEM_A_DESPATCH_UNIT
,      IS_TRADE_ITEM_AN_INVOICE_UNIT
,      MIN_TRADE_ITEM_LIFE_ARR
,      ORDER_QUANTITY_MAX
,      ORDER_QUANTITY_MIN
FROM EGO.EGO_ITEM_CUST_ATTRS_B;

Dependencies

[top of page]

EGO.EGO_ITEM_CUST_ATTRS_B does not reference any database object

EGO.EGO_ITEM_CUST_ATTRS_B is referenced by following:

APPS: EGO_ITEM_CUST_ATTRS_B