[Home] [Help] [Dependency Information]

TABLE: FA.FA_MASS_ADDITIONS_GT

Object Details

Object Name:	FA_MASS_ADDITIONS_GT
Object Type:	TABLE
Owner:	FA
FND Design Data:	OFA.FA_MASS_ADDITIONS_GT
Subobject Name:
Status:	VALID

Temporary Table Details

FA.FA_MASS_ADDITIONS_GT is a global temporary table. The current session is able see data that it placed in the table but other sessions cannot. Data in the table is temporary. It has a data duration of SYS$SESSION. Data is removed at the end of this period.

Storage Details

Tablespace:
PCT Free:	10
PCT Used:	40

Indexes

Index	Type	Uniqueness	Tablespace	Column
FA_MASS_ADDITIONS_GT_N1	NORMAL	NONUNIQUE		BOOK_TYPE_CODE LINE_STATUS LINE_TYPE_LOOKUP_CODE LEDGER_CATEGORY_CODE
FA_MASS_ADDITIONS_GT_N2	NORMAL	NONUNIQUE		LINE_STATUS LINE_TYPE_LOOKUP_CODE LEDGER_CATEGORY_CODE
FA_MASS_ADDITIONS_GT_N3	NORMAL	NONUNIQUE		INVOICE_DISTRIBUTION_ID

Columns

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
,      PO_DISTRIBUTION_ID
,      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
,      WARRANTY_NUMBER
,      LEASE_ID
,      LESSOR_ID
,      PROPERTY_TYPE_CODE
,      PROPERTY_1245_1250_CODE
,      IN_USE_FLAG
,      OWNED_LEASED
,      NEW_USED
,      ASSET_ID
,      MATERIAL_INDICATOR_FLAG
,      INVOICE_DISTRIBUTION_ID
,      INVOICE_LINE_NUMBER
,      PARENT_INVOICE_DIST_ID
,      AP_DIST_LINE_NUMBER_OLD
,      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_AMOUNT
,      ALLOWED_DEPRN_LIMIT
,      LINE_STATUS
,      LINE_TYPE_LOOKUP_CODE
,      LEDGER_ID
,      LEDGER_CATEGORY_CODE
,      EXPENDITURE_ITEM_ID
,      LINE_NUM
,      INVOICE_PAYMENT_ID
,      PARENT_PAYABLES_CCID
FROM FA.FA_MASS_ADDITIONS_GT;

Dependencies

[top of page]

FA.FA_MASS_ADDITIONS_GT does not reference any database object

FA.FA_MASS_ADDITIONS_GT is referenced by following:

APPS

FA_MASS_ADDITIONS_GT