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: OPI.OPI_EDW_INV_DAILY_STAT_F

Object Details

Object Name:	OPI_EDW_INV_DAILY_STAT_F
Object Type:	TABLE
Owner:	OPI
FND Design Data:	OPI.OPI_EDW_INV_DAILY_STAT_F
Subobject Name:
Status:	VALID

Fact Table for the Inventory Daily Status Fact

Storage Details

Tablespace:	APPS_TS_SUMMARY
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
OPI_EDW_INV_DAILY_STATUS_F_U2	NORMAL	UNIQUE	APPS_TS_SUMMARY	INV_DAILY_STATUS_PK INV_DAILY_STATUS_PK_KEY
OPI_EDW_INV_DAILY_STAT_F_PK	NORMAL	UNIQUE	APPS_TS_SUMMARY	INV_DAILY_STATUS_PK_KEY
OPI_EDW_INV_DAILY_STAT_F_N1	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	BASE_CURRENCY_FK_KEY BASE_UOM_FK_KEY INSTANCE_FK_KEY INV_ORG_FK_KEY ITEM_ORG_FK_KEY LOCATOR_FK_KEY LOT_FK_KEY PRD_DATE_FK_KEY
OPI_EDW_INV_DAILY_STAT_F_N11	BITMAP	NONUNIQUE	APPS_TS_SUMMARY	BASE_CURRENCY_FK_KEY
OPI_EDW_INV_DAILY_STAT_F_N12	BITMAP	NONUNIQUE	APPS_TS_SUMMARY	BASE_UOM_FK_KEY
OPI_EDW_INV_DAILY_STAT_F_N13	BITMAP	NONUNIQUE	APPS_TS_SUMMARY	INSTANCE_FK_KEY
OPI_EDW_INV_DAILY_STAT_F_N14	BITMAP	NONUNIQUE	APPS_TS_SUMMARY	INV_ORG_FK_KEY
OPI_EDW_INV_DAILY_STAT_F_N15	BITMAP	NONUNIQUE	APPS_TS_SUMMARY	ITEM_ORG_FK_KEY
OPI_EDW_INV_DAILY_STAT_F_N16	BITMAP	NONUNIQUE	APPS_TS_SUMMARY	LOCATOR_FK_KEY
OPI_EDW_INV_DAILY_STAT_F_N17	BITMAP	NONUNIQUE	APPS_TS_SUMMARY	LOT_FK_KEY
OPI_EDW_INV_DAILY_STAT_F_N18	BITMAP	NONUNIQUE	APPS_TS_SUMMARY	PRD_DATE_FK_KEY
OPI_EDW_INV_DAILY_STAT_F_N19	BITMAP	NONUNIQUE	APPS_TS_SUMMARY	TRX_DATE_FK_KEY

Columns

Name	Datatype	Length	Mandatory	Comments
AVG_INT_QTY	NUMBER			Average daily intransit quantity in Warehouse Base UOM
AVG_INT_VAL_B	NUMBER			(Beg Intransit Value + End Intransit Value) / 2 , in Functional Currency
AVG_INT_VAL_G	NUMBER			(Beg Intransit Value + End Intransit Value) / 2 , in Warehouse Currency
AVG_ONH_QTY	NUMBER			Average Daily onhand quantity
AVG_ONH_VAL_B	NUMBER			Value of Average Daily Onhand Quantity, in Functional Currency
AVG_ONH_VAL_G	NUMBER			Value of Average Daily Onhand Quantity, in Warehouse Currency
AVG_WIP_QTY	NUMBER			Average Daily WIP quantity
AVG_WIP_VAL_B	NUMBER			Value of Average Daily WIP quantity , in Functional Currency
AVG_WIP_VAL_G	NUMBER			Value of Average Daily WIP quantity , in Warehouse Currency
BASE_CURRENCY_FK_KEY	NUMBER			FK Key to Currency Dimension for Functional Currency
BASE_UOM_FK_KEY	NUMBER			EDW-Assigned Surrogate FK Key to UOM Dimension
BEG_INT_QTY	NUMBER			Beginning Daily In-Transit Quantity
BEG_INT_VAL_B	NUMBER			Value of Beginning Daily In-Transit Quantity , in Functional Currency
BEG_INT_VAL_G	NUMBER			Value of Beginning Daily In-Transit Quantity , in Warehouse Currency
BEG_ONH_QTY	NUMBER			Beginning Daily On-Hand Quantity
BEG_ONH_VAL_B	NUMBER			Value of Beginning Daily On-Hand Quantity , in Functional Currency
BEG_ONH_VAL_G	NUMBER			Value of Beginning Daily On-Hand Quantity , in Warehouse Currency
BEG_WIP_QTY	NUMBER			Beginning Daily WIP Quantity
BEG_WIP_VAL_B	NUMBER			Value of Beginning Daily WIP Quantity , in Functional Currency
BEG_WIP_VAL_G	NUMBER			Value of Beginning Daily WIP Quantity , in Warehouse Currency
COMMODITY_CODE	VARCHAR2	(40)		Commodity Code
COST_GROUP	VARCHAR2	(40)		Cost Group
CREATION_DATE	DATE		Yes	Creation Date
END_INT_QTY	NUMBER			Ending Daily In-Transit Quantity
END_INT_VAL_B	NUMBER			Value of Ending Daily In-Transit Quantity , in Functional Currency
END_INT_VAL_G	NUMBER			Value of Ending Daily In-Transit Quantity , in Warehouse Currency
END_ONH_QTY	NUMBER			Ending Daily On-Hand Quantity
END_ONH_VAL_B	NUMBER			Value of Ending Daily On-Hand Quantity , in Functional Currency
END_ONH_VAL_G	NUMBER			Value of Ending Daily On-Hand Quantity , in Warehouse Currency
END_WIP_QTY	NUMBER			Ending Daily WIP Quantity
END_WIP_VAL_B	NUMBER			Value of Ending Daily WIP Quantity , in Functional Currency
END_WIP_VAL_G	NUMBER			Value of Ending Daily WIP Quantity , in Warehouse Currency
FROM_ORG_QTY	NUMBER			Quanity Transfered From Org to Other Orgs
FROM_ORG_VAL_B	NUMBER			Value of Quanity Transfered From Org to Other Orgs, in Functional Currency
FROM_ORG_VAL_G	NUMBER			Value of Quanity Transfered From Org to Other Orgs, in Warehouse Currency
INSTANCE_FK_KEY	NUMBER			EDW-Assigned Surrogate Foreign Key to Instance Dimension
INV_ADJ_QTY	NUMBER			Quantity of Misc Inventory Adjustments During the day
INV_ADJ_VAL_B	NUMBER			Value of Quantity of Misc Inventory Adjustments During the day, in Functional Currency
INV_ADJ_VAL_G	NUMBER			Value of Quantity of Misc Inventory Adjustments During the day, in Warehouse Currency
INV_DAILY_STATUS_PK	VARCHAR2	(240)		Primary Key to Daily Status Record
INV_DAILY_STATUS_PK_KEY	NUMBER		Yes	EDW-Assigned Surrogate Primary Key to Daily Status Record
INV_ORG_FK_KEY	NUMBER			EDW-Assigned Surrogate Foreign Key to the Internal Organization Dimension
ITEM_ORG_FK_KEY	NUMBER			EDW-Assigned Surrogate Foreign Key to Item Dimension at Item Org Level
ITEM_STATUS	VARCHAR2	(40)		Status of an item (Obsolete, inactive etc.)
ITEM_TYPE	VARCHAR2	(40)		Seeded or user-defined item type
LAST_UPDATE_DATE	DATE		Yes	Last Update Date of Transaction on Source System
LOCATOR_FK_KEY	NUMBER			EDW-Assigned Surrogate Foreign Key to Inventory Locator Dimension
LOT_FK_KEY	NUMBER			EDW-Assigned Surrogate Foreign Key to Lot Dimension
NETTABLE_FLAG	VARCHAR2	(15)		Indicates if Inventory is nettable to planning
PO_DEL_QTY	NUMBER			Quantity of PO Receipts During the day
PO_DEL_VAL_B	NUMBER			Value of Quantity of PO Receipts During the day, in functional currency
PO_DEL_VAL_G	NUMBER			Value of Quantity of PO Receipts During the day, in warehouse currency
PRD_DATE_FK_KEY	NUMBER			EDW-Assigned Surrogate Foreign Key to Period of Time Dimension
TOTAL_REC_QTY	NUMBER			Total Quantity Received from Purchasing, Stock Transfers, Manufacturing, Misc Receipts
TOTAL_REC_VAL_B	NUMBER			Value of TOTAL_REC_QTY, in Functional Currency
TOTAL_REC_VAL_G	NUMBER			Value of TOTAL_REC_QTY, in Warehouse Currency
TOT_CUST_SHIP_QTY	NUMBER			Total Quantity Issued to Customer Order Shipments
TOT_CUST_SHIP_VAL_B	NUMBER			Value of TOT_CUST_SHIP_QTY, in Functional Currency
TOT_CUST_SHIP_VAL_G	NUMBER			Value of TOT_CUST_SHIP_QTY, in Warehouse Currency
TOT_ISSUES_QTY	NUMBER			Total Quantity Issued to Sales and Transfer Shipments, Manufacturing, Misc. Issues
TOT_ISSUES_VAL_B	NUMBER			Value fo TOT_ISSUES_QTY, in Functional Currency
TOT_ISSUES_VAL_G	NUMBER			Value fo TOT_ISSUES_QTY, in Warehouse Currency
TO_ORG_QTY	NUMBER			Quanity Transfered to Org (from Other Orgs)
TO_ORG_VAL_B	NUMBER			Value of Quanity Transfered to Org (from Other Orgs), in Functional Currency
TO_ORG_VAL_G	NUMBER			Value of Quanity Transfered to Org (from Other Orgs), in Warehouse Currency
TRX_DATE_FK_KEY	NUMBER			EDW-Assigned Surrogate Foreign Key for Transaction Date
USER_ATTRIBUTE1	VARCHAR2	(240)		User-Defined Attribute 1
USER_ATTRIBUTE10	VARCHAR2	(240)		User-Defined Attribute 10
USER_ATTRIBUTE11	VARCHAR2	(240)		User-Defined Attribute 11
USER_ATTRIBUTE12	VARCHAR2	(240)		User-Defined Attribute 12
USER_ATTRIBUTE13	VARCHAR2	(240)		User-Defined Attribute 13
USER_ATTRIBUTE14	VARCHAR2	(240)		User-Defined Attribute 14
USER_ATTRIBUTE15	VARCHAR2	(240)		User-Defined Attribute 15
USER_ATTRIBUTE2	VARCHAR2	(240)		User-Defined Attribute 2
USER_ATTRIBUTE3	VARCHAR2	(240)		User-Defined Attribute 3
USER_ATTRIBUTE4	VARCHAR2	(240)		User-Defined Attribute 4
USER_ATTRIBUTE5	VARCHAR2	(240)		User-Defined Attribute 5
USER_ATTRIBUTE6	VARCHAR2	(240)		User-Defined Attribute 6
USER_ATTRIBUTE7	VARCHAR2	(240)		User-Defined Attribute 7
USER_ATTRIBUTE8	VARCHAR2	(240)		User-Defined Attribute 8
USER_ATTRIBUTE9	VARCHAR2	(240)		User-Defined Attribute 9
USER_FK1_KEY	NUMBER			Foreign Key to User Defined Dimension
USER_FK2_KEY	NUMBER			Foreign Key to User Defined Dimension
USER_FK3_KEY	NUMBER			Foreign Key to User Defined Dimension
USER_FK4_KEY	NUMBER			Foreign Key to User Defined Dimension
USER_FK5_KEY	NUMBER			Foreign Key to User Defined Dimension
USER_MEASURE1	NUMBER			User Defined Measure
USER_MEASURE2	NUMBER			User Defined Measure
USER_MEASURE3	NUMBER			User Defined Measure
USER_MEASURE4	NUMBER			User Defined Measure
USER_MEASURE5	NUMBER			User Defined Measure
WIP_ASSY_QTY	NUMBER			Quantity Returned to WIP for Rework
WIP_ASSY_VAL_B	NUMBER			Value of WIP_ASSY_QTY, in Functional Currency
WIP_ASSY_VAL_G	NUMBER			Value of WIP_ASSY_QTY, in Warehouse Currency
WIP_COMP_QTY	NUMBER			Quantity Recieved from Manfacturing
WIP_COMP_VAL_B	NUMBER			Value of WIP_COMP_QTY, in Functional Currency
WIP_COMP_VAL_G	NUMBER			Value of WIP_COMP_QTY, in Warehouse Currency
WIP_ISSUE_QTY	NUMBER			Quantity Issued to Manufacturing
WIP_ISSUE_VAL_B	NUMBER			Value of WIP_ISSUE_QTY, in Functional Currency
WIP_ISSUE_VAL_G	NUMBER			Value of WIP_ISSUE_QTY, in Warehouse Currency
TRX_DATE	DATE			Transaction Date
PERIOD_FLAG	NUMBER			Flag to indicate that record represents a period summary

Query Text

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


SELECT AVG_INT_QTY
,      AVG_INT_VAL_B
,      AVG_INT_VAL_G
,      AVG_ONH_QTY
,      AVG_ONH_VAL_B
,      AVG_ONH_VAL_G
,      AVG_WIP_QTY
,      AVG_WIP_VAL_B
,      AVG_WIP_VAL_G
,      BASE_CURRENCY_FK_KEY
,      BASE_UOM_FK_KEY
,      BEG_INT_QTY
,      BEG_INT_VAL_B
,      BEG_INT_VAL_G
,      BEG_ONH_QTY
,      BEG_ONH_VAL_B
,      BEG_ONH_VAL_G
,      BEG_WIP_QTY
,      BEG_WIP_VAL_B
,      BEG_WIP_VAL_G
,      COMMODITY_CODE
,      COST_GROUP
,      CREATION_DATE
,      END_INT_QTY
,      END_INT_VAL_B
,      END_INT_VAL_G
,      END_ONH_QTY
,      END_ONH_VAL_B
,      END_ONH_VAL_G
,      END_WIP_QTY
,      END_WIP_VAL_B
,      END_WIP_VAL_G
,      FROM_ORG_QTY
,      FROM_ORG_VAL_B
,      FROM_ORG_VAL_G
,      INSTANCE_FK_KEY
,      INV_ADJ_QTY
,      INV_ADJ_VAL_B
,      INV_ADJ_VAL_G
,      INV_DAILY_STATUS_PK
,      INV_DAILY_STATUS_PK_KEY
,      INV_ORG_FK_KEY
,      ITEM_ORG_FK_KEY
,      ITEM_STATUS
,      ITEM_TYPE
,      LAST_UPDATE_DATE
,      LOCATOR_FK_KEY
,      LOT_FK_KEY
,      NETTABLE_FLAG
,      PO_DEL_QTY
,      PO_DEL_VAL_B
,      PO_DEL_VAL_G
,      PRD_DATE_FK_KEY
,      TOTAL_REC_QTY
,      TOTAL_REC_VAL_B
,      TOTAL_REC_VAL_G
,      TOT_CUST_SHIP_QTY
,      TOT_CUST_SHIP_VAL_B
,      TOT_CUST_SHIP_VAL_G
,      TOT_ISSUES_QTY
,      TOT_ISSUES_VAL_B
,      TOT_ISSUES_VAL_G
,      TO_ORG_QTY
,      TO_ORG_VAL_B
,      TO_ORG_VAL_G
,      TRX_DATE_FK_KEY
,      USER_ATTRIBUTE1
,      USER_ATTRIBUTE10
,      USER_ATTRIBUTE11
,      USER_ATTRIBUTE12
,      USER_ATTRIBUTE13
,      USER_ATTRIBUTE14
,      USER_ATTRIBUTE15
,      USER_ATTRIBUTE2
,      USER_ATTRIBUTE3
,      USER_ATTRIBUTE4
,      USER_ATTRIBUTE5
,      USER_ATTRIBUTE6
,      USER_ATTRIBUTE7
,      USER_ATTRIBUTE8
,      USER_ATTRIBUTE9
,      USER_FK1_KEY
,      USER_FK2_KEY
,      USER_FK3_KEY
,      USER_FK4_KEY
,      USER_FK5_KEY
,      USER_MEASURE1
,      USER_MEASURE2
,      USER_MEASURE3
,      USER_MEASURE4
,      USER_MEASURE5
,      WIP_ASSY_QTY
,      WIP_ASSY_VAL_B
,      WIP_ASSY_VAL_G
,      WIP_COMP_QTY
,      WIP_COMP_VAL_B
,      WIP_COMP_VAL_G
,      WIP_ISSUE_QTY
,      WIP_ISSUE_VAL_B
,      WIP_ISSUE_VAL_G
,      TRX_DATE
,      PERIOD_FLAG
FROM OPI.OPI_EDW_INV_DAILY_STAT_F;

Dependencies

[top of page]

OPI.OPI_EDW_INV_DAILY_STAT_F does not reference any database object

OPI.OPI_EDW_INV_DAILY_STAT_F is referenced by following:

APPS: OPI_EDW_INV_DAILY_STAT_F