VIEW: FA.FA_MASS_ADDITIONS#

Source

View Text - Preformatted

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

View Text - HTML Formatted

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