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.FA_ASSET_DISTRIBUTION_V

Object Details

Object Name:	FA_ASSET_DISTRIBUTION_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	OFA.FA_ASSET_DISTRIBUTION_V
Subobject Name:
Status:	VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.

This view contains asset identification and distribution
information. To access category, location, and general ledger
expense account information, update the view definition with
appropriate segment numbers for your flexfields.
Oracle Assets standard modules do not use this view.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ASSET_NUMBER	VARCHAR2	(15)	Yes	Refer to base table
TAG_NUMBER	VARCHAR2	(15)		Refer to base table
DESCRIPTION	VARCHAR2	(80)		Refer to base table
MANUFACTURER_NAME	VARCHAR2	(360)		Refer to base table
SERIAL_NUMBER	VARCHAR2	(35)		Refer to base table
MODEL_NUMBER	VARCHAR2	(40)		Refer to base table
MAJOR_CATEGORY	VARCHAR2	(30)		Major category segment
SUB_CATEGORY	VARCHAR2	(30)		Minor Category Segment
BOOK_TYPE_CODE	VARCHAR2	(15)	Yes	Refer to base table
DATE_PLACED_IN_SERVICE	DATE		Yes	Refer to base table
COST	NUMBER			Refer to base table
EMPLOYEE_NUMBER	VARCHAR2	(30)		Refer to base table
EMPLOYEE_NAME	VARCHAR2	(240)		Refer to base table
STATE	VARCHAR2	(30)		Location flexfield segment
CITY	VARCHAR2	(30)		Location flexfield segment
SITE	VARCHAR2	(30)		Location flexfield segment
LOCATOR	VARCHAR2	(30)		Location flexfield segment
COMPANY	VARCHAR2	(25)		Depreciation expense Accounting Flexfield Segment Column
REGION	VARCHAR2	(25)		Depreciation expense Accounting Flexfield Segment Column
COST_CENTER	VARCHAR2	(25)		Depreciation expense Accounting Flexfield Segment Column
EXPENSE_ACCOUNT	VARCHAR2	(25)		Depreciation expense Accounting Flexfield Segment Column
PRODUCT	VARCHAR2	(25)		Depreciation expense Accounting Flexfield Segment Column
SUB_ACCOUNT	VARCHAR2	(25)		Depreciation expense Accounting Flexfield Segment Column
ASSET_ACCOUNT	VARCHAR2	(25)	Yes	Asset cost account

Query Text

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


SELECT ASSET_NUMBER
,      TAG_NUMBER
,      DESCRIPTION
,      MANUFACTURER_NAME
,      SERIAL_NUMBER
,      MODEL_NUMBER
,      MAJOR_CATEGORY
,      SUB_CATEGORY
,      BOOK_TYPE_CODE
,      DATE_PLACED_IN_SERVICE
,      COST
,      EMPLOYEE_NUMBER
,      EMPLOYEE_NAME
,      STATE
,      CITY
,      SITE
,      LOCATOR
,      COMPANY
,      REGION
,      COST_CENTER
,      EXPENSE_ACCOUNT
,      PRODUCT
,      SUB_ACCOUNT
,      ASSET_ACCOUNT
FROM APPS.FA_ASSET_DISTRIBUTION_V;

Dependencies

[top of page]

APPS.FA_ASSET_DISTRIBUTION_V references the following:

APPS: FA_ADDITIONS; FA_BOOKS; FA_BOOK_CONTROLS; FA_CATEGORIES_B; FA_CATEGORY_BOOKS; FA_DISTRIBUTION_HISTORY; FA_EMPLOYEES; FA_LOCATIONS; GL_CODE_COMBINATIONS; HR_GENERAL - show dependent code; HR_PERSON_NAME - show dependent code; HR_SECURITY - show dependent code

APPS.FA_ASSET_DISTRIBUTION_V is not referenced by any database object