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_IDS_PUSH_LOG

Object Details

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

Staging table for the EDW inventory daily status program. Daily inventory activity is extracted from the source instance OLTP tables into this table before being transferred to the source side staging table, OPI_EDW_INV_DAILY_STAT_FSTG. This table keeps track of the starting and ending values of all activity that occurs on any day.

Storage Details

Tablespace:	APPS_TS_SUMMARY
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
OPI_IDS_PUSH_LOG_N1	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	INVENTORY_ITEM_ID ORGANIZATION_ID TRX_DATE
OPI_IDS_PUSH_LOG_N2	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	ORGANIZATION_ID TRX_DATE
OPI_IDS_PUSH_LOG_N3	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	PUSH_FLAG
OPI_IDS_PUSH_LOG_PK	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	IDS_KEY

Columns

Name	Datatype	Length	Mandatory	Comments
IDS_KEY	VARCHAR2	(240)	Yes	Unique primary key. Concatenation of date, organization id, inventory item id, subinventory code, locator id, cost group id, lot number
AVG_INT_QTY	NUMBER			Average = [(beginning + ending)]/2 quantity of intransit inventory quantity.
AVG_INT_VAL_B	NUMBER			Average = [(beginning + ending)]/2 value of intransit inventory in functional currency
AVG_ONH_QTY	NUMBER			Average = [(beginning + ending)]/2 onhand inventory quantity.
AVG_ONH_VAL_B	NUMBER			Average = [(beginning + ending)]/2 onhand inventory value in the functional currency
AVG_WIP_QTY	NUMBER			Average = [(beginning + ending)]/2 WIP inventory quantity.
AVG_WIP_VAL_B	NUMBER			Average = [(beginning + ending)]/2 WIP inventory value in the functional currency.
BASE_CURRENCY_CODE	VARCHAR2	(40)		Currency code of the functional currency.
BASE_UOM	VARCHAR2	(3)		Unit of measure code
BEG_INT_QTY	NUMBER			Beginning intransit inventory quantity
BEG_INT_VAL_B	NUMBER			Beginning intransit value in functional currency
BEG_ONH_QTY	NUMBER			Beginning onhand inventory quantity
BEG_ONH_VAL_B	NUMBER			Beginning onhand inventory value in functional currency
BEG_WIP_QTY	NUMBER			Beginning WIP inventory quantity
BEG_WIP_VAL_B	NUMBER			Beginning WIP inventory value in functional currency
COMMODITY_CODE	VARCHAR2	(40)		Commodity Code
COST_GROUP_ID	NUMBER			Cost Group Identifier
END_INT_QTY	NUMBER			Ending intransit inventory quantity
END_INT_VAL_B	NUMBER			Ending intransit inventory value in functional currency
END_ONH_QTY	NUMBER			Ending onhand inventory quantity
END_ONH_VAL_B	NUMBER			Ending onhand inventory value in base currency
END_WIP_QTY	NUMBER			Ending WIP inventory quantity
END_WIP_VAL_B	NUMBER			Ending WIP inventory value in functional currency.
FROM_ORG_QTY	NUMBER			Quantity shipped from source organization (for inter-organization transfers).
FROM_ORG_VAL_B	NUMBER			Value of shipment from source organization (for inter-organization transfers) in base functional currency.
INV_ADJ_QTY	NUMBER			Quantity of inventory adjustment
INV_ADJ_VAL_B	NUMBER			Value of inventory adjustment in functional currency
ORGANIZATION_ID	NUMBER		Yes	Organization ID
INVENTORY_ITEM_ID	NUMBER		Yes	Inventory Item ID
REVISION	VARCHAR2	(3)		Item Revision
ITEM_STATUS	VARCHAR2	(10)		Item Status
ITEM_TYPE	VARCHAR2	(30)		Item type
SUBINVENTORY_CODE	VARCHAR2	(10)		Subinventory Code
LOCATOR_ID	NUMBER			Locator ID
LOT_NUMBER	VARCHAR2	(30)		Lot number
NETTABLE_FLAG	VARCHAR2	(15)		Nettable Flag
PO_DEL_QTY	NUMBER			PO Delivery quantity
PO_DEL_VAL_B	NUMBER			PO Delivery value in functional currency
TOTAL_REC_QTY	NUMBER			Total received quantity
TOTAL_REC_VAL_B	NUMBER			Total received value in functional currency
TOT_CUST_SHIP_QTY	NUMBER			Total quantity of customer shipments
TOT_CUST_SHIP_VAL_B	NUMBER			Total values of customer shipments in functional currency
TOT_ISSUES_QTY	NUMBER			Total quantity of issues
TOT_ISSUES_VAL_B	NUMBER			Total value of issues in functional currency
TO_ORG_QTY	NUMBER			Quantity shipped to destination org (in case of inter-organization transfers)
TO_ORG_VAL_B	NUMBER			Value shipped to destination org (in case of inter-organization transfers) in functional currency
WIP_ASSY_QTY	NUMBER			Quantity of WIP assemblies
WIP_ASSY_VAL_B	NUMBER			Value of WIP assemblies in functional currency
WIP_COMP_QTY	NUMBER			Quantity of WIP completions
WIP_COMP_VAL_B	NUMBER			Value of WIP completions in functional currency
WIP_ISSUE_QTY	NUMBER			Quantity of WIP issues
WIP_ISSUE_VAL_B	NUMBER			Value of WIP issues in functional currency
TRX_DATE	DATE		Yes	Transaction date
PERIOD_FLAG	NUMBER			Period flag: 0 - start date of period, 1 = end date of period, NULL = neither start/end of period
PUSH_FLAG	NUMBER			Push Flag: 0 - data row not pushed to fact table yet, 1 = data row already pushed to fact table
CREATION_DATE	DATE			WHO column
CREATED_BY	NUMBER			WHO column
LAST_UPDATE_DATE	DATE			WHO column
LAST_UPDATED_BY	NUMBER			WHO column
REQUEST_ID	NUMBER			WHO column
PROGRAM_APPLICATION_ID	NUMBER			WHO column
PROGRAM_ID	NUMBER			WHO column
PROGRAM_UPDATE_DATE	NUMBER			WHO column
EDW_BASE_UOM	VARCHAR2	(20)		Base UOM code
EDW_CONV_RATE	NUMBER			EDW currency conversion rate
EDW_UOM_CONV_RATE	NUMBER			EDW unit of measure conversion rate
PROJECT_LOCATOR_ID	NUMBER			Project locator information

Query Text

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


SELECT IDS_KEY
,      AVG_INT_QTY
,      AVG_INT_VAL_B
,      AVG_ONH_QTY
,      AVG_ONH_VAL_B
,      AVG_WIP_QTY
,      AVG_WIP_VAL_B
,      BASE_CURRENCY_CODE
,      BASE_UOM
,      BEG_INT_QTY
,      BEG_INT_VAL_B
,      BEG_ONH_QTY
,      BEG_ONH_VAL_B
,      BEG_WIP_QTY
,      BEG_WIP_VAL_B
,      COMMODITY_CODE
,      COST_GROUP_ID
,      END_INT_QTY
,      END_INT_VAL_B
,      END_ONH_QTY
,      END_ONH_VAL_B
,      END_WIP_QTY
,      END_WIP_VAL_B
,      FROM_ORG_QTY
,      FROM_ORG_VAL_B
,      INV_ADJ_QTY
,      INV_ADJ_VAL_B
,      ORGANIZATION_ID
,      INVENTORY_ITEM_ID
,      REVISION
,      ITEM_STATUS
,      ITEM_TYPE
,      SUBINVENTORY_CODE
,      LOCATOR_ID
,      LOT_NUMBER
,      NETTABLE_FLAG
,      PO_DEL_QTY
,      PO_DEL_VAL_B
,      TOTAL_REC_QTY
,      TOTAL_REC_VAL_B
,      TOT_CUST_SHIP_QTY
,      TOT_CUST_SHIP_VAL_B
,      TOT_ISSUES_QTY
,      TOT_ISSUES_VAL_B
,      TO_ORG_QTY
,      TO_ORG_VAL_B
,      WIP_ASSY_QTY
,      WIP_ASSY_VAL_B
,      WIP_COMP_QTY
,      WIP_COMP_VAL_B
,      WIP_ISSUE_QTY
,      WIP_ISSUE_VAL_B
,      TRX_DATE
,      PERIOD_FLAG
,      PUSH_FLAG
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      EDW_BASE_UOM
,      EDW_CONV_RATE
,      EDW_UOM_CONV_RATE
,      PROJECT_LOCATOR_ID
FROM OPI.OPI_IDS_PUSH_LOG;

Dependencies

[top of page]

OPI.OPI_IDS_PUSH_LOG does not reference any database object

OPI.OPI_IDS_PUSH_LOG is referenced by following:

APPS: OPI_IDS_PUSH_LOG