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]

VIEW: APPS.MTL_FISCAL_CAT_ACCOUNTS_V

Object Details

Object Name:	MTL_FISCAL_CAT_ACCOUNTS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	INV.MTL_FISCAL_CAT_ACCOUNTS_V
Subobject Name:
Status:	VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ROW_ID	ROWID	(10)
LEGAL_ENTITY_ID	NUMBER	(15)	Yes	Legal Entity Identifier
COST_TYPE_ID	NUMBER		Yes	Cost type Identifier
COST_TYPE	VARCHAR2	(10)	Yes	Cost type
COST_TYPE_DESCRIPTION	VARCHAR2	(240)		Cost type description
COST_GROUP_ID	NUMBER		Yes	Cost group identifier
LEGAL_ENTITY	VARCHAR2	(240)	Yes	Legal entity
CATEGORY_ID	NUMBER		Yes	Category identifier
LAST_UPDATE_DATE	DATE		Yes	WHO column
LAST_UPDATED_BY	NUMBER		Yes	WHO column
CREATION_DATE	DATE		Yes	WHO column
CREATED_BY	NUMBER		Yes	WHO column
LAST_UPDATE_LOGIN	NUMBER			WHO column
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_ACCOUNT	NUMBER			Non invoiced sales order account
NON_INVOICED_REVENUE_ACCOUNT	NUMBER			Non invoiced revenue account
CATEGORY_DESCRIPTION	VARCHAR2	(240)		Category description
COST_GROUP_NAME	VARCHAR2	(10)	Yes	Cost group name
COST_GROUP_DESCRIPTION	VARCHAR2	(240)		Cost group description
SET_OF_BOOKS_NAME	VARCHAR2	(30)	Yes	Set of books
CHART_OF_ACCOUNTS_ID	NUMBER	(15)	Yes	Chart of accounts identifier

Query Text

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


SELECT ROW_ID
,      LEGAL_ENTITY_ID
,      COST_TYPE_ID
,      COST_TYPE
,      COST_TYPE_DESCRIPTION
,      COST_GROUP_ID
,      LEGAL_ENTITY
,      CATEGORY_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      MATERIAL_ACCOUNT
,      MATERIAL_OVERHEAD_ACCOUNT
,      RESOURCE_ACCOUNT
,      OUTSIDE_PROCESSING_ACCOUNT
,      OVERHEAD_ACCOUNT
,      EXPENSE_ACCOUNT
,      BRIDGING_ACCOUNT
,      NON_INVOICED_SO_ACCOUNT
,      NON_INVOICED_REVENUE_ACCOUNT
,      CATEGORY_DESCRIPTION
,      COST_GROUP_NAME
,      COST_GROUP_DESCRIPTION
,      SET_OF_BOOKS_NAME
,      CHART_OF_ACCOUNTS_ID
FROM APPS.MTL_FISCAL_CAT_ACCOUNTS_V;

Dependencies

[top of page]

APPS.MTL_FISCAL_CAT_ACCOUNTS_V references the following:

APPS: CST_COST_GROUPS; CST_COST_TYPES; CST_LE_COST_TYPES; GL_SETS_OF_BOOKS; MTL_CATEGORIES; MTL_FISCAL_CAT_ACCOUNTS; XLE_FIRSTPARTY_INFORMATION_V

APPS.MTL_FISCAL_CAT_ACCOUNTS_V is not referenced by any database object