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_DLOG

Object Details

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

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	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	VARCHAR2	(40)	FK Key to Currency Dimension for Functional Currency
BASE_CURRENCY_FK_KEY	NUMBER		EDW-Assigned Surrogate FK Key to Currency Dimension for Functional Currency
BASE_UOM_FK	VARCHAR2	(40)	FK Key to UOM Dimension
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		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	VARCHAR2	(40)	Foreign Key to Instance Dimension
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	(120)	Primary Key to Daily Status Record
INV_DAILY_STATUS_PK_KEY	NUMBER		EDW-Assigned Surrogate Primary Key to Daily Status Record
INV_ORG_FK	VARCHAR2	(120)	Foreign Key to the Internal Organization Dimension
INV_ORG_FK_KEY	NUMBER		EDW-Assigned Surrogate Foreign Key to the Internal Organization Dimension
ITEM_ORG_FK	VARCHAR2	(240)	Foreign Key to Item Dimension at Item Org Level
ITEM_ORG_FK_KEY	NUMBER		EDW-Assigned Surrogate Foreign Key to Item Dimension
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		Last Update Date
LOCATOR_FK	VARCHAR2	(120)	Foreign Key to Inventory Locator Dimension
LOCATOR_FK_KEY	NUMBER		EDW-Assigned Surrogate Foreign Key to Inventory Locator Dimension
LOT_FK	VARCHAR2	(120)	Foreign Key to Lot 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	VARCHAR2	(240)	Foreign Key to Time Dimension at Period Level
PRD_DATE_FK_KEY	NUMBER		EDW-Assigned Surrogate Foreign Key to Period of Time Dimension
ROW_ID	VARCHAR2	(30)	Row Id of the Inventory Daily Status Fact
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	VARCHAR2	(240)	Foreign Key to Time Dimension at Day Level
TRX_DATE_FK_KEY	NUMBER		EDW-Assigned Surrogate Foreign Key to Time Dimension
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	VARCHAR2	(240)	Foreign Key to User Defined Dimension
USER_FK1_KEY	NUMBER		Foreign Key to User Defined Dimension
USER_FK2	VARCHAR2	(240)	Foreign Key to User Defined Dimension
USER_FK2_KEY	NUMBER		Foreign Key to User Defined Dimension
USER_FK3	VARCHAR2	(240)	Foreign Key to User Defined Dimension
USER_FK3_KEY	NUMBER		Foreign Key to User Defined Dimension
USER_FK4	VARCHAR2	(240)	Foreign Key to User Defined Dimension
USER_FK4_KEY	NUMBER		Foreign Key to User Defined Dimension
USER_FK5	VARCHAR2	(240)	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
,      BASE_CURRENCY_FK_KEY
,      BASE_UOM_FK
,      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
,      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
,      INV_ORG_FK_KEY
,      ITEM_ORG_FK
,      ITEM_ORG_FK_KEY
,      ITEM_STATUS
,      ITEM_TYPE
,      LAST_UPDATE_DATE
,      LOCATOR_FK
,      LOCATOR_FK_KEY
,      LOT_FK
,      LOT_FK_KEY
,      NETTABLE_FLAG
,      PO_DEL_QTY
,      PO_DEL_VAL_B
,      PO_DEL_VAL_G
,      PRD_DATE_FK
,      PRD_DATE_FK_KEY
,      ROW_ID
,      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
,      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
,      USER_FK1_KEY
,      USER_FK2
,      USER_FK2_KEY
,      USER_FK3
,      USER_FK3_KEY
,      USER_FK4
,      USER_FK4_KEY
,      USER_FK5
,      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_DLOG;

Dependencies

[top of page]

OPI.OPI_EDW_INV_DAILY_STAT_F_DLOG does not reference any database object

OPI.OPI_EDW_INV_DAILY_STAT_F_DLOG is referenced by following:

APPS: OPI_EDW_INV_DAILY_STAT_F_DLOG