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_INVOICES_V

Object Details

Object Name:	FA_ASSET_INVOICES_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	OFA.FA_ASSET_INVOICES_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, financial, and
purchasing information. To access category information,
update the view definition with the appropriate segment
number for your flexfield.
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.
ASSET_TYPE	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 column
SUB_CATEGORY	VARCHAR2	(30)		Minor category segment column
BOOK_TYPE_CODE	VARCHAR2	(15)	Yes	Refer to base table.
DATE_PLACED_IN_SERVICE	DATE		Yes	Refer to base table.
DEPRN_METHOD_CODE	VARCHAR2	(12)	Yes	Refer to base table.
LIFE_IN_MONTHS	NUMBER	(4)		Refer to base table.
SALVAGE_VALUE	NUMBER		Yes	Refer to base table.
ADJUSTED_RATE	NUMBER			Refer to base table.
PRODUCTION_CAPACITY	NUMBER			Refer to base table.
VENDOR_NAME	VARCHAR2	(240)		Refer to base table.
VENDOR_NUMBER	VARCHAR2	(30)	Yes	Refer to base table.
PO_NUMBER	VARCHAR2	(20)		Refer to base table.
INVOICE_NUMBER	VARCHAR2	(50)		Refer to base table.
INVOICE_ID	NUMBER	(15)		Refer to base table.
INVOICE_LINE_NUMBER	NUMBER			Refer to base table.
INVOICE_LINE_DESCRIPTION	VARCHAR2	(80)		Refer to base table.
INVOICE_COST	NUMBER			Refer to base table.
DISTRIBUTION_LINE_NUMBER	NUMBER	(15)		Distribution line identification number
PRIOR_SOURCE_LINE_ID	NUMBER	(15)		Refer to base table.
INVOICE_DISTRIBUTION_ID	NUMBER	(15)		Refer to base table.
PO_DISTRIBUTION_ID	NUMBER	(15)		Refer to base table.

Query Text

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


SELECT ASSET_NUMBER
,      TAG_NUMBER
,      DESCRIPTION
,      ASSET_TYPE
,      MANUFACTURER_NAME
,      SERIAL_NUMBER
,      MODEL_NUMBER
,      MAJOR_CATEGORY
,      SUB_CATEGORY
,      BOOK_TYPE_CODE
,      DATE_PLACED_IN_SERVICE
,      DEPRN_METHOD_CODE
,      LIFE_IN_MONTHS
,      SALVAGE_VALUE
,      ADJUSTED_RATE
,      PRODUCTION_CAPACITY
,      VENDOR_NAME
,      VENDOR_NUMBER
,      PO_NUMBER
,      INVOICE_NUMBER
,      INVOICE_ID
,      INVOICE_LINE_NUMBER
,      INVOICE_LINE_DESCRIPTION
,      INVOICE_COST
,      DISTRIBUTION_LINE_NUMBER
,      PRIOR_SOURCE_LINE_ID
,      INVOICE_DISTRIBUTION_ID
,      PO_DISTRIBUTION_ID
FROM APPS.FA_ASSET_INVOICES_V;

Dependencies

[top of page]

APPS.FA_ASSET_INVOICES_V references the following:

APPS: FA_ADDITIONS; FA_ASSET_INVOICES; FA_BOOKS; FA_BOOK_CONTROLS; FA_CATEGORIES_B; FA_LOOKUPS; PO_VENDORS

APPS.FA_ASSET_INVOICES_V is not referenced by any database object