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: IBE.IBE_ECR_QUOTES_FACT

Object Details

Object Name:	IBE_ECR_QUOTES_FACT
Object Type:	TABLE
Owner:	IBE
FND Design Data:	IBE.IBE_ECR_QUOTES_FACT
Subobject Name:
Status:	VALID

This table will provide the fine granular aggregate information about quotes for a given period.

Storage Details

Tablespace:	APPS_TS_SUMMARY
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IBE_ECR_QUOTES_FACT_N1	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	ORGANIZATION_ID INVENTORY_ITEM_ID
IBE_ECR_QUOTES_FACT_N2	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	ORG_ID
IBE_ECR_QUOTES_FACT_N3	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	CUST_ACCOUNT_ID
IBE_ECR_QUOTES_FACT_N4	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	QUOTE_DATE

Columns

Name	Datatype	Length	Mandatory	Comments
QUOTE_DATE	DATE		Yes	Quote creation date.
OBJECT_VERSION_NUMBER	NUMBER	(9)	Yes	Object Version Number for Locking.
CREATED_BY	NUMBER		Yes	standard WHO column.
CREATION_DATE	DATE		Yes	standard WHO column.
LAST_UPDATED_BY	NUMBER		Yes	standard WHO column.
LAST_UPDATE_DATE	DATE		Yes	standard WHO column.
LAST_UPDATE_LOGIN	NUMBER			standard WHO column.
SECURITY_GROUP_ID	NUMBER			Security Group Identifier.
MSITE_ID	NUMBER			Specialty Store identifier.
ORG_ID	NUMBER			Operating Unit Identifier.
CURRENCY_CODE	VARCHAR2	(15)		Currency in which quote is placed.
SECTION_ID	NUMBER			Section Identifier.
ORGANIZATION_ID	NUMBER			Inventory Organization Identifier.
INVENTORY_ITEM_ID	NUMBER			Inventory Item Identifier.
UOM_CODE	VARCHAR2	(3)		Unit of measure of product item in quote.
CUST_ACCOUNT_ID	NUMBER			Customer Account Identifier.
EMPLOYEE_PERSON_ID	NUMBER			Sales Representative Identifier.
ADDED_TO_CART_FREQUENCY	NUMBER			Number of times the item is selected in Quote.
QUOTE_QUANTITY	NUMBER			Total number of product item selected in Quote(s).
ITEM_ORDERED_FREQUENCY	NUMBER			Number of Times the Item is Ordered.
ORDER_QUANTITY	NUMBER			Total number of the product item units ordered.

Query Text

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


SELECT QUOTE_DATE
,      OBJECT_VERSION_NUMBER
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      SECURITY_GROUP_ID
,      MSITE_ID
,      ORG_ID
,      CURRENCY_CODE
,      SECTION_ID
,      ORGANIZATION_ID
,      INVENTORY_ITEM_ID
,      UOM_CODE
,      CUST_ACCOUNT_ID
,      EMPLOYEE_PERSON_ID
,      ADDED_TO_CART_FREQUENCY
,      QUOTE_QUANTITY
,      ITEM_ORDERED_FREQUENCY
,      ORDER_QUANTITY
FROM IBE.IBE_ECR_QUOTES_FACT;

Dependencies

[top of page]

IBE.IBE_ECR_QUOTES_FACT does not reference any database object

IBE.IBE_ECR_QUOTES_FACT is referenced by following:

IBE: IBE_ECR_QUOTES_FACT#