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_TRANSFERS

Object Details

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

FA_MASS_TRANSFERS stores information about your mass transfer
Requests. Oracle Assets uses this information to run a concurrent
process that updates the location, Accounting Flexfield, and
employee information for a group of assets.
.
When you define a mass transfer request using the Mass Transfers
form, Oracle Assets inserts a row that stores your transfer
criteria into this table. It uses this information to
generate the Mass Transfer Preview Report so you can preview the
results of the mass transfer before you initiate it. When you
perform the mass transfer, it uses this table to
transfer your assets.
.
MASS_TRANSFER_ID identifies each mass transfer transaction.
.
CONCURRENT_REQUEST_ID identifies the concurrent request Oracle
Assets submits when you perform a mass transfer.
.
.

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
FA_MASS_TRANSFERS_U1	NORMAL	UNIQUE	APPS_TS_INTERFACE	MASS_TRANSFER_ID

Columns

Name	Datatype	Length	Mandatory	Comments
MASS_TRANSFER_ID	NUMBER	(15)	Yes	Mass transfer unique identification number
BOOK_TYPE_CODE	VARCHAR2	(15)	Yes	Book associated with the transfer
TRANSACTION_DATE_ENTERED	DATE		Yes	Date when the transaction occurred
DATE_EFFECTIVE	DATE		Yes	System date when the transaction was entered into Oracle Assets
CONCURRENT_REQUEST_ID	NUMBER	(15)		Concurrent request identification number for the mass transfer
FROM_LOCATION_ID	NUMBER	(15)		Identifies location from which to transfer
TO_LOCATION_ID	NUMBER	(15)		Identifies location into which to transfer
FROM_GL_CCID	NUMBER	(15)		Identifies the code combination for the account from which to transfer
TO_GL_CCID	NUMBER	(15)		Identifies the code combination for the account into which to transfer
FROM_EMPLOYEE_ID	NUMBER	(15)		Identifies the employee from whom to transfer
TO_EMPLOYEE_ID	NUMBER	(15)		Identifies the employee to whom to transfer
DESCRIPTION	VARCHAR2	(200)		Description of the transaction
ATTRIBUTE1	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE2	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE3	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE4	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE5	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE6	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE7	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE8	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE9	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE10	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE11	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE12	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE13	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE14	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE15	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE_CATEGORY_CODE	VARCHAR2	(30)		Descriptive flexfield structure defining column
SEGMENT1_LOW	VARCHAR2	(25)		Lower limit on expense account segment.
SEGMENT2_LOW	VARCHAR2	(25)		Lower limit on expense account segment.
SEGMENT3_LOW	VARCHAR2	(25)		Lower limit on expense account segment.
SEGMENT4_LOW	VARCHAR2	(25)		Lower limit on expense account segment.
SEGMENT5_LOW	VARCHAR2	(25)		Lower limit on expense account segment.
SEGMENT6_LOW	VARCHAR2	(25)		Lower limit on expense account segment.
SEGMENT7_LOW	VARCHAR2	(25)		Lower limit on expense account segment.
SEGMENT8_LOW	VARCHAR2	(25)		Lower limit on expense account segment.
SEGMENT9_LOW	VARCHAR2	(25)		Lower limit on expense account segment.
SEGMENT10_LOW	VARCHAR2	(25)		Lower limit on expense account segment.
SEGMENT11_LOW	VARCHAR2	(25)		Lower limit on expense account segment.
SEGMENT12_LOW	VARCHAR2	(25)		Lower limit on expense account segment.
SEGMENT13_LOW	VARCHAR2	(25)		Lower limit on expense account segment.
SEGMENT14_LOW	VARCHAR2	(25)		Lower limit on expense account segment.
SEGMENT15_LOW	VARCHAR2	(25)		Lower limit on expense account segment.
SEGMENT16_LOW	VARCHAR2	(25)		Lower limit on expense account segment.
SEGMENT17_LOW	VARCHAR2	(25)		Lower limit on expense account segment.
SEGMENT18_LOW	VARCHAR2	(25)		Lower limit on expense account segment.
SEGMENT19_LOW	VARCHAR2	(25)		Lower limit on expense account segment.
SEGMENT20_LOW	VARCHAR2	(25)		Lower limit on expense account segment.
SEGMENT21_LOW	VARCHAR2	(25)		Lower limit on expense account segment.
SEGMENT22_LOW	VARCHAR2	(25)		Lower limit on expense account segment.
SEGMENT23_LOW	VARCHAR2	(25)		Lower limit on expense account segment.
SEGMENT24_LOW	VARCHAR2	(25)		Lower limit on expense account segment.
SEGMENT25_LOW	VARCHAR2	(25)		Lower limit on expense account segment.
SEGMENT26_LOW	VARCHAR2	(25)		Lower limit on expense account segment.
SEGMENT27_LOW	VARCHAR2	(25)		Lower limit on expense account segment.
SEGMENT28_LOW	VARCHAR2	(25)		Lower limit on expense account segment.
SEGMENT29_LOW	VARCHAR2	(25)		Lower limit on expense account segment.
SEGMENT30_LOW	VARCHAR2	(25)		Lower limit on expense account segment.
SEGMENT1_HIGH	VARCHAR2	(25)		Upper limit on expense account segment.
SEGMENT2_HIGH	VARCHAR2	(25)		Upper limit on expense account segment.
SEGMENT3_HIGH	VARCHAR2	(25)		Upper limit on expense account segment.
SEGMENT4_HIGH	VARCHAR2	(25)		Upper limit on expense account segment.
SEGMENT5_HIGH	VARCHAR2	(25)		Upper limit on expense account segment.
SEGMENT6_HIGH	VARCHAR2	(25)		Upper limit on expense account segment.
SEGMENT7_HIGH	VARCHAR2	(25)		Upper limit on expense account segment.
SEGMENT8_HIGH	VARCHAR2	(25)		Upper limit on expense account segment.
SEGMENT9_HIGH	VARCHAR2	(25)		Upper limit on expense account segment.
SEGMENT10_HIGH	VARCHAR2	(25)		Upper limit on expense account segment.
SEGMENT11_HIGH	VARCHAR2	(25)		Upper limit on expense account segment.
SEGMENT12_HIGH	VARCHAR2	(25)		Upper limit on expense account segment.
SEGMENT13_HIGH	VARCHAR2	(25)		Upper limit on expense account segment.
SEGMENT14_HIGH	VARCHAR2	(25)		Upper limit on expense account segment.
SEGMENT15_HIGH	VARCHAR2	(25)		Upper limit on expense account segment.
SEGMENT16_HIGH	VARCHAR2	(25)		Upper limit on expense account segment.
SEGMENT17_HIGH	VARCHAR2	(25)		Upper limit on expense account segment.
SEGMENT18_HIGH	VARCHAR2	(25)		Upper limit on expense account segment.
SEGMENT19_HIGH	VARCHAR2	(25)		Upper limit on expense account segment.
SEGMENT20_HIGH	VARCHAR2	(25)		Upper limit on expense account segment.
SEGMENT21_HIGH	VARCHAR2	(25)		Upper limit on expense account segment.
SEGMENT22_HIGH	VARCHAR2	(25)		Upper limit on expense account segment.
SEGMENT23_HIGH	VARCHAR2	(25)		Upper limit on expense account segment.
SEGMENT24_HIGH	VARCHAR2	(25)		Upper limit on expense account segment.
SEGMENT25_HIGH	VARCHAR2	(25)		Upper limit on expense account segment.
SEGMENT26_HIGH	VARCHAR2	(25)		Upper limit on expense account segment.
SEGMENT27_HIGH	VARCHAR2	(25)		Upper limit on expense account segment.
SEGMENT28_HIGH	VARCHAR2	(25)		Upper limit on expense account segment.
SEGMENT29_HIGH	VARCHAR2	(25)		Upper limit on expense account segment.
SEGMENT30_HIGH	VARCHAR2	(25)		Upper limit on expense account segment.
SEGMENT1	VARCHAR2	(25)		Accounting Flexfield segment column
SEGMENT2	VARCHAR2	(25)		Accounting Flexfield segment column
SEGMENT3	VARCHAR2	(25)		Accounting Flexfield segment column
SEGMENT4	VARCHAR2	(25)		Accounting Flexfield segment column
SEGMENT5	VARCHAR2	(25)		Accounting Flexfield segment column
SEGMENT6	VARCHAR2	(25)		Accounting Flexfield segment column
SEGMENT7	VARCHAR2	(25)		Accounting Flexfield segment column
SEGMENT8	VARCHAR2	(25)		Accounting Flexfield segment column
SEGMENT9	VARCHAR2	(25)		Accounting Flexfield segment column
SEGMENT10	VARCHAR2	(25)		Accounting Flexfield segment column
SEGMENT11	VARCHAR2	(25)		Accounting Flexfield segment column
SEGMENT12	VARCHAR2	(25)		Accounting Flexfield segment column
SEGMENT13	VARCHAR2	(25)		Accounting Flexfield segment column
SEGMENT14	VARCHAR2	(25)		Accounting Flexfield segment column
SEGMENT15	VARCHAR2	(25)		Accounting Flexfield segment column
SEGMENT16	VARCHAR2	(25)		Accounting Flexfield segment column
SEGMENT17	VARCHAR2	(25)		Accounting Flexfield segment column
SEGMENT18	VARCHAR2	(25)		Accounting Flexfield segment column
SEGMENT19	VARCHAR2	(25)		Accounting Flexfield segment column
SEGMENT20	VARCHAR2	(25)		Accounting Flexfield segment column
SEGMENT21	VARCHAR2	(25)		Accounting Flexfield segment column
SEGMENT22	VARCHAR2	(25)		Accounting Flexfield segment column
SEGMENT23	VARCHAR2	(25)		Accounting Flexfield segment column
SEGMENT24	VARCHAR2	(25)		Accounting Flexfield segment column
SEGMENT25	VARCHAR2	(25)		Accounting Flexfield segment column
SEGMENT26	VARCHAR2	(25)		Accounting Flexfield segment column
SEGMENT27	VARCHAR2	(25)		Accounting Flexfield segment column
SEGMENT28	VARCHAR2	(25)		Accounting Flexfield segment column
SEGMENT29	VARCHAR2	(25)		Accounting Flexfield segment column
SEGMENT30	VARCHAR2	(25)		Accounting Flexfield segment column
CATEGORY_ID	NUMBER	(15)		Identifies the category which is one of several selecion criteria used to select assets to transfer.

Query Text

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


SELECT MASS_TRANSFER_ID
,      BOOK_TYPE_CODE
,      TRANSACTION_DATE_ENTERED
,      DATE_EFFECTIVE
,      CONCURRENT_REQUEST_ID
,      FROM_LOCATION_ID
,      TO_LOCATION_ID
,      FROM_GL_CCID
,      TO_GL_CCID
,      FROM_EMPLOYEE_ID
,      TO_EMPLOYEE_ID
,      DESCRIPTION
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE_CATEGORY_CODE
,      SEGMENT1_LOW
,      SEGMENT2_LOW
,      SEGMENT3_LOW
,      SEGMENT4_LOW
,      SEGMENT5_LOW
,      SEGMENT6_LOW
,      SEGMENT7_LOW
,      SEGMENT8_LOW
,      SEGMENT9_LOW
,      SEGMENT10_LOW
,      SEGMENT11_LOW
,      SEGMENT12_LOW
,      SEGMENT13_LOW
,      SEGMENT14_LOW
,      SEGMENT15_LOW
,      SEGMENT16_LOW
,      SEGMENT17_LOW
,      SEGMENT18_LOW
,      SEGMENT19_LOW
,      SEGMENT20_LOW
,      SEGMENT21_LOW
,      SEGMENT22_LOW
,      SEGMENT23_LOW
,      SEGMENT24_LOW
,      SEGMENT25_LOW
,      SEGMENT26_LOW
,      SEGMENT27_LOW
,      SEGMENT28_LOW
,      SEGMENT29_LOW
,      SEGMENT30_LOW
,      SEGMENT1_HIGH
,      SEGMENT2_HIGH
,      SEGMENT3_HIGH
,      SEGMENT4_HIGH
,      SEGMENT5_HIGH
,      SEGMENT6_HIGH
,      SEGMENT7_HIGH
,      SEGMENT8_HIGH
,      SEGMENT9_HIGH
,      SEGMENT10_HIGH
,      SEGMENT11_HIGH
,      SEGMENT12_HIGH
,      SEGMENT13_HIGH
,      SEGMENT14_HIGH
,      SEGMENT15_HIGH
,      SEGMENT16_HIGH
,      SEGMENT17_HIGH
,      SEGMENT18_HIGH
,      SEGMENT19_HIGH
,      SEGMENT20_HIGH
,      SEGMENT21_HIGH
,      SEGMENT22_HIGH
,      SEGMENT23_HIGH
,      SEGMENT24_HIGH
,      SEGMENT25_HIGH
,      SEGMENT26_HIGH
,      SEGMENT27_HIGH
,      SEGMENT28_HIGH
,      SEGMENT29_HIGH
,      SEGMENT30_HIGH
,      SEGMENT1
,      SEGMENT2
,      SEGMENT3
,      SEGMENT4
,      SEGMENT5
,      SEGMENT6
,      SEGMENT7
,      SEGMENT8
,      SEGMENT9
,      SEGMENT10
,      SEGMENT11
,      SEGMENT12
,      SEGMENT13
,      SEGMENT14
,      SEGMENT15
,      SEGMENT16
,      SEGMENT17
,      SEGMENT18
,      SEGMENT19
,      SEGMENT20
,      SEGMENT21
,      SEGMENT22
,      SEGMENT23
,      SEGMENT24
,      SEGMENT25
,      SEGMENT26
,      SEGMENT27
,      SEGMENT28
,      SEGMENT29
,      SEGMENT30
,      CATEGORY_ID
FROM FA.FA_MASS_TRANSFERS;

Dependencies

[top of page]

FA.FA_MASS_TRANSFERS does not reference any database object

FA.FA_MASS_TRANSFERS is referenced by following:

FA: FA_MASS_TRANSFERS#