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_PERD_STAT_F

Object Details

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

Fact Table for the Inventory Period Status Derived Fact

Storage Details

Tablespace:	APPS_TS_SUMMARY
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
OPI_EDW_INV_PERD_STAT_F_U	NORMAL	UNIQUE	APPS_TS_SUMMARY	ITEM_ORG_FK_KEY LOT_FK_KEY LOCATOR_FK_KEY INV_ORG_FK_KEY PRD_DATE_FK_KEY COST_GROUP BASE_CURRENCY_FK_KEY BASE_UOM_FK_KEY INSTANCE_FK_KEY USER_FK1_KEY USER_FK2_KEY USER_FK3_KEY USER_FK4_KEY USER_FK5_KEY
OPI_EDW_INV_PERD_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_PERD_STAT_F_N11	BITMAP	NONUNIQUE	APPS_TS_SUMMARY	BASE_CURRENCY_FK_KEY
OPI_EDW_INV_PERD_STAT_F_N12	BITMAP	NONUNIQUE	APPS_TS_SUMMARY	BASE_UOM_FK_KEY
OPI_EDW_INV_PERD_STAT_F_N13	BITMAP	NONUNIQUE	APPS_TS_SUMMARY	INSTANCE_FK_KEY
OPI_EDW_INV_PERD_STAT_F_N14	BITMAP	NONUNIQUE	APPS_TS_SUMMARY	INV_ORG_FK_KEY
OPI_EDW_INV_PERD_STAT_F_N15	BITMAP	NONUNIQUE	APPS_TS_SUMMARY	ITEM_ORG_FK_KEY
OPI_EDW_INV_PERD_STAT_F_N16	BITMAP	NONUNIQUE	APPS_TS_SUMMARY	LOCATOR_FK_KEY
OPI_EDW_INV_PERD_STAT_F_N17	BITMAP	NONUNIQUE	APPS_TS_SUMMARY	LOT_FK_KEY
OPI_EDW_INV_PERD_STAT_F_N18	BITMAP	NONUNIQUE	APPS_TS_SUMMARY	PRD_DATE_FK_KEY

Columns

Name	Datatype	Length	Mandatory	Comments
AVG_INT_QTY	NUMBER			Average Period 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 Period onhand quantity
AVG_ONH_VAL_B	NUMBER			Value of Average Period Onhand Quantity, in Functional Currency
AVG_ONH_VAL_G	NUMBER			Value of Average Period Onhand Quantity, in Warehouse Currency
AVG_WIP_QTY	NUMBER			Average Period WIP quantity
AVG_WIP_VAL_B	NUMBER			Value of Average Period WIP quantity , in Functional Currency
AVG_WIP_VAL_G	NUMBER			Value of Average Period 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 Currency Dimension for Functional Currency
BEG_INT_QTY	NUMBER			Beginning Period In-Transit Quantity
BEG_INT_VAL_B	NUMBER			Value of Beginning Period In-Transit Quantity , in Functional Currency
BEG_INT_VAL_G	NUMBER			Value of Beginning Period In-Transit Quantity , in Warehouse Currency
BEG_ONH_QTY	NUMBER			Beginning Period On-Hand Quantity
BEG_ONH_VAL_B	NUMBER			Value of Beginning Period On-Hand Quantity , in Functional Currency
BEG_ONH_VAL_G	NUMBER			Value of Beginning Period On-Hand Quantity , in Warehouse Currency
BEG_WIP_QTY	NUMBER			Beginning Period WIP Quantity
BEG_WIP_VAL_B	NUMBER			Value of Beginning Period WIP Quantity , in Functional Currency
BEG_WIP_VAL_G	NUMBER			Value of Beginning Period WIP Quantity , in Warehouse Currency
COST_GROUP	VARCHAR2	(40)		Cost Group
CREATION_DATE	DATE		Yes	Creation Date
END_INT_QTY	NUMBER			Ending Period In-Transit Quantity
END_INT_VAL_B	NUMBER			Value of Ending Period In-Transit Quantity , in Functional Currency
END_INT_VAL_G	NUMBER			Value of Ending Period In-Transit Quantity , in Warehouse Currency
END_ONH_QTY	NUMBER			Ending Period On-Hand Quantity
END_ONH_VAL_B	NUMBER			Value of Ending Period On-Hand Quantity , in Functional Currency
END_ONH_VAL_G	NUMBER			Value of Ending Period On-Hand Quantity , in Warehouse Currency
END_WIP_QTY	NUMBER			Ending Period WIP Quantity
END_WIP_VAL_B	NUMBER			Value of Ending Period WIP Quantity , in Functional Currency
END_WIP_VAL_G	NUMBER			Value of Ending Period 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 Period
INV_ADJ_VAL_B	NUMBER			Value of Quantity of Misc Inventory Adjustments During Period, in Functional Currency
INV_ADJ_VAL_G	NUMBER			Value of Quantity of Misc Inventory Adjustments During Period, in Warehouse Currency
INV_ORG_FK_KEY	NUMBER			EDW-Assigned Surrogate Foreign Key to Internal Organization Dimension
INV_PERIOD_STATUS_PK	VARCHAR2	(240)		Primary Key of the Inventory Period Status Record
INV_PERIOD_STATUS_PK_KEY	NUMBER			EDW-Assigned Surrogate Foreign Key to the Inventory Calendar Period Status
ITEM_ORG_FK_KEY	NUMBER			EDW-Assigned Surrogate Foreign Key to Item-Org Dimension
ITEM_STATUS	VARCHAR2	(40)		Status of an item (Obsolete, inactive etc.)
LAST_UPDATE_DATE	DATE		Yes	Last Update Date
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 Period
PO_DEL_VAL_B	NUMBER			Value of Quantity of PO Receipts During Period, in functional currency
PO_DEL_VAL_G	NUMBER			Value of Quantity of PO Receipts During Period, 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
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

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
,      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_ORG_FK_KEY
,      INV_PERIOD_STATUS_PK
,      INV_PERIOD_STATUS_PK_KEY
,      ITEM_ORG_FK_KEY
,      ITEM_STATUS
,      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
,      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
FROM OPI.OPI_EDW_INV_PERD_STAT_F;

Dependencies

[top of page]

OPI.OPI_EDW_INV_PERD_STAT_F does not reference any database object

OPI.OPI_EDW_INV_PERD_STAT_F is referenced by following:

APPS: OPI_EDW_INV_PERD_STAT_F