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

TABLE: FA.FA_HR_RETIREMENT_DETAILS

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

Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
FA_HR_RETIREMENT_DETAILS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnBATCH_ID
ColumnBOOK_TYPE_CODE
ColumnASSET_ID
FA_HR_RETIREMENT_DETAILS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnASSET_ID
Columns
Name Datatype Length Mandatory Comments
BATCH_ID NUMBER
Yes
BOOK_TYPE_CODE VARCHAR2 (15) Yes
ASSET_ID NUMBER
Yes
DATE_PLACED_IN_SERVICE DATE
Yes
CURRENT_COST NUMBER
Yes
COST_RETIRED NUMBER
Yes
CURRENT_UNITS NUMBER

UNITS_RETIRED NUMBER

PRORATE_PERCENT NUMBER

RETIREMENT_CONVENTION_CODE VARCHAR2 (30)
STATUS_CODE VARCHAR2 (2)
REJECTION_REASON VARCHAR2 (240)
RETIREMENT_ID NUMBER

CREATED_BY NUMBER
Yes
CREATION_DATE DATE
Yes
LAST_UPDATED_BY NUMBER
Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATE_LOGIN NUMBER
Yes
CONCURRENT_REQUEST_ID NUMBER

COST_OF_REMOVAL NUMBER

PROCEEDS_OF_SALE NUMBER

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT BATCH_ID
,      BOOK_TYPE_CODE
,      ASSET_ID
,      DATE_PLACED_IN_SERVICE
,      CURRENT_COST
,      COST_RETIRED
,      CURRENT_UNITS
,      UNITS_RETIRED
,      PRORATE_PERCENT
,      RETIREMENT_CONVENTION_CODE
,      STATUS_CODE
,      REJECTION_REASON
,      RETIREMENT_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      CONCURRENT_REQUEST_ID
,      COST_OF_REMOVAL
,      PROCEEDS_OF_SALE
FROM FA.FA_HR_RETIREMENT_DETAILS;

Dependencies

[top of page]

FA.FA_HR_RETIREMENT_DETAILS does not reference any database object

FA.FA_HR_RETIREMENT_DETAILS is referenced by following:

SchemaAPPS
SynonymFA_HR_RETIREMENT_DETAILS