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_PER_CLOSE_DTLS

Object Details

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

MTL_PER_CLOSE_DTLS stores period end quantities, costs, and
values by subinventory, item, and cost group for an organization
under Average Costing for Work in Process. The table also
stores the period end value in intransit inventory for the
organization. This table is populated by the period close program.
This table is a child table of MTL_PERIOD_SUMMARY.
The table records the inventory value for each inventory item by cost
group in the organization at the end of a period.
The COST_GROUP_ID for the intransit inventory will be 1 and
SECONDARY_INVENTORY will be NULL.

Storage Details

Tablespace:	APPS_TS_SUMMARY
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
MTL_PER_CLOSE_DTLS_U1	NORMAL	UNIQUE	APPS_TS_SUMMARY	ORGANIZATION_ID ACCT_PERIOD_ID COST_GROUP_ID INVENTORY_ITEM_ID SECONDARY_INVENTORY

Columns

Name	Datatype	Length	Mandatory	Comments
ORGANIZATION_ID	NUMBER		Yes	Organization identifier.
ACCT_PERIOD_ID	NUMBER		Yes	Accounting period identifier for the closed period.
COST_GROUP_ID	NUMBER			Cost group identifier.
SECONDARY_INVENTORY	VARCHAR2	(10)		Subinventory code.
INVENTORY_ITEM_ID	NUMBER		Yes	Item identifier.
PERIOD_END_QUANTITY	NUMBER			Item quantity at period close.
PERIOD_END_UNIT_COST	NUMBER			Item cost at period close.
LAST_UPDATE_DATE	DATE		Yes	Standard who column.
LAST_UPDATED_BY	NUMBER		Yes	Standard who column.
CREATED_BY	NUMBER		Yes	Standard who column.
CREATION_DATE	DATE		Yes	Standard who column.
PROGRAM_ID	NUMBER		Yes	Concurrent who column.
PROGRAM_APPLICATION_ID	NUMBER		Yes	Concurrent who column.
LOGIN_ID	NUMBER		Yes	Standard who column.

Query Text

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


SELECT ORGANIZATION_ID
,      ACCT_PERIOD_ID
,      COST_GROUP_ID
,      SECONDARY_INVENTORY
,      INVENTORY_ITEM_ID
,      PERIOD_END_QUANTITY
,      PERIOD_END_UNIT_COST
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATED_BY
,      CREATION_DATE
,      PROGRAM_ID
,      PROGRAM_APPLICATION_ID
,      LOGIN_ID
FROM INV.MTL_PER_CLOSE_DTLS;

Dependencies

[top of page]

INV.MTL_PER_CLOSE_DTLS does not reference any database object

INV.MTL_PER_CLOSE_DTLS is referenced by following:

APPS: MTL_PER_CLOSE_DTLS