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

Columns

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_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