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_CATEGORY_ACCOUNTS

Object Details

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

Use this table to store asset, expense, encumbrance and bridging
accounts by item category by subinventory.
This table is intended to be used by the European localization effort
and is not part of the base product.

Storage Details

Tablespace:	APPS_TS_SEED
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
MTL_CATEGORY_ACCOUNTS_U1	NORMAL	UNIQUE	APPS_TS_SEED	ORGANIZATION_ID CATEGORY_ID COST_GROUP_ID SUBINVENTORY_CODE

Columns

Name	Datatype	Length	Mandatory	Comments
CATEGORY_ID	NUMBER		Yes	Item category identifier
ORGANIZATION_ID	NUMBER		Yes	Organization identifier
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
CATEGORY_SET_ID	NUMBER			Category set cross reference
SUBINVENTORY_CODE	VARCHAR2	(10)		Subinventory name
MATERIAL_ACCOUNT	NUMBER			Material account
MATERIAL_OVERHEAD_ACCOUNT	NUMBER			Material overhead account
RESOURCE_ACCOUNT	NUMBER			Resource account
OUTSIDE_PROCESSING_ACCOUNT	NUMBER			Outside processing account
OVERHEAD_ACCOUNT	NUMBER			Overhead account
EXPENSE_ACCOUNT	NUMBER			Expense account
ENCUMBRANCE_ACCOUNT	NUMBER			Encumbrance account
BRIDGING_ACCOUNT	NUMBER			Bridging account
REQUEST_ID	NUMBER			Concurrent Who column
PROGRAM_APPLICATION_ID	NUMBER			Concurrent Who column
PROGRAM_ID	NUMBER			Concurrent Who column
PROGRAM_UPDATE_DATE	DATE			Concurrent Who column
COST_GROUP_ID	NUMBER			Cost group identifier
ANALYTICAL_IPV	NUMBER			Analytical invoice price variance
ANALYTICAL_PO_MIRROR	NUMBER			Analytical purchase order mirror
NON_INVOICED_SO	NUMBER			Non-invoiced sales order
NON_INVOICED_REVENUE	NUMBER			Non-invoiced revenue
ANALYTICAL_REVENUE_MIRROR	NUMBER			Analytical revenue mirror
ANALYTICAL_MOGS	NUMBER			Analytical margin of goods sold
AVERAGE_COST_VAR_ACCOUNT	NUMBER			Specifies the average cost variance account

Query Text

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


SELECT CATEGORY_ID
,      ORGANIZATION_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      CATEGORY_SET_ID
,      SUBINVENTORY_CODE
,      MATERIAL_ACCOUNT
,      MATERIAL_OVERHEAD_ACCOUNT
,      RESOURCE_ACCOUNT
,      OUTSIDE_PROCESSING_ACCOUNT
,      OVERHEAD_ACCOUNT
,      EXPENSE_ACCOUNT
,      ENCUMBRANCE_ACCOUNT
,      BRIDGING_ACCOUNT
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      COST_GROUP_ID
,      ANALYTICAL_IPV
,      ANALYTICAL_PO_MIRROR
,      NON_INVOICED_SO
,      NON_INVOICED_REVENUE
,      ANALYTICAL_REVENUE_MIRROR
,      ANALYTICAL_MOGS
,      AVERAGE_COST_VAR_ACCOUNT
FROM INV.MTL_CATEGORY_ACCOUNTS;

Dependencies

[top of page]

INV.MTL_CATEGORY_ACCOUNTS does not reference any database object

INV.MTL_CATEGORY_ACCOUNTS is referenced by following:

INV: MTL_CATEGORY_ACCOUNTS#