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_ORDERS_FACT

Object Details

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

This table contains the fine granular aggregate data of Orders placed for a given period.

Storage Details

Tablespace:	APPS_TS_SUMMARY
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IBE_ECR_ORDERS_FACT_N1	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	ORGANIZATION_ID INVENTORY_ITEM_ID
IBE_ECR_ORDERS_FACT_N2	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	ORG_ID
IBE_ECR_ORDERS_FACT_N3	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	FACT_DATE

Columns

Name	Datatype	Length	Mandatory	Comments
FACT_DATE	DATE		Yes	Fact Date -- Date the order is Booked
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.
RESOURCE_ID	NUMBER			Resource Identifier
ORG_ID	NUMBER			Operating Unit Identifier.
MSITE_ID	NUMBER			Specialty Store Identifier.
CURRENCY_CODE	VARCHAR2	(15)		Reporting Currency Code.
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.
SOLD_TO_ORG_ID	NUMBER			Sold to Customer Organization Identifier.
INVOICE_TO_ORG_ID	NUMBER			Invoice to Customer Address Identifier.
AGREEMENT_ID	NUMBER			Customer Agreement Identifier.
SALESREP_ID	NUMBER			Salesrep Identifier.
NUM_TIMES_ORDERED	NUMBER			Number of Times an Item is Ordered.
SALE_QUANTITY	NUMBER			Total Quantity of Item that is Ordered.
FUNCTIONAL_AMOUNT	NUMBER			Total amount of product item ordered in transactional currency.
REPORTED_AMOUNT	NUMBER			Total amount of product item ordered in reporting currency.

Query Text

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


SELECT FACT_DATE
,      OBJECT_VERSION_NUMBER
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      SECURITY_GROUP_ID
,      RESOURCE_ID
,      ORG_ID
,      MSITE_ID
,      CURRENCY_CODE
,      SECTION_ID
,      ORGANIZATION_ID
,      INVENTORY_ITEM_ID
,      UOM_CODE
,      SOLD_TO_ORG_ID
,      INVOICE_TO_ORG_ID
,      AGREEMENT_ID
,      SALESREP_ID
,      NUM_TIMES_ORDERED
,      SALE_QUANTITY
,      FUNCTIONAL_AMOUNT
,      REPORTED_AMOUNT
FROM IBE.IBE_ECR_ORDERS_FACT;

Dependencies

[top of page]

IBE.IBE_ECR_ORDERS_FACT does not reference any database object

IBE.IBE_ECR_ORDERS_FACT is referenced by following:

IBE: IBE_ECR_ORDERS_FACT#