[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | FA_MASS_RECLASS |
|---|---|
| Object Type: | TABLE |
| Owner: | FA |
| FND Design Data: |  OFA.FA_MASS_RECLASS
|
| Subobject Name: | |
| Status: | VALID |
FA_MASS_RECLASS stores asset selection and reclass criteria for mass
reclassification requests.
.
When you define a mass reclass request using the Mass Reclass
form, Oracle Assets inserts a row that stores your reclass
criteria into this table.
| Tablespace: |  APPS_TS_INTERFACE |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| FA_MASS_RECLASS_U1 | NORMAL | UNIQUE |
APPS_TS_INTERFACE
|
 MASS_RECLASS_ID
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| MASS_RECLASS_ID | NUMBER | (15) | Yes | Unique mass reclass identification |
| BOOK_TYPE_CODE | VARCHAR2 | (15) | Yes | Book name |
| TRANSACTION_DATE_ENTERED | DATE | Yes | Date when transaction occurred | |
| DATE_EFFECTIVE | DATE | Yes | System date when the transaction was entered into Oracle Assets | |
| STATUS | VARCHAR2 | (10) | Yes | Either NEW, PREVIEWED, UPDATED, PREVIEW, RUNNING, or COMPLETED |
| CONCURRENT_REQUEST_ID | NUMBER | (15) | Last concurrent request identification number for the mass reclass | |
| DESCRIPTION | VARCHAR2 | (80) | Description of the reclass transaction | |
| ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
| ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
| ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
| ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
| ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
| ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
| ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
| ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
| ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
| ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
| ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
| ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
| ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
| ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
| ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
| ATTRIBUTE_CATEGORY_CODE | VARCHAR2 | (30) | Descriptive Flexfield structure defining column | |
| ASSET_TYPE | VARCHAR2 | (11) | Indicates whether the asset is CIP, capitalized, or expensed | |
| LOCATION_ID | NUMBER | (15) | Location flexfield identification number | |
| EMPLOYEE_ID | NUMBER | (15) | Employee identification number | |
| ASSET_KEY_ID | NUMBER | (15) | Identifies an asset key flexfield combination for assets to reclass | |
| FROM_COST | NUMBER | Lower limit of asset cost range | ||
| TO_COST | NUMBER | Upper limit of asset cost range | ||
| FROM_ASSET_NUMBER | VARCHAR2 | (15) | First asset number in the range to reclass | |
| TO_ASSET_NUMBER | VARCHAR2 | (15) | Last asset number in the range to reclass | |
| FROM_DATE_PLACED_IN_SERVICE | DATE | First date placed in service to reclass | ||
| TO_DATE_PLACED_IN_SERVICE | DATE | Last date placed in service to reclass | ||
| FROM_CATEGORY_ID | NUMBER | (15) | Identifies asset category to reclass | |
| TO_CATEGORY_ID | NUMBER | (15) | Yes | Identifies new asset category after reclass |
| SEGMENT1_LOW | VARCHAR2 | (25) | Lower limit on expense account Segment column | |
| SEGMENT2_LOW | VARCHAR2 | (25) | Lower limit on expense account Segment column | |
| SEGMENT3_LOW | VARCHAR2 | (25) | Lower limit on expense account Segment column | |
| SEGMENT4_LOW | VARCHAR2 | (25) | Lower limit on expense account Segment column | |
| SEGMENT5_LOW | VARCHAR2 | (25) | Lower limit on expense account Segment column | |
| SEGMENT6_LOW | VARCHAR2 | (25) | Lower limit on expense account Segment column | |
| SEGMENT7_LOW | VARCHAR2 | (25) | Lower limit on expense account Segment column | |
| SEGMENT8_LOW | VARCHAR2 | (25) | Lower limit on expense account Segment column | |
| SEGMENT9_LOW | VARCHAR2 | (25) | Lower limit on expense account Segment column | |
| SEGMENT10_LOW | VARCHAR2 | (25) | Lower limit on expense account Segment column | |
| SEGMENT11_LOW | VARCHAR2 | (25) | Lower limit on expense account Segment column | |
| SEGMENT12_LOW | VARCHAR2 | (25) | Lower limit on expense account Segment column | |
| SEGMENT13_LOW | VARCHAR2 | (25) | Lower limit on expense account Segment column | |
| SEGMENT14_LOW | VARCHAR2 | (25) | Lower limit on expense account Segment column | |
| SEGMENT15_LOW | VARCHAR2 | (25) | Lower limit on expense account Segment column | |
| SEGMENT16_LOW | VARCHAR2 | (25) | Lower limit on expense account Segment column | |
| SEGMENT17_LOW | VARCHAR2 | (25) | Lower limit on expense account Segment column | |
| SEGMENT18_LOW | VARCHAR2 | (25) | Lower limit on expense account Segment column | |
| SEGMENT19_LOW | VARCHAR2 | (25) | Lower limit on expense account Segment column | |
| SEGMENT20_LOW | VARCHAR2 | (25) | Lower limit on expense account Segment column | |
| SEGMENT21_LOW | VARCHAR2 | (25) | Lower limit on expense account Segment column | |
| SEGMENT22_LOW | VARCHAR2 | (25) | Lower limit on expense account Segment column | |
| SEGMENT23_LOW | VARCHAR2 | (25) | Lower limit on expense account Segment column | |
| SEGMENT24_LOW | VARCHAR2 | (25) | Lower limit on expense account Segment column | |
| SEGMENT25_LOW | VARCHAR2 | (25) | Lower limit on expense account Segment column | |
| SEGMENT26_LOW | VARCHAR2 | (25) | Lower limit on expense account Segment column | |
| SEGMENT27_LOW | VARCHAR2 | (25) | Lower limit on expense account Segment column | |
| SEGMENT28_LOW | VARCHAR2 | (25) | Lower limit on expense account Segment column | |
| SEGMENT29_LOW | VARCHAR2 | (25) | Lower limit on expense account Segment column | |
| SEGMENT30_LOW | VARCHAR2 | (25) | Lower limit on expense account Segment column | |
| SEGMENT1_HIGH | VARCHAR2 | (25) | Upper limit on expense account Segment column | |
| SEGMENT2_HIGH | VARCHAR2 | (25) | Upper limit on expense account Segment column | |
| SEGMENT3_HIGH | VARCHAR2 | (25) | Upper limit on expense account Segment column | |
| SEGMENT4_HIGH | VARCHAR2 | (25) | Upper limit on expense account Segment column | |
| SEGMENT5_HIGH | VARCHAR2 | (25) | Upper limit on expense account Segment column | |
| SEGMENT6_HIGH | VARCHAR2 | (25) | Upper limit on expense account Segment column | |
| SEGMENT7_HIGH | VARCHAR2 | (25) | Upper limit on expense account Segment column | |
| SEGMENT8_HIGH | VARCHAR2 | (25) | Upper limit on expense account Segment column | |
| SEGMENT9_HIGH | VARCHAR2 | (25) | Upper limit on expense account Segment column | |
| SEGMENT10_HIGH | VARCHAR2 | (25) | Upper limit on expense account Segment column | |
| SEGMENT11_HIGH | VARCHAR2 | (25) | Upper limit on expense account Segment column | |
| SEGMENT12_HIGH | VARCHAR2 | (25) | Upper limit on expense account Segment column | |
| SEGMENT13_HIGH | VARCHAR2 | (25) | Upper limit on expense account Segment column | |
| SEGMENT14_HIGH | VARCHAR2 | (25) | Upper limit on expense account Segment column | |
| SEGMENT15_HIGH | VARCHAR2 | (25) | Upper limit on expense account Segment column | |
| SEGMENT16_HIGH | VARCHAR2 | (25) | Upper limit on expense account Segment column | |
| SEGMENT17_HIGH | VARCHAR2 | (25) | Upper limit on expense account Segment column | |
| SEGMENT18_HIGH | VARCHAR2 | (25) | Upper limit on expense account Segment column | |
| SEGMENT19_HIGH | VARCHAR2 | (25) | Upper limit on expense account Segment column | |
| SEGMENT20_HIGH | VARCHAR2 | (25) | Upper limit on expense account Segment column | |
| SEGMENT21_HIGH | VARCHAR2 | (25) | Upper limit on expense account Segment column | |
| SEGMENT22_HIGH | VARCHAR2 | (25) | Upper limit on expense account Segment column | |
| SEGMENT23_HIGH | VARCHAR2 | (25) | Upper limit on expense account Segment column | |
| SEGMENT24_HIGH | VARCHAR2 | (25) | Upper limit on expense account Segment column | |
| SEGMENT25_HIGH | VARCHAR2 | (25) | Upper limit on expense account Segment column | |
| SEGMENT26_HIGH | VARCHAR2 | (25) | Upper limit on expense account Segment column | |
| SEGMENT27_HIGH | VARCHAR2 | (25) | Upper limit on expense account Segment column | |
| SEGMENT28_HIGH | VARCHAR2 | (25) | Upper limit on expense account Segment column | |
| SEGMENT29_HIGH | VARCHAR2 | (25) | Upper limit on expense account Segment column | |
| SEGMENT30_HIGH | VARCHAR2 | (25) | Upper limit on expense account Segment column | |
| INCLUDE_FULLY_RSVD_FLAG | VARCHAR2 | (3) | Indicates whether to include fully reserved assets | |
| COPY_CAT_DESC_FLAG | VARCHAR2 | (3) | Yes | Indicates whether to copy the category descriptive Flexfield information to the new category for the asset |
| INHERIT_DEPRN_RULES_FLAG | VARCHAR2 | (3) | Yes | Indicates whether to inherit depreciation rules of new category |
| AMORTIZE_FLAG | VARCHAR2 | (3) | Yes | Indicates whether to amortize the adjustment upon inheriting depreciation rules |
| LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
| LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who column |
| CREATED_BY | NUMBER | (15) | Standard Who column | |
| CREATION_DATE | DATE | Standard Who column | ||
| LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column |
Cut, paste (and edit) the following text to query this object:
SELECT MASS_RECLASS_ID
, BOOK_TYPE_CODE
, TRANSACTION_DATE_ENTERED
, DATE_EFFECTIVE
, STATUS
, CONCURRENT_REQUEST_ID
, DESCRIPTION
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE_CATEGORY_CODE
, ASSET_TYPE
, LOCATION_ID
, EMPLOYEE_ID
, ASSET_KEY_ID
, FROM_COST
, TO_COST
, FROM_ASSET_NUMBER
, TO_ASSET_NUMBER
, FROM_DATE_PLACED_IN_SERVICE
, TO_DATE_PLACED_IN_SERVICE
, FROM_CATEGORY_ID
, TO_CATEGORY_ID
, 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
, INCLUDE_FULLY_RSVD_FLAG
, COPY_CAT_DESC_FLAG
, INHERIT_DEPRN_RULES_FLAG
, AMORTIZE_FLAG
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATED_BY
, CREATION_DATE
, LAST_UPDATE_LOGIN
FROM FA.FA_MASS_RECLASS;
FA.FA_MASS_RECLASS does not reference any database object
FA.FA_MASS_RECLASS is referenced by following:
FA
FA_MASS_RECLASS#
|
|
|
|