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]

TABLE: FA.FA_MASS_EXTERNAL_TRANSFERS

Object Details

Object Name:	FA_MASS_EXTERNAL_TRANSFERS
Object Type:	TABLE
Owner:	FA
FND Design Data:	OFA.FA_MASS_EXTERNAL_TRANSFERS
Subobject Name:
Status:	VALID

Interface Table for Mass External Transfers.
Scope: public
Product: FA
Lifecycle: active
Display Name: FA Mass External Transfers
Category: BUSINESS_ENTITY FA_ASSET

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
FA_MASS_EXTERNAL_TRANSFERS_U1	NORMAL	UNIQUE	APPS_TS_INTERFACE	MASS_EXTERNAL_TRANSFER_ID
FA_MASS_EXTERNAL_TRANSFERS_N1	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	BOOK_TYPE_CODE TRANSACTION_TYPE TRANSACTION_STATUS BATCH_NAME
FA_MASS_EXTERNAL_TRANSFERS_N2	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	BATCH_NAME TRANSACTION_TYPE TRANSACTION_STATUS BOOK_TYPE_CODE
FA_MASS_EXTERNAL_TRANSFERS_N3	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	FROM_ASSET_ID BOOK_TYPE_CODE
FA_MASS_EXTERNAL_TRANSFERS_N4	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	TO_ASSET_ID BOOK_TYPE_CODE
FA_MASS_EXTERNAL_TRANSFERS_N5	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	FROM_GROUP_ASSET_ID BOOK_TYPE_CODE BATCH_NAME
FA_MASS_EXTERNAL_TRANSFERS_N6	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	TO_GROUP_ASSET_ID BOOK_TYPE_CODE BATCH_NAME

Columns

Name	Datatype	Length	Mandatory	Comments
BATCH_NAME	VARCHAR2	(15)	Yes	Name of Batch
MASS_EXTERNAL_TRANSFER_ID	NUMBER	(15)	Yes	System-generated identifier of the external transfer
EXTERNAL_REFERENCE_NUM	VARCHAR2	(15)		Reference number used by external system
TRANSACTION_REFERENCE_NUM	NUMBER	(15)		Indicates the order of transactions for the same asset_id
TRANSACTION_TYPE	VARCHAR2	(15)	Yes	Type of Transaction for this record: 'ADJUSTMENT' for a source line transfer or 'TRANSFER' for an asset transfer.
FROM_ASSET_ID	NUMBER	(15)		Source Asset for Source Line transfer. Applicable to ADJUSTMENT transaction only.
TO_ASSET_ID	NUMBER	(15)		Destination Asset for Source Line transfer. Applicable to ADJUSTMENT transaction only.
BOOK_TYPE_CODE	VARCHAR2	(15)		Corporate Book Type Code
TRANSACTION_STATUS	VARCHAR2	(20)	Yes	Status of Transaction: New, Post, Posted, On Hold, Delete or Error
TRANSACTION_DATE_ENTERED	DATE			Date of when this transaction is entered into Oracle Assets
FROM_DISTRIBUTION_ID	NUMBER	(15)		Originating Distribution ID. Applicable to TRANSFER transaction only.
FROM_LOCATION_ID	NUMBER	(15)		Originating Location ID. Applicable to TRANSFER transaction only.
FROM_GL_CCID	NUMBER	(15)		Originating GL Code Combination ID. Applicable to TRANSFER transaction only.
FROM_EMPLOYEE_ID	NUMBER	(15)		Originating Employee ID. Applicable to TRANSFER transaction only.
TO_DISTRIBUTION_ID	NUMBER	(15)		Destination Distribution ID. Applicable to TRANSFER transaction only.
TO_LOCATION_ID	NUMBER	(15)		Destination Location ID. Applicable to TRANSFER transaction only.
TO_GL_CCID	NUMBER	(15)		Destination GL Code Combination ID. Applicable to TRANSFER transaction only.
TO_EMPLOYEE_ID	NUMBER	(15)		Destination Employee ID. Applicable to TRANSFER transaction only.
DESCRIPTION	VARCHAR2	(200)		Description of Transaction
TRANSFER_UNITS	NUMBER			Number of Asset Units to Transfer. Applicable to TRANSFER transaction only.
TRANSFER_AMOUNT	NUMBER			Amount of Cost to Transfer. Applicable to ADJUSTMENT transaction only.
SOURCE_LINE_ID	NUMBER	(15)		Source Line Identifier. Applicable to ADJUSTMENT transaction only.
CREATED_BY	NUMBER	(15)	Yes	Standard Who
CREATION_DATE	DATE		Yes	Standard Who
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who
LAST_UPDATE_DATE	DATE		Yes	Standard Who
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who
LAST_UPDATED_DATE	DATE		Yes	OBSOLETE
TRX_ATTRIBUTE1	VARCHAR2	(150)
TRX_ATTRIBUTE2	VARCHAR2	(150)
TRX_ATTRIBUTE3	VARCHAR2	(150)
TRX_ATTRIBUTE4	VARCHAR2	(150)
TRX_ATTRIBUTE5	VARCHAR2	(150)
TRX_ATTRIBUTE6	VARCHAR2	(150)
TRX_ATTRIBUTE7	VARCHAR2	(150)
TRX_ATTRIBUTE8	VARCHAR2	(150)
TRX_ATTRIBUTE9	VARCHAR2	(150)
TRX_ATTRIBUTE10	VARCHAR2	(150)
TRX_ATTRIBUTE11	VARCHAR2	(150)
TRX_ATTRIBUTE12	VARCHAR2	(150)
TRX_ATTRIBUTE13	VARCHAR2	(150)
TRX_ATTRIBUTE14	VARCHAR2	(150)
TRX_ATTRIBUTE15	VARCHAR2	(150)
TRX_ATTRIBUTE_CATEGORY_CODE	VARCHAR2	(30)
POST_BATCH_ID	NUMBER	(15)		Unique identifier for a Post Mass External Transfer or Post Source Line Transfer request
TH_ATTRIBUTE_CATEGORY	VARCHAR2	(30)
TH_ATTRIBUTE1	VARCHAR2	(150)
TH_ATTRIBUTE2	VARCHAR2	(150)
TH_ATTRIBUTE3	VARCHAR2	(150)
TH_ATTRIBUTE4	VARCHAR2	(150)
TH_ATTRIBUTE5	VARCHAR2	(150)
TH_ATTRIBUTE6	VARCHAR2	(150)
TH_ATTRIBUTE7	VARCHAR2	(150)
TH_ATTRIBUTE8	VARCHAR2	(150)
TH_ATTRIBUTE9	VARCHAR2	(150)
TH_ATTRIBUTE10	VARCHAR2	(150)
TH_ATTRIBUTE11	VARCHAR2	(150)
TH_ATTRIBUTE12	VARCHAR2	(150)
TH_ATTRIBUTE13	VARCHAR2	(150)
TH_ATTRIBUTE14	VARCHAR2	(150)
TH_ATTRIBUTE15	VARCHAR2	(150)
ATTRIBUTE_CATEGORY	VARCHAR2	(30)
ATTRIBUTE1	VARCHAR2	(150)		Descriptive flexfield segments
ATTRIBUTE2	VARCHAR2	(150)		Descriptive flexfield segments
ATTRIBUTE3	VARCHAR2	(150)		Descriptive flexfield segments
ATTRIBUTE4	VARCHAR2	(150)		Descriptive flexfield segments
ATTRIBUTE5	VARCHAR2	(150)		Descriptive flexfield segments
ATTRIBUTE6	VARCHAR2	(150)		Descriptive flexfield segments
ATTRIBUTE7	VARCHAR2	(150)		Descriptive flexfield segments
ATTRIBUTE8	VARCHAR2	(150)		Descriptive flexfield segments
ATTRIBUTE9	VARCHAR2	(150)		Descriptive flexfield segments
ATTRIBUTE10	VARCHAR2	(150)		Descriptive flexfield segments
ATTRIBUTE11	VARCHAR2	(150)		Descriptive flexfield segments
ATTRIBUTE12	VARCHAR2	(150)		Descriptive flexfield segments
ATTRIBUTE13	VARCHAR2	(150)		Descriptive flexfield segments
ATTRIBUTE14	VARCHAR2	(150)		Descriptive flexfield segments
ATTRIBUTE15	VARCHAR2	(150)		Descriptive flexfield segments
ATTRIBUTE_CATEGORY_CODE	VARCHAR2	(30)		Descriptive flexfield structure defining column
WORKER_ID	NUMBER	(15)		When the program is run in parallel, this is the worker that is processing the asset. The worker number corresponds to the sequence number assigned by the pogram, which is used to match assets with available processors.
FROM_GROUP_ASSET_ID	NUMBER	(15)		Reserved for system use. Do not use
TO_GROUP_ASSET_ID	NUMBER	(15)		Reserved for system use. Do not use

Query Text

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


SELECT BATCH_NAME
,      MASS_EXTERNAL_TRANSFER_ID
,      EXTERNAL_REFERENCE_NUM
,      TRANSACTION_REFERENCE_NUM
,      TRANSACTION_TYPE
,      FROM_ASSET_ID
,      TO_ASSET_ID
,      BOOK_TYPE_CODE
,      TRANSACTION_STATUS
,      TRANSACTION_DATE_ENTERED
,      FROM_DISTRIBUTION_ID
,      FROM_LOCATION_ID
,      FROM_GL_CCID
,      FROM_EMPLOYEE_ID
,      TO_DISTRIBUTION_ID
,      TO_LOCATION_ID
,      TO_GL_CCID
,      TO_EMPLOYEE_ID
,      DESCRIPTION
,      TRANSFER_UNITS
,      TRANSFER_AMOUNT
,      SOURCE_LINE_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      LAST_UPDATED_DATE
,      TRX_ATTRIBUTE1
,      TRX_ATTRIBUTE2
,      TRX_ATTRIBUTE3
,      TRX_ATTRIBUTE4
,      TRX_ATTRIBUTE5
,      TRX_ATTRIBUTE6
,      TRX_ATTRIBUTE7
,      TRX_ATTRIBUTE8
,      TRX_ATTRIBUTE9
,      TRX_ATTRIBUTE10
,      TRX_ATTRIBUTE11
,      TRX_ATTRIBUTE12
,      TRX_ATTRIBUTE13
,      TRX_ATTRIBUTE14
,      TRX_ATTRIBUTE15
,      TRX_ATTRIBUTE_CATEGORY_CODE
,      POST_BATCH_ID
,      TH_ATTRIBUTE_CATEGORY
,      TH_ATTRIBUTE1
,      TH_ATTRIBUTE2
,      TH_ATTRIBUTE3
,      TH_ATTRIBUTE4
,      TH_ATTRIBUTE5
,      TH_ATTRIBUTE6
,      TH_ATTRIBUTE7
,      TH_ATTRIBUTE8
,      TH_ATTRIBUTE9
,      TH_ATTRIBUTE10
,      TH_ATTRIBUTE11
,      TH_ATTRIBUTE12
,      TH_ATTRIBUTE13
,      TH_ATTRIBUTE14
,      TH_ATTRIBUTE15
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE_CATEGORY_CODE
,      WORKER_ID
,      FROM_GROUP_ASSET_ID
,      TO_GROUP_ASSET_ID
FROM FA.FA_MASS_EXTERNAL_TRANSFERS;

Dependencies

[top of page]

FA.FA_MASS_EXTERNAL_TRANSFERS does not reference any database object

FA.FA_MASS_EXTERNAL_TRANSFERS is referenced by following:

FA: FA_MASS_EXTERNAL_TRANSFERS#