Skip to content

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

TABLE: FA.FA_TRANSFER_REP_ITF

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

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

Storage Details
Tablespace: TablespaceAPPS_TS_INTERFACE
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
FA_TRANSFER_REP_ITF_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnREQUEST_ID
Columns
Name Datatype Length Mandatory Comments
REQUEST_ID NUMBER

Concurrent request ID
ASSET_NUMBER VARCHAR2 (25)
User assigned asset number
DESCRIPTION VARCHAR2 (80)
Description of the asset
SERIAL_NUMBER VARCHAR2 (35)
Serial number of the asset
TAG_NUMBER VARCHAR2 (25)
Tag number of the asset
ASSET_KEY VARCHAR2 (240)
Asset key flexfield combination
TO_COMPANY VARCHAR2 (25)
Company to which asset is transferred
TO_COST_CENTER VARCHAR2 (25)
Cost center to which asset is transferred
TO_EXPENSE_ACCT VARCHAR2 (25)
Expense account to which asset is transferred
FROM_COMPANY VARCHAR2 (25)
Company from which asset is transferred
FROM_COST_CENTER VARCHAR2 (25)
Cost center from which asset was transferred
FROM_EXPENSE_ACCT VARCHAR2 (25)
Expense account from which asset was transferred
COST_ACCT VARCHAR2 (25)
Cost account of the asset
RESERVE_ACCT VARCHAR2 (25)
Reserve account of the asset
YTD_DEPRN NUMBER

Year-to-date depreciation of the asset
RESERVE NUMBER

Reserve of the asset
TRANSACTION_HEADER_ID NUMBER

Transaction header ID of the asset
MASS_TRANSFER_ID NUMBER

Mass transfer ID of the asset
TO_LOCATION VARCHAR2 (500)
Location to which asset was transferred
TO_EMPLOYEE_NAME VARCHAR2 (240)
Name of the employee to which asset was transferred
TO_EMPLOYEE_NUMBER VARCHAR2 (30)
Employee number of the employee to which the asset was transferred
FROM_LOCATION VARCHAR2 (500)
Location from which the asset was transferred
FROM_EMPLOYEE_NAME VARCHAR2 (240)
Name of the employee from which the asset was transferred
FROM_EMPLOYEE_NUMBER VARCHAR2 (30)
Employee number of the employee from which the asset was transferred
TRANSACTION_DATE DATE

Date of the mass transfer transaction
COST_TRANSFERRED NUMBER

Cost of asset transferred
RESERVE_TRANSFERRED NUMBER

Reserve of asset transferred
UNITS_TRANSFERRED NUMBER

Units of asset transferred
CREATED_BY NUMBER

Standard Who column
CREATION_DATE DATE

Standard Who column
LAST_UPDATED_BY NUMBER

Standard Who column
LAST_UPDATE_DATE DATE

Standard Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column
INVENTORIAL VARCHAR2 (3)
Indicates whether the asset should be included in physical inventory
ASSET_TYPE VARCHAR2 (15)
Indicates whether the asset is CIP, capitalized, expensed, or group.
Query Text

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


SELECT REQUEST_ID
,      ASSET_NUMBER
,      DESCRIPTION
,      SERIAL_NUMBER
,      TAG_NUMBER
,      ASSET_KEY
,      TO_COMPANY
,      TO_COST_CENTER
,      TO_EXPENSE_ACCT
,      FROM_COMPANY
,      FROM_COST_CENTER
,      FROM_EXPENSE_ACCT
,      COST_ACCT
,      RESERVE_ACCT
,      YTD_DEPRN
,      RESERVE
,      TRANSACTION_HEADER_ID
,      MASS_TRANSFER_ID
,      TO_LOCATION
,      TO_EMPLOYEE_NAME
,      TO_EMPLOYEE_NUMBER
,      FROM_LOCATION
,      FROM_EMPLOYEE_NAME
,      FROM_EMPLOYEE_NUMBER
,      TRANSACTION_DATE
,      COST_TRANSFERRED
,      RESERVE_TRANSFERRED
,      UNITS_TRANSFERRED
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      INVENTORIAL
,      ASSET_TYPE
FROM FA.FA_TRANSFER_REP_ITF;

Dependencies

[top of page]

FA.FA_TRANSFER_REP_ITF does not reference any database object

FA.FA_TRANSFER_REP_ITF is referenced by following:

SchemaFA
ViewFA_TRANSFER_REP_ITF#