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_DELETED_MASS_ADDITIONS

Object Details

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

FA_DELETED_MASS_ADDITIONS stores information about the mass
additions you do not want to post to Oracle Assets.
.
When you run the delete mass additions process, Oracle Assets
inserts a row into this table for each mass addition that has a
POSTING_STATUS of DELETE in FA_MASS_ADDITIONS and where
BOOK_TYPE_CODE matches the book you specified in the Delete Mass
Additions form.
.
When you run the mass additions purge process, Oracle Assets
deletes the records in this table where CREATE_BATCH_ID matches the
batch you specified in the Purge Mass Additions form.
.
.

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
FA_DELETED_MASS_ADDITIONS_U1	NORMAL	UNIQUE	APPS_TS_INTERFACE	MASS_ADDITION_ID

Columns

Name	Datatype	Length	Mandatory	Comments
INVOICE_ID	NUMBER	(15)		Invoice identification number
AP_DISTRIBUTION_LINE_NUMBER	NUMBER	(15)		Distribution line number in accounts payable
CREATE_BATCH_ID	NUMBER	(15)		Create mass additions unique request identification number
POST_BATCH_ID	NUMBER	(15)		Post mass addition unique request identification number
STATUS	VARCHAR2	(1)		Mass additions queue name
PAYABLES_CODE_COMBINATION_ID	NUMBER	(15)		Account debited in accounts payable
FEEDER_SYSTEM_NAME	VARCHAR2	(40)		Identifies the system which originated the mass addition
CREATE_BATCH_DATE	DATE			Standard Who column
INVOICE_DATE	DATE			Date of the invoice
PAYABLES_COST	NUMBER			Cost from accounts payable
PAYABLES_UNITS	NUMBER			Units from accounts payable
REVIEWER_COMMENTS	VARCHAR2	(60)		Comments
BOOK_TYPE_CODE	VARCHAR2	(15)		Name of the corporate book
DESCRIPTION	VARCHAR2	(80)		Description of the asset
MASS_ADDITION_ID	NUMBER	(15)	Yes	Identification number of the deleted mass addition
PROJECT_ASSET_LINE_ID	NUMBER	(15)		Identifier of the summarized asset cost line transferred from Oracle Projects to create this line.
PROJECT_ID	NUMBER	(15)		Identifier of the project from which the costs are collected, summarized, and transferred from Oracle Projects.
TASK_ID	NUMBER	(15)		Identifier of the task from which the costs were collected, summarized, and transferred from Oracle Projects. This column is only populated if the costs were summarized by task.
INVOICE_DISTRIBUTION_ID	NUMBER	(15)		Invoice distribution identifier
INVOICE_LINE_NUMBER	NUMBER			Invoice line number

Query Text

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


SELECT INVOICE_ID
,      AP_DISTRIBUTION_LINE_NUMBER
,      CREATE_BATCH_ID
,      POST_BATCH_ID
,      STATUS
,      PAYABLES_CODE_COMBINATION_ID
,      FEEDER_SYSTEM_NAME
,      CREATE_BATCH_DATE
,      INVOICE_DATE
,      PAYABLES_COST
,      PAYABLES_UNITS
,      REVIEWER_COMMENTS
,      BOOK_TYPE_CODE
,      DESCRIPTION
,      MASS_ADDITION_ID
,      PROJECT_ASSET_LINE_ID
,      PROJECT_ID
,      TASK_ID
,      INVOICE_DISTRIBUTION_ID
,      INVOICE_LINE_NUMBER
FROM FA.FA_DELETED_MASS_ADDITIONS;

Dependencies

[top of page]

FA.FA_DELETED_MASS_ADDITIONS does not reference any database object

FA.FA_DELETED_MASS_ADDITIONS is referenced by following:

FA: FA_DELETED_MASS_ADDITIONS#