[Home] [Help]
[Dependency Information]
Object Name: | FA_HR_RETIREMENT_HEADERS |
---|---|
Object Type: | TABLE |
Owner: | FA |
FND Design Data: | ![]() |
Subobject Name: | |
Status: | VALID |
Header information for mass retirement of assets in a hierarchy. Contains the retirement selection parameters defined by the user.
Tablespace: | ![]() |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
FA_HR_RETIREMENT_HDRS_U1 | NORMAL | UNIQUE |
![]() |
![]() |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
BATCH_ID | NUMBER | Yes | System generated identifier of a batch | |
BOOK_TYPE_CODE | VARCHAR2 | (15) | Yes | Identifier of the Book associated with the Asset |
EVENT_CODE | VARCHAR2 | (30) | Yes | Event that triggers the creation of the batch: 'MASS_HR_RETIREMENT' - Mass Hierarchy Retirement |
STATUS_CODE | VARCHAR2 | (2) | Status of the batch: 'P' - Pending, 'IP' - In Process, 'CP' - Completely Processed, 'R' - Rejected 'RC' - Reinstated Completely , 'RF' - Reinstatement Failed | |
ASSET_HIERARCHY_ID | NUMBER | Hierarchy ID. | ||
RETIREMENT_METHOD | VARCHAR2 | (15) | Retirement method. FIFO or Pro Rate | |
RETIREMENT_TYPE_CODE | VARCHAR2 | (15) | User Defined Retirement type. | |
PRORATE_BY | VARCHAR2 | (10) | Whether to Retire COST or UNITS on the Asset. | |
RETIRE_BY | VARCHAR2 | (10) | What measure to use when calculating what is to be retired - either COST/ UNITS or PERCENT. | |
RETIREMENT_PERCENT | NUMBER | User entered amount if Retire by is PERCENTAGE | ||
RETIREMENT_AMOUNT | NUMBER | User entered amount if Retire by is COST/UNITS | ||
RETIRE_DATE | DATE | Retirement date. | ||
RETIREMENT_CONVENTION_CODE | VARCHAR2 | (30) | Not Used | |
ALLOW_PARTIAL_RETIRE_FLAG | VARCHAR2 | (1) | Flag to indicate whether to allow partial retirements | |
RETIRE_UNITS_FLAG | VARCHAR2 | (1) | Flag to indicate whether to allow unit retirements | |
REJECTION_REASON_CODE | VARCHAR2 | (30) | Reason the Batch was Rejected | |
TRANSACTION_NAME | VARCHAR2 | (30) | Transaction name | |
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 | Yes | Standard WHO column. | |
CONCURRENT_REQUEST_ID | NUMBER | Concurrent request Id of the last run | ||
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield segment. | |
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. | |
TH_ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Attribute Category | |
TH_ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
TH_ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
TH_ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
TH_ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
TH_ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
TH_ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
TH_ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
TH_ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
TH_ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
TH_ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
TH_ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
TH_ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
TH_ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
TH_ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
TH_ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
COST_OF_REMOVAL | NUMBER | Cost of removing the asset | ||
PROCEEDS_OF_SALE | NUMBER | Proceeds from the sale of the asset |
Cut, paste (and edit) the following text to query this object:
SELECT BATCH_ID
, BOOK_TYPE_CODE
, EVENT_CODE
, STATUS_CODE
, ASSET_HIERARCHY_ID
, RETIREMENT_METHOD
, RETIREMENT_TYPE_CODE
, PRORATE_BY
, RETIRE_BY
, RETIREMENT_PERCENT
, RETIREMENT_AMOUNT
, RETIRE_DATE
, RETIREMENT_CONVENTION_CODE
, ALLOW_PARTIAL_RETIRE_FLAG
, RETIRE_UNITS_FLAG
, REJECTION_REASON_CODE
, TRANSACTION_NAME
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, CONCURRENT_REQUEST_ID
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, TH_ATTRIBUTE_CATEGORY
, TH_ATTRIBUTE1
, TH_ATTRIBUTE2
, TH_ATTRIBUTE3
, TH_ATTRIBUTE4
, TH_ATTRIBUTE5
, TH_ATTRIBUTE6
, TH_ATTRIBUTE7
, TH_ATTRIBUTE8
, TH_ATTRIBUTE9
, TH_ATTRIBUTE10
, TH_ATTRIBUTE11
, TH_ATTRIBUTE12
, TH_ATTRIBUTE13
, TH_ATTRIBUTE14
, TH_ATTRIBUTE15
, COST_OF_REMOVAL
, PROCEEDS_OF_SALE
FROM FA.FA_HR_RETIREMENT_HEADERS;
FA.FA_HR_RETIREMENT_HEADERS does not reference any database object
FA.FA_HR_RETIREMENT_HEADERS is referenced by following:
|
|
|