DBA Data[Home] [Help] [Dependency Information]

TABLE: FA.FA_HR_RETIREMENT_HEADERS

Object Details
Object Name: FA_HR_RETIREMENT_HEADERS
Object Type: TABLE
Owner: FA
FND Design Data: TableOFA.FA_HR_RETIREMENT_HEADERS
Subobject Name:
Status: VALID


Header information for mass retirement of assets in a hierarchy. Contains the retirement selection parameters defined by the user.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
FA_HR_RETIREMENT_HDRS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnBATCH_ID
Columns
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
Query Text

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;

Dependencies

[top of page]

FA.FA_HR_RETIREMENT_HEADERS does not reference any database object

FA.FA_HR_RETIREMENT_HEADERS is referenced by following:

SchemaFA
ViewFA_HR_RETIREMENT_HEADERS#