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

Object Details

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

View Type

A Business Intelligence System view

This shows accounts payable and purchasing information about assets.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
FIXED_ASSETS_COST	NUMBER			Cost of asset in Oracle Assets
PAYABLES_COST	NUMBER			Invoice cost from accounts payable
DESCRIPTION	VARCHAR2	(80)		Invoice line description
ASSET_ID	NUMBER	(15)	Yes	Asset identification number
PO_VENDOR_ID	NUMBER	(15)		Supplier identification number
PO_NUMBER	VARCHAR2	(20)		Purchase order number
INVOICE_NUMBER	VARCHAR2	(50)		Invoice number
INVOICE_DATE	DATE			Invoice date from accounts payable
INVOICE_ID	NUMBER	(15)		Invoice identification number
AP_DISTRIBUTION_LINE_NUMBER	NUMBER	(15)		Distribution line identification number
PROJECT_ID	NUMBER	(15)		Identifier of the project from which the costs are collected, summarized, and transferred from Oracle Projects.
TASK_ID	NUMBER	(15)		Identifier of the task from which costs are collected, summarized, and transferred from Oracle Projects. This column is only populated if the costs were summarized by task.
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who column
CREATED_BY	NUMBER	(15)		Standard Who column
CREATION_DATE	DATE			Standard Who column
INVOICE_LINE_NUMBER	NUMBER			Invoice line number
INVOICE_DISTRIBUTION_ID	NUMBER	(15)		Invoice distribution identifier

Query Text

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


SELECT FIXED_ASSETS_COST
,      PAYABLES_COST
,      DESCRIPTION
,      ASSET_ID
,      PO_VENDOR_ID
,      PO_NUMBER
,      INVOICE_NUMBER
,      INVOICE_DATE
,      INVOICE_ID
,      AP_DISTRIBUTION_LINE_NUMBER
,      PROJECT_ID
,      TASK_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATED_BY
,      CREATION_DATE
,      INVOICE_LINE_NUMBER
,      INVOICE_DISTRIBUTION_ID
FROM APPS.FABV_SRC_LNS;

Dependencies

[top of page]

APPS.FABV_SRC_LNS references the following:

APPS: FA_ASSET_INVOICES

APPS.FABV_SRC_LNS is not referenced by any database object