[Home] [Help] [Dependency Information]
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.
Tablespace: | APPS_TS_INTERFACE |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
FA_MASS_UPDATE_BATCH_HDRS_U1 | NORMAL | UNIQUE | APPS_TS_INTERFACE | BATCH_ID |
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. |
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;
FA.FA_MASS_UPDATE_BATCH_HEADERS does not reference any database object
FA.FA_MASS_UPDATE_BATCH_HEADERS is referenced by following:
|
|
|