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


TABLE: FA.FA_MASS_ADDITIONS

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

Storage Details
Tablespace: TablespaceAPPS_TS_INTERFACE
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
FA_MASS_ADDITIONS_U1 NORMAL UNIQUE TablespaceAPPS_TS_INTERFACE ColumnMASS_ADDITION_ID
FA_MASS_ADDITIONS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnASSET_KEY_CCID
FA_MASS_ADDITIONS_N10 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnINVOICE_NUMBER
ColumnBOOK_TYPE_CODE
FA_MASS_ADDITIONS_N11 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnMERGE_PARENT_MASS_ADDITIONS_ID
FA_MASS_ADDITIONS_N12 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnSPLIT_PARENT_MASS_ADDITIONS_ID
FA_MASS_ADDITIONS_N13 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnADD_TO_ASSET_ID
FA_MASS_ADDITIONS_N14 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnTAG_NUMBER
FA_MASS_ADDITIONS_N15 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnCREATE_BATCH_ID
FA_MASS_ADDITIONS_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnASSET_NUMBER
ColumnBOOK_TYPE_CODE
FA_MASS_ADDITIONS_N3 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnPARENT_MASS_ADDITION_ID
FA_MASS_ADDITIONS_N4 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnINVOICE_NUMBER
ColumnVENDOR_NUMBER
FA_MASS_ADDITIONS_N5 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnPOSTING_STATUS
ColumnBOOK_TYPE_CODE
ColumnREQUEST_ID
ColumnWORKER_ID
ColumnPROCESS_ORDER
FA_MASS_ADDITIONS_N6 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnPO_NUMBER
FA_MASS_ADDITIONS_N7 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnPO_VENDOR_ID
FA_MASS_ADDITIONS_N8 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnINVOICE_ID
ColumnAP_DISTRIBUTION_LINE_NUMBER
FA_MASS_ADDITIONS_N9 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnMERGE_INVOICE_NUMBER
ColumnMERGE_VENDOR_NUMBER
Columns
Name Datatype Length Mandatory Comments
MASS_ADDITION_ID NUMBER (15)
ASSET_NUMBER VARCHAR2 (15)
TAG_NUMBER VARCHAR2 (15)
DESCRIPTION VARCHAR2 (80)
ASSET_CATEGORY_ID NUMBER (15)
MANUFACTURER_NAME VARCHAR2 (30)
SERIAL_NUMBER VARCHAR2 (35)
MODEL_NUMBER VARCHAR2 (40)
BOOK_TYPE_CODE VARCHAR2 (15)
DATE_PLACED_IN_SERVICE DATE

FIXED_ASSETS_COST NUMBER

PAYABLES_UNITS NUMBER

FIXED_ASSETS_UNITS NUMBER

PAYABLES_CODE_COMBINATION_ID NUMBER (15)
EXPENSE_CODE_COMBINATION_ID NUMBER (15)
LOCATION_ID NUMBER (15)
ASSIGNED_TO NUMBER (15)
FEEDER_SYSTEM_NAME VARCHAR2 (40)
CREATE_BATCH_DATE DATE

CREATE_BATCH_ID NUMBER (15)
LAST_UPDATE_DATE DATE

LAST_UPDATED_BY NUMBER

REVIEWER_COMMENTS VARCHAR2 (60)
INVOICE_NUMBER VARCHAR2 (50)
VENDOR_NUMBER VARCHAR2 (30)
PO_VENDOR_ID NUMBER (15)
PO_NUMBER VARCHAR2 (20)
POSTING_STATUS VARCHAR2 (15)
QUEUE_NAME VARCHAR2 (15)
INVOICE_DATE DATE

INVOICE_CREATED_BY NUMBER (15)
INVOICE_UPDATED_BY NUMBER (15)
PAYABLES_COST NUMBER

INVOICE_ID NUMBER (15)
PAYABLES_BATCH_NAME VARCHAR2 (50)
DEPRECIATE_FLAG VARCHAR2 (3)
PARENT_MASS_ADDITION_ID NUMBER (15)
PARENT_ASSET_ID NUMBER (15)
SPLIT_MERGED_CODE VARCHAR2 (3)
AP_DISTRIBUTION_LINE_NUMBER NUMBER (15)
POST_BATCH_ID NUMBER (15)
ADD_TO_ASSET_ID NUMBER (15)
AMORTIZE_FLAG VARCHAR2 (3)
NEW_MASTER_FLAG VARCHAR2 (3)
ASSET_KEY_CCID NUMBER (15)
ASSET_TYPE VARCHAR2 (11)
DEPRN_RESERVE NUMBER

YTD_DEPRN NUMBER

BEGINNING_NBV NUMBER

CREATED_BY NUMBER (15)
CREATION_DATE DATE

LAST_UPDATE_LOGIN NUMBER (15)
SALVAGE_VALUE NUMBER

ACCOUNTING_DATE DATE

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)
FULLY_RSVD_REVALS_COUNTER NUMBER

MERGE_INVOICE_NUMBER VARCHAR2 (50)
MERGE_VENDOR_NUMBER VARCHAR2 (30)
PRODUCTION_CAPACITY NUMBER

REVAL_AMORTIZATION_BASIS NUMBER

REVAL_RESERVE NUMBER

UNIT_OF_MEASURE VARCHAR2 (25)
UNREVALUED_COST NUMBER

YTD_REVAL_DEPRN_EXPENSE NUMBER

ATTRIBUTE16 VARCHAR2 (150)
ATTRIBUTE17 VARCHAR2 (150)
ATTRIBUTE18 VARCHAR2 (150)
ATTRIBUTE19 VARCHAR2 (150)
ATTRIBUTE20 VARCHAR2 (150)
ATTRIBUTE21 VARCHAR2 (150)
ATTRIBUTE22 VARCHAR2 (150)
ATTRIBUTE23 VARCHAR2 (150)
ATTRIBUTE24 VARCHAR2 (150)
ATTRIBUTE25 VARCHAR2 (150)
ATTRIBUTE26 VARCHAR2 (150)
ATTRIBUTE27 VARCHAR2 (150)
ATTRIBUTE28 VARCHAR2 (150)
ATTRIBUTE29 VARCHAR2 (150)
ATTRIBUTE30 VARCHAR2 (150)
MERGED_CODE VARCHAR2 (3)
SPLIT_CODE VARCHAR2 (3)
MERGE_PARENT_MASS_ADDITIONS_ID NUMBER (15)
SPLIT_PARENT_MASS_ADDITIONS_ID NUMBER (15)
PROJECT_ASSET_LINE_ID NUMBER (15)
PROJECT_ID NUMBER (15)
TASK_ID NUMBER (15)
SUM_UNITS VARCHAR2 (3)
DIST_NAME VARCHAR2 (25)
GLOBAL_ATTRIBUTE1 VARCHAR2 (150)
GLOBAL_ATTRIBUTE2 VARCHAR2 (150)
GLOBAL_ATTRIBUTE3 VARCHAR2 (150)
GLOBAL_ATTRIBUTE4 VARCHAR2 (150)
GLOBAL_ATTRIBUTE5 VARCHAR2 (150)
GLOBAL_ATTRIBUTE6 VARCHAR2 (150)
GLOBAL_ATTRIBUTE7 VARCHAR2 (150)
GLOBAL_ATTRIBUTE8 VARCHAR2 (150)
GLOBAL_ATTRIBUTE9 VARCHAR2 (150)
GLOBAL_ATTRIBUTE10 VARCHAR2 (150)
GLOBAL_ATTRIBUTE11 VARCHAR2 (150)
GLOBAL_ATTRIBUTE12 VARCHAR2 (150)
GLOBAL_ATTRIBUTE13 VARCHAR2 (150)
GLOBAL_ATTRIBUTE14 VARCHAR2 (150)
GLOBAL_ATTRIBUTE15 VARCHAR2 (150)
GLOBAL_ATTRIBUTE16 VARCHAR2 (150)
GLOBAL_ATTRIBUTE17 VARCHAR2 (150)
GLOBAL_ATTRIBUTE18 VARCHAR2 (150)
GLOBAL_ATTRIBUTE19 VARCHAR2 (150)
GLOBAL_ATTRIBUTE20 VARCHAR2 (150)
GLOBAL_ATTRIBUTE_CATEGORY VARCHAR2 (30)
CONTEXT VARCHAR2 (210)
INVENTORIAL VARCHAR2 (3)
SHORT_FISCAL_YEAR_FLAG VARCHAR2 (3)
CONVERSION_DATE DATE

ORIGINAL_DEPRN_START_DATE DATE

GROUP_ASSET_ID NUMBER

CUA_PARENT_HIERARCHY_ID NUMBER

UNITS_TO_ADJUST NUMBER (15)
BONUS_YTD_DEPRN NUMBER

BONUS_DEPRN_RESERVE NUMBER

AMORTIZE_NBV_FLAG VARCHAR2 (1)
AMORTIZATION_START_DATE DATE

TRANSACTION_TYPE_CODE VARCHAR2 (20)
TRANSACTION_DATE DATE

WARRANTY_ID NUMBER (15)
LEASE_ID NUMBER (15)
LESSOR_ID NUMBER (15)
PROPERTY_TYPE_CODE VARCHAR2 (10)
PROPERTY_1245_1250_CODE VARCHAR2 (4)
IN_USE_FLAG VARCHAR2 (3)
OWNED_LEASED VARCHAR2 (15)
NEW_USED VARCHAR2 (4)
ASSET_ID NUMBER (15)
MATERIAL_INDICATOR_FLAG VARCHAR2 (1)
DEPRN_METHOD_CODE VARCHAR2 (12)
LIFE_IN_MONTHS NUMBER (4)
BASIC_RATE NUMBER

ADJUSTED_RATE NUMBER

PRORATE_CONVENTION_CODE VARCHAR2 (10)
BONUS_RULE VARCHAR2 (30)
SALVAGE_TYPE VARCHAR2 (30)
PERCENT_SALVAGE_VALUE NUMBER

DEPRN_LIMIT_TYPE VARCHAR2 (30)
ALLOWED_DEPRN_LIMIT NUMBER

ALLOWED_DEPRN_LIMIT_AMOUNT NUMBER

WARRANTY_NUMBER VARCHAR2 (15)
INVOICE_LINE_NUMBER NUMBER

INVOICE_DISTRIBUTION_ID NUMBER (15)
PO_DISTRIBUTION_ID NUMBER (15)
ASSET_KEY_SEGMENT1 VARCHAR2 (30)
ASSET_KEY_SEGMENT2 VARCHAR2 (30)
ASSET_KEY_SEGMENT3 VARCHAR2 (30)
ASSET_KEY_SEGMENT4 VARCHAR2 (30)
ASSET_KEY_SEGMENT5 VARCHAR2 (30)
ASSET_KEY_SEGMENT6 VARCHAR2 (30)
ASSET_KEY_SEGMENT7 VARCHAR2 (30)
ASSET_KEY_SEGMENT8 VARCHAR2 (30)
ASSET_KEY_SEGMENT9 VARCHAR2 (30)
ASSET_KEY_SEGMENT10 VARCHAR2 (30)
REQUEST_ID NUMBER (15)
WORKER_ID NUMBER (15)
PROCESS_ORDER NUMBER (15)
MASS_PROPERTY_FLAG VARCHAR2 (1)
INVOICE_PAYMENT_ID NUMBER (15)
TH_ATTRIBUTE1 VARCHAR2 (150)
TH_ATTRIBUTE2 VARCHAR2 (150)
TH_ATTRIBUTE3 VARCHAR2 (150)
TH_ATTRIBUTE4 VARCHAR2 (150)
TH_ATTRIBUTE5 VARCHAR2 (150)
TH_ATTRIBUTE6 VARCHAR2 (150)
TH_ATTRIBUTE7 VARCHAR2 (150)
TH_ATTRIBUTE8 VARCHAR2 (150)
TH_ATTRIBUTE9 VARCHAR2 (150)
TH_ATTRIBUTE10 VARCHAR2 (150)
TH_ATTRIBUTE11 VARCHAR2 (150)
TH_ATTRIBUTE12 VARCHAR2 (150)
TH_ATTRIBUTE13 VARCHAR2 (150)
TH_ATTRIBUTE14 VARCHAR2 (150)
TH_ATTRIBUTE15 VARCHAR2 (150)
TH_ATTRIBUTE_CATEGORY_CODE VARCHAR2 (30)
Query Text

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


SELECT MASS_ADDITION_ID
,      ASSET_NUMBER
,      TAG_NUMBER
,      DESCRIPTION
,      ASSET_CATEGORY_ID
,      MANUFACTURER_NAME
,      SERIAL_NUMBER
,      MODEL_NUMBER
,      BOOK_TYPE_CODE
,      DATE_PLACED_IN_SERVICE
,      FIXED_ASSETS_COST
,      PAYABLES_UNITS
,      FIXED_ASSETS_UNITS
,      PAYABLES_CODE_COMBINATION_ID
,      EXPENSE_CODE_COMBINATION_ID
,      LOCATION_ID
,      ASSIGNED_TO
,      FEEDER_SYSTEM_NAME
,      CREATE_BATCH_DATE
,      CREATE_BATCH_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      REVIEWER_COMMENTS
,      INVOICE_NUMBER
,      VENDOR_NUMBER
,      PO_VENDOR_ID
,      PO_NUMBER
,      POSTING_STATUS
,      QUEUE_NAME
,      INVOICE_DATE
,      INVOICE_CREATED_BY
,      INVOICE_UPDATED_BY
,      PAYABLES_COST
,      INVOICE_ID
,      PAYABLES_BATCH_NAME
,      DEPRECIATE_FLAG
,      PARENT_MASS_ADDITION_ID
,      PARENT_ASSET_ID
,      SPLIT_MERGED_CODE
,      AP_DISTRIBUTION_LINE_NUMBER
,      POST_BATCH_ID
,      ADD_TO_ASSET_ID
,      AMORTIZE_FLAG
,      NEW_MASTER_FLAG
,      ASSET_KEY_CCID
,      ASSET_TYPE
,      DEPRN_RESERVE
,      YTD_DEPRN
,      BEGINNING_NBV
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_LOGIN
,      SALVAGE_VALUE
,      ACCOUNTING_DATE
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE_CATEGORY_CODE
,      FULLY_RSVD_REVALS_COUNTER
,      MERGE_INVOICE_NUMBER
,      MERGE_VENDOR_NUMBER
,      PRODUCTION_CAPACITY
,      REVAL_AMORTIZATION_BASIS
,      REVAL_RESERVE
,      UNIT_OF_MEASURE
,      UNREVALUED_COST
,      YTD_REVAL_DEPRN_EXPENSE
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      ATTRIBUTE21
,      ATTRIBUTE22
,      ATTRIBUTE23
,      ATTRIBUTE24
,      ATTRIBUTE25
,      ATTRIBUTE26
,      ATTRIBUTE27
,      ATTRIBUTE28
,      ATTRIBUTE29
,      ATTRIBUTE30
,      MERGED_CODE
,      SPLIT_CODE
,      MERGE_PARENT_MASS_ADDITIONS_ID
,      SPLIT_PARENT_MASS_ADDITIONS_ID
,      PROJECT_ASSET_LINE_ID
,      PROJECT_ID
,      TASK_ID
,      SUM_UNITS
,      DIST_NAME
,      GLOBAL_ATTRIBUTE1
,      GLOBAL_ATTRIBUTE2
,      GLOBAL_ATTRIBUTE3
,      GLOBAL_ATTRIBUTE4
,      GLOBAL_ATTRIBUTE5
,      GLOBAL_ATTRIBUTE6
,      GLOBAL_ATTRIBUTE7
,      GLOBAL_ATTRIBUTE8
,      GLOBAL_ATTRIBUTE9
,      GLOBAL_ATTRIBUTE10
,      GLOBAL_ATTRIBUTE11
,      GLOBAL_ATTRIBUTE12
,      GLOBAL_ATTRIBUTE13
,      GLOBAL_ATTRIBUTE14
,      GLOBAL_ATTRIBUTE15
,      GLOBAL_ATTRIBUTE16
,      GLOBAL_ATTRIBUTE17
,      GLOBAL_ATTRIBUTE18
,      GLOBAL_ATTRIBUTE19
,      GLOBAL_ATTRIBUTE20
,      GLOBAL_ATTRIBUTE_CATEGORY
,      CONTEXT
,      INVENTORIAL
,      SHORT_FISCAL_YEAR_FLAG
,      CONVERSION_DATE
,      ORIGINAL_DEPRN_START_DATE
,      GROUP_ASSET_ID
,      CUA_PARENT_HIERARCHY_ID
,      UNITS_TO_ADJUST
,      BONUS_YTD_DEPRN
,      BONUS_DEPRN_RESERVE
,      AMORTIZE_NBV_FLAG
,      AMORTIZATION_START_DATE
,      TRANSACTION_TYPE_CODE
,      TRANSACTION_DATE
,      WARRANTY_ID
,      LEASE_ID
,      LESSOR_ID
,      PROPERTY_TYPE_CODE
,      PROPERTY_1245_1250_CODE
,      IN_USE_FLAG
,      OWNED_LEASED
,      NEW_USED
,      ASSET_ID
,      MATERIAL_INDICATOR_FLAG
,      DEPRN_METHOD_CODE
,      LIFE_IN_MONTHS
,      BASIC_RATE
,      ADJUSTED_RATE
,      PRORATE_CONVENTION_CODE
,      BONUS_RULE
,      SALVAGE_TYPE
,      PERCENT_SALVAGE_VALUE
,      DEPRN_LIMIT_TYPE
,      ALLOWED_DEPRN_LIMIT
,      ALLOWED_DEPRN_LIMIT_AMOUNT
,      WARRANTY_NUMBER
,      INVOICE_LINE_NUMBER
,      INVOICE_DISTRIBUTION_ID
,      PO_DISTRIBUTION_ID
,      ASSET_KEY_SEGMENT1
,      ASSET_KEY_SEGMENT2
,      ASSET_KEY_SEGMENT3
,      ASSET_KEY_SEGMENT4
,      ASSET_KEY_SEGMENT5
,      ASSET_KEY_SEGMENT6
,      ASSET_KEY_SEGMENT7
,      ASSET_KEY_SEGMENT8
,      ASSET_KEY_SEGMENT9
,      ASSET_KEY_SEGMENT10
,      REQUEST_ID
,      WORKER_ID
,      PROCESS_ORDER
,      MASS_PROPERTY_FLAG
,      INVOICE_PAYMENT_ID
,      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
,      TH_ATTRIBUTE_CATEGORY_CODE
FROM FA.FA_MASS_ADDITIONS;

Dependencies

[top of page]

FA.FA_MASS_ADDITIONS does not reference any database object

FA.FA_MASS_ADDITIONS is referenced by following:

SchemaAPPS
SynonymFA_MASS_ADDITIONS
TriggerFA_MASS_ADDITIONS_BRI
TriggerFA_MASS_ADDITIONS_BRU
TriggerFA_MASS_ADDITIONS_DELETE_DIST
TriggerFA_MASS_ADDITIONS_INSERT_DIST
TriggerFA_MASS_ADDITIONS_INSERT_NAME
TriggerFA_MASS_ADDITIONS_UPDATE_DIST
TriggerJAI_FA_MA_ARIUD_T1
TriggerJAI_FA_MA_BRIUD_T1