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_FISCAL_CAT_ACCOUNTS

Object Details

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

MTL_FISCAL_CAT_ACCOUNTS stores the account numbers defined for a legal entity, cost type, cost group and category.

Storage Details

Tablespace:	APPS_TS_SEED
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
MTL_FISCAL_CAT_ACCOUNTS_U1	NORMAL	UNIQUE	APPS_TS_SEED	LEGAL_ENTITY_ID COST_TYPE_ID COST_GROUP_ID CATEGORY_ID

Columns

Name	Datatype	Length	Mandatory	Comments
LEGAL_ENTITY_ID	NUMBER	(15)	Yes	Legal entity identifier
COST_TYPE_ID	NUMBER		Yes	Cost type identifier
COST_GROUP_ID	NUMBER		Yes	Cost group identifier
CATEGORY_ID	NUMBER		Yes	Item category identifier
MATERIAL_ACCOUNT	NUMBER	(15)		Material account
MATERIAL_OVERHEAD_ACCOUNT	NUMBER	(15)		Material overhead account
RESOURCE_ACCOUNT	NUMBER	(15)		Resource account
OUTSIDE_PROCESSING_ACCOUNT	NUMBER	(15)		Outside processing account
OVERHEAD_ACCOUNT	NUMBER	(15)		Overhead account
EXPENSE_ACCOUNT	NUMBER	(15)		Expense account
BRIDGING_ACCOUNT	NUMBER	(15)		Bridging account
NON_INVOICED_SO	NUMBER			Non-invoiced sales order
NON_INVOICED_REVENUE	NUMBER			Non-invoiced revenue
LAST_UPDATE_DATE	DATE		Yes	Concurrent Who column
LAST_UPDATED_BY	NUMBER		Yes	Concurrent Who column
CREATION_DATE	DATE		Yes	Concurrent Who column
CREATED_BY	NUMBER		Yes	Concurrent Who column
LAST_UPDATE_LOGIN	NUMBER			Concurrent Who column

Query Text

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


SELECT LEGAL_ENTITY_ID
,      COST_TYPE_ID
,      COST_GROUP_ID
,      CATEGORY_ID
,      MATERIAL_ACCOUNT
,      MATERIAL_OVERHEAD_ACCOUNT
,      RESOURCE_ACCOUNT
,      OUTSIDE_PROCESSING_ACCOUNT
,      OVERHEAD_ACCOUNT
,      EXPENSE_ACCOUNT
,      BRIDGING_ACCOUNT
,      NON_INVOICED_SO
,      NON_INVOICED_REVENUE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
FROM INV.MTL_FISCAL_CAT_ACCOUNTS;

Dependencies

[top of page]

INV.MTL_FISCAL_CAT_ACCOUNTS does not reference any database object

INV.MTL_FISCAL_CAT_ACCOUNTS is referenced by following:

INV: MTL_FISCAL_CAT_ACCOUNTS#