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_SUPPLIERSITE_TMP

Object Details

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

This table is used to store the search results of supplier/sites during item association creation

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
EGO_SUPPLIERSITE_TMP_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	BATCH_ID
EGO_SUPPLIERSITE_TMP_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	BATCH_ID SUPPLIER_NAME SUPPLIER_NUMBER SUPPLIER_SITE_NAME

Columns

Name	Datatype	Length	Mandatory	Comments
BATCH_ID	NUMBER		Yes	Grouping Identifier
CREATED_BY	NUMBER		Yes	Who columns
CREATION_DATE	DATE		Yes	Who columns
LAST_UPDATED_BY	NUMBER		Yes	Who columns
LAST_UPDATE_DATE	DATE		Yes	Who columns
LAST_UPDATE_LOGIN	NUMBER			Who columns
SUPPLIER_ID	NUMBER		Yes	Supplier Id of the Supplier or Supplier Site
SUPPLIER_NAME	VARCHAR2	(240)	Yes	Suppliers Name
SUPPLIER_NUMBER	VARCHAR2	(30)	Yes	Suppliers Number
SUPPLIER_SITE_ID	NUMBER			Supplier Site Id
SUPPLIER_SITE_NAME	VARCHAR2	(320)		Supplier Site Name
CITY	VARCHAR2	(25)		City
STATE	VARCHAR2	(150)		State
COUNTRY	VARCHAR2	(30)		Country
SELECT_FLAG	VARCHAR2	(1)		Selection Flag
DUNS_NUMBER	VARCHAR2	(30)		The DUNS number, a unique, nine-digit identification number assigned to business entities by Dun & Bradstreet
TAX_PAYER_ID	VARCHAR2	(30)		Refers to num_1099 in ap_suppliers
TAX_REGISTRATION_NUM	VARCHAR2	(20)		Refers to vat_registration_num in ap_suppliers

Query Text

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


SELECT BATCH_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      SUPPLIER_ID
,      SUPPLIER_NAME
,      SUPPLIER_NUMBER
,      SUPPLIER_SITE_ID
,      SUPPLIER_SITE_NAME
,      CITY
,      STATE
,      COUNTRY
,      SELECT_FLAG
,      DUNS_NUMBER
,      TAX_PAYER_ID
,      TAX_REGISTRATION_NUM
FROM EGO.EGO_SUPPLIERSITE_TMP;

Dependencies

[top of page]

EGO.EGO_SUPPLIERSITE_TMP does not reference any database object

EGO.EGO_SUPPLIERSITE_TMP is referenced by following:

EGO: EGO_SUPPLIERSITE_TMP#