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 Source]

Columns

Name	Datatype	Length	Mandatory
ASSET_NUMBER	VARCHAR2	(15)	Yes
TAG_NUMBER	VARCHAR2	(15)
DESCRIPTION	VARCHAR2	(80)
ASSET_TYPE	VARCHAR2	(80)
MANUFACTURER_NAME	VARCHAR2	(30)
SERIAL_NUMBER	VARCHAR2	(35)
MODEL_NUMBER	VARCHAR2	(40)
MAJOR_CATEGORY	VARCHAR2	(30)
SUB_CATEGORY	VARCHAR2	(30)
BOOK_TYPE_CODE	VARCHAR2	(15)	Yes
DATE_PLACED_IN_SERVICE	DATE		Yes
DEPRN_METHOD_CODE	VARCHAR2	(12)	Yes
LIFE_IN_MONTHS	NUMBER	(4)
SALVAGE_VALUE	NUMBER		Yes
ADJUSTED_RATE	NUMBER
PRODUCTION_CAPACITY	NUMBER
VENDOR_NAME	VARCHAR2	(240)
VENDOR_NUMBER	VARCHAR2	(30)	Yes
PO_NUMBER	VARCHAR2	(20)
INVOICE_NUMBER	VARCHAR2	(50)
INVOICE_ID	NUMBER	(15)
INVOICE_LINE_NUMBER	NUMBER
INVOICE_LINE_DESCRIPTION	VARCHAR2	(80)
INVOICE_COST	NUMBER
DISTRIBUTION_LINE_NUMBER	NUMBER	(15)
PRIOR_SOURCE_LINE_ID	NUMBER	(15)
INVOICE_DISTRIBUTION_ID	NUMBER	(15)
PO_DISTRIBUTION_ID	NUMBER	(15)

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