ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN E811F942597A2075E0530100007FF4F2 Blitz Upload Mode Y select xxen_upload.action_create id, xxen_upload.action_meaning(xxen_upload.action_create) value, null description from dual union all select xxen_upload.action_create || ',' || xxen_upload.action_update id, xxen_upload.action_meaning(xxen_upload.action_create)||', '||xxen_upload.action_meaning(xxen_upload.action_update) value, null description from dual US ED83C3588D118586E0530100007FB788 FA Category Y select fcbk.concatenated_segments value, null description from fa_categories_b_kfv fcbk where (nvl(:$flex$.book,:$flex$.asset_book) is null and (:$flex$.ledger_id is null or fcbk.category_id in (select fcb.category_id from gl_ledgers gl, fa_book_controls_sec fbcs, fa_category_books fcb where xxen_util.contains(:$flex$.ledger,gl.name)='Y' and gl.ledger_id=fbcs.set_of_books_id and fbcs.book_type_code = fcb.book_type_code) ) ) or fcbk.category_id in (select fcb.category_id from fa_category_books fcb where xxen_util.contains(nvl(:$flex$.book,:$flex$.asset_book),fcb.book_type_code)='Y') order by fcbk.concatenated_segments US 3E831F8C1BF26BD6E0633D7D37A2BA15 select null action_, null status_, null message_, null modified_columns_, null request_id_, 'Addition' record_type, fav.asset_number, fav.description, fav.tag_number, fcbk.concatenated_segments category, fav.serial_number, fakk.concatenated_segments asset_key, (select fl0.meaning from fa_lookups fl0 where fl0.lookup_type='ASSET TYPE' and fl0.lookup_code=fav.asset_type) asset_type, fav.current_units units, fab_p.asset_number parent_asset, fav.manufacturer_name manufacturer, fav.model_number model, fw.warranty_number, fl.lease_number, (select fl0.meaning from fa_lookups fl0 where fl0.lookup_type='YESNO' and fl0.lookup_code=fav.in_use_flag) in_use, (select fl0.meaning from fa_lookups fl0 where fl0.lookup_type='YESNO' and fl0.lookup_code=fav.inventorial) in_physical_inventory, (select fl0.meaning from fa_lookups fl0 where fl0.lookup_type='PROPERTY TYPE' and fl0.lookup_code=fav.property_type_code) property_type, (select fl0.meaning from fa_lookups fl0 where fl0.lookup_type='1245/1250 PROPERTY' and fl0.lookup_code=fav.property_1245_1250_code) property_class, (select fl0.meaning from fa_lookups fl0 where fl0.lookup_type='OWNLEASE' and fl0.lookup_code=fav.owned_leased) ownership, (select fl0.meaning from fa_lookups fl0 where fl0.lookup_type='NEWUSE' and fl0.lookup_code=fav.new_used) bought, fav.commitment, fav.investment_law, fb.book_type_code book, fb.cost, fb.original_cost, fds.ytd_deprn ytd_depreciation, fds.deprn_reserve depreciation_reserve, (select fl0.meaning from fa_lookups fl0 where fl0.lookup_type='SALVAGE_DEPRN_LIMIT_TYPE' and fl0.lookup_code=decode(fb.salvage_type,'AMT','AMOUNT','PCT','PERCENT',fb.salvage_type)) salvage_value_type, fb.percent_salvage_value, fb.salvage_value, fb.reval_ceiling revaluation_ceiling, fb.reval_amortization_basis revaluation_amortization_basis, fb.recoverable_cost, (fb.original_cost-nvl(fds.deprn_reserve,0)) net_book_value, fb.deprn_method_code depreciation_method, (select fl0.meaning from fa_lookups fl0 where fl0.lookup_type='YESNO' and fl0.lookup_code=fb.depreciate_flag) depreciate, floor(fb.life_in_months/12) life_years, mod(fb.life_in_months,12) life_months, fb.date_placed_in_service, fb.prorate_convention_code prorate_convention, fth.amortization_start_date, fb.bonus_rule, (select fl0.meaning from fa_lookups fl0 where fl0.lookup_type='SALVAGE_DEPRN_LIMIT_TYPE' and fl0.lookup_code=decode(fb.deprn_limit_type,'AMT','AMOUNT','PCT','PERCENT',fb.deprn_limit_type)) depreciation_limit_type, fb.allowed_deprn_limit_amount depreciation_limit_amount, fb.allowed_deprn_limit depreciation_limit_pct, fab_g.asset_number group_asset, null expense_account_alias, gcck.concatenated_segments expense_account, gcck.segment1 expense_segment1, gcck.segment2 expense_segment2, gcck.segment3 expense_segment3, gcck.segment4 expense_segment4, gcck.segment5 expense_segment5, null location_alias, flk.concatenated_segments location, flk.segment1 location_segment1, flk.segment2 location_segment2, flk.segment3 location_segment3, flk.segment4 location_segment4, papf.full_name employee_name, papf.employee_number, fav.attribute_category_code attribute_category, fav.attribute1, fav.attribute2, fav.attribute3, fav.attribute4, fav.attribute5, fav.attribute6, fav.attribute7, fav.attribute8, fav.attribute9, fav.attribute10, fav.attribute11, fav.attribute12, fav.attribute13, fav.attribute14, fav.attribute15, null date_retired, null cost_retired, null units_retired, null proceeds_of_sale, null cost_of_removal, null retirement_type, null retire_prorate_conv, null sold_to, null reference_num, null trade_in_asset_number, null transaction_name, null retire_status from fa_additions_vl fav, fa_books fb, fa_transaction_headers fth, fa_book_controls fbc, gl_ledgers gl, fa_categories_b_kfv fcbk, fa_category_books fcb, fa_deprn_summary fds, fa_distribution_history fdh, fa_locations_kfv flk, gl_code_combinations_kfv gcck, fa_asset_keywords_kfv fakk, fa_add_warranties faw, fa_warranties fw, fa_leases fl, fa_additions_b fab_p, fa_additions_b fab_g, per_all_people_f papf where 1=1 and :p_upload_mode like '%' || xxen_upload.action_update and nvl(:p_create_empty_file,'N')<>'Y' and fav.asset_id=fb.asset_id and fb.date_ineffective is null and fb.transaction_header_id_in=fth.transaction_header_id and fb.book_type_code=fbc.book_type_code and fbc.set_of_books_id=gl.ledger_id and fav.asset_category_id=fcbk.category_id and fcbk.category_id=fcb.category_id and fb.book_type_code=fcb.book_type_code and fav.asset_id=fds.asset_id and fb.book_type_code=fds.book_type_code and fds.period_counter=(select max(fdp.period_counter) from fa_deprn_periods fdp where fdp.book_type_code=fb.book_type_code and fdp.period_close_date is not null) and fav.asset_id=fdh.asset_id and fb.book_type_code=fdh.book_type_code and fdh.date_ineffective is null and fdh.location_id=flk.location_id and fdh.code_combination_id=gcck.code_combination_id and fav.asset_key_ccid=fakk.code_combination_id(+) and fav.asset_id=faw.asset_id(+) and faw.warranty_id=fw.warranty_id(+) and fav.lease_id=fl.lease_id(+) and fav.parent_asset_id=fab_p.asset_id(+) and fb.group_asset_id=fab_g.asset_id(+) and fdh.assigned_to=papf.person_id(+) and papf.effective_start_date(+)<=trunc(sysdate) and papf.effective_end_date(+)>=trunc(sysdate) union all select null action_, null status_, null message_, null modified_columns_, null request_id_, 'Retirement' record_type, fab.asset_number, fat.description, fab.tag_number, fcbk.concatenated_segments category, fab.serial_number, fakk.concatenated_segments asset_key, (select fl0.meaning from fa_lookups fl0 where fl0.lookup_type='ASSET TYPE' and fl0.lookup_code=fab.asset_type) asset_type, fab.current_units units, fab_p.asset_number parent_asset, fab.manufacturer_name manufacturer, fab.model_number model, null warranty_number, fl.lease_number, (select fl0.meaning from fa_lookups fl0 where fl0.lookup_type='YESNO' and fl0.lookup_code=fab.in_use_flag) in_use, (select fl0.meaning from fa_lookups fl0 where fl0.lookup_type='YESNO' and fl0.lookup_code=fab.inventorial) in_physical_inventory, (select fl0.meaning from fa_lookups fl0 where fl0.lookup_type='PROPERTY TYPE' and fl0.lookup_code=fab.property_type_code) property_type, (select fl0.meaning from fa_lookups fl0 where fl0.lookup_type='1245/1250 PROPERTY' and fl0.lookup_code=fab.property_1245_1250_code) property_class, (select fl0.meaning from fa_lookups fl0 where fl0.lookup_type='OWNLEASE' and fl0.lookup_code=fab.owned_leased) ownership, (select fl0.meaning from fa_lookups fl0 where fl0.lookup_type='NEWUSE' and fl0.lookup_code=fab.new_used) bought, fab.commitment, fab.investment_law, fb.book_type_code book, fb.cost, fb.original_cost, fds.ytd_deprn ytd_depreciation, fds.deprn_reserve depreciation_reserve, (select fl0.meaning from fa_lookups fl0 where fl0.lookup_type='SALVAGE_DEPRN_LIMIT_TYPE' and fl0.lookup_code=decode(fb.salvage_type,'AMT','AMOUNT','PCT','PERCENT',fb.salvage_type)) salvage_value_type, fb.percent_salvage_value, fb.salvage_value, fb.reval_ceiling revaluation_ceiling, fb.reval_amortization_basis revaluation_amortization_basis, fb.recoverable_cost, (fb.original_cost-nvl(fds.deprn_reserve,0)) net_book_value, fb.deprn_method_code depreciation_method, (select fl0.meaning from fa_lookups fl0 where fl0.lookup_type='YESNO' and fl0.lookup_code=fb.depreciate_flag) depreciate, floor(fb.life_in_months/12) life_years, mod(fb.life_in_months,12) life_months, fb.date_placed_in_service, fb.prorate_convention_code prorate_convention, null amortization_start_date, fb.bonus_rule, (select fl0.meaning from fa_lookups fl0 where fl0.lookup_type='SALVAGE_DEPRN_LIMIT_TYPE' and fl0.lookup_code=decode(fb.deprn_limit_type,'AMT','AMOUNT','PCT','PERCENT',fb.deprn_limit_type)) depreciation_limit_type, fb.allowed_deprn_limit_amount depreciation_limit_amount, fb.allowed_deprn_limit depreciation_limit_pct, fab_g.asset_number group_asset, null expense_account_alias, gcck.concatenated_segments expense_account, gcck.segment1 expense_segment1, gcck.segment2 expense_segment2, gcck.segment3 expense_segment3, gcck.segment4 expense_segment4, gcck.segment5 expense_segment5, null location_alias, flk.concatenated_segments location, flk.segment1 location_segment1, flk.segment2 location_segment2, flk.segment3 location_segment3, flk.segment4 location_segment4, null employee_name, null employee_number, fab.attribute_category_code attribute_category, fab.attribute1, fab.attribute2, fab.attribute3, fab.attribute4, fab.attribute5, fab.attribute6, fab.attribute7, fab.attribute8, fab.attribute9, fab.attribute10, fab.attribute11, fab.attribute12, fab.attribute13, fab.attribute14, fab.attribute15, fr.date_retired, fr.cost_retired, fr.units units_retired, fr.proceeds_of_sale, fr.cost_of_removal, fr.retirement_type_code retirement_type, fr.retirement_prorate_convention retire_prorate_conv, fr.sold_to, fr.reference_num, (select fab2.asset_number from fa_additions_b fab2 where fab2.asset_id=fr.trade_in_asset_id) trade_in_asset_number, fth.transaction_name, fr.status retire_status from fa_additions_b fab, fa_additions_tl fat, fa_retirements fr, fa_books fb, fa_transaction_headers fth, fa_categories_b_kfv fcbk, fa_category_books fcb, fa_deprn_summary fds, fa_distribution_history fdh, fa_locations_kfv flk, gl_code_combinations_kfv gcck, fa_asset_keywords_kfv fakk, fa_leases fl, fa_additions_b fab_p, fa_additions_b fab_g where 1=1 and :p_upload_mode like '%' || xxen_upload.action_update and nvl(:p_create_empty_file,'N')<>'Y' and fab.asset_id=fat.asset_id and fat.language=userenv('lang') and fab.asset_id=fr.asset_id and fr.book_type_code=fb.book_type_code and fb.transaction_header_id_out=fr.transaction_header_id_in and fth.transaction_header_id=fr.transaction_header_id_in and fab.asset_id=fb.asset_id and fb.book_type_code=fcb.book_type_code and fab.asset_category_id=fcbk.category_id and fcbk.category_id=fcb.category_id and fds.asset_id=fab.asset_id and fds.book_type_code=fb.book_type_code and fds.period_counter=(select max(fdp.period_counter) from fa_deprn_periods fdp where fdp.book_type_code=fb.book_type_code and fdp.period_close_date is not null) and fab.asset_id=fdh.asset_id and fdh.book_type_code=fb.book_type_code and fdh.date_effective<=fth.date_effective and nvl(fdh.date_ineffective,fth.date_effective+1)>=fth.date_effective and fdh.location_id=flk.location_id and fdh.code_combination_id=gcck.code_combination_id and fab.asset_key_ccid=fakk.code_combination_id(+) and fab.lease_id=fl.lease_id(+) and fab.parent_asset_id=fab_p.asset_id(+) and fb.group_asset_id=fab_g.asset_id(+) Added asset retirement support via fa_retirement_pub; switched asset creation from mass additions to fa_addition_pub API; added reclassification and financial adjustment on update; added record_type column; removed post_mass_additions post-procedure Y U A xxen_fa_upload.create_update_asset xxen_fa_upload.validate_asset( p_book_type_code=>:$column$.book, p_asset_number=>:$column$.asset_number, p_units=>:$column$.units, p_depreciation_method=>:$column$.depreciation_method, p_life_years=>:$column$.life_years, p_life_months=>:$column$.life_months, p_category=>:$column$.category, p_date_placed_in_service=>:$column$.date_placed_in_service, p_expense_account=>:$column$.expense_account, p_expense_segment1=>:$column$.expense_segment1, p_location=>:$column$.location, p_location_segment1=>:$column$.location_segment1, p_record_type=>:$column$.record_type ) US FA Asset Upload Upload to create, update, and retire fixed assets using FA Public APIs. New assets are created via fa_addition_pub.do_addition. Existing assets are updated via fa_asset_desc_pub.update_desc, fa_reclass_pub.do_reclass, and fa_adjustment_pub.do_adjustment. Asset retirements are processed via fa_retirement_pub.do_retirement. Use the Record Type column to select Addition or Retirement processing. Enginatics Upload 1=1 :p_create_empty_file :p_upload_mode 1 10 :p_upload_mode LOV Blitz Upload Mode E811F942597A2075E0530100007FF4F2 Y select xxen_upload.action_create id, xxen_upload.action_meaning(xxen_upload.action_create) value, null description from dual union all select xxen_upload.action_create || ',' || xxen_upload.action_update id, xxen_upload.action_meaning(xxen_upload.action_create)||', '||xxen_upload.action_meaning(xxen_upload.action_update) value, null description from dual C,U Y US Upload Mode 2 30 1=1 fb.book_type_code=:book_type_code LOV Oracle FA_ACTIVE_CORP_BOOK Y select book_type_code id, book_type_code value, book_type_name description from fa_book_controls_sec where book_class='CORPORATE' and nvl(date_ineffective,sysdate+1)>sysdate order by book_type_code US Book Book 3 40 1=1 fav.asset_number=:asset_number LOV custom Y select fab.asset_number id, fab.asset_number value, null description from fa_additions_b fab where exists (select null from fa_books fb where fb.book_type_code=:$flex$.book_type_code and fb.asset_id=fab.asset_id and fb.date_ineffective is null) order by fab.asset_number US Asset Number Asset Number 4 45 1=1 fcbk.concatenated_segments=:p_category LOV FA Category ED83C3588D118586E0530100007FB788 Y select fcbk.concatenated_segments value, null description from fa_categories_b_kfv fcbk where (nvl(:$flex$.book,:$flex$.asset_book) is null and (:$flex$.ledger_id is null or fcbk.category_id in (select fcb.category_id from gl_ledgers gl, fa_book_controls_sec fbcs, fa_category_books fcb where xxen_util.contains(:$flex$.ledger,gl.name)='Y' and gl.ledger_id=fbcs.set_of_books_id and fbcs.book_type_code = fcb.book_type_code) ) ) or fcbk.category_id in (select fcb.category_id from fa_category_books fcb where xxen_util.contains(nvl(:$flex$.book,:$flex$.asset_book),fcb.book_type_code)='Y') order by fcbk.concatenated_segments US Category 5 50 1=1 fcbk.concatenated_segments>=:p_from_category LOV FA Category ED83C3588D118586E0530100007FB788 Y select fcbk.concatenated_segments value, null description from fa_categories_b_kfv fcbk where (nvl(:$flex$.book,:$flex$.asset_book) is null and (:$flex$.ledger_id is null or fcbk.category_id in (select fcb.category_id from gl_ledgers gl, fa_book_controls_sec fbcs, fa_category_books fcb where xxen_util.contains(:$flex$.ledger,gl.name)='Y' and gl.ledger_id=fbcs.set_of_books_id and fbcs.book_type_code = fcb.book_type_code) ) ) or fcbk.category_id in (select fcb.category_id from fa_category_books fcb where xxen_util.contains(nvl(:$flex$.book,:$flex$.asset_book),fcb.book_type_code)='Y') order by fcbk.concatenated_segments US From Category From Category 6 60 1=1 fcbk.concatenated_segments<=:p_to_category LOV FA Category ED83C3588D118586E0530100007FB788 Y select fcbk.concatenated_segments value, null description from fa_categories_b_kfv fcbk where (nvl(:$flex$.book,:$flex$.asset_book) is null and (:$flex$.ledger_id is null or fcbk.category_id in (select fcb.category_id from gl_ledgers gl, fa_book_controls_sec fbcs, fa_category_books fcb where xxen_util.contains(:$flex$.ledger,gl.name)='Y' and gl.ledger_id=fbcs.set_of_books_id and fbcs.book_type_code = fcb.book_type_code) ) ) or fcbk.category_id in (select fcb.category_id from fa_category_books fcb where xxen_util.contains(nvl(:$flex$.book,:$flex$.asset_book),fcb.book_type_code)='Y') order by fcbk.concatenated_segments :$flex$.From_Category US To Category To Category 7 70 1=1 fav.asset_type=:p_asset_type LOV custom Y select fl.lookup_code id, fl.meaning value, null description from fa_lookups fl where fl.lookup_type='ASSET TYPE' and fl.enabled_flag='Y' order by fl.meaning US Asset Type Asset Type 8 80 1=1 (fb.original_cost-nvl(fds.deprn_reserve,0))>=:net_book_value_from Number US Net Book Value Greater Than Net Book Value Greater than or Equal To 9 90 1=1 (fb.original_cost-nvl(fds.deprn_reserve,0))<=:net_book_value_to Number US Net Book Value Less Than Net Book Value Less than or Equal To :$flex$.From_Category From Category To Category :$flex$.book_type_code Book Asset Number :$flex$.book_type_code Book Category :$flex$.book_type_code Book From Category :$flex$.book_type_code Book To Category 1 ACTION_ Char varchar2 2 STATUS_ Char varchar2 3 MESSAGE_ Char varchar2 4 MODIFIED_COLUMNS_ Char varchar2 Y 5 REQUEST_ID_ Char varchar2 Y 6 RECORD_TYPE LOV custom varchar2 Y select 'Addition' value, 'Asset Addition' description from dual union all select 'Retirement' value, 'Asset Retirement' description from dual Addition Y Y 7 ASSET_NUMBER Char varchar2 Can be null if Automatic Asset Numbering is enabled Y 8 DESCRIPTION Char varchar2 Y 9 TAG_NUMBER Char varchar2 10 CATEGORY LOV custom varchar2 Y select fcbk.category_id id, fcbk.concatenated_segments value, null description from fa_categories_b_kfv fcbk where fcbk.enabled_flag='Y' order by fcbk.concatenated_segments Y 11 SERIAL_NUMBER Char varchar2 12 ASSET_KEY LOV custom varchar2 Y select fak.code_combination_id id, fak.concatenated_segments value, null description from fa_asset_keywords_kfv fak where fak.enabled_flag='Y' order by fak.concatenated_segments 13 ASSET_TYPE LOV custom varchar2 Y select fl.lookup_code id, fl.meaning value, null description from fa_lookups fl where fl.lookup_type='ASSET TYPE' and fl.enabled_flag='Y' order by fl.meaning select fl.meaning from fa_lookups fl where fl.lookup_type='ASSET TYPE' and fl.lookup_code='CAPITALIZED' Y 14 UNITS Number number 1 Y 15 PARENT_ASSET LOV custom varchar2 Y select fab.asset_id id, fab.asset_number value, fat.description from fa_additions_b fab, fa_additions_tl fat where fat.asset_id=fab.asset_id and fat.language=userenv('lang') and exists (select null from fa_books fb where fb.book_type_code=:$column$.book and fb.asset_id=fab.asset_id and fb.date_ineffective is null) order by fab.asset_number 16 MANUFACTURER Char varchar2 17 MODEL Char varchar2 18 WARRANTY_NUMBER LOV custom varchar2 Y select fw.warranty_id id, fw.warranty_number value, null description from fa_warranties fw order by fw.warranty_number 19 LEASE_NUMBER LOV custom varchar2 Y select fl.lease_id id, fl.lease_number value, null description from fa_leases fl order by fl.lease_number 20 IN_USE LOV custom varchar2 Y select fl.lookup_code id, fl.meaning value, null description from fa_lookups fl where fl.lookup_type='YESNO' and fl.enabled_flag='Y' order by fl.lookup_code desc select fl.meaning from fa_lookups fl where fl.lookup_type='YESNO' and fl.lookup_code='YES' 21 IN_PHYSICAL_INVENTORY LOV custom varchar2 Y select fl.lookup_code id, fl.meaning value, null description from fa_lookups fl where fl.lookup_type='YESNO' and fl.enabled_flag='Y' order by fl.lookup_code desc select fl.meaning from fa_lookups fl where fl.lookup_type='YESNO' and fl.lookup_code='YES' 22 PROPERTY_TYPE LOV custom varchar2 Y select fl.lookup_code id, fl.meaning value, null description from fa_lookups fl where fl.lookup_type='PROPERTY TYPE' and fl.enabled_flag='Y' order by fl.meaning select fl.meaning from fa_lookups fl where fl.lookup_type='PROPERTY TYPE' and fl.lookup_code='PERSONAL' 23 PROPERTY_CLASS LOV custom varchar2 Y select fl.lookup_code id, fl.meaning value, null description from fa_lookups fl where fl.lookup_type='1245/1250 PROPERTY' and fl.enabled_flag='Y' order by fl.lookup_code select fl.meaning from fa_lookups fl where fl.lookup_type='1245/1250 PROPERTY' and fl.lookup_code='1245' 24 OWNERSHIP LOV custom varchar2 Y select fl.lookup_code id, fl.meaning value, null description from fa_lookups fl where fl.lookup_type='OWNLEASE' and fl.enabled_flag='Y' order by fl.meaning select fl.meaning from fa_lookups fl where fl.lookup_type='OWNLEASE' and fl.lookup_code='OWNED' Y 25 BOUGHT LOV custom varchar2 Y select fl.lookup_code id, fl.meaning value, null description from fa_lookups fl where fl.lookup_type='NEWUSE' and fl.enabled_flag='Y' order by fl.meaning select fl.meaning from fa_lookups fl where fl.lookup_type='NEWUSE' and fl.lookup_code='NEW' Y 26 COMMITMENT Char varchar2 27 INVESTMENT_LAW Char varchar2 28 BOOK LOV custom varchar2 Y select fbcs.book_type_code value, fbcs.book_type_name||' ('||fbcs.book_class||')' description from fa_book_controls_sec fbcs where nvl(fbcs.date_ineffective,sysdate+1)>sysdate and (:$column$.category is null or exists (select null from fa_category_books fcb where fcb.book_type_code=fbcs.book_type_code and fcb.category_id=(select fcbk.category_id from fa_categories_b_kfv fcbk where fcbk.concatenated_segments=:$column$.category))) order by fbcs.book_type_code Y Y 29 COST Number number Y 30 ORIGINAL_COST Number number Y 31 YTD_DEPRECIATION Number number 0 32 DEPRECIATION_RESERVE Number number 0 33 SALVAGE_VALUE_TYPE LOV custom varchar2 Y select decode(fl.lookup_code,'AMOUNT','AMT','PERCENT','PCT',fl.lookup_code) id, fl.meaning value, null description from fa_lookups fl where fl.lookup_type='SALVAGE_DEPRN_LIMIT_TYPE' and fl.enabled_flag='Y' and fl.lookup_code<>'NONE' and (fl.lookup_code<>'SUM' or :$column$.asset_type=(select fl0.meaning from fa_lookups fl0 where fl0.lookup_type='ASSET TYPE' and fl0.lookup_code='GROUP')) order by fl.meaning select fl.meaning from fa_lookups fl where fl.lookup_type='SALVAGE_DEPRN_LIMIT_TYPE' and fl.lookup_code='AMOUNT' Y 34 PERCENT_SALVAGE_VALUE Number number 0 35 SALVAGE_VALUE Number number 0 Y 36 REVALUATION_CEILING Number number 37 REVALUATION_AMORTIZATION_BASIS Number number 38 RECOVERABLE_COST Number number Y 39 NET_BOOK_VALUE Number number Y 40 DEPRECIATION_METHOD LOV custom varchar2 Y select distinct fm.method_code value, fm.name description from fa_methods fm, fa_book_controls fbc, fa_calendar_types fct, fa_deprn_basis_rules fdbr where fbc.book_type_code=:$column$.book and fbc.prorate_calendar=fct.calendar_type and (fct.number_per_fiscal_year=fm.prorate_periods_per_year or fm.prorate_periods_per_year is null) and fm.deprn_basis_rule_id=fdbr.deprn_basis_rule_id(+) and ( (:$column$.asset_type=(select fl0.meaning from fa_lookups fl0 where fl0.lookup_type='ASSET TYPE' and fl0.lookup_code='GROUP') or (:$column$.asset_type<>(select fl0.meaning from fa_lookups fl0 where fl0.lookup_type='ASSET TYPE' and fl0.lookup_code='GROUP') and :$column$.group_asset is not null)) and (fm.rate_source_rule<>'PRODUCTION' or (fm.rate_source_rule='PRODUCTION' and fdbr.rule_name='ENERGY PERIOD END BALANCE' and fbc.allow_member_tracking_flag='Y')) or (:$column$.asset_type<>(select fl0.meaning from fa_lookups fl0 where fl0.lookup_type='ASSET TYPE' and fl0.lookup_code='GROUP') and :$column$.group_asset is null)) order by fm.method_code, fm.name STL Y 41 DEPRECIATE LOV custom varchar2 Y select fl0.lookup_code id, fl0.meaning value, null description from fa_lookups fl0 where fl0.lookup_type='YESNO' order by fl0.meaning Yes 42 LIFE_YEARS Number number select trunc(fcbd.life_in_months/12) from fa_category_book_defaults fcbd, fa_methods fm, fa_deprn_periods fdp, fa_deprn_basis_rules fdbr where fdp.book_type_code=:$column$.book and fdp.period_close_date is null and fcbd.category_id=(select fcbk.category_id from fa_categories_b_kfv fcbk where fcbk.concatenated_segments=:$column$.category) and fcbd.book_type_code=:$column$.book and :$column$.date_placed_in_service>=fcbd.start_dpis and :$column$.date_placed_in_service<=nvl(fcbd.end_dpis,:$column$.date_placed_in_service) and fm.method_code=fcbd.deprn_method and decode(fm.rate_source_rule,'PRODUCTION','PROD','FLAT','FLAT',fm.life_in_months)=decode(fm.rate_source_rule,'PRODUCTION','PROD','FLAT','FLAT',fcbd.life_in_months) and fm.deprn_basis_rule_id=fdbr.deprn_basis_rule_id(+) 43 LIFE_MONTHS Number number select mod(fcbd.life_in_months,12) from fa_category_book_defaults fcbd, fa_methods fm, fa_deprn_periods fdp, fa_deprn_basis_rules fdbr where fdp.book_type_code=:$column$.book and fdp.period_close_date is null and fcbd.category_id=(select fcbk.category_id from fa_categories_b_kfv fcbk where fcbk.concatenated_segments=:$column$.category) and fcbd.book_type_code=:$column$.book and :$column$.date_placed_in_service>=fcbd.start_dpis and :$column$.date_placed_in_service<=nvl(fcbd.end_dpis,:$column$.date_placed_in_service) and fm.method_code=fcbd.deprn_method and decode(fm.rate_source_rule,'PRODUCTION','PROD','FLAT','FLAT',fm.life_in_months)=decode(fm.rate_source_rule,'PRODUCTION','PROD','FLAT','FLAT',fcbd.life_in_months) and fm.deprn_basis_rule_id=fdbr.deprn_basis_rule_id(+) 44 DATE_PLACED_IN_SERVICE Date date select fdp.calendar_period_close_date value from fa_deprn_periods fdp where fdp.book_type_code=:$column$.book and fdp.period_close_date is null Y 45 PRORATE_CONVENTION LOV custom varchar2 Y select distinct fcbd.prorate_convention_code value, null description from fa_category_book_defaults fcbd where fcbd.book_type_code=:$column$.book order by fcbd.prorate_convention_code select fcbd.prorate_convention_code from fa_category_book_defaults fcbd, fa_methods fm, fa_deprn_periods fdp, fa_deprn_basis_rules fdbr where fdp.book_type_code=:$column$.book and fdp.period_close_date is null and fcbd.category_id=(select fcbk.category_id from fa_categories_b_kfv fcbk where fcbk.concatenated_segments=:$column$.category) and fcbd.book_type_code=:$column$.book and :$column$.date_placed_in_service>=fcbd.start_dpis and :$column$.date_placed_in_service<=nvl(fcbd.end_dpis,:$column$.date_placed_in_service) and fm.method_code=fcbd.deprn_method and decode(fm.rate_source_rule,'PRODUCTION','PROD','FLAT','FLAT',fm.life_in_months)=decode(fm.rate_source_rule,'PRODUCTION','PROD','FLAT','FLAT',fcbd.life_in_months) and fm.deprn_basis_rule_id=fdbr.deprn_basis_rule_id(+) Y 46 AMORTIZATION_START_DATE Date date 47 BONUS_RULE LOV custom varchar2 Y select fbr.bonus_rule id, fbr.bonus_rule value, fbr.description from fa_bonus_rules fbr order by fbr.bonus_rule 48 DEPRECIATION_LIMIT_TYPE LOV custom varchar2 Y select decode(fl.lookup_code,'AMOUNT','AMT','PERCENT','PCT',fl.lookup_code) id, fl.meaning value, null description from fa_lookups fl where fl.lookup_type='SALVAGE_DEPRN_LIMIT_TYPE' and fl.enabled_flag='Y' and fl.lookup_code<>'NONE' and (fl.lookup_code<>'SUM' or :$column$.asset_type=(select fl0.meaning from fa_lookups fl0 where fl0.lookup_type='ASSET TYPE' and fl0.lookup_code='GROUP')) order by fl.meaning 49 DEPRECIATION_LIMIT_AMOUNT Number number 50 DEPRECIATION_LIMIT_PCT Number number 51 GROUP_ASSET LOV custom varchar2 Y select fab.asset_id id, fab.asset_number value, fat.description from fa_additions_b fab, fa_additions_tl fat where fat.asset_id=fab.asset_id and fat.language=userenv('lang') and fab.asset_type='GROUP' and exists (select null from fa_books fb where fb.book_type_code=:$column$.book and fb.asset_id=fab.asset_id and fb.date_ineffective is null) order by fab.asset_number 52 EXPENSE_ACCOUNT_ALIAS LOV custom varchar2 Y select fsfa.alias_name id, fsfa.alias_name value, fsfa.concatenated_segments description from fa_book_controls fbc, gl_ledgers gl, fnd_shorthand_flex_aliases fsfa, gl_code_combinations_kfv gcck where fbc.book_type_code=:$column$.book and gl.ledger_id=fbc.set_of_books_id and fsfa.application_id=101 and fsfa.id_flex_code='GL#' and fsfa.id_flex_num=gl.chart_of_accounts_id and fsfa.enabled_flag='Y' and trunc(sysdate) between nvl(fsfa.start_date_active,trunc(sysdate)) and nvl(fsfa.end_date_active,trunc(sysdate)) and gcck.chart_of_accounts_id=gl.chart_of_accounts_id and gcck.concatenated_segments=fsfa.concatenated_segments and gcck.enabled_flag='Y' and gcck.gl_account_type='E' and gcck.summary_flag='N' and gcck.detail_posting_allowed='Y' order by fsfa.alias_name 53 EXPENSE_ACCOUNT LOV custom varchar2 Y Y select gcck.code_combination_id id, gcck.concatenated_segments value, gcck.description from fa_book_controls fbc, gl_ledgers gl, gl_code_combinations_kfv gcck where fbc.book_type_code=:$column$.book and gl.ledger_id=fbc.set_of_books_id and gcck.chart_of_accounts_id=gl.chart_of_accounts_id and gcck.enabled_flag='Y' and gcck.gl_account_type='E' and gcck.summary_flag='N' and gcck.detail_posting_allowed='Y' and sysdate between nvl(gcck.start_date_active,sysdate) and nvl(gcck.end_date_active,sysdate) and (:$column$.expense_account_alias is null or gcck.concatenated_segments=( select fsfa.concatenated_segments from fnd_shorthand_flex_aliases fsfa where fsfa.application_id=101 and fsfa.id_flex_code='GL#' and fsfa.id_flex_num=gl.chart_of_accounts_id and fsfa.enabled_flag='Y' and trunc(sysdate) between nvl(fsfa.start_date_active,trunc(sysdate)) and nvl(fsfa.end_date_active,trunc(sysdate)) and fsfa.alias_name=:$column$.expense_account_alias)) order by gcck.concatenated_segments select gcck.concatenated_segments value from fa_book_controls fbc, gl_ledgers gl, gl_code_combinations_kfv gcck, fnd_shorthand_flex_aliases fsfa where fbc.book_type_code=:$column$.book and gl.ledger_id=fbc.set_of_books_id and gcck.chart_of_accounts_id=gl.chart_of_accounts_id and gcck.enabled_flag='Y' and gcck.gl_account_type='E' and gcck.summary_flag='N' and gcck.detail_posting_allowed='Y' and fsfa.application_id=101 and fsfa.id_flex_code='GL#' and fsfa.id_flex_num=gl.chart_of_accounts_id and fsfa.enabled_flag='Y' and trunc(sysdate) between nvl(fsfa.start_date_active,trunc(sysdate)) and nvl(fsfa.end_date_active,trunc(sysdate)) and gcck.concatenated_segments=fsfa.concatenated_segments and fsfa.alias_name=:$column$.expense_account_alias 54 EXPENSE_SEGMENT1 LOV custom varchar2 Y select distinct ffvv.flex_value id, ffvv.flex_value value, ffvv.description from fa_book_controls fbc, gl_ledgers gl, fnd_id_flex_segments_vl fifsgv, fnd_flex_values_vl ffvv where fbc.book_type_code=:$column$.book and gl.ledger_id=fbc.set_of_books_id and fifsgv.application_id=101 and fifsgv.id_flex_code='GL#' and fifsgv.id_flex_num=gl.chart_of_accounts_id and fifsgv.enabled_flag='Y' and fifsgv.application_column_name='SEGMENT1' and fifsgv.flex_value_set_id=ffvv.flex_value_set_id and ffvv.enabled_flag='Y' and sysdate between nvl(ffvv.start_date_active,sysdate) and nvl(ffvv.end_date_active,sysdate) and (:$column$.expense_account is null or ffvv.flex_value=(select gcck.segment1 from gl_code_combinations_kfv gcck where gcck.concatenated_segments=:$column$.expense_account and gcck.chart_of_accounts_id=fifsgv.id_flex_num)) order by ffvv.flex_value select distinct ffvv.flex_value value from fa_book_controls fbc, gl_ledgers gl, fnd_id_flex_segments_vl fifsgv, fnd_flex_values_vl ffvv where fbc.book_type_code=:$column$.book and gl.ledger_id=fbc.set_of_books_id and fifsgv.application_id=101 and fifsgv.id_flex_code='GL#' and fifsgv.id_flex_num=gl.chart_of_accounts_id and fifsgv.application_column_name='SEGMENT1' and fifsgv.flex_value_set_id=ffvv.flex_value_set_id and ffvv.flex_value=(select gcck.segment1 from gl_code_combinations_kfv gcck where gcck.concatenated_segments=:$column$.expense_account and gcck.chart_of_accounts_id=fifsgv.id_flex_num) 55 EXPENSE_SEGMENT2 LOV custom varchar2 Y select distinct ffvv.flex_value id, ffvv.flex_value value, ffvv.description from fa_book_controls fbc, gl_ledgers gl, fnd_id_flex_segments_vl fifsgv, fnd_flex_values_vl ffvv where fbc.book_type_code=:$column$.book and gl.ledger_id=fbc.set_of_books_id and fifsgv.application_id=101 and fifsgv.id_flex_code='GL#' and fifsgv.id_flex_num=gl.chart_of_accounts_id and fifsgv.enabled_flag='Y' and fifsgv.application_column_name='SEGMENT2' and fifsgv.flex_value_set_id=ffvv.flex_value_set_id and ffvv.enabled_flag='Y' and sysdate between nvl(ffvv.start_date_active,sysdate) and nvl(ffvv.end_date_active,sysdate) and (:$column$.expense_account is null or ffvv.flex_value=(select gcck.segment2 from gl_code_combinations_kfv gcck where gcck.concatenated_segments=:$column$.expense_account and gcck.chart_of_accounts_id=fifsgv.id_flex_num)) order by ffvv.flex_value select distinct ffvv.flex_value value from fa_book_controls fbc, gl_ledgers gl, fnd_id_flex_segments_vl fifsgv, fnd_flex_values_vl ffvv where fbc.book_type_code=:$column$.book and gl.ledger_id=fbc.set_of_books_id and fifsgv.application_id=101 and fifsgv.id_flex_code='GL#' and fifsgv.id_flex_num=gl.chart_of_accounts_id and fifsgv.application_column_name='SEGMENT2' and fifsgv.flex_value_set_id=ffvv.flex_value_set_id and ffvv.flex_value=(select gcck.segment2 from gl_code_combinations_kfv gcck where gcck.concatenated_segments=:$column$.expense_account and gcck.chart_of_accounts_id=fifsgv.id_flex_num) 56 EXPENSE_SEGMENT3 LOV custom varchar2 Y select distinct ffvv.flex_value id, ffvv.flex_value value, ffvv.description from fa_book_controls fbc, gl_ledgers gl, fnd_id_flex_segments_vl fifsgv, fnd_flex_values_vl ffvv where fbc.book_type_code=:$column$.book and gl.ledger_id=fbc.set_of_books_id and fifsgv.application_id=101 and fifsgv.id_flex_code='GL#' and fifsgv.id_flex_num=gl.chart_of_accounts_id and fifsgv.enabled_flag='Y' and fifsgv.application_column_name='SEGMENT3' and fifsgv.flex_value_set_id=ffvv.flex_value_set_id and ffvv.enabled_flag='Y' and sysdate between nvl(ffvv.start_date_active,sysdate) and nvl(ffvv.end_date_active,sysdate) and (:$column$.expense_account is null and substr(ffvv.compiled_value_attributes,5,1)='E' or ffvv.flex_value=(select gcck.segment3 from gl_code_combinations_kfv gcck where gcck.concatenated_segments=:$column$.expense_account and gcck.chart_of_accounts_id=fifsgv.id_flex_num)) order by ffvv.flex_value select distinct ffvv.flex_value value from fa_book_controls fbc, gl_ledgers gl, fnd_id_flex_segments_vl fifsgv, fnd_flex_values_vl ffvv where fbc.book_type_code=:$column$.book and gl.ledger_id=fbc.set_of_books_id and fifsgv.application_id=101 and fifsgv.id_flex_code='GL#' and fifsgv.id_flex_num=gl.chart_of_accounts_id and fifsgv.application_column_name='SEGMENT3' and fifsgv.flex_value_set_id=ffvv.flex_value_set_id and ffvv.flex_value=(select gcck.segment3 from gl_code_combinations_kfv gcck where gcck.concatenated_segments=:$column$.expense_account and gcck.chart_of_accounts_id=fifsgv.id_flex_num) 57 EXPENSE_SEGMENT4 LOV custom varchar2 Y select distinct ffvv.flex_value id, ffvv.flex_value value, ffvv.description from fa_book_controls fbc, gl_ledgers gl, fnd_id_flex_segments_vl fifsgv, fnd_flex_values_vl ffvv where fbc.book_type_code=:$column$.book and gl.ledger_id=fbc.set_of_books_id and fifsgv.application_id=101 and fifsgv.id_flex_code='GL#' and fifsgv.id_flex_num=gl.chart_of_accounts_id and fifsgv.enabled_flag='Y' and fifsgv.application_column_name='SEGMENT4' and fifsgv.flex_value_set_id=ffvv.flex_value_set_id and ffvv.enabled_flag='Y' and sysdate between nvl(ffvv.start_date_active,sysdate) and nvl(ffvv.end_date_active,sysdate) and (:$column$.expense_account is null or ffvv.flex_value=(select gcck.segment4 from gl_code_combinations_kfv gcck where gcck.concatenated_segments=:$column$.expense_account and gcck.chart_of_accounts_id=fifsgv.id_flex_num)) order by ffvv.flex_value select distinct ffvv.flex_value value from fa_book_controls fbc, gl_ledgers gl, fnd_id_flex_segments_vl fifsgv, fnd_flex_values_vl ffvv where fbc.book_type_code=:$column$.book and gl.ledger_id=fbc.set_of_books_id and fifsgv.application_id=101 and fifsgv.id_flex_code='GL#' and fifsgv.id_flex_num=gl.chart_of_accounts_id and fifsgv.application_column_name='SEGMENT4' and fifsgv.flex_value_set_id=ffvv.flex_value_set_id and ffvv.flex_value=(select gcck.segment4 from gl_code_combinations_kfv gcck where gcck.concatenated_segments=:$column$.expense_account and gcck.chart_of_accounts_id=fifsgv.id_flex_num) 58 EXPENSE_SEGMENT5 LOV custom varchar2 Y select distinct ffvv.flex_value id, ffvv.flex_value value, ffvv.description from fa_book_controls fbc, gl_ledgers gl, fnd_id_flex_segments_vl fifsgv, fnd_flex_values_vl ffvv where fbc.book_type_code=:$column$.book and gl.ledger_id=fbc.set_of_books_id and fifsgv.application_id=101 and fifsgv.id_flex_code='GL#' and fifsgv.id_flex_num=gl.chart_of_accounts_id and fifsgv.enabled_flag='Y' and fifsgv.application_column_name='SEGMENT5' and fifsgv.flex_value_set_id=ffvv.flex_value_set_id and ffvv.enabled_flag='Y' and sysdate between nvl(ffvv.start_date_active,sysdate) and nvl(ffvv.end_date_active,sysdate) and (:$column$.expense_account is null or ffvv.flex_value=(select gcck.segment5 from gl_code_combinations_kfv gcck where gcck.concatenated_segments=:$column$.expense_account and gcck.chart_of_accounts_id=fifsgv.id_flex_num)) order by ffvv.flex_value select distinct ffvv.flex_value value from fa_book_controls fbc, gl_ledgers gl, fnd_id_flex_segments_vl fifsgv, fnd_flex_values_vl ffvv where fbc.book_type_code=:$column$.book and gl.ledger_id=fbc.set_of_books_id and fifsgv.application_id=101 and fifsgv.id_flex_code='GL#' and fifsgv.id_flex_num=gl.chart_of_accounts_id and fifsgv.application_column_name='SEGMENT5' and fifsgv.flex_value_set_id=ffvv.flex_value_set_id and ffvv.flex_value=(select gcck.segment5 from gl_code_combinations_kfv gcck where gcck.concatenated_segments=:$column$.expense_account and gcck.chart_of_accounts_id=fifsgv.id_flex_num) 59 LOCATION_ALIAS LOV custom varchar2 Y select fsfa.alias_name id, fsfa.alias_name value, fsfa.concatenated_segments description from fnd_shorthand_flex_aliases fsfa where fsfa.application_id=140 and fsfa.id_flex_code='LOC#' and fsfa.id_flex_num=101 and fsfa.enabled_flag='Y' and trunc(sysdate) between nvl(fsfa.start_date_active,trunc(sysdate)) and nvl(fsfa.end_date_active,trunc(sysdate)) order by fsfa.alias_name 60 LOCATION LOV custom varchar2 select flk.location_id id, flk.concatenated_segments value, null description from fa_locations_kfv flk where (:$column$.location_alias is null or flk.concatenated_segments=( select fsfa.concatenated_segments from fnd_shorthand_flex_aliases fsfa where fsfa.application_id=140 and fsfa.id_flex_code='LOC#' and fsfa.id_flex_num=101 and fsfa.enabled_flag='Y' and trunc(sysdate) between nvl(fsfa.start_date_active,trunc(sysdate)) and nvl(fsfa.end_date_active,trunc(sysdate)) and fsfa.alias_name=:$column$.location_alias)) order by flk.concatenated_segments select flk.concatenated_segments value from fa_locations_kfv flk, fnd_shorthand_flex_aliases fsfa where fsfa.application_id=140 and fsfa.id_flex_code='LOC#' and fsfa.id_flex_num=101 and fsfa.enabled_flag='Y' and trunc(sysdate) between nvl(fsfa.start_date_active,trunc(sysdate)) and nvl(fsfa.end_date_active,trunc(sysdate)) and flk.concatenated_segments=fsfa.concatenated_segments and fsfa.alias_name=:$column$.location_alias 61 LOCATION_SEGMENT1 LOV custom varchar2 Y select distinct ffvv.flex_value id, ffvv.flex_value value, ffvv.description from fnd_id_flex_segments_vl fifsgv, fnd_flex_values_vl ffvv where fifsgv.application_id=140 and fifsgv.id_flex_code='LOC#' and fifsgv.id_flex_num=101 and fifsgv.enabled_flag='Y' and fifsgv.application_column_name='SEGMENT1' and fifsgv.flex_value_set_id=ffvv.flex_value_set_id and ffvv.enabled_flag='Y' and sysdate between nvl(ffvv.start_date_active,sysdate) and nvl(ffvv.end_date_active,sysdate) and (:$column$.location is null or ffvv.flex_value=(select fl.segment1 from fa_locations fl, fa_locations_kfv flk where flk.concatenated_segments=:$column$.location and fl.location_id=flk.location_id)) order by ffvv.flex_value select distinct ffvv.flex_value value from fnd_id_flex_segments_vl fifsgv, fnd_flex_values_vl ffvv where fifsgv.application_id=140 and fifsgv.id_flex_code='LOC#' and fifsgv.id_flex_num=101 and fifsgv.application_column_name='SEGMENT1' and fifsgv.flex_value_set_id=ffvv.flex_value_set_id and ffvv.flex_value=(select fl.segment1 from fa_locations fl, fa_locations_kfv flk where flk.concatenated_segments=:$column$.location and fl.location_id=flk.location_id) 62 LOCATION_SEGMENT2 LOV custom varchar2 Y select distinct ffvv.flex_value id, ffvv.flex_value value, ffvv.description from fnd_id_flex_segments_vl fifsgv, fnd_flex_values_vl ffvv where fifsgv.application_id=140 and fifsgv.id_flex_code='LOC#' and fifsgv.id_flex_num=101 and fifsgv.enabled_flag='Y' and fifsgv.application_column_name='SEGMENT2' and fifsgv.flex_value_set_id=ffvv.flex_value_set_id and ffvv.enabled_flag='Y' and sysdate between nvl(ffvv.start_date_active,sysdate) and nvl(ffvv.end_date_active,sysdate) and (:$column$.location is null or ffvv.flex_value=(select fl.segment2 from fa_locations fl, fa_locations_kfv flk where flk.concatenated_segments=:$column$.location and fl.location_id=flk.location_id)) order by ffvv.flex_value select distinct ffvv.flex_value value from fnd_id_flex_segments_vl fifsgv, fnd_flex_values_vl ffvv where fifsgv.application_id=140 and fifsgv.id_flex_code='LOC#' and fifsgv.id_flex_num=101 and fifsgv.application_column_name='SEGMENT2' and fifsgv.flex_value_set_id=ffvv.flex_value_set_id and ffvv.flex_value=(select fl.segment2 from fa_locations fl, fa_locations_kfv flk where flk.concatenated_segments=:$column$.location and fl.location_id=flk.location_id) 63 LOCATION_SEGMENT3 LOV custom varchar2 Y select distinct ffvv.flex_value id, ffvv.flex_value value, ffvv.description from fnd_id_flex_segments_vl fifsgv, fnd_flex_values_vl ffvv where fifsgv.application_id=140 and fifsgv.id_flex_code='LOC#' and fifsgv.id_flex_num=101 and fifsgv.enabled_flag='Y' and fifsgv.application_column_name='SEGMENT3' and fifsgv.flex_value_set_id=ffvv.flex_value_set_id and ffvv.enabled_flag='Y' and sysdate between nvl(ffvv.start_date_active,sysdate) and nvl(ffvv.end_date_active,sysdate) and (:$column$.location is null or ffvv.flex_value=(select fl.segment3 from fa_locations fl, fa_locations_kfv flk where flk.concatenated_segments=:$column$.location and fl.location_id=flk.location_id)) order by ffvv.flex_value select distinct ffvv.flex_value value from fnd_id_flex_segments_vl fifsgv, fnd_flex_values_vl ffvv where fifsgv.application_id=140 and fifsgv.id_flex_code='LOC#' and fifsgv.id_flex_num=101 and fifsgv.application_column_name='SEGMENT3' and fifsgv.flex_value_set_id=ffvv.flex_value_set_id and ffvv.flex_value=(select fl.segment3 from fa_locations fl, fa_locations_kfv flk where flk.concatenated_segments=:$column$.location and fl.location_id=flk.location_id) 64 LOCATION_SEGMENT4 LOV custom varchar2 Y select distinct ffvv.flex_value id, ffvv.flex_value value, ffvv.description from fnd_id_flex_segments_vl fifsgv, fnd_flex_values_vl ffvv where fifsgv.application_id=140 and fifsgv.id_flex_code='LOC#' and fifsgv.id_flex_num=101 and fifsgv.enabled_flag='Y' and fifsgv.application_column_name='SEGMENT4' and fifsgv.flex_value_set_id=ffvv.flex_value_set_id and ffvv.enabled_flag='Y' and sysdate between nvl(ffvv.start_date_active,sysdate) and nvl(ffvv.end_date_active,sysdate) and (:$column$.location is null or ffvv.flex_value=(select fl.segment4 from fa_locations fl, fa_locations_kfv flk where flk.concatenated_segments=:$column$.location and fl.location_id=flk.location_id)) order by ffvv.flex_value select distinct ffvv.flex_value value from fnd_id_flex_segments_vl fifsgv, fnd_flex_values_vl ffvv where fifsgv.application_id=140 and fifsgv.id_flex_code='LOC#' and fifsgv.id_flex_num=101 and fifsgv.application_column_name='SEGMENT4' and fifsgv.flex_value_set_id=ffvv.flex_value_set_id and ffvv.flex_value=(select fl.segment4 from fa_locations fl, fa_locations_kfv flk where flk.concatenated_segments=:$column$.location and fl.location_id=flk.location_id) 65 EMPLOYEE_NAME LOV custom varchar2 Y Y select papf.person_id id, papf.full_name value, papf.employee_number description from per_all_people_f papf where papf.current_employee_flag='Y' and trunc(sysdate) between papf.effective_start_date and papf.effective_end_date order by papf.full_name 66 EMPLOYEE_NUMBER LOV custom varchar2 Y select papf.person_id id, papf.employee_number value, papf.full_name description from per_all_people_f papf where papf.current_employee_flag='Y' and trunc(sysdate) between papf.effective_start_date and papf.effective_end_date and (:$column$.employee_name is null or papf.full_name=:$column$.employee_name) order by papf.employee_number select papf.employee_number value from per_all_people_f papf where papf.full_name=:$column$.employee_name and papf.current_employee_flag='Y' and trunc(sysdate) between papf.effective_start_date and papf.effective_end_date 67 ATTRIBUTE_CATEGORY LOV custom varchar2 Y select distinct fdfcv.descriptive_flex_context_name value, fdfcv.description from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts_vl fdfcv where fdfcv.application_id=fdfv.application_id and fdfcv.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfcv.enabled_flag='Y' and fdfv.application_id=140 and fdfv.descriptive_flexfield_name='FA_ADDITIONS' and fdfcv.descriptive_flex_context_code<>'Global Data Elements' order by fdfcv.descriptive_flex_context_name 68 ATTRIBUTE1 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table(xxen_util.dff_attribute_lov( p_application_id=>140, p_descriptive_flexfield_name=>'FA_ADDITIONS', p_context_name=>:$column$.attribute_category, p_column_name=>'ATTRIBUTE1', p_attribute1=>:$column$.attribute1, p_attribute2=>:$column$.attribute2, p_attribute3=>:$column$.attribute3, p_attribute4=>:$column$.attribute4, p_attribute5=>:$column$.attribute5, p_attribute6=>:$column$.attribute6, p_attribute7=>:$column$.attribute7, p_attribute8=>:$column$.attribute8, p_attribute9=>:$column$.attribute9, p_attribute10=>:$column$.attribute10, p_attribute11=>:$column$.attribute11, p_attribute12=>:$column$.attribute12, p_attribute13=>:$column$.attribute13, p_attribute14=>:$column$.attribute14, p_attribute15=>:$column$.attribute15 )) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '|| listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=140 and fdfv.descriptive_flexfield_name='FA_ADDITIONS' and fdfcuv.application_column_name='ATTRIBUTE1' 69 ATTRIBUTE2 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table(xxen_util.dff_attribute_lov( p_application_id=>140, p_descriptive_flexfield_name=>'FA_ADDITIONS', p_context_name=>:$column$.attribute_category, p_column_name=>'ATTRIBUTE2', p_attribute1=>:$column$.attribute1, p_attribute2=>:$column$.attribute2, p_attribute3=>:$column$.attribute3, p_attribute4=>:$column$.attribute4, p_attribute5=>:$column$.attribute5, p_attribute6=>:$column$.attribute6, p_attribute7=>:$column$.attribute7, p_attribute8=>:$column$.attribute8, p_attribute9=>:$column$.attribute9, p_attribute10=>:$column$.attribute10, p_attribute11=>:$column$.attribute11, p_attribute12=>:$column$.attribute12, p_attribute13=>:$column$.attribute13, p_attribute14=>:$column$.attribute14, p_attribute15=>:$column$.attribute15 )) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '|| listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=140 and fdfv.descriptive_flexfield_name='FA_ADDITIONS' and fdfcuv.application_column_name='ATTRIBUTE2' 70 ATTRIBUTE3 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table(xxen_util.dff_attribute_lov( p_application_id=>140, p_descriptive_flexfield_name=>'FA_ADDITIONS', p_context_name=>:$column$.attribute_category, p_column_name=>'ATTRIBUTE3', p_attribute1=>:$column$.attribute1, p_attribute2=>:$column$.attribute2, p_attribute3=>:$column$.attribute3, p_attribute4=>:$column$.attribute4, p_attribute5=>:$column$.attribute5, p_attribute6=>:$column$.attribute6, p_attribute7=>:$column$.attribute7, p_attribute8=>:$column$.attribute8, p_attribute9=>:$column$.attribute9, p_attribute10=>:$column$.attribute10, p_attribute11=>:$column$.attribute11, p_attribute12=>:$column$.attribute12, p_attribute13=>:$column$.attribute13, p_attribute14=>:$column$.attribute14, p_attribute15=>:$column$.attribute15 )) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '|| listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=140 and fdfv.descriptive_flexfield_name='FA_ADDITIONS' and fdfcuv.application_column_name='ATTRIBUTE3' 71 ATTRIBUTE4 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table(xxen_util.dff_attribute_lov( p_application_id=>140, p_descriptive_flexfield_name=>'FA_ADDITIONS', p_context_name=>:$column$.attribute_category, p_column_name=>'ATTRIBUTE4', p_attribute1=>:$column$.attribute1, p_attribute2=>:$column$.attribute2, p_attribute3=>:$column$.attribute3, p_attribute4=>:$column$.attribute4, p_attribute5=>:$column$.attribute5, p_attribute6=>:$column$.attribute6, p_attribute7=>:$column$.attribute7, p_attribute8=>:$column$.attribute8, p_attribute9=>:$column$.attribute9, p_attribute10=>:$column$.attribute10, p_attribute11=>:$column$.attribute11, p_attribute12=>:$column$.attribute12, p_attribute13=>:$column$.attribute13, p_attribute14=>:$column$.attribute14, p_attribute15=>:$column$.attribute15 )) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '|| listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=140 and fdfv.descriptive_flexfield_name='FA_ADDITIONS' and fdfcuv.application_column_name='ATTRIBUTE4' 72 ATTRIBUTE5 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table(xxen_util.dff_attribute_lov( p_application_id=>140, p_descriptive_flexfield_name=>'FA_ADDITIONS', p_context_name=>:$column$.attribute_category, p_column_name=>'ATTRIBUTE5', p_attribute1=>:$column$.attribute1, p_attribute2=>:$column$.attribute2, p_attribute3=>:$column$.attribute3, p_attribute4=>:$column$.attribute4, p_attribute5=>:$column$.attribute5, p_attribute6=>:$column$.attribute6, p_attribute7=>:$column$.attribute7, p_attribute8=>:$column$.attribute8, p_attribute9=>:$column$.attribute9, p_attribute10=>:$column$.attribute10, p_attribute11=>:$column$.attribute11, p_attribute12=>:$column$.attribute12, p_attribute13=>:$column$.attribute13, p_attribute14=>:$column$.attribute14, p_attribute15=>:$column$.attribute15 )) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '|| listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=140 and fdfv.descriptive_flexfield_name='FA_ADDITIONS' and fdfcuv.application_column_name='ATTRIBUTE5' 73 ATTRIBUTE6 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table(xxen_util.dff_attribute_lov( p_application_id=>140, p_descriptive_flexfield_name=>'FA_ADDITIONS', p_context_name=>:$column$.attribute_category, p_column_name=>'ATTRIBUTE6', p_attribute1=>:$column$.attribute1, p_attribute2=>:$column$.attribute2, p_attribute3=>:$column$.attribute3, p_attribute4=>:$column$.attribute4, p_attribute5=>:$column$.attribute5, p_attribute6=>:$column$.attribute6, p_attribute7=>:$column$.attribute7, p_attribute8=>:$column$.attribute8, p_attribute9=>:$column$.attribute9, p_attribute10=>:$column$.attribute10, p_attribute11=>:$column$.attribute11, p_attribute12=>:$column$.attribute12, p_attribute13=>:$column$.attribute13, p_attribute14=>:$column$.attribute14, p_attribute15=>:$column$.attribute15 )) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '|| listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=140 and fdfv.descriptive_flexfield_name='FA_ADDITIONS' and fdfcuv.application_column_name='ATTRIBUTE6' 74 ATTRIBUTE7 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table(xxen_util.dff_attribute_lov( p_application_id=>140, p_descriptive_flexfield_name=>'FA_ADDITIONS', p_context_name=>:$column$.attribute_category, p_column_name=>'ATTRIBUTE7', p_attribute1=>:$column$.attribute1, p_attribute2=>:$column$.attribute2, p_attribute3=>:$column$.attribute3, p_attribute4=>:$column$.attribute4, p_attribute5=>:$column$.attribute5, p_attribute6=>:$column$.attribute6, p_attribute7=>:$column$.attribute7, p_attribute8=>:$column$.attribute8, p_attribute9=>:$column$.attribute9, p_attribute10=>:$column$.attribute10, p_attribute11=>:$column$.attribute11, p_attribute12=>:$column$.attribute12, p_attribute13=>:$column$.attribute13, p_attribute14=>:$column$.attribute14, p_attribute15=>:$column$.attribute15 )) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '|| listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=140 and fdfv.descriptive_flexfield_name='FA_ADDITIONS' and fdfcuv.application_column_name='ATTRIBUTE7' 75 ATTRIBUTE8 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table(xxen_util.dff_attribute_lov( p_application_id=>140, p_descriptive_flexfield_name=>'FA_ADDITIONS', p_context_name=>:$column$.attribute_category, p_column_name=>'ATTRIBUTE8', p_attribute1=>:$column$.attribute1, p_attribute2=>:$column$.attribute2, p_attribute3=>:$column$.attribute3, p_attribute4=>:$column$.attribute4, p_attribute5=>:$column$.attribute5, p_attribute6=>:$column$.attribute6, p_attribute7=>:$column$.attribute7, p_attribute8=>:$column$.attribute8, p_attribute9=>:$column$.attribute9, p_attribute10=>:$column$.attribute10, p_attribute11=>:$column$.attribute11, p_attribute12=>:$column$.attribute12, p_attribute13=>:$column$.attribute13, p_attribute14=>:$column$.attribute14, p_attribute15=>:$column$.attribute15 )) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '|| listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=140 and fdfv.descriptive_flexfield_name='FA_ADDITIONS' and fdfcuv.application_column_name='ATTRIBUTE8' 76 ATTRIBUTE9 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table(xxen_util.dff_attribute_lov( p_application_id=>140, p_descriptive_flexfield_name=>'FA_ADDITIONS', p_context_name=>:$column$.attribute_category, p_column_name=>'ATTRIBUTE9', p_attribute1=>:$column$.attribute1, p_attribute2=>:$column$.attribute2, p_attribute3=>:$column$.attribute3, p_attribute4=>:$column$.attribute4, p_attribute5=>:$column$.attribute5, p_attribute6=>:$column$.attribute6, p_attribute7=>:$column$.attribute7, p_attribute8=>:$column$.attribute8, p_attribute9=>:$column$.attribute9, p_attribute10=>:$column$.attribute10, p_attribute11=>:$column$.attribute11, p_attribute12=>:$column$.attribute12, p_attribute13=>:$column$.attribute13, p_attribute14=>:$column$.attribute14, p_attribute15=>:$column$.attribute15 )) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '|| listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=140 and fdfv.descriptive_flexfield_name='FA_ADDITIONS' and fdfcuv.application_column_name='ATTRIBUTE9' 77 ATTRIBUTE10 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table(xxen_util.dff_attribute_lov( p_application_id=>140, p_descriptive_flexfield_name=>'FA_ADDITIONS', p_context_name=>:$column$.attribute_category, p_column_name=>'ATTRIBUTE10', p_attribute1=>:$column$.attribute1, p_attribute2=>:$column$.attribute2, p_attribute3=>:$column$.attribute3, p_attribute4=>:$column$.attribute4, p_attribute5=>:$column$.attribute5, p_attribute6=>:$column$.attribute6, p_attribute7=>:$column$.attribute7, p_attribute8=>:$column$.attribute8, p_attribute9=>:$column$.attribute9, p_attribute10=>:$column$.attribute10, p_attribute11=>:$column$.attribute11, p_attribute12=>:$column$.attribute12, p_attribute13=>:$column$.attribute13, p_attribute14=>:$column$.attribute14, p_attribute15=>:$column$.attribute15 )) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '|| listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=140 and fdfv.descriptive_flexfield_name='FA_ADDITIONS' and fdfcuv.application_column_name='ATTRIBUTE10' 78 ATTRIBUTE11 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table(xxen_util.dff_attribute_lov( p_application_id=>140, p_descriptive_flexfield_name=>'FA_ADDITIONS', p_context_name=>:$column$.attribute_category, p_column_name=>'ATTRIBUTE11', p_attribute1=>:$column$.attribute1, p_attribute2=>:$column$.attribute2, p_attribute3=>:$column$.attribute3, p_attribute4=>:$column$.attribute4, p_attribute5=>:$column$.attribute5, p_attribute6=>:$column$.attribute6, p_attribute7=>:$column$.attribute7, p_attribute8=>:$column$.attribute8, p_attribute9=>:$column$.attribute9, p_attribute10=>:$column$.attribute10, p_attribute11=>:$column$.attribute11, p_attribute12=>:$column$.attribute12, p_attribute13=>:$column$.attribute13, p_attribute14=>:$column$.attribute14, p_attribute15=>:$column$.attribute15 )) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '|| listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=140 and fdfv.descriptive_flexfield_name='FA_ADDITIONS' and fdfcuv.application_column_name='ATTRIBUTE11' 79 ATTRIBUTE12 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table(xxen_util.dff_attribute_lov( p_application_id=>140, p_descriptive_flexfield_name=>'FA_ADDITIONS', p_context_name=>:$column$.attribute_category, p_column_name=>'ATTRIBUTE12', p_attribute1=>:$column$.attribute1, p_attribute2=>:$column$.attribute2, p_attribute3=>:$column$.attribute3, p_attribute4=>:$column$.attribute4, p_attribute5=>:$column$.attribute5, p_attribute6=>:$column$.attribute6, p_attribute7=>:$column$.attribute7, p_attribute8=>:$column$.attribute8, p_attribute9=>:$column$.attribute9, p_attribute10=>:$column$.attribute10, p_attribute11=>:$column$.attribute11, p_attribute12=>:$column$.attribute12, p_attribute13=>:$column$.attribute13, p_attribute14=>:$column$.attribute14, p_attribute15=>:$column$.attribute15 )) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '|| listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=140 and fdfv.descriptive_flexfield_name='FA_ADDITIONS' and fdfcuv.application_column_name='ATTRIBUTE12' 80 ATTRIBUTE13 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table(xxen_util.dff_attribute_lov( p_application_id=>140, p_descriptive_flexfield_name=>'FA_ADDITIONS', p_context_name=>:$column$.attribute_category, p_column_name=>'ATTRIBUTE13', p_attribute1=>:$column$.attribute1, p_attribute2=>:$column$.attribute2, p_attribute3=>:$column$.attribute3, p_attribute4=>:$column$.attribute4, p_attribute5=>:$column$.attribute5, p_attribute6=>:$column$.attribute6, p_attribute7=>:$column$.attribute7, p_attribute8=>:$column$.attribute8, p_attribute9=>:$column$.attribute9, p_attribute10=>:$column$.attribute10, p_attribute11=>:$column$.attribute11, p_attribute12=>:$column$.attribute12, p_attribute13=>:$column$.attribute13, p_attribute14=>:$column$.attribute14, p_attribute15=>:$column$.attribute15 )) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '|| listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=140 and fdfv.descriptive_flexfield_name='FA_ADDITIONS' and fdfcuv.application_column_name='ATTRIBUTE13' 81 ATTRIBUTE14 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table(xxen_util.dff_attribute_lov( p_application_id=>140, p_descriptive_flexfield_name=>'FA_ADDITIONS', p_context_name=>:$column$.attribute_category, p_column_name=>'ATTRIBUTE14', p_attribute1=>:$column$.attribute1, p_attribute2=>:$column$.attribute2, p_attribute3=>:$column$.attribute3, p_attribute4=>:$column$.attribute4, p_attribute5=>:$column$.attribute5, p_attribute6=>:$column$.attribute6, p_attribute7=>:$column$.attribute7, p_attribute8=>:$column$.attribute8, p_attribute9=>:$column$.attribute9, p_attribute10=>:$column$.attribute10, p_attribute11=>:$column$.attribute11, p_attribute12=>:$column$.attribute12, p_attribute13=>:$column$.attribute13, p_attribute14=>:$column$.attribute14, p_attribute15=>:$column$.attribute15 )) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '|| listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=140 and fdfv.descriptive_flexfield_name='FA_ADDITIONS' and fdfcuv.application_column_name='ATTRIBUTE14' 82 ATTRIBUTE15 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table(xxen_util.dff_attribute_lov( p_application_id=>140, p_descriptive_flexfield_name=>'FA_ADDITIONS', p_context_name=>:$column$.attribute_category, p_column_name=>'ATTRIBUTE15', p_attribute1=>:$column$.attribute1, p_attribute2=>:$column$.attribute2, p_attribute3=>:$column$.attribute3, p_attribute4=>:$column$.attribute4, p_attribute5=>:$column$.attribute5, p_attribute6=>:$column$.attribute6, p_attribute7=>:$column$.attribute7, p_attribute8=>:$column$.attribute8, p_attribute9=>:$column$.attribute9, p_attribute10=>:$column$.attribute10, p_attribute11=>:$column$.attribute11, p_attribute12=>:$column$.attribute12, p_attribute13=>:$column$.attribute13, p_attribute14=>:$column$.attribute14, p_attribute15=>:$column$.attribute15 )) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '|| listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=140 and fdfv.descriptive_flexfield_name='FA_ADDITIONS' and fdfcuv.application_column_name='ATTRIBUTE15' 83 DATE_RETIRED Date date select fdp.calendar_period_close_date from fa_deprn_periods fdp where fdp.book_type_code=:$column$.book and fdp.period_close_date is null 84 COST_RETIRED Number number 85 UNITS_RETIRED Number number 86 PROCEEDS_OF_SALE Number number 87 COST_OF_REMOVAL Number number 88 RETIREMENT_TYPE LOV custom varchar2 Y select fl.lookup_code value, fl.meaning description from fa_lookups fl where fl.lookup_type='RETIREMENT' and fl.enabled_flag='Y' order by fl.lookup_code 89 RETIRE_PRORATE_CONV LOV custom varchar2 Y select fct.prorate_convention_code value, fct.description from fa_convention_types fct, fa_book_controls fbc where fbc.book_type_code=:$column$.book and fct.fiscal_year_name=fbc.fiscal_year_name order by fct.prorate_convention_code 90 SOLD_TO Char varchar2 91 REFERENCE_NUM Char varchar2 92 TRADE_IN_ASSET_NUMBER LOV custom varchar2 select fab.asset_id id, fab.asset_number value, fat.description from fa_additions_b fab, fa_additions_tl fat where fab.asset_id=fat.asset_id and fat.language=userenv('lang') and exists (select null from fa_books fb where fb.asset_id=fab.asset_id and fb.book_type_code=:$column$.book and fb.date_ineffective is null) order by fab.asset_number 93 TRANSACTION_NAME Char varchar2 94 RETIRE_STATUS Char varchar2 Y U 1 status_ out Char STATUS_CODE_ U 2 message_ out Char MESSAGE_ U 3 request_id_ out Number REQUEST_ID_ U 4 p_record_type in Char RECORD_TYPE U 5 p_book_type_code in Char BOOK U 6 p_asset_number in Char ASSET_NUMBER U 7 p_description in Char DESCRIPTION U 8 p_tag_number in Char TAG_NUMBER U 9 p_serial_number in Char SERIAL_NUMBER U 10 p_category_id in Number CATEGORY U 11 p_asset_key_ccid in Number ASSET_KEY U 12 p_asset_type in Char ASSET_TYPE U 13 p_units in Number UNITS U 14 p_parent_asset_id in Number PARENT_ASSET U 15 p_manufacturer in Char MANUFACTURER U 16 p_model in Char MODEL U 17 p_warranty_id in Number WARRANTY_NUMBER U 18 p_lease_id in Number LEASE_NUMBER U 19 p_in_use in Char IN_USE U 20 p_in_physical_inventory in Char IN_PHYSICAL_INVENTORY U 21 p_property_type in Char PROPERTY_TYPE U 22 p_property_class in Char PROPERTY_CLASS U 23 p_ownership in Char OWNERSHIP U 24 p_bought in Char BOUGHT U 25 p_commitment in Char COMMITMENT U 26 p_investment_law in Char INVESTMENT_LAW U 27 p_cost in Number COST U 29 p_ytd_depreciation in Number YTD_DEPRECIATION U 30 p_depreciation_reserve in Number DEPRECIATION_RESERVE U 31 p_salvage_value_type in Char SALVAGE_VALUE_TYPE U 32 p_percent_salvage_value in Number PERCENT_SALVAGE_VALUE U 33 p_salvage_value in Number SALVAGE_VALUE U 38 p_depreciation_method in Char DEPRECIATION_METHOD U 39 p_depreciate in Char DEPRECIATE U 40 p_life_years in Number LIFE_YEARS U 41 p_life_months in Number LIFE_MONTHS U 42 p_date_placed_in_service in Date DATE_PLACED_IN_SERVICE U 43 p_prorate_convention in Char PRORATE_CONVENTION U 44 p_amortization_start_date in Date AMORTIZATION_START_DATE U 45 p_bonus_rule in Char BONUS_RULE U 46 p_depreciation_limit_type in Char DEPRECIATION_LIMIT_TYPE U 47 p_depreciation_limit_amount in Number DEPRECIATION_LIMIT_AMOUNT U 48 p_depreciation_limit_pct in Number DEPRECIATION_LIMIT_PCT U 49 p_group_asset_id in Number GROUP_ASSET U 50 p_expense_ccid in Number EXPENSE_ACCOUNT U 51 p_location_id in Number LOCATION U 52 p_location_segments in Char LOCATION U 53 p_assigned_to in Number EMPLOYEE_NAME U 54 p_attribute_category in Char ATTRIBUTE_CATEGORY U 55 p_attribute1 in Char ATTRIBUTE1 U 56 p_attribute2 in Char ATTRIBUTE2 U 57 p_attribute3 in Char ATTRIBUTE3 U 58 p_attribute4 in Char ATTRIBUTE4 U 59 p_attribute5 in Char ATTRIBUTE5 U 60 p_attribute6 in Char ATTRIBUTE6 U 61 p_attribute7 in Char ATTRIBUTE7 U 62 p_attribute8 in Char ATTRIBUTE8 U 63 p_attribute9 in Char ATTRIBUTE9 U 64 p_attribute10 in Char ATTRIBUTE10 U 65 p_attribute11 in Char ATTRIBUTE11 U 66 p_attribute12 in Char ATTRIBUTE12 U 67 p_attribute13 in Char ATTRIBUTE13 U 68 p_attribute14 in Char ATTRIBUTE14 U 69 p_attribute15 in Char ATTRIBUTE15 U 71 p_expense_segment1 in Char EXPENSE_SEGMENT1 U 72 p_expense_segment2 in Char EXPENSE_SEGMENT2 U 73 p_expense_segment3 in Char EXPENSE_SEGMENT3 U 74 p_expense_segment4 in Char EXPENSE_SEGMENT4 U 75 p_expense_segment5 in Char EXPENSE_SEGMENT5 U 76 p_location_segment1 in Char LOCATION_SEGMENT1 U 77 p_location_segment2 in Char LOCATION_SEGMENT2 U 78 p_location_segment3 in Char LOCATION_SEGMENT3 U 79 p_location_segment4 in Char LOCATION_SEGMENT4 U 80 p_date_retired in Date DATE_RETIRED U 81 p_cost_retired in Number COST_RETIRED U 82 p_units_retired in Number UNITS_RETIRED U 83 p_proceeds_of_sale in Number PROCEEDS_OF_SALE U 84 p_cost_of_removal in Number COST_OF_REMOVAL U 85 p_retirement_type in Char RETIREMENT_TYPE U 86 p_retire_prorate_conv in Char RETIRE_PRORATE_CONV U 87 p_sold_to in Char SOLD_TO U 88 p_reference_num in Char REFERENCE_NUM U 89 p_trade_in_asset_id in Number TRADE_IN_ASSET_NUMBER U 90 p_transaction_name in Char TRANSACTION_NAME Error SQL select xu.action_, xu.status_, xu.message_, xu.modified_columns_, xu.record_type, xu.request_id_, xu.asset_number, xu.description, xu.tag_number, xu.category, xu.serial_number, xu.asset_key, xu.asset_type, xu.units, xu.parent_asset, xu.manufacturer, xu.model, xu.warranty_number, xu.lease_number, xu.in_use, xu.in_physical_inventory, xu.property_type, xu.property_class, xu.ownership, xu.bought, xu.commitment, xu.investment_law, xu.book, xu.cost, xu.original_cost, xu.ytd_depreciation, xu.depreciation_reserve, xu.salvage_value_type, xu.percent_salvage_value, xu.salvage_value, xu.revaluation_ceiling, xu.revaluation_amortization_basis, xu.recoverable_cost, null net_book_value, xu.depreciation_method, xu.depreciate, xu.life_years, xu.life_months, xu.date_placed_in_service, xu.prorate_convention, xu.amortization_start_date, xu.bonus_rule, xu.depreciation_limit_type, xu.depreciation_limit_amount, xu.depreciation_limit_pct, xu.group_asset, null expense_account_alias, xu.expense_account, xu.expense_segment1, xu.expense_segment2, xu.expense_segment3, xu.expense_segment4, xu.expense_segment5, null location_alias, xu.location, xu.location_segment1, xu.location_segment2, xu.location_segment3, xu.location_segment4, xu.employee_name, xu.employee_number, xu.attribute_category, xu.attribute1, xu.attribute2, xu.attribute3, xu.attribute4, xu.attribute5, xu.attribute6, xu.attribute7, xu.attribute8, xu.attribute9, xu.attribute10, xu.attribute11, xu.attribute12, xu.attribute13, xu.attribute14, xu.attribute15, xu.date_retired, xu.cost_retired, xu.units_retired, xu.proceeds_of_sale, xu.cost_of_removal, xu.retirement_type, xu.retire_prorate_conv, xu.sold_to, xu.reference_num, xu.trade_in_asset_number, xu.transaction_name, xu.retire_status from xxen_fa_asset_upload_6245_u xu where xu.status_code_='E' Success SQL select xu.action_, xu.status_, xu.message_, xu.modified_columns_, xu.record_type, xu.request_id_, xu.asset_number, xu.description, xu.tag_number, xu.category, xu.serial_number, xu.asset_key, xu.asset_type, xu.units, xu.parent_asset, xu.manufacturer, xu.model, xu.warranty_number, xu.lease_number, xu.in_use, xu.in_physical_inventory, xu.property_type, xu.property_class, xu.ownership, xu.bought, xu.commitment, xu.investment_law, xu.book, xu.cost, xu.original_cost, xu.ytd_depreciation, xu.depreciation_reserve, xu.salvage_value_type, xu.percent_salvage_value, xu.salvage_value, xu.revaluation_ceiling, xu.revaluation_amortization_basis, xu.recoverable_cost, null net_book_value, xu.depreciation_method, xu.depreciate, xu.life_years, xu.life_months, xu.date_placed_in_service, xu.prorate_convention, xu.amortization_start_date, xu.bonus_rule, xu.depreciation_limit_type, xu.depreciation_limit_amount, xu.depreciation_limit_pct, xu.group_asset, null expense_account_alias, xu.expense_account, xu.expense_segment1, xu.expense_segment2, xu.expense_segment3, xu.expense_segment4, xu.expense_segment5, null location_alias, xu.location, xu.location_segment1, xu.location_segment2, xu.location_segment3, xu.location_segment4, xu.employee_name, xu.employee_number, xu.attribute_category, xu.attribute1, xu.attribute2, xu.attribute3, xu.attribute4, xu.attribute5, xu.attribute6, xu.attribute7, xu.attribute8, xu.attribute9, xu.attribute10, xu.attribute11, xu.attribute12, xu.attribute13, xu.attribute14, xu.attribute15, xu.date_retired, xu.cost_retired, xu.units_retired, xu.proceeds_of_sale, xu.cost_of_removal, xu.retirement_type, xu.retire_prorate_conv, xu.sold_to, xu.reference_num, xu.trade_in_asset_number, xu.transaction_name, xu.retire_status from xxen_fa_asset_upload_6245_u xu where xu.status_code_='S' LOV query :$column$.attribute1 ATTRIBUTE1 ATTRIBUTE1 LOV query :$column$.attribute10 ATTRIBUTE10 ATTRIBUTE1 LOV query :$column$.attribute11 ATTRIBUTE11 ATTRIBUTE1 LOV query :$column$.attribute12 ATTRIBUTE12 ATTRIBUTE1 LOV query :$column$.attribute13 ATTRIBUTE13 ATTRIBUTE1 LOV query :$column$.attribute14 ATTRIBUTE14 ATTRIBUTE1 LOV query :$column$.attribute15 ATTRIBUTE15 ATTRIBUTE1 LOV query :$column$.attribute2 ATTRIBUTE2 ATTRIBUTE1 LOV query :$column$.attribute3 ATTRIBUTE3 ATTRIBUTE1 LOV query :$column$.attribute4 ATTRIBUTE4 ATTRIBUTE1 LOV query :$column$.attribute5 ATTRIBUTE5 ATTRIBUTE1 LOV query :$column$.attribute6 ATTRIBUTE6 ATTRIBUTE1 LOV query :$column$.attribute7 ATTRIBUTE7 ATTRIBUTE1 LOV query :$column$.attribute8 ATTRIBUTE8 ATTRIBUTE1 LOV query :$column$.attribute9 ATTRIBUTE9 ATTRIBUTE1 LOV query :$column$.attribute_category ATTRIBUTE_CATEGORY ATTRIBUTE1 LOV query :$column$.attribute1 ATTRIBUTE1 ATTRIBUTE10 LOV query :$column$.attribute10 ATTRIBUTE10 ATTRIBUTE10 LOV query :$column$.attribute11 ATTRIBUTE11 ATTRIBUTE10 LOV query :$column$.attribute12 ATTRIBUTE12 ATTRIBUTE10 LOV query :$column$.attribute13 ATTRIBUTE13 ATTRIBUTE10 LOV query :$column$.attribute14 ATTRIBUTE14 ATTRIBUTE10 LOV query :$column$.attribute15 ATTRIBUTE15 ATTRIBUTE10 LOV query :$column$.attribute2 ATTRIBUTE2 ATTRIBUTE10 LOV query :$column$.attribute3 ATTRIBUTE3 ATTRIBUTE10 LOV query :$column$.attribute4 ATTRIBUTE4 ATTRIBUTE10 LOV query :$column$.attribute5 ATTRIBUTE5 ATTRIBUTE10 LOV query :$column$.attribute6 ATTRIBUTE6 ATTRIBUTE10 LOV query :$column$.attribute7 ATTRIBUTE7 ATTRIBUTE10 LOV query :$column$.attribute8 ATTRIBUTE8 ATTRIBUTE10 LOV query :$column$.attribute9 ATTRIBUTE9 ATTRIBUTE10 LOV query :$column$.attribute_category ATTRIBUTE_CATEGORY ATTRIBUTE10 LOV query :$column$.attribute1 ATTRIBUTE1 ATTRIBUTE11 LOV query :$column$.attribute10 ATTRIBUTE10 ATTRIBUTE11 LOV query :$column$.attribute11 ATTRIBUTE11 ATTRIBUTE11 LOV query :$column$.attribute12 ATTRIBUTE12 ATTRIBUTE11 LOV query :$column$.attribute13 ATTRIBUTE13 ATTRIBUTE11 LOV query :$column$.attribute14 ATTRIBUTE14 ATTRIBUTE11 LOV query :$column$.attribute15 ATTRIBUTE15 ATTRIBUTE11 LOV query :$column$.attribute2 ATTRIBUTE2 ATTRIBUTE11 LOV query :$column$.attribute3 ATTRIBUTE3 ATTRIBUTE11 LOV query :$column$.attribute4 ATTRIBUTE4 ATTRIBUTE11 LOV query :$column$.attribute5 ATTRIBUTE5 ATTRIBUTE11 LOV query :$column$.attribute6 ATTRIBUTE6 ATTRIBUTE11 LOV query :$column$.attribute7 ATTRIBUTE7 ATTRIBUTE11 LOV query :$column$.attribute8 ATTRIBUTE8 ATTRIBUTE11 LOV query :$column$.attribute9 ATTRIBUTE9 ATTRIBUTE11 LOV query :$column$.attribute_category ATTRIBUTE_CATEGORY ATTRIBUTE11 LOV query :$column$.attribute1 ATTRIBUTE1 ATTRIBUTE12 LOV query :$column$.attribute10 ATTRIBUTE10 ATTRIBUTE12 LOV query :$column$.attribute11 ATTRIBUTE11 ATTRIBUTE12 LOV query :$column$.attribute12 ATTRIBUTE12 ATTRIBUTE12 LOV query :$column$.attribute13 ATTRIBUTE13 ATTRIBUTE12 LOV query :$column$.attribute14 ATTRIBUTE14 ATTRIBUTE12 LOV query :$column$.attribute15 ATTRIBUTE15 ATTRIBUTE12 LOV query :$column$.attribute2 ATTRIBUTE2 ATTRIBUTE12 LOV query :$column$.attribute3 ATTRIBUTE3 ATTRIBUTE12 LOV query :$column$.attribute4 ATTRIBUTE4 ATTRIBUTE12 LOV query :$column$.attribute5 ATTRIBUTE5 ATTRIBUTE12 LOV query :$column$.attribute6 ATTRIBUTE6 ATTRIBUTE12 LOV query :$column$.attribute7 ATTRIBUTE7 ATTRIBUTE12 LOV query :$column$.attribute8 ATTRIBUTE8 ATTRIBUTE12 LOV query :$column$.attribute9 ATTRIBUTE9 ATTRIBUTE12 LOV query :$column$.attribute_category ATTRIBUTE_CATEGORY ATTRIBUTE12 LOV query :$column$.attribute1 ATTRIBUTE1 ATTRIBUTE13 LOV query :$column$.attribute10 ATTRIBUTE10 ATTRIBUTE13 LOV query :$column$.attribute11 ATTRIBUTE11 ATTRIBUTE13 LOV query :$column$.attribute12 ATTRIBUTE12 ATTRIBUTE13 LOV query :$column$.attribute13 ATTRIBUTE13 ATTRIBUTE13 LOV query :$column$.attribute14 ATTRIBUTE14 ATTRIBUTE13 LOV query :$column$.attribute15 ATTRIBUTE15 ATTRIBUTE13 LOV query :$column$.attribute2 ATTRIBUTE2 ATTRIBUTE13 LOV query :$column$.attribute3 ATTRIBUTE3 ATTRIBUTE13 LOV query :$column$.attribute4 ATTRIBUTE4 ATTRIBUTE13 LOV query :$column$.attribute5 ATTRIBUTE5 ATTRIBUTE13 LOV query :$column$.attribute6 ATTRIBUTE6 ATTRIBUTE13 LOV query :$column$.attribute7 ATTRIBUTE7 ATTRIBUTE13 LOV query :$column$.attribute8 ATTRIBUTE8 ATTRIBUTE13 LOV query :$column$.attribute9 ATTRIBUTE9 ATTRIBUTE13 LOV query :$column$.attribute_category ATTRIBUTE_CATEGORY ATTRIBUTE13 LOV query :$column$.attribute1 ATTRIBUTE1 ATTRIBUTE14 LOV query :$column$.attribute10 ATTRIBUTE10 ATTRIBUTE14 LOV query :$column$.attribute11 ATTRIBUTE11 ATTRIBUTE14 LOV query :$column$.attribute12 ATTRIBUTE12 ATTRIBUTE14 LOV query :$column$.attribute13 ATTRIBUTE13 ATTRIBUTE14 LOV query :$column$.attribute14 ATTRIBUTE14 ATTRIBUTE14 LOV query :$column$.attribute15 ATTRIBUTE15 ATTRIBUTE14 LOV query :$column$.attribute2 ATTRIBUTE2 ATTRIBUTE14 LOV query :$column$.attribute3 ATTRIBUTE3 ATTRIBUTE14 LOV query :$column$.attribute4 ATTRIBUTE4 ATTRIBUTE14 LOV query :$column$.attribute5 ATTRIBUTE5 ATTRIBUTE14 LOV query :$column$.attribute6 ATTRIBUTE6 ATTRIBUTE14 LOV query :$column$.attribute7 ATTRIBUTE7 ATTRIBUTE14 LOV query :$column$.attribute8 ATTRIBUTE8 ATTRIBUTE14 LOV query :$column$.attribute9 ATTRIBUTE9 ATTRIBUTE14 LOV query :$column$.attribute_category ATTRIBUTE_CATEGORY ATTRIBUTE14 LOV query :$column$.attribute1 ATTRIBUTE1 ATTRIBUTE15 LOV query :$column$.attribute10 ATTRIBUTE10 ATTRIBUTE15 LOV query :$column$.attribute11 ATTRIBUTE11 ATTRIBUTE15 LOV query :$column$.attribute12 ATTRIBUTE12 ATTRIBUTE15 LOV query :$column$.attribute13 ATTRIBUTE13 ATTRIBUTE15 LOV query :$column$.attribute14 ATTRIBUTE14 ATTRIBUTE15 LOV query :$column$.attribute15 ATTRIBUTE15 ATTRIBUTE15 LOV query :$column$.attribute2 ATTRIBUTE2 ATTRIBUTE15 LOV query :$column$.attribute3 ATTRIBUTE3 ATTRIBUTE15 LOV query :$column$.attribute4 ATTRIBUTE4 ATTRIBUTE15 LOV query :$column$.attribute5 ATTRIBUTE5 ATTRIBUTE15 LOV query :$column$.attribute6 ATTRIBUTE6 ATTRIBUTE15 LOV query :$column$.attribute7 ATTRIBUTE7 ATTRIBUTE15 LOV query :$column$.attribute8 ATTRIBUTE8 ATTRIBUTE15 LOV query :$column$.attribute9 ATTRIBUTE9 ATTRIBUTE15 LOV query :$column$.attribute_category ATTRIBUTE_CATEGORY ATTRIBUTE15 LOV query :$column$.attribute1 ATTRIBUTE1 ATTRIBUTE2 LOV query :$column$.attribute10 ATTRIBUTE10 ATTRIBUTE2 LOV query :$column$.attribute11 ATTRIBUTE11 ATTRIBUTE2 LOV query :$column$.attribute12 ATTRIBUTE12 ATTRIBUTE2 LOV query :$column$.attribute13 ATTRIBUTE13 ATTRIBUTE2 LOV query :$column$.attribute14 ATTRIBUTE14 ATTRIBUTE2 LOV query :$column$.attribute15 ATTRIBUTE15 ATTRIBUTE2 LOV query :$column$.attribute2 ATTRIBUTE2 ATTRIBUTE2 LOV query :$column$.attribute3 ATTRIBUTE3 ATTRIBUTE2 LOV query :$column$.attribute4 ATTRIBUTE4 ATTRIBUTE2 LOV query :$column$.attribute5 ATTRIBUTE5 ATTRIBUTE2 LOV query :$column$.attribute6 ATTRIBUTE6 ATTRIBUTE2 LOV query :$column$.attribute7 ATTRIBUTE7 ATTRIBUTE2 LOV query :$column$.attribute8 ATTRIBUTE8 ATTRIBUTE2 LOV query :$column$.attribute9 ATTRIBUTE9 ATTRIBUTE2 LOV query :$column$.attribute_category ATTRIBUTE_CATEGORY ATTRIBUTE2 LOV query :$column$.attribute1 ATTRIBUTE1 ATTRIBUTE3 LOV query :$column$.attribute10 ATTRIBUTE10 ATTRIBUTE3 LOV query :$column$.attribute11 ATTRIBUTE11 ATTRIBUTE3 LOV query :$column$.attribute12 ATTRIBUTE12 ATTRIBUTE3 LOV query :$column$.attribute13 ATTRIBUTE13 ATTRIBUTE3 LOV query :$column$.attribute14 ATTRIBUTE14 ATTRIBUTE3 LOV query :$column$.attribute15 ATTRIBUTE15 ATTRIBUTE3 LOV query :$column$.attribute2 ATTRIBUTE2 ATTRIBUTE3 LOV query :$column$.attribute3 ATTRIBUTE3 ATTRIBUTE3 LOV query :$column$.attribute4 ATTRIBUTE4 ATTRIBUTE3 LOV query :$column$.attribute5 ATTRIBUTE5 ATTRIBUTE3 LOV query :$column$.attribute6 ATTRIBUTE6 ATTRIBUTE3 LOV query :$column$.attribute7 ATTRIBUTE7 ATTRIBUTE3 LOV query :$column$.attribute8 ATTRIBUTE8 ATTRIBUTE3 LOV query :$column$.attribute9 ATTRIBUTE9 ATTRIBUTE3 LOV query :$column$.attribute_category ATTRIBUTE_CATEGORY ATTRIBUTE3 LOV query :$column$.attribute1 ATTRIBUTE1 ATTRIBUTE4 LOV query :$column$.attribute10 ATTRIBUTE10 ATTRIBUTE4 LOV query :$column$.attribute11 ATTRIBUTE11 ATTRIBUTE4 LOV query :$column$.attribute12 ATTRIBUTE12 ATTRIBUTE4 LOV query :$column$.attribute13 ATTRIBUTE13 ATTRIBUTE4 LOV query :$column$.attribute14 ATTRIBUTE14 ATTRIBUTE4 LOV query :$column$.attribute15 ATTRIBUTE15 ATTRIBUTE4 LOV query :$column$.attribute2 ATTRIBUTE2 ATTRIBUTE4 LOV query :$column$.attribute3 ATTRIBUTE3 ATTRIBUTE4 LOV query :$column$.attribute4 ATTRIBUTE4 ATTRIBUTE4 LOV query :$column$.attribute5 ATTRIBUTE5 ATTRIBUTE4 LOV query :$column$.attribute6 ATTRIBUTE6 ATTRIBUTE4 LOV query :$column$.attribute7 ATTRIBUTE7 ATTRIBUTE4 LOV query :$column$.attribute8 ATTRIBUTE8 ATTRIBUTE4 LOV query :$column$.attribute9 ATTRIBUTE9 ATTRIBUTE4 LOV query :$column$.attribute_category ATTRIBUTE_CATEGORY ATTRIBUTE4 LOV query :$column$.attribute1 ATTRIBUTE1 ATTRIBUTE5 LOV query :$column$.attribute10 ATTRIBUTE10 ATTRIBUTE5 LOV query :$column$.attribute11 ATTRIBUTE11 ATTRIBUTE5 LOV query :$column$.attribute12 ATTRIBUTE12 ATTRIBUTE5 LOV query :$column$.attribute13 ATTRIBUTE13 ATTRIBUTE5 LOV query :$column$.attribute14 ATTRIBUTE14 ATTRIBUTE5 LOV query :$column$.attribute15 ATTRIBUTE15 ATTRIBUTE5 LOV query :$column$.attribute2 ATTRIBUTE2 ATTRIBUTE5 LOV query :$column$.attribute3 ATTRIBUTE3 ATTRIBUTE5 LOV query :$column$.attribute4 ATTRIBUTE4 ATTRIBUTE5 LOV query :$column$.attribute5 ATTRIBUTE5 ATTRIBUTE5 LOV query :$column$.attribute6 ATTRIBUTE6 ATTRIBUTE5 LOV query :$column$.attribute7 ATTRIBUTE7 ATTRIBUTE5 LOV query :$column$.attribute8 ATTRIBUTE8 ATTRIBUTE5 LOV query :$column$.attribute9 ATTRIBUTE9 ATTRIBUTE5 LOV query :$column$.attribute_category ATTRIBUTE_CATEGORY ATTRIBUTE5 LOV query :$column$.attribute1 ATTRIBUTE1 ATTRIBUTE6 LOV query :$column$.attribute10 ATTRIBUTE10 ATTRIBUTE6 LOV query :$column$.attribute11 ATTRIBUTE11 ATTRIBUTE6 LOV query :$column$.attribute12 ATTRIBUTE12 ATTRIBUTE6 LOV query :$column$.attribute13 ATTRIBUTE13 ATTRIBUTE6 LOV query :$column$.attribute14 ATTRIBUTE14 ATTRIBUTE6 LOV query :$column$.attribute15 ATTRIBUTE15 ATTRIBUTE6 LOV query :$column$.attribute2 ATTRIBUTE2 ATTRIBUTE6 LOV query :$column$.attribute3 ATTRIBUTE3 ATTRIBUTE6 LOV query :$column$.attribute4 ATTRIBUTE4 ATTRIBUTE6 LOV query :$column$.attribute5 ATTRIBUTE5 ATTRIBUTE6 LOV query :$column$.attribute6 ATTRIBUTE6 ATTRIBUTE6 LOV query :$column$.attribute7 ATTRIBUTE7 ATTRIBUTE6 LOV query :$column$.attribute8 ATTRIBUTE8 ATTRIBUTE6 LOV query :$column$.attribute9 ATTRIBUTE9 ATTRIBUTE6 LOV query :$column$.attribute_category ATTRIBUTE_CATEGORY ATTRIBUTE6 LOV query :$column$.attribute1 ATTRIBUTE1 ATTRIBUTE7 LOV query :$column$.attribute10 ATTRIBUTE10 ATTRIBUTE7 LOV query :$column$.attribute11 ATTRIBUTE11 ATTRIBUTE7 LOV query :$column$.attribute12 ATTRIBUTE12 ATTRIBUTE7 LOV query :$column$.attribute13 ATTRIBUTE13 ATTRIBUTE7 LOV query :$column$.attribute14 ATTRIBUTE14 ATTRIBUTE7 LOV query :$column$.attribute15 ATTRIBUTE15 ATTRIBUTE7 LOV query :$column$.attribute2 ATTRIBUTE2 ATTRIBUTE7 LOV query :$column$.attribute3 ATTRIBUTE3 ATTRIBUTE7 LOV query :$column$.attribute4 ATTRIBUTE4 ATTRIBUTE7 LOV query :$column$.attribute5 ATTRIBUTE5 ATTRIBUTE7 LOV query :$column$.attribute6 ATTRIBUTE6 ATTRIBUTE7 LOV query :$column$.attribute7 ATTRIBUTE7 ATTRIBUTE7 LOV query :$column$.attribute8 ATTRIBUTE8 ATTRIBUTE7 LOV query :$column$.attribute9 ATTRIBUTE9 ATTRIBUTE7 LOV query :$column$.attribute_category ATTRIBUTE_CATEGORY ATTRIBUTE7 LOV query :$column$.attribute1 ATTRIBUTE1 ATTRIBUTE8 LOV query :$column$.attribute10 ATTRIBUTE10 ATTRIBUTE8 LOV query :$column$.attribute11 ATTRIBUTE11 ATTRIBUTE8 LOV query :$column$.attribute12 ATTRIBUTE12 ATTRIBUTE8 LOV query :$column$.attribute13 ATTRIBUTE13 ATTRIBUTE8 LOV query :$column$.attribute14 ATTRIBUTE14 ATTRIBUTE8 LOV query :$column$.attribute15 ATTRIBUTE15 ATTRIBUTE8 LOV query :$column$.attribute2 ATTRIBUTE2 ATTRIBUTE8 LOV query :$column$.attribute3 ATTRIBUTE3 ATTRIBUTE8 LOV query :$column$.attribute4 ATTRIBUTE4 ATTRIBUTE8 LOV query :$column$.attribute5 ATTRIBUTE5 ATTRIBUTE8 LOV query :$column$.attribute6 ATTRIBUTE6 ATTRIBUTE8 LOV query :$column$.attribute7 ATTRIBUTE7 ATTRIBUTE8 LOV query :$column$.attribute8 ATTRIBUTE8 ATTRIBUTE8 LOV query :$column$.attribute9 ATTRIBUTE9 ATTRIBUTE8 LOV query :$column$.attribute_category ATTRIBUTE_CATEGORY ATTRIBUTE8 LOV query :$column$.attribute1 ATTRIBUTE1 ATTRIBUTE9 LOV query :$column$.attribute10 ATTRIBUTE10 ATTRIBUTE9 LOV query :$column$.attribute11 ATTRIBUTE11 ATTRIBUTE9 LOV query :$column$.attribute12 ATTRIBUTE12 ATTRIBUTE9 LOV query :$column$.attribute13 ATTRIBUTE13 ATTRIBUTE9 LOV query :$column$.attribute14 ATTRIBUTE14 ATTRIBUTE9 LOV query :$column$.attribute15 ATTRIBUTE15 ATTRIBUTE9 LOV query :$column$.attribute2 ATTRIBUTE2 ATTRIBUTE9 LOV query :$column$.attribute3 ATTRIBUTE3 ATTRIBUTE9 LOV query :$column$.attribute4 ATTRIBUTE4 ATTRIBUTE9 LOV query :$column$.attribute5 ATTRIBUTE5 ATTRIBUTE9 LOV query :$column$.attribute6 ATTRIBUTE6 ATTRIBUTE9 LOV query :$column$.attribute7 ATTRIBUTE7 ATTRIBUTE9 LOV query :$column$.attribute8 ATTRIBUTE8 ATTRIBUTE9 LOV query :$column$.attribute9 ATTRIBUTE9 ATTRIBUTE9 LOV query :$column$.attribute_category ATTRIBUTE_CATEGORY ATTRIBUTE9 LOV query :$column$.category CATEGORY BOOK Default value :$column$.book BOOK DATE_PLACED_IN_SERVICE Default value :$column$.book BOOK DATE_RETIRED LOV query :$column$.asset_type ASSET_TYPE DEPRECIATION_LIMIT_TYPE LOV query :$column$.asset_type ASSET_TYPE DEPRECIATION_METHOD LOV query :$column$.book BOOK DEPRECIATION_METHOD LOV query :$column$.group_asset GROUP_ASSET DEPRECIATION_METHOD Default value :$column$.employee_name EMPLOYEE_NAME EMPLOYEE_NUMBER LOV query :$column$.employee_name EMPLOYEE_NAME EMPLOYEE_NUMBER LOV query :$column$.book BOOK EXPENSE_ACCOUNT Default value :$column$.book BOOK EXPENSE_ACCOUNT Default value :$column$.expense_account_alias EXPENSE_ACCOUNT_ALIAS EXPENSE_ACCOUNT LOV query :$column$.expense_account_alias EXPENSE_ACCOUNT_ALIAS EXPENSE_ACCOUNT LOV query :$column$.book BOOK EXPENSE_ACCOUNT_ALIAS Default value :$column$.book BOOK EXPENSE_SEGMENT1 LOV query :$column$.book BOOK EXPENSE_SEGMENT1 LOV query :$column$.expense_account EXPENSE_ACCOUNT EXPENSE_SEGMENT1 Default value :$column$.expense_account EXPENSE_ACCOUNT EXPENSE_SEGMENT1 Default value :$column$.book BOOK EXPENSE_SEGMENT2 LOV query :$column$.book BOOK EXPENSE_SEGMENT2 Default value :$column$.expense_account EXPENSE_ACCOUNT EXPENSE_SEGMENT2 LOV query :$column$.expense_account EXPENSE_ACCOUNT EXPENSE_SEGMENT2 Default value :$column$.book BOOK EXPENSE_SEGMENT3 LOV query :$column$.book BOOK EXPENSE_SEGMENT3 Default value :$column$.expense_account EXPENSE_ACCOUNT EXPENSE_SEGMENT3 LOV query :$column$.expense_account EXPENSE_ACCOUNT EXPENSE_SEGMENT3 LOV query :$column$.book BOOK EXPENSE_SEGMENT4 Default value :$column$.book BOOK EXPENSE_SEGMENT4 LOV query :$column$.expense_account EXPENSE_ACCOUNT EXPENSE_SEGMENT4 Default value :$column$.expense_account EXPENSE_ACCOUNT EXPENSE_SEGMENT4 Default value :$column$.book BOOK EXPENSE_SEGMENT5 LOV query :$column$.book BOOK EXPENSE_SEGMENT5 Default value :$column$.expense_account EXPENSE_ACCOUNT EXPENSE_SEGMENT5 LOV query :$column$.expense_account EXPENSE_ACCOUNT EXPENSE_SEGMENT5 LOV query :$column$.book BOOK GROUP_ASSET Default value :$column$.book BOOK LIFE_MONTHS Default value :$column$.category CATEGORY LIFE_MONTHS Default value :$column$.date_placed_in_service DATE_PLACED_IN_SERVICE LIFE_MONTHS Default value :$column$.book BOOK LIFE_YEARS Default value :$column$.category CATEGORY LIFE_YEARS Default value :$column$.date_placed_in_service DATE_PLACED_IN_SERVICE LIFE_YEARS Default value :$column$.location_alias LOCATION_ALIAS LOCATION LOV query :$column$.location_alias LOCATION_ALIAS LOCATION LOV query :$column$.location LOCATION LOCATION_SEGMENT1 Default value :$column$.location LOCATION LOCATION_SEGMENT1 LOV query :$column$.location LOCATION LOCATION_SEGMENT2 Default value :$column$.location LOCATION LOCATION_SEGMENT2 Default value :$column$.location LOCATION LOCATION_SEGMENT3 LOV query :$column$.location LOCATION LOCATION_SEGMENT3 Default value :$column$.location LOCATION LOCATION_SEGMENT4 LOV query :$column$.location LOCATION LOCATION_SEGMENT4 LOV query :$column$.book BOOK PARENT_ASSET LOV query :$column$.book BOOK PRORATE_CONVENTION Default value :$column$.book BOOK PRORATE_CONVENTION Default value :$column$.category CATEGORY PRORATE_CONVENTION Default value :$column$.date_placed_in_service DATE_PLACED_IN_SERVICE PRORATE_CONVENTION LOV query :$column$.book BOOK RETIRE_PRORATE_CONV LOV query :$column$.asset_type ASSET_TYPE SALVAGE_VALUE_TYPE LOV query :$column$.book BOOK TRADE_IN_ASSET_NUMBER Excel validation :$column$.asset_number ASSET_NUMBER Value to id query :$column$.asset_type ASSET_TYPE p_depreciation_limit_type Value to id query :$column$.asset_type ASSET_TYPE p_salvage_value_type Value to id query :$column$.book BOOK p_expense_ccid Value to id query :$column$.book BOOK p_group_asset_id Value to id query :$column$.book BOOK p_parent_asset_id Value to id query :$column$.book BOOK p_trade_in_asset_id Excel validation :$column$.book BOOK Excel validation :$column$.category CATEGORY Excel validation :$column$.date_placed_in_service DATE_PLACED_IN_SERVICE Excel validation :$column$.depreciation_method DEPRECIATION_METHOD Excel validation :$column$.expense_account EXPENSE_ACCOUNT Value to id query :$column$.expense_account_alias EXPENSE_ACCOUNT_ALIAS p_expense_ccid Excel validation :$column$.expense_segment1 EXPENSE_SEGMENT1 Excel validation :$column$.life_months LIFE_MONTHS Excel validation :$column$.life_years LIFE_YEARS Excel validation :$column$.location LOCATION Value to id query :$column$.location_alias LOCATION_ALIAS p_location_id Value to id query :$column$.location_alias LOCATION_ALIAS p_location_segments Excel validation :$column$.location_segment1 LOCATION_SEGMENT1 Excel validation :$column$.record_type RECORD_TYPE Excel validation :$column$.units UNITS