eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.FA_MASS_ADDITIONS_V

Source

View Text - Preformatted


SELECT ma.rowid row_id , ma.accounting_date ,ma.add_to_asset_id , ma.amortize_flag , ma.ap_distribution_line_number , ma.asset_category_id , ma.asset_key_ccid, ma.asset_number , ma.asset_type , ma.assigned_to , ma.attribute1 , ma.attribute10 , ma.attribute11 , ma.attribute12 , ma.attribute13 , ma.attribute14 , ma.attribute15 , ma.attribute16 , ma.attribute17 , ma.attribute18 , ma.attribute19 , ma.attribute2 , ma.attribute20 , ma.attribute21 , ma.attribute22 , ma.attribute23 , ma.attribute24 , ma.attribute25 , ma.attribute26 , ma.attribute27 , ma.attribute28 , ma.attribute29 , ma.attribute3, ma.attribute30 , ma.attribute4 , ma.attribute5 , ma.attribute6 , ma.attribute7 , ma.attribute8 , ma.attribute9 , ma.attribute_category_code , ma.beginning_nbv , ma.book_type_code , ma.context , ma.created_by , trunc(ma.create_batch_date) create_batch_date , ma.create_batch_id , ma.creation_date , ma.date_placed_in_service , ma.depreciate_flag , ma.deprn_reserve , ma.description , ma.expense_code_combination_id , ma.feeder_system_name , ma.fixed_assets_cost , ma.fixed_assets_units , ma.fully_rsvd_revals_counter , ma.invoice_created_by , ma.invoice_date , ma.invoice_id , ma.invoice_number , ma.invoice_updated_by , ma.last_updated_by , ma.last_update_date , ma.last_update_login , ma.location_id , ma.manufacturer_name , ma.mass_addition_id , ma.merged_code , ma.merge_invoice_number , ma.merge_parent_mass_additions_id , ma.merge_vendor_number , ma.model_number , ma.new_master_flag , ma.parent_asset_id , ma.parent_mass_addition_id , ma.payables_batch_name , ma.payables_code_combination_id , ma.payables_cost , ma.payables_units , ma.posting_status , ma.post_batch_id , ma.po_number , ma.po_vendor_id , ma.production_capacity , ma.queue_name , ma.reval_amortization_basis , ma.reval_reserve , ma.reviewer_comments , ma.salvage_value , ma.serial_number , ma.split_code , ma.split_merged_code , ma.split_parent_mass_additions_id , ma.sum_units , ma.tag_number , ma.unit_of_measure , ma.unrevalued_cost , ma.ytd_deprn , ma.ytd_reval_deprn_expense , ma.project_asset_line_id , ma.project_id , ma.task_id , ma.global_attribute1 , ma.global_attribute10 , ma.global_attribute11 , ma.global_attribute12 , ma.global_attribute13 , ma.global_attribute14 , ma.global_attribute15 , ma.global_attribute16 , ma.global_attribute17 , ma.global_attribute18 , ma.global_attribute19, ma.global_attribute2 , ma.global_attribute20, ma.global_attribute3 , ma.global_attribute4 , ma.global_attribute5 , ma.global_attribute6 , ma.global_attribute7 , ma.global_attribute8 , ma.global_attribute9 , ma.global_attribute_category, falk1.lookup_code queue_name_lookup_code , falk1.lookup_type queue_name_lookup_type , falk1.meaning queue_name_disp , falk2.lookup_code asset_type_lookup_code , falk2.lookup_type asset_type_lookup_type , falk2.meaning asset_type_meaning , falk3.lookup_code depreciate_flag_lookup_code , falk3.lookup_type depreciate_flag_lookup_type , falk3.meaning depreciate_flag_meaning , emp.full_name employee_name ,emp.employee_number employee_number , po.vendor_name vendor_name , po.segment1 vendor_number , ad.asset_number parent_asset_number , ad.description parent_asset_description , ma.inventorial, ma.group_asset_id ,ma.transaction_type_code, falk6.meaning transaction_type_disp, ma.transaction_date, ma.warranty_id, ma.lease_id, lease.lease_number, lease.description lease_desc, ma.lessor_id, pv.vendor_name lessor, ma.property_type_code, falk4.meaning property_type_meaning, ma.property_1245_1250_code, falk5.meaning property_1245_1250_meaning, ma.in_use_flag, ma.owned_leased, ma.new_used, ma.asset_id, decode(ma.warranty_number, null, war.warranty_number, ma.warranty_number ) warranty_number, gad.asset_number group_asset_number, ma.material_indicator_flag, ma.invoice_distribution_id, ma.invoice_line_number, ma.deprn_method_code, ma.life_in_months, ma.basic_rate, ma.adjusted_rate, ma.prorate_convention_code, ma.bonus_rule, ma.salvage_type, ma.percent_salvage_value, ma.deprn_limit_type, ma.allowed_deprn_limit_amount, ma.allowed_deprn_limit, ma.po_distribution_id from fa_lookups falk1, fa_lookups falk2, fa_lookups falk3, fa_lookups falk4, fa_lookups falk5, fa_lookups falk6, po_vendors po, per_people_f emp, fa_additions_non_sec_vl ad, fa_mass_additions ma, fa_leases lease, fa_warranties war, po_vendors pv, fa_additions_b gad WHERE falk1.lookup_type ( + ) = 'QUEUE NAME' and falk2.lookup_type ( + ) = 'ASSET TYPE' and falk3.lookup_type ( + ) = 'YESNO' and decode (ma.posting_status, 'SPLIT', ma.posting_status, decode ( ma.posting_status, 'MERGED', ma.posting_status, ma.queue_name ) ) = falk1.lookup_code ( + ) and ma.asset_type = falk2.lookup_code ( + ) and ma.depreciate_flag = falk3.lookup_code ( + ) and ma.assigned_to = emp.person_id ( + ) and trunc ( sysdate ) between nvl ( emp.effective_start_date,trunc ( sysdate ) ) and nvl ( emp.effective_end_date,trunc ( sysdate ) ) and ma.po_vendor_id = po.vendor_id ( + ) and ma.parent_asset_id = ad.asset_id ( + ) and ma.lease_id = lease.lease_id ( + ) and ma.property_type_code = falk4.lookup_code (+) and falk4.lookup_type(+) = 'PROPERTY TYPE' and ma.property_1245_1250_code = falk5.lookup_code (+) and falk5.lookup_type(+) = '1245/1250 PROPERTY' and ma.transaction_type_code = falk6.lookup_code (+) and falk6.lookup_type(+) = 'FAXOLTRX' and exists (select 'X' from fa_book_controls_sec bc where bc.book_type_code = ma.book_type_code and nvl ( bc.date_ineffective, sysdate+1 ) > sysdate ) and ma.warranty_id = war.warranty_id (+) and pv.vendor_id (+) = lease.lessor_id and gad.asset_id (+) = ma.group_asset_id

View Text - HTML Formatted

SELECT MA.ROWID ROW_ID
, MA.ACCOUNTING_DATE
, MA.ADD_TO_ASSET_ID
, MA.AMORTIZE_FLAG
, MA.AP_DISTRIBUTION_LINE_NUMBER
, MA.ASSET_CATEGORY_ID
, MA.ASSET_KEY_CCID
, MA.ASSET_NUMBER
, MA.ASSET_TYPE
, MA.ASSIGNED_TO
, MA.ATTRIBUTE1
, MA.ATTRIBUTE10
, MA.ATTRIBUTE11
, MA.ATTRIBUTE12
, MA.ATTRIBUTE13
, MA.ATTRIBUTE14
, MA.ATTRIBUTE15
, MA.ATTRIBUTE16
, MA.ATTRIBUTE17
, MA.ATTRIBUTE18
, MA.ATTRIBUTE19
, MA.ATTRIBUTE2
, MA.ATTRIBUTE20
, MA.ATTRIBUTE21
, MA.ATTRIBUTE22
, MA.ATTRIBUTE23
, MA.ATTRIBUTE24
, MA.ATTRIBUTE25
, MA.ATTRIBUTE26
, MA.ATTRIBUTE27
, MA.ATTRIBUTE28
, MA.ATTRIBUTE29
, MA.ATTRIBUTE3
, MA.ATTRIBUTE30
, MA.ATTRIBUTE4
, MA.ATTRIBUTE5
, MA.ATTRIBUTE6
, MA.ATTRIBUTE7
, MA.ATTRIBUTE8
, MA.ATTRIBUTE9
, MA.ATTRIBUTE_CATEGORY_CODE
, MA.BEGINNING_NBV
, MA.BOOK_TYPE_CODE
, MA.CONTEXT
, MA.CREATED_BY
, TRUNC(MA.CREATE_BATCH_DATE) CREATE_BATCH_DATE
, MA.CREATE_BATCH_ID
, MA.CREATION_DATE
, MA.DATE_PLACED_IN_SERVICE
, MA.DEPRECIATE_FLAG
, MA.DEPRN_RESERVE
, MA.DESCRIPTION
, MA.EXPENSE_CODE_COMBINATION_ID
, MA.FEEDER_SYSTEM_NAME
, MA.FIXED_ASSETS_COST
, MA.FIXED_ASSETS_UNITS
, MA.FULLY_RSVD_REVALS_COUNTER
, MA.INVOICE_CREATED_BY
, MA.INVOICE_DATE
, MA.INVOICE_ID
, MA.INVOICE_NUMBER
, MA.INVOICE_UPDATED_BY
, MA.LAST_UPDATED_BY
, MA.LAST_UPDATE_DATE
, MA.LAST_UPDATE_LOGIN
, MA.LOCATION_ID
, MA.MANUFACTURER_NAME
, MA.MASS_ADDITION_ID
, MA.MERGED_CODE
, MA.MERGE_INVOICE_NUMBER
, MA.MERGE_PARENT_MASS_ADDITIONS_ID
, MA.MERGE_VENDOR_NUMBER
, MA.MODEL_NUMBER
, MA.NEW_MASTER_FLAG
, MA.PARENT_ASSET_ID
, MA.PARENT_MASS_ADDITION_ID
, MA.PAYABLES_BATCH_NAME
, MA.PAYABLES_CODE_COMBINATION_ID
, MA.PAYABLES_COST
, MA.PAYABLES_UNITS
, MA.POSTING_STATUS
, MA.POST_BATCH_ID
, MA.PO_NUMBER
, MA.PO_VENDOR_ID
, MA.PRODUCTION_CAPACITY
, MA.QUEUE_NAME
, MA.REVAL_AMORTIZATION_BASIS
, MA.REVAL_RESERVE
, MA.REVIEWER_COMMENTS
, MA.SALVAGE_VALUE
, MA.SERIAL_NUMBER
, MA.SPLIT_CODE
, MA.SPLIT_MERGED_CODE
, MA.SPLIT_PARENT_MASS_ADDITIONS_ID
, MA.SUM_UNITS
, MA.TAG_NUMBER
, MA.UNIT_OF_MEASURE
, MA.UNREVALUED_COST
, MA.YTD_DEPRN
, MA.YTD_REVAL_DEPRN_EXPENSE
, MA.PROJECT_ASSET_LINE_ID
, MA.PROJECT_ID
, MA.TASK_ID
, MA.GLOBAL_ATTRIBUTE1
, MA.GLOBAL_ATTRIBUTE10
, MA.GLOBAL_ATTRIBUTE11
, MA.GLOBAL_ATTRIBUTE12
, MA.GLOBAL_ATTRIBUTE13
, MA.GLOBAL_ATTRIBUTE14
, MA.GLOBAL_ATTRIBUTE15
, MA.GLOBAL_ATTRIBUTE16
, MA.GLOBAL_ATTRIBUTE17
, MA.GLOBAL_ATTRIBUTE18
, MA.GLOBAL_ATTRIBUTE19
, MA.GLOBAL_ATTRIBUTE2
, MA.GLOBAL_ATTRIBUTE20
, MA.GLOBAL_ATTRIBUTE3
, MA.GLOBAL_ATTRIBUTE4
, MA.GLOBAL_ATTRIBUTE5
, MA.GLOBAL_ATTRIBUTE6
, MA.GLOBAL_ATTRIBUTE7
, MA.GLOBAL_ATTRIBUTE8
, MA.GLOBAL_ATTRIBUTE9
, MA.GLOBAL_ATTRIBUTE_CATEGORY
, FALK1.LOOKUP_CODE QUEUE_NAME_LOOKUP_CODE
, FALK1.LOOKUP_TYPE QUEUE_NAME_LOOKUP_TYPE
, FALK1.MEANING QUEUE_NAME_DISP
, FALK2.LOOKUP_CODE ASSET_TYPE_LOOKUP_CODE
, FALK2.LOOKUP_TYPE ASSET_TYPE_LOOKUP_TYPE
, FALK2.MEANING ASSET_TYPE_MEANING
, FALK3.LOOKUP_CODE DEPRECIATE_FLAG_LOOKUP_CODE
, FALK3.LOOKUP_TYPE DEPRECIATE_FLAG_LOOKUP_TYPE
, FALK3.MEANING DEPRECIATE_FLAG_MEANING
, EMP.FULL_NAME EMPLOYEE_NAME
, EMP.EMPLOYEE_NUMBER EMPLOYEE_NUMBER
, PO.VENDOR_NAME VENDOR_NAME
, PO.SEGMENT1 VENDOR_NUMBER
, AD.ASSET_NUMBER PARENT_ASSET_NUMBER
, AD.DESCRIPTION PARENT_ASSET_DESCRIPTION
, MA.INVENTORIAL
, MA.GROUP_ASSET_ID
, MA.TRANSACTION_TYPE_CODE
, FALK6.MEANING TRANSACTION_TYPE_DISP
, MA.TRANSACTION_DATE
, MA.WARRANTY_ID
, MA.LEASE_ID
, LEASE.LEASE_NUMBER
, LEASE.DESCRIPTION LEASE_DESC
, MA.LESSOR_ID
, PV.VENDOR_NAME LESSOR
, MA.PROPERTY_TYPE_CODE
, FALK4.MEANING PROPERTY_TYPE_MEANING
, MA.PROPERTY_1245_1250_CODE
, FALK5.MEANING PROPERTY_1245_1250_MEANING
, MA.IN_USE_FLAG
, MA.OWNED_LEASED
, MA.NEW_USED
, MA.ASSET_ID
, DECODE(MA.WARRANTY_NUMBER
, NULL
, WAR.WARRANTY_NUMBER
, MA.WARRANTY_NUMBER ) WARRANTY_NUMBER
, GAD.ASSET_NUMBER GROUP_ASSET_NUMBER
, MA.MATERIAL_INDICATOR_FLAG
, MA.INVOICE_DISTRIBUTION_ID
, MA.INVOICE_LINE_NUMBER
, MA.DEPRN_METHOD_CODE
, MA.LIFE_IN_MONTHS
, MA.BASIC_RATE
, MA.ADJUSTED_RATE
, MA.PRORATE_CONVENTION_CODE
, MA.BONUS_RULE
, MA.SALVAGE_TYPE
, MA.PERCENT_SALVAGE_VALUE
, MA.DEPRN_LIMIT_TYPE
, MA.ALLOWED_DEPRN_LIMIT_AMOUNT
, MA.ALLOWED_DEPRN_LIMIT
, MA.PO_DISTRIBUTION_ID
FROM FA_LOOKUPS FALK1
, FA_LOOKUPS FALK2
, FA_LOOKUPS FALK3
, FA_LOOKUPS FALK4
, FA_LOOKUPS FALK5
, FA_LOOKUPS FALK6
, PO_VENDORS PO
, PER_PEOPLE_F EMP
, FA_ADDITIONS_NON_SEC_VL AD
, FA_MASS_ADDITIONS MA
, FA_LEASES LEASE
, FA_WARRANTIES WAR
, PO_VENDORS PV
, FA_ADDITIONS_B GAD
WHERE FALK1.LOOKUP_TYPE ( + ) = 'QUEUE NAME'
AND FALK2.LOOKUP_TYPE ( + ) = 'ASSET TYPE'
AND FALK3.LOOKUP_TYPE ( + ) = 'YESNO'
AND DECODE (MA.POSTING_STATUS
, 'SPLIT'
, MA.POSTING_STATUS
, DECODE ( MA.POSTING_STATUS
, 'MERGED'
, MA.POSTING_STATUS
, MA.QUEUE_NAME ) ) = FALK1.LOOKUP_CODE ( + )
AND MA.ASSET_TYPE = FALK2.LOOKUP_CODE ( + )
AND MA.DEPRECIATE_FLAG = FALK3.LOOKUP_CODE ( + )
AND MA.ASSIGNED_TO = EMP.PERSON_ID ( + )
AND TRUNC ( SYSDATE ) BETWEEN NVL ( EMP.EFFECTIVE_START_DATE
, TRUNC ( SYSDATE ) )
AND NVL ( EMP.EFFECTIVE_END_DATE
, TRUNC ( SYSDATE ) )
AND MA.PO_VENDOR_ID = PO.VENDOR_ID ( + )
AND MA.PARENT_ASSET_ID = AD.ASSET_ID ( + )
AND MA.LEASE_ID = LEASE.LEASE_ID ( + )
AND MA.PROPERTY_TYPE_CODE = FALK4.LOOKUP_CODE (+)
AND FALK4.LOOKUP_TYPE(+) = 'PROPERTY TYPE'
AND MA.PROPERTY_1245_1250_CODE = FALK5.LOOKUP_CODE (+)
AND FALK5.LOOKUP_TYPE(+) = '1245/1250 PROPERTY'
AND MA.TRANSACTION_TYPE_CODE = FALK6.LOOKUP_CODE (+)
AND FALK6.LOOKUP_TYPE(+) = 'FAXOLTRX'
AND EXISTS (SELECT 'X'
FROM FA_BOOK_CONTROLS_SEC BC
WHERE BC.BOOK_TYPE_CODE = MA.BOOK_TYPE_CODE
AND NVL ( BC.DATE_INEFFECTIVE
, SYSDATE+1 ) > SYSDATE )
AND MA.WARRANTY_ID = WAR.WARRANTY_ID (+)
AND PV.VENDOR_ID (+) = LEASE.LESSOR_ID
AND GAD.ASSET_ID (+) = MA.GROUP_ASSET_ID