[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | FA_MASS_RETIREMENTS |
|---|---|
| Object Type: | TABLE |
| Owner: | FA |
| FND Design Data: |  OFA.FA_MASS_RETIREMENTS
|
| Subobject Name: | |
| Status: | VALID |
FA_MASS_RETIREMENTS contains information about your mass retirement
and mass reinstatement processes. Oracle Assets uses this information
to retire the assets you select. When you submit a mass retirement,
Oracle Assets inserts PENDING rows for individual assets in the
FA_RETIREMENTS table. At this point the status of the mass retirement
is COMPLETED. The individual retirements are not PROCESSED until you
run the Calculate Gains and Losses program. If afterwards you
reinstate the mass retirement, you must rerun the Calculate Gains and
Losses program to process the individual reinstatements.
.
When you enter a mass retirement transaction using the Mass
Retirements form, Oracle Assets inserts a row that stores your mass
retirement information in this table. It uses this information to
generate the Mass Retirements Report and the Mass Retirements
Exception Report.
.
MASS_RETIREMENT_ID identifies each mass retirement transaction.
.
RETIRE_REQUEST_ID and REINSTATE_REQUEST_ID identify the concurrent
request Oracle Assets submits when you perform a mass retirement and
mass reinstatement respectively.
.
| Tablespace: |  APPS_TS_INTERFACE |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| FA_MASS_RETIREMENTS_U1 | NORMAL | UNIQUE |
APPS_TS_INTERFACE
|
 MASS_RETIREMENT_ID
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| MASS_RETIREMENT_ID | NUMBER | (15) | Yes | Unique mass retirement identification number |
| BOOK_TYPE_CODE | VARCHAR2 | (15) | Yes | Book name |
| RETIRE_SUBCOMPONENTS_FLAG | VARCHAR2 | (3) | Yes | Indicates whether to retire subcomponents of selected assets |
| STATUS | VARCHAR2 | (15) | Yes | Either NEW, PENDING, RUNNING, COMPLETED, ERROR, or REINSTATED |
| RETIRE_REQUEST_ID | NUMBER | Concurrent request number for the mass retirement | ||
| REINSTATE_REQUEST_ID | NUMBER | Concurrent request number for the mass reinstatement | ||
| RETIREMENT_DATE | DATE | Yes | Date of the mass retirement | |
| PROCEEDS_OF_SALE | NUMBER | Total proceeds of sale | ||
| COST_OF_REMOVAL | NUMBER | Total cost of removal | ||
| FROM_COST | NUMBER | Lower limit of asset cost range | ||
| INCLUDE_FULLY_RSVD_FLAG | VARCHAR2 | (3) | Indicates whether to include fully reserved assets | |
| TO_COST | NUMBER | Upper limit of asset cost range | ||
| DESCRIPTION | VARCHAR2 | (80) | Description of mass retirement | |
| RETIREMENT_TYPE_CODE | VARCHAR2 | (15) | Retirement type | |
| 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 | |
| CATEGORY_ID | NUMBER | (15) | Identifies the category to which the asset belongs | |
| ASSET_KEY_ID | NUMBER | (15) | identifies the asset key flexfield combination for the asset | |
| FROM_ASSET_NUMBER | VARCHAR2 | (15) | First asset number in the range to retire | |
| TO_ASSET_NUMBER | VARCHAR2 | (15) | Last asset number in the range to retire | |
| FROM_DATE_PLACED_IN_SERVICE | DATE | First date in service in the range to retire | ||
| TO_DATE_PLACED_IN_SERVICE | DATE | Last date in service in the range to retire | ||
| 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 | |
| LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
| LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who column |
| CREATION_DATE | DATE | Standard Who column | ||
| CREATED_BY | NUMBER | (15) | Standard Who column | |
| LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column | |
| GROUP_ASSET_ID | NUMBER | (15) | Identifies the associated group asset for group member assets. | |
| FROM_THRESHOLD_AMOUNT | NUMBER | Reserved for system use. Do not use. | ||
| TO_THRESHOLD_AMOUNT | NUMBER | Reserved for system use. Do not use. | ||
| CREATE_REQUEST_ID | NUMBER | (15) | Concurrent request number for the Create Mass Retirements process. | |
| GROUP_ASSOCIATION | VARCHAR2 | (30) | Indicates how to restrict candidate assets based on their association with a group asset | |
| SERIAL_NUMBER | VARCHAR2 | (35) | Model number of asset | |
| MANUFACTURER_NAME | VARCHAR2 | (360) | Name of manufacturer | |
| MODEL_NUMBER | VARCHAR2 | (40) | Model number of asset | |
| TAG_NUMBER | VARCHAR2 | (15) | Tag number of asset | |
| UNITS_TO_RETIRE | NUMBER | (15) | Total number of units to retire | |
| PROJECT_ID | NUMBER | (15) | Project Identifier | |
| TASK_ID | NUMBER | (15) | Task identifier |
Cut, paste (and edit) the following text to query this object:
SELECT MASS_RETIREMENT_ID
, BOOK_TYPE_CODE
, RETIRE_SUBCOMPONENTS_FLAG
, STATUS
, RETIRE_REQUEST_ID
, REINSTATE_REQUEST_ID
, RETIREMENT_DATE
, PROCEEDS_OF_SALE
, COST_OF_REMOVAL
, FROM_COST
, INCLUDE_FULLY_RSVD_FLAG
, TO_COST
, DESCRIPTION
, RETIREMENT_TYPE_CODE
, ASSET_TYPE
, LOCATION_ID
, EMPLOYEE_ID
, CATEGORY_ID
, ASSET_KEY_ID
, FROM_ASSET_NUMBER
, TO_ASSET_NUMBER
, FROM_DATE_PLACED_IN_SERVICE
, TO_DATE_PLACED_IN_SERVICE
, 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
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, GROUP_ASSET_ID
, FROM_THRESHOLD_AMOUNT
, TO_THRESHOLD_AMOUNT
, CREATE_REQUEST_ID
, GROUP_ASSOCIATION
, SERIAL_NUMBER
, MANUFACTURER_NAME
, MODEL_NUMBER
, TAG_NUMBER
, UNITS_TO_RETIRE
, PROJECT_ID
, TASK_ID
FROM FA.FA_MASS_RETIREMENTS;
FA.FA_MASS_RETIREMENTS does not reference any database object
FA.FA_MASS_RETIREMENTS is referenced by following:
FA
FA_MASS_RETIREMENTS#
|
|
|
|