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

TABLE: FA.FA_MASS_RECLASS

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

Storage Details
Tablespace: TablespaceAPPS_TS_INTERFACE
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
FA_MASS_RECLASS_U1 NORMAL UNIQUE TablespaceAPPS_TS_INTERFACE ColumnMASS_RECLASS_ID
Columns
Name Datatype Length Mandatory Comments
MASS_RECLASS_ID NUMBER (15) Yes
BOOK_TYPE_CODE VARCHAR2 (15) Yes
TRANSACTION_DATE_ENTERED DATE
Yes
DATE_EFFECTIVE DATE
Yes
STATUS VARCHAR2 (10) Yes
CONCURRENT_REQUEST_ID NUMBER (15)
DESCRIPTION VARCHAR2 (80)
ATTRIBUTE1 VARCHAR2 (150)
ATTRIBUTE2 VARCHAR2 (150)
ATTRIBUTE3 VARCHAR2 (150)
ATTRIBUTE4 VARCHAR2 (150)
ATTRIBUTE5 VARCHAR2 (150)
ATTRIBUTE6 VARCHAR2 (150)
ATTRIBUTE7 VARCHAR2 (150)
ATTRIBUTE8 VARCHAR2 (150)
ATTRIBUTE9 VARCHAR2 (150)
ATTRIBUTE10 VARCHAR2 (150)
ATTRIBUTE11 VARCHAR2 (150)
ATTRIBUTE12 VARCHAR2 (150)
ATTRIBUTE13 VARCHAR2 (150)
ATTRIBUTE14 VARCHAR2 (150)
ATTRIBUTE15 VARCHAR2 (150)
ATTRIBUTE_CATEGORY_CODE VARCHAR2 (30)
ASSET_TYPE VARCHAR2 (11)
LOCATION_ID NUMBER (15)
EMPLOYEE_ID NUMBER (15)
ASSET_KEY_ID NUMBER (15)
FROM_COST NUMBER

TO_COST NUMBER

FROM_ASSET_NUMBER VARCHAR2 (15)
TO_ASSET_NUMBER VARCHAR2 (15)
FROM_DATE_PLACED_IN_SERVICE DATE

TO_DATE_PLACED_IN_SERVICE DATE

FROM_CATEGORY_ID NUMBER (15)
TO_CATEGORY_ID NUMBER (15) Yes
SEGMENT1_LOW VARCHAR2 (25)
SEGMENT2_LOW VARCHAR2 (25)
SEGMENT3_LOW VARCHAR2 (25)
SEGMENT4_LOW VARCHAR2 (25)
SEGMENT5_LOW VARCHAR2 (25)
SEGMENT6_LOW VARCHAR2 (25)
SEGMENT7_LOW VARCHAR2 (25)
SEGMENT8_LOW VARCHAR2 (25)
SEGMENT9_LOW VARCHAR2 (25)
SEGMENT10_LOW VARCHAR2 (25)
SEGMENT11_LOW VARCHAR2 (25)
SEGMENT12_LOW VARCHAR2 (25)
SEGMENT13_LOW VARCHAR2 (25)
SEGMENT14_LOW VARCHAR2 (25)
SEGMENT15_LOW VARCHAR2 (25)
SEGMENT16_LOW VARCHAR2 (25)
SEGMENT17_LOW VARCHAR2 (25)
SEGMENT18_LOW VARCHAR2 (25)
SEGMENT19_LOW VARCHAR2 (25)
SEGMENT20_LOW VARCHAR2 (25)
SEGMENT21_LOW VARCHAR2 (25)
SEGMENT22_LOW VARCHAR2 (25)
SEGMENT23_LOW VARCHAR2 (25)
SEGMENT24_LOW VARCHAR2 (25)
SEGMENT25_LOW VARCHAR2 (25)
SEGMENT26_LOW VARCHAR2 (25)
SEGMENT27_LOW VARCHAR2 (25)
SEGMENT28_LOW VARCHAR2 (25)
SEGMENT29_LOW VARCHAR2 (25)
SEGMENT30_LOW VARCHAR2 (25)
SEGMENT1_HIGH VARCHAR2 (25)
SEGMENT2_HIGH VARCHAR2 (25)
SEGMENT3_HIGH VARCHAR2 (25)
SEGMENT4_HIGH VARCHAR2 (25)
SEGMENT5_HIGH VARCHAR2 (25)
SEGMENT6_HIGH VARCHAR2 (25)
SEGMENT7_HIGH VARCHAR2 (25)
SEGMENT8_HIGH VARCHAR2 (25)
SEGMENT9_HIGH VARCHAR2 (25)
SEGMENT10_HIGH VARCHAR2 (25)
SEGMENT11_HIGH VARCHAR2 (25)
SEGMENT12_HIGH VARCHAR2 (25)
SEGMENT13_HIGH VARCHAR2 (25)
SEGMENT14_HIGH VARCHAR2 (25)
SEGMENT15_HIGH VARCHAR2 (25)
SEGMENT16_HIGH VARCHAR2 (25)
SEGMENT17_HIGH VARCHAR2 (25)
SEGMENT18_HIGH VARCHAR2 (25)
SEGMENT19_HIGH VARCHAR2 (25)
SEGMENT20_HIGH VARCHAR2 (25)
SEGMENT21_HIGH VARCHAR2 (25)
SEGMENT22_HIGH VARCHAR2 (25)
SEGMENT23_HIGH VARCHAR2 (25)
SEGMENT24_HIGH VARCHAR2 (25)
SEGMENT25_HIGH VARCHAR2 (25)
SEGMENT26_HIGH VARCHAR2 (25)
SEGMENT27_HIGH VARCHAR2 (25)
SEGMENT28_HIGH VARCHAR2 (25)
SEGMENT29_HIGH VARCHAR2 (25)
SEGMENT30_HIGH VARCHAR2 (25)
INCLUDE_FULLY_RSVD_FLAG VARCHAR2 (3)
COPY_CAT_DESC_FLAG VARCHAR2 (3) Yes
INHERIT_DEPRN_RULES_FLAG VARCHAR2 (3) Yes
AMORTIZE_FLAG VARCHAR2 (3) Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER (15) Yes
CREATED_BY NUMBER (15)
CREATION_DATE DATE

LAST_UPDATE_LOGIN NUMBER (15)
Query Text

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;

Dependencies

[top of page]

FA.FA_MASS_RECLASS does not reference any database object

FA.FA_MASS_RECLASS is referenced by following:

SchemaAPPS
SynonymFA_MASS_RECLASS