DBA Data[Home] [Help] [Dependency Information]

TABLE: FA.FA_INV_COMPARE_REP_ITF

Object Details
Object Name: FA_INV_COMPARE_REP_ITF
Object Type: TABLE
Owner: FA
FND Design Data: TableOFA.FA_INV_COMPARE_REP_ITF
Subobject Name:
Status: VALID

Storage Details
Tablespace: TablespaceAPPS_TS_INTERFACE
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
FA_INV_COMPARE_REP_ITF_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnREQUEST_ID
Columns
Name Datatype Length Mandatory Comments
REQUEST_ID NUMBER
Yes
INVENTORY_NAME VARCHAR2 (80)
ASSET_NUMBER VARCHAR2 (15)
ASSET_KEY VARCHAR2 (240)
TAG_NUMBER VARCHAR2 (15)
DESCRIPTION VARCHAR2 (80)
MODEL_NUMBER VARCHAR2 (40)
SERIAL_NUMBER VARCHAR2 (35)
MANUFACTURER_NAME VARCHAR2 (30)
ASSET_CATEGORY VARCHAR2 (240)
UNITS NUMBER

LOCATION VARCHAR2 (240)
STATUS VARCHAR2 (80)
UNIT_RECONCILE_MTH_MEAN VARCHAR2 (80)
LOC_RECONCILE_MTH_MEAN VARCHAR2 (80)
CREATED_BY NUMBER (15)
CREATION_DATE DATE

LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER (15) Yes
LAST_UPDATE_LOGIN NUMBER (15)
Query Text

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


SELECT REQUEST_ID
,      INVENTORY_NAME
,      ASSET_NUMBER
,      ASSET_KEY
,      TAG_NUMBER
,      DESCRIPTION
,      MODEL_NUMBER
,      SERIAL_NUMBER
,      MANUFACTURER_NAME
,      ASSET_CATEGORY
,      UNITS
,      LOCATION
,      STATUS
,      UNIT_RECONCILE_MTH_MEAN
,      LOC_RECONCILE_MTH_MEAN
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
FROM FA.FA_INV_COMPARE_REP_ITF;

Dependencies

[top of page]

FA.FA_INV_COMPARE_REP_ITF does not reference any database object

FA.FA_INV_COMPARE_REP_ITF is referenced by following:

SchemaAPPS
SynonymFA_INV_COMPARE_REP_ITF