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_INV_INTERFACE_V

Object Details

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

[View Source]

Columns

Name	Datatype	Length	Mandatory
INVENTORY_NAME	VARCHAR2	(80)
ASSET_ID	NUMBER	(15)
ASSET_NUMBER	VARCHAR2	(15)
TAG_NUMBER	VARCHAR2	(15)
DESCRIPTION	VARCHAR2	(80)
MODEL_NUMBER	VARCHAR2	(40)
SERIAL_NUMBER	VARCHAR2	(35)
MANUFACTURER_NAME	VARCHAR2	(30)
UNITS	NUMBER
STATUS	VARCHAR2	(80)
UNIT_RECONCILE_MTH	VARCHAR2	(80)
LOC_RECONCILE_MTH	VARCHAR2	(80)
DISTRIBUTION_ID	NUMBER	(15)
INVENTORY_ID	NUMBER		Yes
RECONCILIATION_ID	NUMBER
LOC_SEGMENT1	VARCHAR2	(30)
LOC_SEGMENT2	VARCHAR2	(30)
LOC_SEGMENT3	VARCHAR2	(30)
LOC_SEGMENT4	VARCHAR2	(30)
LOC_SEGMENT5	VARCHAR2	(30)
LOC_SEGMENT6	VARCHAR2	(30)
LOC_SEGMENT7	VARCHAR2	(30)
CAT_SEGMENT1	VARCHAR2	(30)
CAT_SEGMENT2	VARCHAR2	(30)
CAT_SEGMENT3	VARCHAR2	(30)
CAT_SEGMENT4	VARCHAR2	(30)
CAT_SEGMENT5	VARCHAR2	(30)
CAT_SEGMENT6	VARCHAR2	(30)
CAT_SEGMENT7	VARCHAR2	(30)
KEY_SEGMENT1	VARCHAR2	(30)
KEY_SEGMENT2	VARCHAR2	(30)
KEY_SEGMENT3	VARCHAR2	(30)
KEY_SEGMENT4	VARCHAR2	(30)
KEY_SEGMENT5	VARCHAR2	(30)
KEY_SEGMENT6	VARCHAR2	(30)
KEY_SEGMENT7	VARCHAR2	(30)
KEY_SEGMENT8	VARCHAR2	(30)
KEY_SEGMENT9	VARCHAR2	(30)

Query Text

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


SELECT INVENTORY_NAME
,      ASSET_ID
,      ASSET_NUMBER
,      TAG_NUMBER
,      DESCRIPTION
,      MODEL_NUMBER
,      SERIAL_NUMBER
,      MANUFACTURER_NAME
,      UNITS
,      STATUS
,      UNIT_RECONCILE_MTH
,      LOC_RECONCILE_MTH
,      DISTRIBUTION_ID
,      INVENTORY_ID
,      RECONCILIATION_ID
,      LOC_SEGMENT1
,      LOC_SEGMENT2
,      LOC_SEGMENT3
,      LOC_SEGMENT4
,      LOC_SEGMENT5
,      LOC_SEGMENT6
,      LOC_SEGMENT7
,      CAT_SEGMENT1
,      CAT_SEGMENT2
,      CAT_SEGMENT3
,      CAT_SEGMENT4
,      CAT_SEGMENT5
,      CAT_SEGMENT6
,      CAT_SEGMENT7
,      KEY_SEGMENT1
,      KEY_SEGMENT2
,      KEY_SEGMENT3
,      KEY_SEGMENT4
,      KEY_SEGMENT5
,      KEY_SEGMENT6
,      KEY_SEGMENT7
,      KEY_SEGMENT8
,      KEY_SEGMENT9
FROM APPS.FA_INV_INTERFACE_V;

Dependencies

[top of page]

APPS.FA_INV_INTERFACE_V references the following:

APPS: FA_ASSET_KEYWORDS; FA_CATEGORIES; FA_DISTRIBUTION_HISTORY; FA_INV_INTERFACE; FA_LOCATIONS; FA_LOOKUPS

APPS.FA_INV_INTERFACE_V is not referenced by any database object