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: INV.MTL_BIS_INV_BY_PERIOD

Object Details

Object Name:	MTL_BIS_INV_BY_PERIOD
Object Type:	TABLE
Owner:	INV
FND Design Data:	INV.MTL_BIS_INV_BY_PERIOD
Subobject Name:
Status:	VALID

This table stores inventory turns data by organization, accounting period and Inventory item id for open periods and closed periods.

Storage Details

Tablespace:	APPS_TS_SUMMARY
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
MTL_BIS_INV_BY_PERIOD_U1	NORMAL	UNIQUE	APPS_TS_SUMMARY	ACCT_PERIOD_ID ORGANIZATION_ID INVENTORY_ITEM_ID

Columns

Name	Datatype	Mandatory	Comments
ORGANIZATION_ID	NUMBER	Yes	Organization identifier
ACCT_PERIOD_ID	NUMBER	Yes	Accounting Period Identifier
ONHAND	NUMBER		End of period inventory onhand value for item
WIP	NUMBER		End of period WIP value for item
INTRANSIT	NUMBER		End of period intransit value for item
COGS	NUMBER		Cost of goods sold for item
LAST_UPDATE_DATE	DATE	Yes	Standard Who column
LAST_UPDATED_BY	NUMBER	Yes	Standard Who column
CREATION_DATE	DATE	Yes	Standard Who column
CREATED_BY	NUMBER	Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER		Standard Who column
REQUEST_ID	NUMBER		Standard Who column
PROGRAM_APPLICATION_ID	NUMBER		Standard Who column
PROGRAM_ID	NUMBER		Standard Who column
PROGRAM_UPDATE_DATE	DATE		Standard Who column
INVENTORY_ITEM_ID	NUMBER	Yes	Inventory item identifier
BOP_ONHAND	NUMBER		Begining of period Onhand value
BOP_WIP	NUMBER		Begining of period WIP value
BOP_INTRANSIT	NUMBER		Begining of period intransit value

Query Text

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


SELECT ORGANIZATION_ID
,      ACCT_PERIOD_ID
,      ONHAND
,      WIP
,      INTRANSIT
,      COGS
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      INVENTORY_ITEM_ID
,      BOP_ONHAND
,      BOP_WIP
,      BOP_INTRANSIT
FROM INV.MTL_BIS_INV_BY_PERIOD;

Dependencies

[top of page]

INV.MTL_BIS_INV_BY_PERIOD does not reference any database object

INV.MTL_BIS_INV_BY_PERIOD is referenced by following:

APPS: MTL_BIS_INV_BY_PERIOD