ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN F4C1A55E7510E001E0530100007FAAAAY select gl.name ledger, :p_book book, gl.currency_code currency, fab.asset_number, fat.description asset_description, fakk.concatenated_segments asset_key, fab.tag_number, fcbk.concatenated_segments asset_category, flk.concatenated_segments asset_location, fb.cost asset_cost, fb.date_placed_in_service, fai.invoice_number, fai.invoice_date, fai.fixed_assets_cost invoice_cost, fai.description invoice_description, fai.po_number purchase_order, aps.vendor_name, &chart_of_accounts fai.feeder_system_name, fai.payables_batch_name, &dff_column fai.creation_date invoice_creation_date, fdh.last_update_date distribution_last_update from fa_book_controls fbc, gl_ledgers gl, fa_additions_b fab, fa_asset_keywords_kfv fakk, fa_additions_tl fat, fa_books fb, fa_distribution_history fdh, gl_code_combinations gcc, fa_categories_b_kfv fcbk, fa_locations_kfv flk, fa_asset_invoices fai, ap_suppliers aps where fbc.book_type_code=:p_book and fbc.set_of_books_id=gl.ledger_id and fab.asset_type='CIP' and fab.asset_id=fat.asset_id and fat.language=userenv('lang') and fab.asset_id=fb.asset_id and fb.book_type_code=fbc.book_type_code and fb.transaction_header_id_out is null and fab.asset_id=fdh.asset_id and fdh.book_type_code=fbc.book_type_code and fdh.date_ineffective is null and fdh.code_combination_id=gcc.code_combination_id and fdh.location_id=flk.location_id and fab.asset_key_ccid=fakk.code_combination_id(+) and fab.asset_category_id=fcbk.category_id and fab.asset_id=fai.asset_id(+) and fai.po_vendor_id=aps.vendor_id(+) and 1=1 order by fab.asset_number, fai.invoice_number #,##0.00;[Red]-#,##0.00 US FA CIP Assets and Invoices CIP (Construction in Progress) assets with invoice details. Shows asset master information (category, location, tag, cost) alongside AP invoice lines that feed into CIP. Run as-is for invoice-level detail, or pivot/group in Excel for an asset-level summary - Use template Asset Summary Covers the use cases of: - Monthly CIP Report - Asset Details (CapEx) - Monthly CIP Report - CIP Invoice Activity Enginatics &chart_of_accounts &dff_column 1=1 :p_book 1 -10 &chart_of_accounts select 'gcc.'||lower(fifsv.application_column_name)||' "'||substrb(fifsv.form_left_prompt_,1,xxen_report.max_column_length)||'",' text from (select xxen_util.init_cap(fifsv.form_left_prompt) form_left_prompt_, fifsv.* from fnd_id_flex_segments_vl fifsv) fifsv where fifsv.application_id=101 and fifsv.id_flex_code='GL#' and fifsv.enabled_flag='Y' and fifsv.id_flex_num=(select fifsv0.id_flex_num from fnd_id_flex_structures_vl fifsv0 where fifsv0.application_id=101 and fifsv0.id_flex_code='GL#' and fifsv0.id_flex_structure_name=:chart_of_accounts) order by fifsv.segment_num LOV GL Chart of Accounts (inv org related) 8E2FF36EDEC879D2E0530100007F1FF2 Y select fifsv.id_flex_structure_name value, fifsv.id_flex_structure_code description from fnd_id_flex_structures_vl fifsv where fifsv.id_flex_code='GL#' and fifsv.application_id=101 and fifsv.id_flex_num in (select ood.chart_of_accounts_id from org_organization_definitions ood where nvl(ood.disable_date,sysdate + 1) > sysdate) order by fifsv.id_flex_structure_name select fifsv.id_flex_structure_name from fnd_id_flex_structures_vl fifsv where fifsv.id_flex_code='GL#' and fifsv.application_id=101 and fifsv.id_flex_num=(select ood.chart_of_accounts_id from org_organization_definitions ood where ood.organization_id=fnd_profile.value('MFG_ORGANIZATION_ID')) US Chart of Accounts 2 10 :p_book LOV Oracle FA_BOOK_TYPE Y select book_type_code id, book_type_code value, book_type_name description from fa_book_controls_sec order by book_type_code xxen_util.previous_parameter_value(:parameter_id) Y US Book Asset book 3 20 1=1 fab.asset_number=:asset_number LOV custom Y select fab.asset_number value, fat.description description from fa_additions_b fab, fa_additions_tl fat where fab.asset_type='CIP' and fab.asset_id=fat.asset_id and fat.language=userenv('lang') order by fab.asset_number US Asset Number 4 30 1=1 fcbk.concatenated_segments=:asset_category LOV custom Y select fcbk.concatenated_segments value, null description from fa_categories_b_kfv fcbk where fcbk.enabled_flag='Y' order by 1 US Asset Category 5 40 1=1 fai.invoice_date>=:invoice_date_from Date US Invoice Date From 6 50 1=1 fai.invoice_date<:invoice_date_to+1 Date last_day(:$flex$.invoice_date_from) US Invoice Date To 7 60 &dff_columns select xxen_util.dff_columns(p_table_name=>'FA_ADDITIONS',p_table_alias=>'fab',p_column_name_prefix=>'Asset: ',p_display_mode=>:dff_display) from dual LOV Blitz Report DFF Display 53B31EFFC6B85470E0630100007F501D Y select 'V' id, 'Value' value, 'Value only' description from dual union all select 'C' id, 'Value: Description' value, 'Concatenated value and description' description from dual union all select 'S' id, 'Value, Description' value, 'Value and description in separate columns' description from dual fnd_profile.value('XXEN_REPORT_DFF_DISPLAY') US DFF Display 5075AC8AA907077CE06362FB09057D86 Asset Summary PIYUSH.KHANDELWAL 8 ASSET_CATEGORY 10 ASSET_COST 5 ASSET_DESCRIPTION 6 ASSET_KEY 9 ASSET_LOCATION 4 ASSET_NUMBER 20 Account 2 BOOK 3 CURRENCY 18 Company 11 DATE_PLACED_IN_SERVICE 26 DISTRIBUTION_LAST_UPDATE 19 Department 23 FEEDER_SYSTEM_NAME 14 INVOICE_COST 25 INVOICE_CREATION_DATE 13 INVOICE_DATE 15 INVOICE_DESCRIPTION 12 INVOICE_NUMBER 1 LEDGER 24 PAYABLES_BATCH_NAME 16 PURCHASE_ORDER 22 Product 21 Sub-Account 7 TAG_NUMBER 17 VENDOR_NAME ASSET_CATEGORY ROW 1 ASSET_COST VALUE 1 SUM ASSET_DESCRIPTION ROW 3 ASSET_NUMBER ROW 2 CURRENCY FILTER 1 US T S Site 5075AC8AA907077CE06362FB09057D86