ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 3E831F8C1BF26BD6E0633D7D37A2BA15Y 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, case when (select fdp.fiscal_year from fa_deprn_periods fdp where fds.book_type_code=fdp.book_type_code and fds.period_counter=fdp.period_counter)=fbc.current_fiscal_year then fds.ytd_deprn else 0 end 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, flk.segment5 location_segment5, flk.segment6 location_segment6, flk.segment7 location_segment7, 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 (nvl(:p_include_retired_assets,'N')='Y' or fb.period_counter_fully_retired 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(fds2.period_counter) from fa_deprn_summary fds2 where fds.asset_id=fds2.asset_id and fds.book_type_code=fds2.book_type_code) and fav.asset_id=fdh.asset_id and fb.book_type_code=fdh.book_type_code and (fdh.date_ineffective is null or fb.period_counter_fully_retired is not null and fdh.date_ineffective=(select max(fdh2.date_ineffective) from fa_distribution_history fdh2 where fdh.asset_id=fdh2.asset_id and fdh.book_type_code=fdh2.book_type_code)) 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, 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, null 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, case when (select fdp.fiscal_year from fa_deprn_periods fdp where fds.book_type_code=fdp.book_type_code and fds.period_counter=fdp.period_counter)=fbc.current_fiscal_year then fds.ytd_deprn else 0 end 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, flk.segment5 location_segment5, flk.segment6 location_segment6, flk.segment7 location_segment7, null employee_name, null 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, 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_vl fav, fa_retirements fr, fa_books fb, fa_transaction_headers fth, fa_book_controls fbc, 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 fav.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 fav.asset_id=fb.asset_id and fb.book_type_code=fbc.book_type_code and fb.book_type_code=fcb.book_type_code and fav.asset_category_id=fcbk.category_id and fcbk.category_id=fcb.category_id and fds.asset_id=fav.asset_id and fds.book_type_code=fb.book_type_code and fds.period_counter=(select max(fds2.period_counter) from fa_deprn_summary fds2 where fds.asset_id=fds2.asset_id and fds.book_type_code=fds2.book_type_code) and fav.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 fav.asset_key_ccid=fakk.code_combination_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(+) Fix missing assets in the download: the fa_deprn_summary join was pinned to the book's latest closed period, dropping every asset without a depreciation row in exactly that period (fully reserved, non-depreciating and retired assets) - now joins each asset's own latest depreciation row, with ytd_depreciation shown only when that row falls in the current fiscal year. Fully retired assets now also appear as Addition rows when Include Retired Assets is Yes, using their last distribution. 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, p_cost_retired=>:$column$.cost_retired, p_units_retired=>:$column$.units_retired, p_date_retired=>:$column$.date_retired, p_retirement_type=>:$column$.retirement_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; after uploading retirements, run the Calculate Gains and Losses program to finalize them and post the gain/loss. Use the Record Type column to select Addition or Retirement processing. Fully retired assets are excluded from the list unless Include Retired Assets is set to Yes. Enginatics Upload 1=1 :p_create_empty_file :p_include_retired_assets :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 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 10 100 :p_include_retired_assets LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual US Include Retired Assets Include fully retired assets in the active list for descriptive updates. Excluded by default; retired assets always appear in the already-retired rows. 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 10 Y select 'Addition' value, 'Asset Addition' description from dual union all select 'Retirement' value, 'Asset Retirement' description from dual Addition Y 7 ASSET_NUMBER Char varchar2 15 Can be null if Automatic Asset Numbering is enabled Y 8 DESCRIPTION Char varchar2 80 Y 9 TAG_NUMBER Char varchar2 15 10 CATEGORY LOV custom varchar2 61 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 35 12 ASSET_KEY LOV custom varchar2 30 select 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 80 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 15 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 360 17 MODEL Char varchar2 40 18 WARRANTY_NUMBER LOV custom varchar2 15 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 15 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 80 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 80 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 80 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 80 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 80 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 80 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 30 27 INVESTMENT_LAW Char varchar2 30 28 BOOK LOV custom varchar2 15 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 80 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 12 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 80 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(+) and not exists (select null from fa_additions_b fab where fab.asset_number=:$column$.asset_number) 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(+) and not exists (select null from fa_additions_b fab where fab.asset_number=:$column$.asset_number) 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 10 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(+) and not exists (select null from fa_additions_b fab where fab.asset_number=:$column$.asset_number) Y 46 AMORTIZATION_START_DATE Date date 47 BONUS_RULE LOV custom varchar2 30 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 80 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 15 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 311 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 25 Y select distinct substrb(l.column_value,1,instrb(l.column_value,'~',1,1)-1) id, substrb(l.column_value,instrb(l.column_value,'~',1,1)+1,instrb(l.column_value,'~',1,2)-instrb(l.column_value,'~',1,1)-1) value, substrb(l.column_value,instrb(l.column_value,'~',1,2)+1) description from ( select gl.chart_of_accounts_id id_flex_num from fa_book_controls fbc, gl_ledgers gl where fbc.book_type_code=:$column$.book and gl.ledger_id=fbc.set_of_books_id ) s, table(xxen_util.kff_segment_lov( p_application_id=>101, p_id_flex_code=>'GL#', p_id_flex_num=>s.id_flex_num, p_application_column_name=>'SEGMENT1', p_segment1=>:$column$.expense_segment1, p_segment2=>:$column$.expense_segment2, p_segment3=>:$column$.expense_segment3, p_segment4=>:$column$.expense_segment4, p_segment5=>:$column$.expense_segment5 )) l where ( :$column$.expense_account is null or substrb(l.column_value,1,instrb(l.column_value,'~',1,1)-1)= (select gcck.segment1 from gl_code_combinations_kfv gcck where gcck.concatenated_segments=:$column$.expense_account and gcck.chart_of_accounts_id=s.id_flex_num) ) order by 2 select gcck.segment1 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.concatenated_segments=:$column$.expense_account 55 EXPENSE_SEGMENT2 LOV custom varchar2 25 Y select distinct substrb(l.column_value,1,instrb(l.column_value,'~',1,1)-1) id, substrb(l.column_value,instrb(l.column_value,'~',1,1)+1,instrb(l.column_value,'~',1,2)-instrb(l.column_value,'~',1,1)-1) value, substrb(l.column_value,instrb(l.column_value,'~',1,2)+1) description from ( select gl.chart_of_accounts_id id_flex_num from fa_book_controls fbc, gl_ledgers gl where fbc.book_type_code=:$column$.book and gl.ledger_id=fbc.set_of_books_id ) s, table(xxen_util.kff_segment_lov( p_application_id=>101, p_id_flex_code=>'GL#', p_id_flex_num=>s.id_flex_num, p_application_column_name=>'SEGMENT2', p_segment1=>:$column$.expense_segment1, p_segment2=>:$column$.expense_segment2, p_segment3=>:$column$.expense_segment3, p_segment4=>:$column$.expense_segment4, p_segment5=>:$column$.expense_segment5 )) l where ( :$column$.expense_account is null or substrb(l.column_value,1,instrb(l.column_value,'~',1,1)-1)= (select gcck.segment2 from gl_code_combinations_kfv gcck where gcck.concatenated_segments=:$column$.expense_account and gcck.chart_of_accounts_id=s.id_flex_num) ) order by 2 select gcck.segment2 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.concatenated_segments=:$column$.expense_account 56 EXPENSE_SEGMENT3 LOV custom varchar2 25 Y select distinct substrb(l.column_value,1,instrb(l.column_value,'~',1,1)-1) id, substrb(l.column_value,instrb(l.column_value,'~',1,1)+1,instrb(l.column_value,'~',1,2)-instrb(l.column_value,'~',1,1)-1) value, substrb(l.column_value,instrb(l.column_value,'~',1,2)+1) description from ( select gl.chart_of_accounts_id id_flex_num from fa_book_controls fbc, gl_ledgers gl where fbc.book_type_code=:$column$.book and gl.ledger_id=fbc.set_of_books_id ) s, table(xxen_util.kff_segment_lov( p_application_id=>101, p_id_flex_code=>'GL#', p_id_flex_num=>s.id_flex_num, p_application_column_name=>'SEGMENT3', p_segment1=>:$column$.expense_segment1, p_segment2=>:$column$.expense_segment2, p_segment3=>:$column$.expense_segment3, p_segment4=>:$column$.expense_segment4, p_segment5=>:$column$.expense_segment5 )) l where ( :$column$.expense_account is null or substrb(l.column_value,1,instrb(l.column_value,'~',1,1)-1)= (select gcck.segment3 from gl_code_combinations_kfv gcck where gcck.concatenated_segments=:$column$.expense_account and gcck.chart_of_accounts_id=s.id_flex_num) ) order by 2 select gcck.segment3 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.concatenated_segments=:$column$.expense_account 57 EXPENSE_SEGMENT4 LOV custom varchar2 25 Y select distinct substrb(l.column_value,1,instrb(l.column_value,'~',1,1)-1) id, substrb(l.column_value,instrb(l.column_value,'~',1,1)+1,instrb(l.column_value,'~',1,2)-instrb(l.column_value,'~',1,1)-1) value, substrb(l.column_value,instrb(l.column_value,'~',1,2)+1) description from ( select gl.chart_of_accounts_id id_flex_num from fa_book_controls fbc, gl_ledgers gl where fbc.book_type_code=:$column$.book and gl.ledger_id=fbc.set_of_books_id ) s, table(xxen_util.kff_segment_lov( p_application_id=>101, p_id_flex_code=>'GL#', p_id_flex_num=>s.id_flex_num, p_application_column_name=>'SEGMENT4', p_segment1=>:$column$.expense_segment1, p_segment2=>:$column$.expense_segment2, p_segment3=>:$column$.expense_segment3, p_segment4=>:$column$.expense_segment4, p_segment5=>:$column$.expense_segment5 )) l where ( :$column$.expense_account is null or substrb(l.column_value,1,instrb(l.column_value,'~',1,1)-1)= (select gcck.segment4 from gl_code_combinations_kfv gcck where gcck.concatenated_segments=:$column$.expense_account and gcck.chart_of_accounts_id=s.id_flex_num) ) order by 2 select gcck.segment4 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.concatenated_segments=:$column$.expense_account 58 EXPENSE_SEGMENT5 LOV custom varchar2 25 Y select distinct substrb(l.column_value,1,instrb(l.column_value,'~',1,1)-1) id, substrb(l.column_value,instrb(l.column_value,'~',1,1)+1,instrb(l.column_value,'~',1,2)-instrb(l.column_value,'~',1,1)-1) value, substrb(l.column_value,instrb(l.column_value,'~',1,2)+1) description from ( select gl.chart_of_accounts_id id_flex_num from fa_book_controls fbc, gl_ledgers gl where fbc.book_type_code=:$column$.book and gl.ledger_id=fbc.set_of_books_id ) s, table(xxen_util.kff_segment_lov( p_application_id=>101, p_id_flex_code=>'GL#', p_id_flex_num=>s.id_flex_num, p_application_column_name=>'SEGMENT5', p_segment1=>:$column$.expense_segment1, p_segment2=>:$column$.expense_segment2, p_segment3=>:$column$.expense_segment3, p_segment4=>:$column$.expense_segment4, p_segment5=>:$column$.expense_segment5 )) l where ( :$column$.expense_account is null or substrb(l.column_value,1,instrb(l.column_value,'~',1,1)-1)= (select gcck.segment5 from gl_code_combinations_kfv gcck where gcck.concatenated_segments=:$column$.expense_account and gcck.chart_of_accounts_id=s.id_flex_num) ) order by 2 select gcck.segment5 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.concatenated_segments=:$column$.expense_account 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 123 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 30 Y select distinct substrb(l.column_value,1,instrb(l.column_value,'~',1,1)-1) id, substrb(l.column_value,instrb(l.column_value,'~',1,1)+1,instrb(l.column_value,'~',1,2)-instrb(l.column_value,'~',1,1)-1) value, substrb(l.column_value,instrb(l.column_value,'~',1,2)+1) description from ( select 101 id_flex_num from dual ) s, table(xxen_util.kff_segment_lov( p_application_id=>140, p_id_flex_code=>'LOC#', p_id_flex_num=>s.id_flex_num, p_application_column_name=>'SEGMENT1', p_segment1=>:$column$.location_segment1, p_segment2=>:$column$.location_segment2, p_segment3=>:$column$.location_segment3, p_segment4=>:$column$.location_segment4, p_segment5=>:$column$.location_segment5, p_segment6=>:$column$.location_segment6, p_segment7=>:$column$.location_segment7 )) l where ( :$column$.location is null or substrb(l.column_value,1,instrb(l.column_value,'~',1,1)-1)= (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 2 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 30 Y select distinct substrb(l.column_value,1,instrb(l.column_value,'~',1,1)-1) id, substrb(l.column_value,instrb(l.column_value,'~',1,1)+1,instrb(l.column_value,'~',1,2)-instrb(l.column_value,'~',1,1)-1) value, substrb(l.column_value,instrb(l.column_value,'~',1,2)+1) description from ( select 101 id_flex_num from dual ) s, table(xxen_util.kff_segment_lov( p_application_id=>140, p_id_flex_code=>'LOC#', p_id_flex_num=>s.id_flex_num, p_application_column_name=>'SEGMENT2', p_segment1=>:$column$.location_segment1, p_segment2=>:$column$.location_segment2, p_segment3=>:$column$.location_segment3, p_segment4=>:$column$.location_segment4, p_segment5=>:$column$.location_segment5, p_segment6=>:$column$.location_segment6, p_segment7=>:$column$.location_segment7 )) l where ( :$column$.location is null or substrb(l.column_value,1,instrb(l.column_value,'~',1,1)-1)= (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 2 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 30 Y select distinct substrb(l.column_value,1,instrb(l.column_value,'~',1,1)-1) id, substrb(l.column_value,instrb(l.column_value,'~',1,1)+1,instrb(l.column_value,'~',1,2)-instrb(l.column_value,'~',1,1)-1) value, substrb(l.column_value,instrb(l.column_value,'~',1,2)+1) description from ( select 101 id_flex_num from dual ) s, table(xxen_util.kff_segment_lov( p_application_id=>140, p_id_flex_code=>'LOC#', p_id_flex_num=>s.id_flex_num, p_application_column_name=>'SEGMENT3', p_segment1=>:$column$.location_segment1, p_segment2=>:$column$.location_segment2, p_segment3=>:$column$.location_segment3, p_segment4=>:$column$.location_segment4, p_segment5=>:$column$.location_segment5, p_segment6=>:$column$.location_segment6, p_segment7=>:$column$.location_segment7 )) l where ( :$column$.location is null or substrb(l.column_value,1,instrb(l.column_value,'~',1,1)-1)= (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 2 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 30 Y select distinct substrb(l.column_value,1,instrb(l.column_value,'~',1,1)-1) id, substrb(l.column_value,instrb(l.column_value,'~',1,1)+1,instrb(l.column_value,'~',1,2)-instrb(l.column_value,'~',1,1)-1) value, substrb(l.column_value,instrb(l.column_value,'~',1,2)+1) description from ( select 101 id_flex_num from dual ) s, table(xxen_util.kff_segment_lov( p_application_id=>140, p_id_flex_code=>'LOC#', p_id_flex_num=>s.id_flex_num, p_application_column_name=>'SEGMENT4', p_segment1=>:$column$.location_segment1, p_segment2=>:$column$.location_segment2, p_segment3=>:$column$.location_segment3, p_segment4=>:$column$.location_segment4, p_segment5=>:$column$.location_segment5, p_segment6=>:$column$.location_segment6, p_segment7=>:$column$.location_segment7 )) l where ( :$column$.location is null or substrb(l.column_value,1,instrb(l.column_value,'~',1,1)-1)= (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 2 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 LOCATION_SEGMENT5 LOV custom varchar2 30 Y select distinct substrb(l.column_value,1,instrb(l.column_value,'~',1,1)-1) id, substrb(l.column_value,instrb(l.column_value,'~',1,1)+1,instrb(l.column_value,'~',1,2)-instrb(l.column_value,'~',1,1)-1) value, substrb(l.column_value,instrb(l.column_value,'~',1,2)+1) description from ( select 101 id_flex_num from dual ) s, table(xxen_util.kff_segment_lov( p_application_id=>140, p_id_flex_code=>'LOC#', p_id_flex_num=>s.id_flex_num, p_application_column_name=>'SEGMENT5', p_segment1=>:$column$.location_segment1, p_segment2=>:$column$.location_segment2, p_segment3=>:$column$.location_segment3, p_segment4=>:$column$.location_segment4, p_segment5=>:$column$.location_segment5, p_segment6=>:$column$.location_segment6, p_segment7=>:$column$.location_segment7 )) l where ( :$column$.location is null or substrb(l.column_value,1,instrb(l.column_value,'~',1,1)-1)= (select fl.segment5 from fa_locations fl, fa_locations_kfv flk where flk.concatenated_segments=:$column$.location and fl.location_id=flk.location_id) ) order by 2 select fl.segment5 from fa_locations fl, fa_locations_kfv flk where flk.concatenated_segments=:$column$.location and fl.location_id=flk.location_id 66 LOCATION_SEGMENT6 LOV custom varchar2 30 Y select distinct substrb(l.column_value,1,instrb(l.column_value,'~',1,1)-1) id, substrb(l.column_value,instrb(l.column_value,'~',1,1)+1,instrb(l.column_value,'~',1,2)-instrb(l.column_value,'~',1,1)-1) value, substrb(l.column_value,instrb(l.column_value,'~',1,2)+1) description from ( select 101 id_flex_num from dual ) s, table(xxen_util.kff_segment_lov( p_application_id=>140, p_id_flex_code=>'LOC#', p_id_flex_num=>s.id_flex_num, p_application_column_name=>'SEGMENT6', p_segment1=>:$column$.location_segment1, p_segment2=>:$column$.location_segment2, p_segment3=>:$column$.location_segment3, p_segment4=>:$column$.location_segment4, p_segment5=>:$column$.location_segment5, p_segment6=>:$column$.location_segment6, p_segment7=>:$column$.location_segment7 )) l where ( :$column$.location is null or substrb(l.column_value,1,instrb(l.column_value,'~',1,1)-1)= (select fl.segment6 from fa_locations fl, fa_locations_kfv flk where flk.concatenated_segments=:$column$.location and fl.location_id=flk.location_id) ) order by 2 select fl.segment6 from fa_locations fl, fa_locations_kfv flk where flk.concatenated_segments=:$column$.location and fl.location_id=flk.location_id 67 LOCATION_SEGMENT7 LOV custom varchar2 30 Y select distinct substrb(l.column_value,1,instrb(l.column_value,'~',1,1)-1) id, substrb(l.column_value,instrb(l.column_value,'~',1,1)+1,instrb(l.column_value,'~',1,2)-instrb(l.column_value,'~',1,1)-1) value, substrb(l.column_value,instrb(l.column_value,'~',1,2)+1) description from ( select 101 id_flex_num from dual ) s, table(xxen_util.kff_segment_lov( p_application_id=>140, p_id_flex_code=>'LOC#', p_id_flex_num=>s.id_flex_num, p_application_column_name=>'SEGMENT7', p_segment1=>:$column$.location_segment1, p_segment2=>:$column$.location_segment2, p_segment3=>:$column$.location_segment3, p_segment4=>:$column$.location_segment4, p_segment5=>:$column$.location_segment5, p_segment6=>:$column$.location_segment6, p_segment7=>:$column$.location_segment7 )) l where ( :$column$.location is null or substrb(l.column_value,1,instrb(l.column_value,'~',1,1)-1)= (select fl.segment7 from fa_locations fl, fa_locations_kfv flk where flk.concatenated_segments=:$column$.location and fl.location_id=flk.location_id) ) order by 2 select fl.segment7 from fa_locations fl, fa_locations_kfv flk where flk.concatenated_segments=:$column$.location and fl.location_id=flk.location_id 68 EMPLOYEE_NAME LOV custom varchar2 240 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 69 EMPLOYEE_NUMBER LOV custom varchar2 30 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 70 ATTRIBUTE_CATEGORY LOV custom varchar2 210 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 71 ATTRIBUTE1 LOV custom varchar2 150 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' 72 ATTRIBUTE2 LOV custom varchar2 150 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' 73 ATTRIBUTE3 LOV custom varchar2 150 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' 74 ATTRIBUTE4 LOV custom varchar2 150 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' 75 ATTRIBUTE5 LOV custom varchar2 150 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' 76 ATTRIBUTE6 LOV custom varchar2 150 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' 77 ATTRIBUTE7 LOV custom varchar2 150 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' 78 ATTRIBUTE8 LOV custom varchar2 150 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' 79 ATTRIBUTE9 LOV custom varchar2 150 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' 80 ATTRIBUTE10 LOV custom varchar2 150 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' 81 ATTRIBUTE11 LOV custom varchar2 150 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' 82 ATTRIBUTE12 LOV custom varchar2 150 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' 83 ATTRIBUTE13 LOV custom varchar2 150 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' 84 ATTRIBUTE14 LOV custom varchar2 150 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' 85 ATTRIBUTE15 LOV custom varchar2 150 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' 86 DATE_RETIRED Date date select case when :$column$.record_type='Retirement' then fdp.calendar_period_close_date end from fa_deprn_periods fdp where fdp.book_type_code=:$column$.book and fdp.period_close_date is null 87 COST_RETIRED Number number select case when :$column$.record_type='Retirement' then fb.cost end from fa_books fb where fb.book_type_code=:$column$.book and fb.asset_id=(select fab.asset_id from fa_additions_b fab where fab.asset_number=:$column$.asset_number) and fb.date_ineffective is null 88 UNITS_RETIRED Number number 89 PROCEEDS_OF_SALE Number number 90 COST_OF_REMOVAL Number number 91 RETIREMENT_TYPE LOV custom varchar2 15 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 92 RETIRE_PRORATE_CONV LOV custom varchar2 10 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 93 SOLD_TO Char varchar2 30 94 REFERENCE_NUM Char varchar2 15 95 TRADE_IN_ASSET_NUMBER LOV custom varchar2 15 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 96 TRANSACTION_NAME Char varchar2 30 97 RETIRE_STATUS Char varchar2 15 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 in Char 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 28 p_ytd_depreciation in Number YTD_DEPRECIATION U 29 p_depreciation_reserve in Number DEPRECIATION_RESERVE U 30 p_salvage_value_type in Char SALVAGE_VALUE_TYPE U 31 p_percent_salvage_value in Number PERCENT_SALVAGE_VALUE U 32 p_salvage_value in Number SALVAGE_VALUE U 33 p_depreciation_method in Char DEPRECIATION_METHOD U 34 p_depreciate in Char DEPRECIATE U 35 p_life_years in Number LIFE_YEARS U 36 p_life_months in Number LIFE_MONTHS U 37 p_date_placed_in_service in Date DATE_PLACED_IN_SERVICE U 38 p_prorate_convention in Char PRORATE_CONVENTION U 39 p_amortization_start_date in Date AMORTIZATION_START_DATE U 40 p_bonus_rule in Char BONUS_RULE U 41 p_depreciation_limit_type in Char DEPRECIATION_LIMIT_TYPE U 42 p_depreciation_limit_amount in Number DEPRECIATION_LIMIT_AMOUNT U 43 p_depreciation_limit_pct in Number DEPRECIATION_LIMIT_PCT U 44 p_group_asset_id in Number GROUP_ASSET U 45 p_expense_ccid in Number EXPENSE_ACCOUNT U 46 p_expense_segment1 in Char EXPENSE_SEGMENT1 U 47 p_expense_segment2 in Char EXPENSE_SEGMENT2 U 48 p_expense_segment3 in Char EXPENSE_SEGMENT3 U 49 p_expense_segment4 in Char EXPENSE_SEGMENT4 U 50 p_expense_segment5 in Char EXPENSE_SEGMENT5 U 51 p_location_id in Number LOCATION U 52 p_location_segments in Char LOCATION U 53 p_location_segment1 in Char LOCATION_SEGMENT1 U 54 p_location_segment2 in Char LOCATION_SEGMENT2 U 55 p_location_segment3 in Char LOCATION_SEGMENT3 U 56 p_location_segment4 in Char LOCATION_SEGMENT4 U 57 p_location_segment5 in Char LOCATION_SEGMENT5 U 58 p_location_segment6 in Char LOCATION_SEGMENT6 U 59 p_location_segment7 in Char LOCATION_SEGMENT7 U 60 p_assigned_to in Number EMPLOYEE_NAME U 61 p_attribute_category in Char ATTRIBUTE_CATEGORY U 62 p_attribute1 in Char ATTRIBUTE1 U 63 p_attribute2 in Char ATTRIBUTE2 U 64 p_attribute3 in Char ATTRIBUTE3 U 65 p_attribute4 in Char ATTRIBUTE4 U 66 p_attribute5 in Char ATTRIBUTE5 U 67 p_attribute6 in Char ATTRIBUTE6 U 68 p_attribute7 in Char ATTRIBUTE7 U 69 p_attribute8 in Char ATTRIBUTE8 U 70 p_attribute9 in Char ATTRIBUTE9 U 71 p_attribute10 in Char ATTRIBUTE10 U 72 p_attribute11 in Char ATTRIBUTE11 U 73 p_attribute12 in Char ATTRIBUTE12 U 74 p_attribute13 in Char ATTRIBUTE13 U 75 p_attribute14 in Char ATTRIBUTE14 U 76 p_attribute15 in Char ATTRIBUTE15 U 77 p_date_retired in Date DATE_RETIRED U 78 p_cost_retired in Number COST_RETIRED U 79 p_units_retired in Number UNITS_RETIRED U 80 p_proceeds_of_sale in Number PROCEEDS_OF_SALE U 81 p_cost_of_removal in Number COST_OF_REMOVAL U 82 p_retirement_type in Char RETIREMENT_TYPE U 83 p_retire_prorate_conv in Char RETIRE_PRORATE_CONV U 84 p_sold_to in Char SOLD_TO U 85 p_reference_num in Char REFERENCE_NUM U 86 p_trade_in_asset_id in Number TRADE_IN_ASSET_NUMBER U 87 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.location_segment5, xu.location_segment6, xu.location_segment7, 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.location_segment5, xu.location_segment6, xu.location_segment7, 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'