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_UPDATE_BATCH_HEADERS

Object Details

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

Contains header information for a mass update. Describes the parameters and selection criteria for the update.

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
FA_MASS_UPDATE_BATCH_HDRS_U1	NORMAL	UNIQUE	APPS_TS_INTERFACE	BATCH_ID

Columns

Name	Datatype	Length	Mandatory	Comments
BATCH_ID	NUMBER		Yes	System generated identifier of a batch
BATCH_NUMBER	VARCHAR2	(30)	Yes	Batch Number
CREATED_BY	NUMBER		Yes	Standard WHO column.
CREATION_DATE	DATE		Yes	Standard WHO column.
LAST_UPDATED_BY	NUMBER		Yes	Standard WHO column.
LAST_UPDATE_DATE	DATE		Yes	Standard WHO column.
LAST_UPDATE_LOGIN	NUMBER			Standard WHO column.
BOOK_TYPE_CODE	VARCHAR2	(15)	Yes	Identifier of the Corporate Book for which the Event took place
STATUS_CODE	VARCHAR2	(2)		Status of the batch: 'P' - Pending 'IP' - In Process, 'PP' - Partially Processed, 'CP' - Completely Processed 'R' - Rejected
EVENT_CODE	VARCHAR2	(30)		Event that triggers the creation of the batch: 'CHANGE_NODE_PARENT' - Change Parent of a Node in the Asset Hierarchy, 'CHANGE_NODE_ATTRIBUTE' - Change Attribute Value on Node in the Asset Hierarchy, 'CHANGE_NODE_RULE_SET' - Change Rule Set on a Node in an Asset Hierarchy, 'CHANGE_ASSET_LEASE' - Change Lease on an Asset, 'CHANGE_ASSET_PARENT' - Change Parent Of An Asset, 'CHANGE_ASSET_CATEGORY' - Change Asset Category on an Asset, 'CHANGE_LEASE_LIFE_END_DATE' - Change Life End Date on a Lease, 'CHANGE_CATEGORY_LIFE' - Change Life On Asset Category, 'CHANGE_CATEGORY_LIFE_END_DATE' - Change Life End Date On Asset Category, 'CHANGE_CATEGORY_RULE_SET' - Change Rule Set on Asset Category
SOURCE_ENTITY_NAME	VARCHAR2	(30)		The type of the source entity: 'NODE' - Parent Node, 'ASSET' - Asset, 'LEASE' - Lease Number, 'CATEGORY' - Asset Category
SOURCE_ENTITY_KEY_VALUE	VARCHAR2	(30)		The value of the source entity triggering the event
SOURCE_ATTRIBUTE_NAME	VARCHAR2	(30)		The name of the source attribute : 'PARENT' - Parent Node, 'CATEGORY' - Asset Category, 'DISTRIBUTION'- Distribution Set, 'SERIAL_NUMBER' - Serial Number, 'LEASE_NUMBER' - Lease Number, 'ASSET_KEY' - Asset Key, 'RULE_SET' - Rule Set, 'LEASE_END_DATE' - Lease End Date, 'LIFE' - Life, 'LIFE_END_DATE'- Life End Date
SOURCE_ATTRIBUTE_OLD_ID	VARCHAR2	(30)		Identifier of the source attribute before the event was triggered
SOURCE_ATTRIBUTE_NEW_ID	VARCHAR2	(30)		Identifier of the source attribute after the event was triggered
DESCRIPTION	VARCHAR2	(50)		Description of the batch created
AMORTIZE_FLAG	VARCHAR2	(3)		Indicates whether to use Amortization Date: 'Y'- Amortize, 'N' - Expense
AMORTIZATION_DATE	DATE			Date of Amortization
REJECTION_REASON_CODE	VARCHAR2	(30)		Reason the Batch was Rejected
CONCURRENT_REQUEST_ID	NUMBER			Concurrent request Id of the run which created this record
TRANSACTION_NAME	VARCHAR2	(30)		Transaction name
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Attribute category
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.

Query Text

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


SELECT BATCH_ID
,      BATCH_NUMBER
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      BOOK_TYPE_CODE
,      STATUS_CODE
,      EVENT_CODE
,      SOURCE_ENTITY_NAME
,      SOURCE_ENTITY_KEY_VALUE
,      SOURCE_ATTRIBUTE_NAME
,      SOURCE_ATTRIBUTE_OLD_ID
,      SOURCE_ATTRIBUTE_NEW_ID
,      DESCRIPTION
,      AMORTIZE_FLAG
,      AMORTIZATION_DATE
,      REJECTION_REASON_CODE
,      CONCURRENT_REQUEST_ID
,      TRANSACTION_NAME
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
FROM FA.FA_MASS_UPDATE_BATCH_HEADERS;

Dependencies

[top of page]

FA.FA_MASS_UPDATE_BATCH_HEADERS does not reference any database object

FA.FA_MASS_UPDATE_BATCH_HEADERS is referenced by following:

FA: FA_MASS_UPDATE_BATCH_HEADERS#