ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN B12835F5EC2F6F85E0530100007F7410 FA Period Y select x.value, x.description, x.fiscal_year, x.period_num from ( select fdp.period_name value, fbcs.deprn_calendar || ': ' || fdp.fiscal_year||' - '||fdp.period_num description, fdp.fiscal_year, fdp.period_num, fbcs.deprn_calendar from fa_book_controls_sec fbcs, fa_deprn_periods fdp where fbcs.book_type_code = fdp.book_type_code and (:$flex$.ledger is null or fdp.book_type_code in (select fbcs.book_type_code from gl_ledgers gl, fa_book_controls_sec fbcs where xxen_util.contains(:$flex$.ledger,gl.name)='Y' and gl.ledger_id=fbcs.set_of_books_id)) and (:$flex$.asset_book is null or xxen_util.contains(:$flex$.asset_book,fdp.book_type_code)='Y') and (:$flex$.book is null or xxen_util.contains(:$flex$.book,fdp.book_type_code)='Y') and fdp.book_type_code in (select fbcs.book_type_code from fa_book_controls_sec fbcs) and nvl(:$flex$.mrc_flag,'P') != 'R' union select fdpmv.period_name value, fbcs.deprn_calendar || ': ' || fdpmv.fiscal_year||' - '||fdpmv.period_num description, fdpmv.fiscal_year, fdpmv.period_num, fbcs.deprn_calendar from fa_book_controls_sec fbcs, fa_deprn_periods_mrc_v fdpmv where fbcs.book_type_code = fdpmv.book_type_code and (:$flex$.ledger is null or fdpmv.book_type_code in (select fbcmv.book_type_code from gl_ledgers gl, fa_book_controls_mrc_v fbcmv where xxen_util.contains(:$flex$.ledger,gl.name)='Y' and gl.ledger_id=fbcmv.set_of_books_id)) and (:$flex$.asset_book is null or xxen_util.contains(:$flex$.asset_book,fdpmv.book_type_code)='Y') and (:$flex$.book is null or xxen_util.contains(:$flex$.book,fdpmv.book_type_code)='Y') and fdpmv.book_type_code in (select fbcs.book_type_code from fa_book_controls_sec fbcs) and nvl(:$flex$.mrc_flag,'P') = 'R' ) x order by x.fiscal_year desc, x.period_num desc, x.deprn_calendar US 8E2FF36EDEB979D2E0530100007F1FF2 HR Operating Unit Y select hou.name value, null description from hr_operating_units hou where sysdate between hou.date_from and nvl(hou.date_to,sysdate) and (:$flex$.ledger is null or hou.set_of_books_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y')) and hou.organization_id in (select mgoat.organization_id from mo_glob_org_access_tmp mgoat union select fnd_global.org_id from dual where fnd_release.major_version=11) order by hou.name Fixed where clause duplication AR وحدة التشغيل مقيدة بالتحكم في الوصول متعدد المنظمات (MOAC) D Bedieneinheit eingeschränkt durch Multi Org Access Control (MOAC) E Unidad operativa restringida por el control de acceso multiorgánico (MOAC) F Unité opérationnelle restreinte par un contrôle d'accès multi-organismes (MOAC) I Unità operativa limitata dal controllo di accesso multiorgano (MOAC) JA 多機関アクセス制御(MOAC)で制限された操作ユニット KO 다중 조직 액세스 제어 (MOAC)에 의해 제한되는 운영 단위 PTB Unidade operacional restrita por controle de acesso multi org (MOAC) RU Операционное устройство, ограниченное мультиорганизованным контролем доступа (MOAC) S Styrenhet begränsad av multi-org access control (MOAC) TR Çoklu kuruluş erişim kontrolü (MOAC) tarafından kısıtlanan işletim birimi US Operating unit restricted by multi org access control (MOAC) ZHS 受多机构访问控制（MOAC）限制的操作单元。 AA09F562F23A22D9E053B46B6358D0E2 select x.* from ( select haouv.name operating_unit, cv.project_type, cv.project_number, cv.project_name, (select ppa.long_name from pa_projects_all ppa where ppa.project_id = cv.project_id) long_name, (select pps.project_status_name from pa_project_statuses pps where pps.project_status_code = cv.project_status_code) project_status, cv.project_id, cv.expensed -(decode(pa_mc_currency_pkg.get_mrc_sob_type_code,'R',0, nvl(rv.retirable_cost,0))) expensed_amount, cv.cip_cost cip_amount, cv.capitalized_cost interfaced_cip_amount, decode(pa_mc_currency_pkg.get_mrc_sob_type_code,'R',null, nvl(rv.rwip,0))rwip_amount, decode(pa_mc_currency_pkg.get_mrc_sob_type_code, 'R',null, nvl(rv.retired_cost,0))interfaced_rwip_amount, cv.total_costs total_amount, cv.project_organization, ppav.asset_name, ppav.project_asset_type, ppav.estimated_in_service_date, ppav.date_placed_in_service, ppav.total_asset_cost, rep_total_asset_cost, set_of_books_id, ppav.reverse_flag, ppav.capital_hold_flag, ppav.book_type_code, ppav.asset_number, ppav.asset_units, ppav.estimated_asset_units, ppav.estimated_cost, ppav.pm_product_code, ppav.pm_asset_reference, flk.concatenated_segments location, ppav.full_name employee_name, ppav.employee_number, ppav.depreciate_flag, ppav.amortize_flag, ppav.asset_description, ppav.manufacturer_name, ppav.model_number, ppav.serial_number, ppav.tag_number, ppav.capitalized_flag, ppav.capitalized_date, ppav.cost_adjustment_flag, (select distinct listagg(ppc.class_category || ' > ' || ppc.class_code,', ') within group(order by ppc.class_category,ppc.class_code) from pa_project_classes ppc where ppc.project_id = cv.project_id ) project_class_category_class, fth.transaction_date_entered asset_trx_entered_date, fdp.period_name asset_trx_entered_period, fth.date_effective asset_date_effective, fdp2.period_name asset_date_effective_period, -- unidentified asset line columns null asset_line_type, null asset_line_description, null asset_line_task_number, null asset_line_task_name, to_number(null) asset_line_amount, to_number(null) asset_line_original_amount, to_number(null) asset_line_split_percent, null asset_line_cip_account, null asset_line_fa_period, null asset_line_status, null asset_line_rejection_reason, -- null detail_expenditure_type, null detail_expenditure_category, to_date(null) detail_expenditure_item_date, null detail_employee_vendor_name, null detail_employee_vendor_number, to_number(null) detail_quantity, null detail_unit_of_measure_m, to_number(null) detail_cip_cost, null detail_expenditure_comment, null detail_expenditure_org, null detail_non_labor_resource, null detail_non_labor_resource_org, null detail_transaction_source, null detail_source_transaction_ref, null detail_job_name from hr_all_organization_units_vl haouv, fa_locations_kfv flk, pa_project_assets_v ppav, pa_capital_projects_v cv, (select sum(prcv.retirable_cost) retirable_cost, sum(prcv.retired_cost) retired_cost, sum(prcv.retirable_cost - retired_cost) rwip, prcv.project_id from pa_retirement_costs_v prcv where 4=4 group by prcv.project_id ) rv, fa_transaction_headers fth, fa_deprn_periods fdp, fa_deprn_periods fdp2 where 1=1 and 2=2 and haouv.organization_id=cv.org_id and flk.location_id(+)=ppav.location_id and ppav.project_id(+)=cv.project_id and ppav.project_asset_type(+) != 'RETIREMENT_ADJUSTMENT' and rv.project_id(+)=cv.project_id and fth.asset_id(+)=ppav.fa_asset_id and fth.book_type_code(+)=ppav.book_type_code and fth.transaction_type_code(+)='ADDITION' and fdp.book_type_code(+)=fth.book_type_code and fdp.calendar_period_open_date(+)<=trunc(fth.transaction_date_entered) and fdp.calendar_period_close_date(+)>=trunc(fth.transaction_date_entered) and fdp2.book_type_code(+)=fth.book_type_code and fdp2.period_open_date(+)<=fth.date_effective and nvl(fdp2.period_close_date(+),sysdate)>=fth.date_effective -- union -- unassigned asset lines -- select haouv.name operating_unit, cv.project_type, cv.project_number, cv.project_name, (select ppa.long_name from pa_projects_all ppa where ppa.project_id = cv.project_id) long_name, (select pps.project_status_name from pa_project_statuses pps where pps.project_status_code = cv.project_status_code) project_status, cv.project_id, cv.expensed -(decode(pa_mc_currency_pkg.get_mrc_sob_type_code,'R',0, nvl(rv.retirable_cost,0))) expensed_amount, cv.cip_cost cip_amount, cv.capitalized_cost interfaced_cip_amount, decode(pa_mc_currency_pkg.get_mrc_sob_type_code,'R',null, nvl(rv.rwip,0))rwip_amount, decode(pa_mc_currency_pkg.get_mrc_sob_type_code, 'R',null, nvl(rv.retired_cost,0))interfaced_rwip_amount, cv.total_costs total_amount, cv.project_organization, ppalv.asset_name, null project_asset_type, to_date(null) estimated_in_service_date, to_date(null) date_placed_in_service, to_number(null) total_asset_cost, to_number(null) rep_total_asset_cost, to_number(null) set_of_books_id, null reverse_flag, null capital_hold_flag, null book_type_code, null asset_number, to_number(null) asset_units, to_number(null) estimated_asset_units, to_number(null) estimated_cost, null pm_product_code, null pm_asset_reference, null location, null employee_name, null employee_number, null depreciate_flag, null amortize_flag, null asset_description, null manufacturer_name, null model_number, null serial_number, null tag_number, null capitalized_flag, null capitalized_date, null cost_adjustment_flag, (select distinct listagg(ppc.class_category || ' > ' || ppc.class_code,', ') within group(order by ppc.class_category,ppc.class_code) from pa_project_classes ppc where ppc.project_id = cv.project_id ) project_class_category_class, to_date(null) asset_trx_entered_date, null asset_trx_entered_period, to_date(null) asset_date_effective, null asset_date_effective_period, -- unassigned asset lines columns decode(ppalv.line_type,'C','Capital Asset Line','R','Retirement Cost Line',ppalv.line_type) asset_line_type, ppalv.description asset_line_description, ppalv.task_number asset_line_task_number, ppalv.task_name asset_line_task_name, ppalv.current_asset_cost asset_line_amount, ppalv.original_asset_cost asset_line_original_amount, case when nvl(ppalv.original_asset_cost,0) != 0 then round(ppalv.current_asset_cost / ppalv.original_asset_cost * 100,2) else to_number(null) end asset_line_split_percentage, (select gcck.concatenated_segments from gl_code_combinations_kfv gcck where gcck.code_combination_id = ppalv.cip_ccid) asset_line_cip_account, ppalv.fa_period_name asset_line_fa_period, ppalv.transfer_status_m asset_line_transfer_status, ppalv.transfer_rejection_reason_m asset_line_rejection_reason, -- paldv.expenditure_type detail_expenditure_type, paldv.expenditure_category detail_expenditure_category, paldv.expenditure_item_date detail_expenditure_item_date, paldv.employee_vendor_name detail_employee_vendor_name, paldv.employee_vendor_number detail_employee_vendor_number, paldv.quantity detail_quantity, paldv.unit_of_measure_m detail_unit_of_measure_m, paldv.cip_cost detail_cip_cost, paldv.expenditure_comment detail_expenditure_comment, paldv.expenditure_organization_name detail_expenditure_org, paldv.non_labor_resource detail_non_labor_resource, paldv.nlr_organization_name detail_non_labor_resource_org, paldv.transaction_source detail_transaction_source, paldv.orig_transaction_reference detail_source_transaction_ref, paldv.job_name detail_job_name from hr_all_organization_units_vl haouv, pa_project_asset_lines_v ppalv, pa_asset_line_details_v paldv, pa_capital_projects_v cv, (select sum(prcv.retirable_cost) retirable_cost, sum(prcv.retired_cost) retired_cost, sum(prcv.retirable_cost - retired_cost) rwip, prcv.project_id from pa_retirement_costs_v prcv where 4=4 group by prcv.project_id ) rv where :p_incl_unassigned_lines is not null and 1=1 and 3=3 and haouv.organization_id=cv.org_id and ppalv.project_id=cv.project_id and decode(:p_incl_unassigned_lines,'Lines',-999,ppalv.project_id) = paldv.project_id (+) and decode(:p_incl_unassigned_lines,'Lines',-999,ppalv.project_asset_line_detail_id) = paldv.project_asset_line_detail_id (+) and ppalv.project_asset_id=0 and rv.project_id(+)=cv.project_id ) x order by x.project_type, x.project_organization, x.project_name, decode(x.asset_name,'UNASSIGNED',2,1), x.asset_name Y PA PACRCAPS_XML US PA Capital Project Summary with Asset Detail Detail project report that shows the project asset details, and combined project level costs breakdown, along with the project assets details from the Capital Summary Enginatics R12 only 1=1 2=2 3=3 4=4 :cp_company_name :cp_project_id :cp_project_number :cp_project_org :operating_unit :p_class_category :p_class_code :p_conc_request_id :p_debug_mode :p_incl_unassigned_lines :p_project_id :p_project_org :p_project_type 1 10 1=1 cv.project_type=:p_project_type LOV Oracle PA_SRS_PROJECT_TYPE_CAPITAL Y select project_type id, project_type value, description description from pa_project_types where project_type_class_code='CAPITAL' order by project_type AR نوع المشروع D Projektart F Type de projet US Project Type ZHS 项目类型 2 4=4 prcv.project_type=:p_project_type US Project Type 3 20 1=1 cv.project_id=:p_project_id LOV Oracle PA_SRS_PROJECT_ID_CAPITAL Y select project_id id, project_number value, project_name description from pa_projects_basic_v where template_flag!='Y' and project_type_class_code='CAPITAL' and 'Y' in (select pa_utils.initialize from sys.dual) order by project_number_sort_order AR رقم المشروع D Projektnummer F Numéro de projet US Project Number ZHS 项目编号 4 4=4 prcv.project_id=:p_project_id US Project Number 5 30 1=1 haouv.name=:operating_unit LOV HR Operating Unit 8E2FF36EDEB979D2E0530100007F1FF2 Y select hou.name value, null description from hr_operating_units hou where sysdate between hou.date_from and nvl(hou.date_to,sysdate) and (:$flex$.ledger is null or hou.set_of_books_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y')) and hou.organization_id in (select mgoat.organization_id from mo_glob_org_access_tmp mgoat union select fnd_global.org_id from dual where fnd_release.major_version=11) order by hou.name coalesce(xxen_util.default_operating_unit,xxen_util.previous_parameter_value(:parameter_id)) US Operating Unit 6 40 1=1 cv.project_organization in (select name from pa_organizations_proj_all_bg_v where organization_id=:p_project_org) LOV Oracle PA_SRS_PROJECT_ORGANIZATION Y Y select organization_id id, name value, null description from pa_organizations_project_v where active_flag='Y' order by value,description AR تنظيم المشروع D Projektorganisation F Organisation du projet US Project Organization ZHS 项目组织 7 4=4 prcv.carrying_out_organization_id in (select name from pa_organizations_proj_all_bg_v where organization_id=:p_project_org) US Project Organization 8 50 1=1 cv.project_id in (select project_id from pa_project_classes where class_category = :p_class_category) LOV Oracle PA_SRS_CAP_CLASS_CATEGORY Y select class_category id, class_category value, description description from pa_class_categories where class_category in (select cc.class_category from pa_class_categories cc ,pa_valid_categories vc ,pa_project_types_all ppta where cc.class_category=vc.class_category and vc.object_type_id=ppta.project_type_id union select cc1.class_category from pa_class_categories cc1 where cc1.object_type='PA_PROJECTS' and cc1.all_types_valid_flag='Y' and not exists (select 'Y' from pa_valid_categories vc1 ,pa_project_types_all ppta1 where vc1.class_category=cc1.class_category and vc1.object_type_id=ppta1.project_type_id)) order by 1 AR فئة الطبقة D Klassenkategorie F Catégorie de classe US Class Category ZHS 分类类别 9 4=4 prcv.project_id in (select project_id from pa_project_classes where class_category = :p_class_category) US Class Category 10 60 1=1 cv.project_id in (select project_id from pa_project_classes where class_code = :p_class_code and class_category = :p_class_category) LOV Oracle PA_SRS_CAP_CLASS_CODE Y select class_code id, class_code value, description description from pa_class_codes where class_category=:$flex$.pa_srs_cap_class_category and (trunc(sysdate) between start_date_active and nvl(end_date_active,sysdate)) order by class_code AR رمز الطبقة D Klassenschlüssel F Code classe US Class Code ZHS 分类代码 11 4=4 prcv.project_id in (select project_id from pa_project_classes where class_code = :p_class_code and class_category = :p_class_category) US Class Code 12 70 2=2 fdp.period_name=:p_asset_trx_ent_period LOV FA Period B12835F5EC2F6F85E0530100007F7410 Y select x.value, x.description, x.fiscal_year, x.period_num from ( select fdp.period_name value, fbcs.deprn_calendar || ': ' || fdp.fiscal_year||' - '||fdp.period_num description, fdp.fiscal_year, fdp.period_num, fbcs.deprn_calendar from fa_book_controls_sec fbcs, fa_deprn_periods fdp where fbcs.book_type_code = fdp.book_type_code and (:$flex$.ledger is null or fdp.book_type_code in (select fbcs.book_type_code from gl_ledgers gl, fa_book_controls_sec fbcs where xxen_util.contains(:$flex$.ledger,gl.name)='Y' and gl.ledger_id=fbcs.set_of_books_id)) and (:$flex$.asset_book is null or xxen_util.contains(:$flex$.asset_book,fdp.book_type_code)='Y') and (:$flex$.book is null or xxen_util.contains(:$flex$.book,fdp.book_type_code)='Y') and fdp.book_type_code in (select fbcs.book_type_code from fa_book_controls_sec fbcs) and nvl(:$flex$.mrc_flag,'P') != 'R' union select fdpmv.period_name value, fbcs.deprn_calendar || ': ' || fdpmv.fiscal_year||' - '||fdpmv.period_num description, fdpmv.fiscal_year, fdpmv.period_num, fbcs.deprn_calendar from fa_book_controls_sec fbcs, fa_deprn_periods_mrc_v fdpmv where fbcs.book_type_code = fdpmv.book_type_code and (:$flex$.ledger is null or fdpmv.book_type_code in (select fbcmv.book_type_code from gl_ledgers gl, fa_book_controls_mrc_v fbcmv where xxen_util.contains(:$flex$.ledger,gl.name)='Y' and gl.ledger_id=fbcmv.set_of_books_id)) and (:$flex$.asset_book is null or xxen_util.contains(:$flex$.asset_book,fdpmv.book_type_code)='Y') and (:$flex$.book is null or xxen_util.contains(:$flex$.book,fdpmv.book_type_code)='Y') and fdpmv.book_type_code in (select fbcs.book_type_code from fa_book_controls_sec fbcs) and nvl(:$flex$.mrc_flag,'P') = 'R' ) x order by x.fiscal_year desc, x.period_num desc, x.deprn_calendar US Asset Trx Entered Period 13 80 2=2 fdp2.period_name=:p_asset_date_eff_period LOV FA Period B12835F5EC2F6F85E0530100007F7410 Y select x.value, x.description, x.fiscal_year, x.period_num from ( select fdp.period_name value, fbcs.deprn_calendar || ': ' || fdp.fiscal_year||' - '||fdp.period_num description, fdp.fiscal_year, fdp.period_num, fbcs.deprn_calendar from fa_book_controls_sec fbcs, fa_deprn_periods fdp where fbcs.book_type_code = fdp.book_type_code and (:$flex$.ledger is null or fdp.book_type_code in (select fbcs.book_type_code from gl_ledgers gl, fa_book_controls_sec fbcs where xxen_util.contains(:$flex$.ledger,gl.name)='Y' and gl.ledger_id=fbcs.set_of_books_id)) and (:$flex$.asset_book is null or xxen_util.contains(:$flex$.asset_book,fdp.book_type_code)='Y') and (:$flex$.book is null or xxen_util.contains(:$flex$.book,fdp.book_type_code)='Y') and fdp.book_type_code in (select fbcs.book_type_code from fa_book_controls_sec fbcs) and nvl(:$flex$.mrc_flag,'P') != 'R' union select fdpmv.period_name value, fbcs.deprn_calendar || ': ' || fdpmv.fiscal_year||' - '||fdpmv.period_num description, fdpmv.fiscal_year, fdpmv.period_num, fbcs.deprn_calendar from fa_book_controls_sec fbcs, fa_deprn_periods_mrc_v fdpmv where fbcs.book_type_code = fdpmv.book_type_code and (:$flex$.ledger is null or fdpmv.book_type_code in (select fbcmv.book_type_code from gl_ledgers gl, fa_book_controls_mrc_v fbcmv where xxen_util.contains(:$flex$.ledger,gl.name)='Y' and gl.ledger_id=fbcmv.set_of_books_id)) and (:$flex$.asset_book is null or xxen_util.contains(:$flex$.asset_book,fdpmv.book_type_code)='Y') and (:$flex$.book is null or xxen_util.contains(:$flex$.book,fdpmv.book_type_code)='Y') and fdpmv.book_type_code in (select fbcs.book_type_code from fa_book_controls_sec fbcs) and nvl(:$flex$.mrc_flag,'P') = 'R' ) x order by x.fiscal_year desc, x.period_num desc, x.deprn_calendar US Asset Date Effective Period 14 90 2=2 fth.transaction_date_entered>=:p_asset_trx_date_fr Date US Asset Trx Entered Date From 15 100 2=2 fth.transaction_date_entered<:p_asset_trx_date_to+1 Date last_day(:$flex$.Asset_Trx_Entered_Date_From) US Asset Trx Entered Date To 16 110 2=2 fth.date_effective>=:p_asset_date_eff_fr Date US Asset Date Effective From 17 120 2=2 fth.date_effective<:p_asset_date_eff_to+1 Date last_day(:$flex$.Asset_Date_Effective_From) US Asset Date Effective To 18 130 :p_incl_unassigned_lines LOV custom Y select value value, null description from ( select 'Lines' value from dual union select 'Lines and Details' value from dual ) order by value US Include Unassigned Asset Lines 19 140 3=3 decode(ppalv.line_type,'C','Capital Asset Line','R','Retirement Cost Line',ppalv.line_type) = :p_asset_line_type LOV custom Y select value, null description from (select 'Capital Asset Line' value from dual union select 'Retirement Cost Line' value from dual ) order by value US Unassigned Asset Line Type :$flex$.Asset_Date_Effective_From Asset Date Effective From Y Asset Date Effective To :$flex$.Asset_Trx_Entered_Date_From Asset Trx Entered Date From Y Asset Trx Entered Date To :$flex$.pa_srs_cap_class_category Class Category Class Code