ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 15B2E2DBB743E8CCE0630100007F9602 Copy Existing Budget Y select xxen_util.meaning('Y','YES_NO',0) value, null description from dual where :$flex$.upload_mode = xxen_upload.action_create 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）限制的操作单元。 8E2FF36EDEA679D2E0530100007F1FF2 Yes Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual US 136AC44795674C98E0636AFB0905AE6D /* &report_table_name */ select x.* from ( select decode(:p_upload_mode,xxen_upload.action_create,xxen_upload.action_meaning(xxen_upload.action_create),null) action_, decode(:p_upload_mode,xxen_upload.action_create,xxen_upload.status_meaning(xxen_upload.status_new),null)status_, null message_, null baseline_message_, null request_id_, null modified_columns_, :p_upload_mode upload_mode_, decode(:p_upload_mode,xxen_upload.action_create,to_number(null),pbl.budget_line_id) budget_line_id, -- -- Budget -- :p_pm_product_code product_source, haouv.name operating_unit, ppa.segment1 project_number, ppa.name project_name, pbt.budget_type, pbv.version_name, --pbv.version_number, --pbv.budget_status_m status, pbv.description, pbem.budget_entry_method entry_method, prl.name resource_list, null baseline_budget, xxen_util.meaning(pbv.change_reason_code,'BUDGET CHANGE REASON',275) change_reason, -- -- Budget line -- pt.task_number, pt.task_name, pbl.period_name, pbl.start_date, pbl.end_date, prlm.alias_path resource_alias, pbl.raw_cost, pbl.burdened_cost, pbl.revenue, pbl.quantity, xxen_util.meaning(pra.unit_of_measure,'UNIT',275) unit_of_measure, pbl.description line_description, --xxen_util.meaning(pbl.change_reason_code,'BUDGET CHANGE REASON',275) line_change_reason, --xxen_util.meaning(pra.track_as_labor_flag,'YES_NO',0) track_as_labor, null delete_this_line, -- -- DFF Columns pbv.attribute_category budget_attribute_category, pbv.attribute1 budget_attribute1, pbv.attribute2 budget_attribute2, pbv.attribute3 budget_attribute3, pbv.attribute4 budget_attribute4, pbv.attribute5 budget_attribute5, pbv.attribute6 budget_attribute6, pbv.attribute7 budget_attribute7, pbv.attribute8 budget_attribute8, pbv.attribute9 budget_attribute9, pbv.attribute10 budget_attribute10, pbv.attribute11 budget_attribute11, pbv.attribute12 budget_attribute12, pbv.attribute13 budget_attribute13, pbv.attribute14 budget_attribute14, pbv.attribute15 budget_attribute15, pbl.attribute_category line_attribute_category, pbl.attribute1 line_attribute1, pbl.attribute2 line_attribute2, pbl.attribute3 line_attribute3, pbl.attribute4 line_attribute4, pbl.attribute5 line_attribute5, pbl.attribute6 line_attribute6, pbl.attribute7 line_attribute7, pbl.attribute8 line_attribute8, pbl.attribute9 line_attribute9, pbl.attribute10 line_attribute10, pbl.attribute11 line_attribute11, pbl.attribute12 line_attribute12, pbl.attribute13 line_attribute13, pbl.attribute14 line_attribute14, pbl.attribute15 line_attribute15, -- null mark_as_original from hr_all_organization_units_vl haouv, pa_projects_all ppa, pa_budget_versions pbv, pa_budget_types pbt, pa_budget_entry_methods pbem, pa_resource_lists prl, pa_resource_assignments pra, pa_budget_lines pbl, pa_tasks pt, --pa_resource_list_members prlm (select prlm.resource_list_id, prlm.resource_list_member_id, prlm.alias alias, substr(sys_connect_by_path (prlm.alias,'|'),2) alias_path from pa_resource_list_members prlm where nvl(prlm.migration_code, '-99') <> 'N' connect by prior prlm.resource_list_member_id = prlm.parent_member_id and prior prlm.resource_list_id = prlm.resource_list_id start with prlm.parent_member_id is null ) prlm where 1=1 and ( (:p_upload_mode = xxen_upload.action_update and pbv.budget_status_code IN ('W','S')) or -- draft (:p_upload_mode = xxen_upload.action_create and :p_create_copy = xxen_util.meaning('Y','YES_NO',0)) ) and haouv.name = nvl(:p_operating_unit,haouv.name) and nvl(:p_pm_product_code,'?') = nvl(:p_pm_product_code,'?') and haouv.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) and haouv.organization_id = ppa.org_id and ppa.project_id = pbv.project_id and pbv.budget_type_code = pbt.budget_type_code and pbv.budget_entry_method_code = pbem.budget_entry_method_code and pbv.resource_list_id = prl.resource_list_id and pbv.budget_version_id = pra.budget_version_id (+) and pbv.project_id = pra.project_id (+) and pra.resource_assignment_id = pbl.resource_assignment_id (+) and pra.task_id = pt.task_id (+) and pra.resource_list_member_id = prlm.resource_list_member_id (+) &not_use_first_block &processed_errors_query &processed_success_query &processed_run ) x order by x.operating_unit, x.project_number, x.project_name, x.budget_type, x.version_name, &lp_sort_col1 &lp_sort_col2 &lp_sort_col3 x.budget_line_id Y U (:upload_mode = xxen_upload.action_create and (:Copy_Existing_Budget is null or (:Copy_Existing_Budget is not null and (:project_number is not null or :project_name is not null) and :budget_type is not null and :budget_version is not null ) ) ) or (:upload_mode = xxen_upload.action_update and (:project_number is not null or :project_name is not null) ) A xxen_pa_upload.upload_project_budget xxen_pa_upload.baseline_budget xxen_pa_upload.validate_budget_line_excel_row (p_operating_unit => :$column$.operating_unit ,p_project_number => :$column$.project_number ,p_task_number => :$column$.task_number ,p_budget_type => :$column$.budget_type ,p_entry_method => :$column$.entry_method ,p_budget_start_date => :$column$.start_date ,p_budget_end_date => :$column$.end_date ,p_period_name => :$column$.period_name ,p_raw_cost => :$column$.raw_cost ,p_burdened_cost => :$column$.burdened_cost ,p_revenue => :$column$.revenue ,p_quantity => :$column$.quantity ) US PA Project Budget Upload The PA Project Budget Upload supports the creation/update of standard project budgets. At this stage it does not support the creation/update of Financial Plan Budgets. The PA Project Budget Upload allows users to: - Create new working budgets. When creating a new working budget, any existing working budget for the specified Project and Budget Type will be overwritten. The upload allows the user to create a working budget either by entering the data directly into an empty upload excel file, or by copying a prior version of the budget and modifying this in the upload excel file. - Update existing working budgets. This option allows for the update of an existing working budget. In this mode the existing budget is retained, and the update mode allows for individual budget lines to be added, updated, and/or deleted from the existing working budget. - Additionally, the upload allows users to Baseline a Working Budget. Working Budgets can be uploaded against the Projects belonging to the Operating Units accessible to the responsibility in which the PA Project Budget Upload process is run. Copy Existing Budget Mode requires the Project, Budget Type, and Budget Verion to be entered. Update Mode requires the Project to be entered. Enginatics R12 only Upload &lp_sort_col1 &lp_sort_col2 &lp_sort_col3 &not_use_first_block &processed_errors_query &processed_run &processed_success_query &report_table_name 1=1 :p_create_copy :p_operating_unit :p_pm_product_code :p_upload_mode 1 10 :p_upload_mode LOV custom 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_update id, xxen_upload.action_meaning(xxen_upload.action_update) value, null description from dual C Y US Upload Mode 2 20 :p_pm_product_code LOV custom Y select pl.meaning value, pl.description description from pa_lookups pl where pl.lookup_type = 'PM_PRODUCT_CODE' order by value Y US Product Source 3 30 :p_create_copy LOV Copy Existing Budget 15B2E2DBB743E8CCE0630100007F9602 Y select xxen_util.meaning('Y','YES_NO',0) value, null description from dual where :$flex$.upload_mode = xxen_upload.action_create US Copy Existing Budget 4 40 :p_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 5 50 1=1 ppa.segment1=:p_project_number LOV custom Y Y select ppa.segment1 value, ppa.name description from hr_all_organization_units_vl haouv, pa_projects_all ppa, pa_project_types_all pt where haouv.organization_id = ppa.org_id and ppa.project_type = pt.project_type and ppa.org_id = pt.org_id and (pt.allow_cost_budget_entry_flag = 'Y' or pt.allow_rev_budget_entry_flag = 'Y' ) and exists (select null from pa_budget_versions pbv where pbv.project_id = ppa.project_id and pbv.budget_type_code is not null and (pbv.budget_status_code in ('S','W') or :$flex$.copy_existing_budget = xxen_util.meaning('Y','YES_NO',0)) ) and (:$flex$.operating_unit is null or xxen_util.contains(:$flex$.operating_unit,haouv.name) = 'Y') and (:$flex$.upload_mode = xxen_upload.action_update or :$flex$.copy_existing_budget = xxen_util.meaning('Y','YES_NO',0)) order by value US Project Number 6 60 1=1 ppa.name=:p_project_name LOV custom Y select ppa.name value, ppa.segment1 description from hr_all_organization_units_vl haouv, pa_projects_all ppa, pa_project_types_all pt where haouv.organization_id = ppa.org_id and ppa.project_type = pt.project_type and ppa.org_id = pt.org_id and (pt.allow_cost_budget_entry_flag = 'Y' or pt.allow_rev_budget_entry_flag = 'Y' ) and exists (select null from pa_budget_versions pbv where pbv.project_id = ppa.project_id and pbv.budget_type_code is not null and (pbv.budget_status_code in ('S','W') or :$flex$.copy_existing_budget = xxen_util.meaning('Y','YES_NO',0)) ) and (:$flex$.operating_unit is null or xxen_util.contains(:$flex$.operating_unit,haouv.name) = 'Y') and (:$flex$.project_number is null or xxen_util.contains(:$flex$.project_number,ppa.segment1) = 'Y') and (:$flex$.upload_mode = xxen_upload.action_update or :$flex$.copy_existing_budget = xxen_util.meaning('Y','YES_NO',0)) order by value US Project Name 7 70 1=1 pbt.budget_type=:p_budget_type LOV custom Y select pbt.budget_type value, pbt.description from pa_budget_types pbt where nvl(pbt.plan_type, 'BUDGET') = 'BUDGET' and trunc(sysdate) between trunc(pbt.start_date_active) and trunc(nvl(pbt.end_date_active,sysdate)) and pbt.budget_type_code in (select pbv.budget_type_code from hr_all_organization_units_vl haouv, pa_projects_all ppa, pa_budget_versions pbv where haouv.organization_id = ppa.org_id and ppa.project_id = pbv.project_id and pbv.budget_type_code is not null and (pbv.budget_status_code in ('S','W') or :$flex$.copy_existing_budget = xxen_util.meaning('Y','YES_NO',0)) and (:$flex$.operating_unit is null or xxen_util.contains(:$flex$.operating_unit,haouv.name) = 'Y') and (:$flex$.project_number is null or xxen_util.contains(:$flex$.project_number,ppa.segment1) = 'Y') and (:$flex$.project_name is null or xxen_util.contains(:$flex$.project_name,ppa.name) = 'Y') and (:$flex$.project_number is not null or :$flex$.project_name is not null) ) and (:$flex$.upload_mode = xxen_upload.action_update or :$flex$.copy_existing_budget = xxen_util.meaning('Y','YES_NO',0)) order by value US Budget Type 8 80 1=1 decode(pbv.budget_status_code,'B',to_char(pbv.version_number),xxen_util.meaning(pbv.budget_status_code,'BUDGET STATUS',275)) = :p_budget_version LOV custom Y select decode(pbv.budget_status_code,'B',to_char(pbv.version_number),xxen_util.meaning(pbv.budget_status_code,'BUDGET STATUS',275)) value, pbv.version_name description from hr_all_organization_units_vl haouv, pa_projects_all ppa, pa_budget_versions pbv, pa_budget_types pbt where haouv.organization_id = ppa.org_id and ppa.project_id = pbv.project_id and pbv.budget_type_code is not null and pbv.budget_type_code = pbt.budget_type_code and (:$flex$.operating_unit is null or xxen_util.contains(:$flex$.operating_unit,haouv.name) = 'Y') and (:$flex$.project_number is null or xxen_util.contains(:$flex$.project_number,ppa.segment1) = 'Y') and (:$flex$.project_name is null or xxen_util.contains(:$flex$.project_name,ppa.name) = 'Y') and (:$flex$.project_number is not null or :$flex$.project_name is not null) and xxen_util.contains(:$flex$.budget_type,pbt.budget_type) = 'Y' and :$flex$.copy_existing_budget = xxen_util.meaning('Y','YES_NO',0) order by ppa.segment1, pbt.budget_type, pbv.budget_status_code desc, pbv.version_number desc US Budget Version 9 90 1=1 pt.task_number=:p_task_number LOV custom Y select distinct pt.task_number value, pt.task_name description from pa_tasks pt where pt.task_id in (select pra.task_id from hr_all_organization_units_vl haouv, pa_projects_all ppa, pa_budget_versions pbv, pa_budget_types pbt, pa_resource_assignments pra where haouv.organization_id = ppa.org_id and ppa.project_id = pbv.project_id and pbv.budget_type_code is not null and (pbv.budget_status_code in ('S','W') or :$flex$.copy_existing_budget = xxen_util.meaning('Y','YES_NO',0)) and pbv.budget_type_code = pbt.budget_type_code and pbv.project_id = pra.project_id and pbv.budget_version_id = pra.budget_version_id and (:$flex$.operating_unit is null or xxen_util.contains(:$flex$.operating_unit,haouv.name) = 'Y') and (:$flex$.project_number is null or xxen_util.contains(:$flex$.project_number,ppa.segment1) = 'Y') and (:$flex$.project_name is null or xxen_util.contains(:$flex$.project_name,ppa.name) = 'Y') and (:$flex$.project_number is not null or :$flex$.project_name is not null) and (:$flex$.budget_type is null or xxen_util.contains(:$flex$.budget_type,pbt.budget_type) = 'Y') and (:$flex$.budget_version is null or decode(pbv.budget_status_code,'B',to_char(pbv.version_number),xxen_util.meaning(pbv.budget_status_code,'BUDGET STATUS',275)) = :$flex$.budget_version ) ) and (:$flex$.upload_mode = xxen_upload.action_update or :$flex$.copy_existing_budget = xxen_util.meaning('Y','YES_NO',0)) US Task Number 10 100 1=1 pt.task_name=:p_task_name LOV custom Y select distinct pt.task_name value, pt.task_number description from pa_tasks pt where (:$flex$.task_number is null or xxen_util.contains(:$flex$.task_number,pt.task_number) = 'Y') and pt.task_id in (select pra.task_id from hr_all_organization_units_vl haouv, pa_projects_all ppa, pa_budget_versions pbv, pa_budget_types pbt, pa_resource_assignments pra where haouv.organization_id = ppa.org_id and ppa.project_id = pbv.project_id and pbv.budget_type_code is not null and (pbv.budget_status_code in ('S','W') or :$flex$.copy_existing_budget = xxen_util.meaning('Y','YES_NO',0)) and pbv.budget_type_code = pbt.budget_type_code and pbv.project_id = pra.project_id and pbv.budget_version_id = pra.budget_version_id and (:$flex$.operating_unit is null or xxen_util.contains(:$flex$.operating_unit,haouv.name) = 'Y') and (:$flex$.project_number is null or xxen_util.contains(:$flex$.project_number,ppa.segment1) = 'Y') and (:$flex$.project_name is null or xxen_util.contains(:$flex$.project_name,ppa.name) = 'Y') and (:$flex$.project_number is not null or :$flex$.project_name is not null) and (:$flex$.budget_type is null or xxen_util.contains(:$flex$.budget_type,pbt.budget_type) = 'Y') and (:$flex$.budget_version is null or decode(pbv.budget_status_code,'B',to_char(pbv.version_number),xxen_util.meaning(pbv.budget_status_code,'BUDGET STATUS',275)) = :$flex$.budget_version ) ) and (:$flex$.upload_mode = xxen_upload.action_update or :$flex$.copy_existing_budget = xxen_util.meaning('Y','YES_NO',0)) US Task Name 11 110 1=1 prlm.alias=:p_resource_alias LOV custom Y select distinct prlm.alias value, substr(pa_resources_pkg.get_resource_name(prlm.resource_id, prlm.resource_type_id),1,30) description from pa_resource_list_members prlm where prlm.resource_list_member_id in (select pra.resource_list_member_id from hr_all_organization_units_vl haouv, pa_projects_all ppa, pa_budget_versions pbv, pa_budget_types pbt, pa_resource_assignments pra where haouv.organization_id = ppa.org_id and ppa.project_id = pbv.project_id and pbv.budget_type_code is not null and (pbv.budget_status_code in ('S','W') or :$flex$.copy_existing_budget = xxen_util.meaning('Y','YES_NO',0)) and pbv.budget_type_code = pbt.budget_type_code and pbv.project_id = pra.project_id and pbv.budget_version_id = pra.budget_version_id and (:$flex$.operating_unit is null or xxen_util.contains(:$flex$.operating_unit,haouv.name) = 'Y') and (:$flex$.project_number is null or xxen_util.contains(:$flex$.project_number,ppa.segment1) = 'Y') and (:$flex$.project_name is null or xxen_util.contains(:$flex$.project_name,ppa.name) = 'Y') and (:$flex$.project_number is not null or :$flex$.project_name is not null) and (:$flex$.budget_type is null or xxen_util.contains(:$flex$.budget_type,pbt.budget_type) = 'Y') and (:$flex$.budget_version is null or decode(pbv.budget_status_code,'B',to_char(pbv.version_number),xxen_util.meaning(pbv.budget_status_code,'BUDGET STATUS',275)) = :$flex$.budget_version ) ) and (:$flex$.upload_mode = xxen_upload.action_update or :$flex$.copy_existing_budget = xxen_util.meaning('Y','YES_NO',0)) US Resource Alias 12 120 1=1 pbl.period_name is not null and pbl.start_date >= (select min(pbpv.period_start_date) from pa_budget_periods_v2 pbpv where pbpv.org_id = ppa.org_id and pbpv.period_name = :p_period_from ) LOV custom Y select pbpv.period_name value, trunc(pbpv.period_start_date) || ' - ' || trunc(pbpv.period_end_date) || ' (' || xxen_util.meaning(pbpv.period_type_code,'BUDGET TIME PHASED TYPE',275) || ')' description from pa_budget_periods_v2 pbpv where (:$flex$.project_number is not null or :$flex$.project_name is not null) and (pbpv.org_id,pbpv.period_name) in (select ppa.org_id,pbl.period_name from hr_all_organization_units_vl haouv, pa_projects_all ppa, pa_budget_versions pbv, pa_budget_types pbt, pa_budget_lines pbl where haouv.organization_id = ppa.org_id and ppa.project_id = pbv.project_id and pbv.budget_type_code is not null and (pbv.budget_status_code in ('S','W') or :$flex$.copy_existing_budget = xxen_util.meaning('Y','YES_NO',0)) and pbv.budget_type_code = pbt.budget_type_code and pbv.budget_version_id = pbl.budget_version_id and (:$flex$.operating_unit is null or xxen_util.contains(:$flex$.operating_unit,haouv.name) = 'Y') and (:$flex$.project_number is null or xxen_util.contains(:$flex$.project_number,ppa.segment1) = 'Y') and (:$flex$.project_name is null or xxen_util.contains(:$flex$.project_name,ppa.name) = 'Y') and (:$flex$.project_number is not null or :$flex$.project_name is not null) and (:$flex$.budget_type is null or xxen_util.contains(:$flex$.budget_type,pbt.budget_type) = 'Y') and (:$flex$.budget_version is null or decode(pbv.budget_status_code,'B',to_char(pbv.version_number),xxen_util.meaning(pbv.budget_status_code,'BUDGET STATUS',275)) = :$flex$.budget_version ) ) and (:$flex$.upload_mode = xxen_upload.action_update or :$flex$.copy_existing_budget = xxen_util.meaning('Y','YES_NO',0)) order by trunc(pbpv.period_start_date), pbpv.period_type_code US Period From 13 130 1=1 pbl.period_name is not null and pbl.end_date <= (select max(pbpv.period_end_date) from pa_budget_periods_v2 pbpv where pbpv.org_id = ppa.org_id and pbpv.period_name = :p_period_to ) LOV custom Y select pbpv.period_name value, trunc(pbpv.period_start_date) || ' - ' || trunc(pbpv.period_end_date) || ' (' || xxen_util.meaning(pbpv.period_type_code,'BUDGET TIME PHASED TYPE',275) || ')' description from pa_budget_periods_v2 pbpv where (:$flex$.project_number is not null or :$flex$.project_name is not null) and (pbpv.org_id,pbpv.period_name) in (select ppa.org_id,pbl.period_name from hr_all_organization_units_vl haouv, pa_projects_all ppa, pa_budget_versions pbv, pa_budget_types pbt, pa_budget_lines pbl where haouv.organization_id = ppa.org_id and ppa.project_id = pbv.project_id and pbv.budget_type_code is not null and (pbv.budget_status_code in ('S','W') or :$flex$.copy_existing_budget = xxen_util.meaning('Y','YES_NO',0)) and pbv.budget_type_code = pbt.budget_type_code and pbv.budget_version_id = pbl.budget_version_id and (:$flex$.operating_unit is null or xxen_util.contains(:$flex$.operating_unit,haouv.name) = 'Y') and (:$flex$.project_number is null or xxen_util.contains(:$flex$.project_number,ppa.segment1) = 'Y') and (:$flex$.project_name is null or xxen_util.contains(:$flex$.project_name,ppa.name) = 'Y') and (:$flex$.project_number is not null or :$flex$.project_name is not null) and (:$flex$.budget_type is null or xxen_util.contains(:$flex$.budget_type,pbt.budget_type) = 'Y') and (:$flex$.budget_version is null or decode(pbv.budget_status_code,'B',to_char(pbv.version_number),xxen_util.meaning(pbv.budget_status_code,'BUDGET STATUS',275)) = :$flex$.budget_version ) ) and (:$flex$.upload_mode = xxen_upload.action_update or :$flex$.copy_existing_budget = xxen_util.meaning('Y','YES_NO',0)) order by trunc(pbpv.period_start_date), pbpv.period_type_code :$flex$.period_from US Period To 14 140 1=1 pbl.start_date=:p_date_start Date US Budget Line Start Date 15 150 1=1 pbl.end_date=:p_date_end Date US Budget Line End Date 16 160 1=1 trunc(:p_date_active) between pbl.start_date and pbl.end_date Date US Budget Line Active On Date 17 170 &lp_sort_col1 nvl(x.start_date,(select pbpv.period_start_date from hr_all_organization_units_vl haouv, pa_budget_periods_v2 pbpv where haouv.organization_id = pbpv.org_id and haouv.name = x.operating_unit and pbpv.period_name = x.period_name and rownum <= 1)), LOV custom Y select x.value, null description from (select 'Date' value from dual union all select 'Resource Alias' value from dual union all select 'Task Number' value from dual union all select 'Task Name' value from dual ) x order by value Date Task Number Y US Sort Precedence 1 18 &lp_sort_col1 x.resource_alias, Resource Alias US Sort Precedence 1 19 &lp_sort_col1 x.task_name, Task Name US Sort Precedence 1 20 &lp_sort_col1 x.task_number, Task Number US Sort Precedence 1 21 180 &lp_sort_col2 nvl(x.start_date,(select pbpv.period_start_date from hr_all_organization_units_vl haouv, pa_budget_periods_v2 pbpv where haouv.organization_id = pbpv.org_id and haouv.name = x.operating_unit and pbpv.period_name = x.period_name and rownum <= 1)), LOV custom Y select x.value, null description from (select 'Date' value from dual union all select 'Resource Alias' value from dual union all select 'Task Number' value from dual union all select 'Task Name' value from dual ) x order by value Date Date Y US Sort Precedence 2 22 &lp_sort_col2 x.resource_alias, Resource Alias US Sort Precedence 2 23 &lp_sort_col2 x.task_name, Task Name US Sort Precedence 2 24 &lp_sort_col2 x.task_number, Task Number US Sort Precedence 2 25 190 &lp_sort_col3 nvl(x.start_date,(select pbpv.period_start_date from hr_all_organization_units_vl haouv, pa_budget_periods_v2 pbpv where haouv.organization_id = pbpv.org_id and haouv.name = x.operating_unit and pbpv.period_name = x.period_name and rownum <= 1)), LOV custom Y select x.value, null description from (select 'Date' value from dual union all select 'Resource Alias' value from dual union all select 'Task Number' value from dual union all select 'Task Name' value from dual ) x order by value Date Resource Alias Y US Sort Precedence 3 26 &lp_sort_col3 x.resource_alias, Resource Alias US Sort Precedence 3 27 &lp_sort_col3 x.task_name, Task Name US Sort Precedence 3 28 &lp_sort_col3 x.task_number, Task Number US Sort Precedence 3 :$flex$.budget_type Budget Type Budget Version :$flex$.budget_type Budget Type Period From :$flex$.budget_type Budget Type Period To :$flex$.budget_type Budget Type Resource Alias :$flex$.budget_type Budget Type Task Name :$flex$.budget_type Budget Type Task Number :$flex$.budget_version Budget Version Period From :$flex$.budget_version Budget Version Period To :$flex$.budget_version Budget Version Resource Alias :$flex$.budget_version Budget Version Task Name :$flex$.budget_version Budget Version Task Number :$flex$.copy_existing_budget Copy Existing Budget Budget Type :$flex$.copy_existing_budget Copy Existing Budget Budget Version :$flex$.copy_existing_budget Copy Existing Budget Period From :$flex$.copy_existing_budget Copy Existing Budget Period To :$flex$.copy_existing_budget Copy Existing Budget Project Name :$flex$.copy_existing_budget Copy Existing Budget Project Number :$flex$.copy_existing_budget Copy Existing Budget Resource Alias :$flex$.copy_existing_budget Copy Existing Budget Task Name :$flex$.copy_existing_budget Copy Existing Budget Task Number :$flex$.operating_unit Operating Unit Budget Type :$flex$.operating_unit Operating Unit Budget Version :$flex$.operating_unit Operating Unit Period From :$flex$.operating_unit Operating Unit Period To :$flex$.operating_unit Operating Unit Project Name :$flex$.operating_unit Operating Unit Project Number :$flex$.operating_unit Operating Unit Resource Alias :$flex$.operating_unit Operating Unit Task Name :$flex$.operating_unit Operating Unit Task Number :$flex$.period_from Period From Period To :$flex$.project_name Project Name Budget Type :$flex$.project_name Project Name Budget Version :$flex$.project_name Project Name Period From :$flex$.project_name Project Name Period To :$flex$.project_name Project Name Resource Alias :$flex$.project_name Project Name Task Name :$flex$.project_name Project Name Task Number :$flex$.project_number Project Number Budget Type :$flex$.project_number Project Number Budget Version :$flex$.project_number Project Number Period From :$flex$.project_number Project Number Period To :$flex$.project_number Project Number Project Name :$flex$.project_number Project Number Resource Alias :$flex$.project_number Project Number Task Name :$flex$.project_number Project Number Task Number :$flex$.task_number Task Number Task Name :$flex$.upload_mode Upload Mode Budget Type :$flex$.upload_mode Upload Mode Copy Existing Budget :$flex$.upload_mode Upload Mode Period From :$flex$.upload_mode Upload Mode Period To :$flex$.upload_mode Upload Mode Project Name :$flex$.upload_mode Upload Mode Project Number :$flex$.upload_mode Upload Mode Resource Alias :$flex$.upload_mode Upload Mode Task Name :$flex$.upload_mode Upload Mode Task Number Default SYSADMIN 9 BASELINE_BUDGET 25 BUDGET_ATTRIBUTE1 34 BUDGET_ATTRIBUTE10 35 BUDGET_ATTRIBUTE11 36 BUDGET_ATTRIBUTE12 37 BUDGET_ATTRIBUTE13 38 BUDGET_ATTRIBUTE14 39 BUDGET_ATTRIBUTE15 26 BUDGET_ATTRIBUTE2 27 BUDGET_ATTRIBUTE3 28 BUDGET_ATTRIBUTE4 29 BUDGET_ATTRIBUTE5 30 BUDGET_ATTRIBUTE6 31 BUDGET_ATTRIBUTE7 32 BUDGET_ATTRIBUTE8 33 BUDGET_ATTRIBUTE9 24 BUDGET_ATTRIBUTE_CATEGORY 4 BUDGET_TYPE 18 BURDENED_COST 10 CHANGE_REASON 23 DELETE_THIS_LINE 6 DESCRIPTION 15 END_DATE 7 ENTRY_METHOD 41 LINE_ATTRIBUTE1 50 LINE_ATTRIBUTE10 51 LINE_ATTRIBUTE11 52 LINE_ATTRIBUTE12 53 LINE_ATTRIBUTE13 54 LINE_ATTRIBUTE14 55 LINE_ATTRIBUTE15 42 LINE_ATTRIBUTE2 43 LINE_ATTRIBUTE3 44 LINE_ATTRIBUTE4 45 LINE_ATTRIBUTE5 46 LINE_ATTRIBUTE6 47 LINE_ATTRIBUTE7 48 LINE_ATTRIBUTE8 49 LINE_ATTRIBUTE9 40 LINE_ATTRIBUTE_CATEGORY 22 LINE_DESCRIPTION 1 OPERATING_UNIT 13 PERIOD_NAME 3 PROJECT_NAME 2 PROJECT_NUMBER 20 QUANTITY 17 RAW_COST 16 RESOURCE_ALIAS 8 RESOURCE_LIST 19 REVENUE 14 START_DATE 12 TASK_NAME 11 TASK_NUMBER 21 UNIT_OF_MEASURE 5 VERSION_NAME S Site Default 1 ACTION_ Char varchar2 2 STATUS_ Char varchar2 3 MESSAGE_ Char varchar2 4 BASELINE_MESSAGE_ Char varchar2 Y 5 REQUEST_ID_ Char varchar2 Y 6 MODIFIED_COLUMNS_ Char varchar2 Y 7 UPLOAD_MODE_ Char varchar2 :$flex$.upload_mode Y 8 BUDGET_LINE_ID Number number Y 9 PRODUCT_SOURCE LOV custom varchar2 Y select pl.meaning value, pl.description from pa_lookups pl where pl.lookup_type = 'PM_PRODUCT_CODE' and pl.meaning = :$flex$.product_source order by value select pl.lookup_code id, pl.meaning value from pa_lookups pl where pl.lookup_type = 'PM_PRODUCT_CODE' :$flex$.product_source Y Y 10 OPERATING_UNIT LOV custom varchar2 Y select hou.name value, null description from hr_operating_units hou where 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) and hou.name = nvl(:$flex$.operating_unit,hou.name) order by hou.name :$flex$.operating_unit Y Y 11 PROJECT_NUMBER LOV custom varchar2 Y select ppa.segment1 value, ppa.name description from hr_all_organization_units_vl haouv, pa_projects_all ppa, pa_project_types_all pt where haouv.organization_id = ppa.org_id and ppa.project_type = pt.project_type and ppa.org_id = pt.org_id and (pt.allow_cost_budget_entry_flag = 'Y' or pt.allow_rev_budget_entry_flag = 'Y' ) and haouv.name = :$column$.operating_unit order by value Y Y 12 PROJECT_NAME LOV custom varchar2 Y select ppa.name value, ppa.segment1 description from hr_all_organization_units_vl haouv, pa_projects_all ppa where haouv.organization_id = ppa.org_id and haouv.name = :$column$.operating_unit and ppa.segment1 = :$column$.project_number order by value select ppa.name from hr_all_organization_units_vl haouv, pa_projects_all ppa where haouv.organization_id = ppa.org_id and haouv.name = :$column$.operating_unit and ppa.segment1 = :$column$.project_number Y 13 BUDGET_TYPE LOV custom varchar2 Y select x.budget_type value, x.description from ( select pbt.budget_type, pbt.description from hr_all_organization_units_vl haouv, pa_projects_all ppa, pa_project_types_all ppta, pa_budget_types pbt where haouv.organization_id = ppa.org_id and ppa.project_type = ppta.project_type and nvl(ppa.org_id ,-99)= NVL(ppta.org_id, -99) and ((ppta.allow_cost_budget_entry_flag = 'Y') or (ppta.allow_rev_budget_entry_flag = 'Y')) and nvl(pbt.plan_type, 'BUDGET') = 'BUDGET' and trunc(sysdate) between trunc(pbt.start_date_active) and trunc(nvl(pbt.end_date_active,sysdate)) and haouv.name = :$column$.operating_unit and ppa.segment1 = :$column$.project_number union select pbt.budget_type, pbt.description from hr_all_organization_units_vl haouv, pa_projects_all ppa, pa_budget_versions pbv, pa_budget_types pbt where haouv.organization_id = ppa.org_id and ppa.project_id = pbv.project_id and pbv.budget_status_code = 'B' and pbv.budget_type_code = pbt.budget_type_code and nvl(pbt.plan_type, 'BUDGET') = 'BUDGET' and not trunc(sysdate) between trunc(pbt.start_date_active) and trunc(nvl(pbt.end_date_active,sysdate)) and haouv.name = :$column$.operating_unit and ppa.segment1 = :$column$.project_number ) x order by value select pbt.budget_type_code id, pbt.budget_type value from pa_budget_types pbt where nvl(pbt.plan_type, 'BUDGET') = 'BUDGET' Y 14 VERSION_NAME Char varchar2 15 DESCRIPTION Char varchar2 16 ENTRY_METHOD LOV custom varchar2 Y select pbem.budget_entry_method value, pbem.description from (select ppa.project_id, pbt.budget_type_code, pbt.budget_amount_code, pbco.balance_type g_balance_type, case when pbco.budget_type_code is null then 'N' else 'Y' end g_fck_req_flag, case when pbco.budget_type_code is null then 'N' when nvl(pbco.balance_type,'X') = 'B' then 'G' else decode(nvl(pbco.external_budget_code,'X'),'GL','G','CC','C','N') end g_bgt_intg_flag from pa_projects_all ppa, pa_budget_types pbt, pa_budgetary_control_options pbco where ppa.segment1 = :$column$.project_number and pbt.budget_type = :$column$.budget_type and decode(nvl(fnd_profile.value('PA_BC_ENABLED'),'N'),'Y',ppa.project_id,-1) = pbco.project_id (+) and nvl(pbco.budget_type_code,pbt.budget_type_code) = pbt.budget_type_code ) pbco, pa_budget_entry_methods pbem where trunc(sysdate) between trunc(pbem.start_date_active) and trunc(nvl(pbem.end_date_active, sysdate)) and pbem.budget_entry_method_code NOT IN ('PA_FORECASTING_BY_PA_PERIOD' ,'PA_FORECASTING_BY_GL_PERIOD') and ( ( pbco.budget_amount_code = 'R' and ( (pbem.rev_quantity_flag = 'Y') or (pbem.revenue_flag = 'Y')) and ( (pbco.g_fck_req_flag = 'N' and pbco.g_bgt_intg_flag = 'N') or (pbco.g_balance_type = 'E' and (pbem.revenue_flag = 'Y') and pbem.time_phased_type_code = 'G' ) or (pbco.g_balance_type = 'B' and (pbem.raw_cost_flag = 'Y' or pbem.burdened_cost_flag = 'Y' or pbem.revenue_flag = 'Y' ) and pbem.time_phased_type_code = 'G' ) or (pbco.g_balance_type is null and pbco.g_fck_req_flag = 'Y' and (pbem.revenue_flag = 'Y') and pbem.time_phased_type_code in ('G','P','N')) ) ) or ( pbco.budget_amount_code = 'C' and ( (pbem.cost_quantity_flag = 'Y') or (pbem.raw_cost_flag = 'Y') or (pbem.burdened_cost_flag = 'Y')) and ( (pbco.g_fck_req_flag = 'N' and pbco.g_bgt_intg_flag = 'N') or (pbco.g_balance_type = 'E' and (pbem.raw_cost_flag = 'Y' or pbem.burdened_cost_flag = 'Y') and pbem.time_phased_type_code = 'G') or (pbco.g_balance_type = 'B' and (pbem.raw_cost_flag = 'Y' or pbem.burdened_cost_flag = 'Y' or pbem.revenue_flag = 'Y' ) and pbem.time_phased_type_code = 'G') or (pbco.g_balance_type is null and pbco.g_fck_req_flag = 'Y' and (pbem.raw_cost_flag = 'Y' or pbem.burdened_cost_flag = 'Y' ) and pbem.time_phased_type_code in ('G','P','N')) ) ) ) and -- pbem.categorization_code = nvl((select pbem2.categorization_code from pa_budget_versions pbv2, pa_budget_entry_methods pbem2 where pbv2.budget_entry_method_code = pbem2.budget_entry_method_code and pbv2.project_id = pbco.project_id and pbv2.budget_type_code = pbco.budget_type_code and pbv2.current_flag='Y' and pbv2.budget_status_code = 'B' and rownum = 1 ), pbem.categorization_code ) order by value select pbem.budget_entry_method_code id, pbem.budget_entry_method value from pa_budget_entry_methods pbem select pbem.budget_entry_method from pa_budget_entry_methods pbem where trunc(sysdate) between trunc(pbem.start_date_active) and trunc(nvl(pbem.end_date_active, sysdate)) and pbem.budget_entry_method_code NOT IN ('PA_FORECASTING_BY_PA_PERIOD' ,'PA_FORECASTING_BY_GL_PERIOD') and pbem.budget_entry_method_code = nvl( (select pbv.budget_entry_method_code from hr_all_organization_units_vl haouv, pa_projects_all ppa, pa_budget_versions pbv, pa_budget_types pbt where haouv.name = :$column$.operating_unit and ppa.segment1 = :$column$.project_number and pbt.budget_type = :$column$.budget_type and haouv.organization_id = ppa.org_id and ppa.project_id = pbv.project_id and pbv.budget_status_code = 'B' and pbv.version_number = (select max(pbv2.version_number) from pa_budget_versions pbv2 where pbv2.project_id = pbv.project_id and pbv2.budget_type_code = pbv.budget_type_code and pbv2.budget_status_code = 'B' ) and pbv.budget_type_code = pbt.budget_type_code ), (select decode(pbt.budget_amount_code,'C',ppta.cost_budget_entry_method_code,'R',ppta.rev_budget_entry_method_code,null) from hr_all_organization_units_vl haouv, pa_projects_all ppa, pa_project_types_all ppta, pa_budget_types pbt where haouv.name = :$column$.operating_unit and ppa.segment1 = :$column$.project_number and pbt.budget_type = :$column$.budget_type and ppa.project_type = ppta.project_type and nvl(ppa.org_id,-99) = nvl(ppta.org_id,-99) ) ) Y 17 RESOURCE_LIST LOV custom varchar2 Y select x.value, x.description from ( select prlav.resource_list_name value, null description from pa_budget_entry_methods pbem, pa_resource_lists_active_v prlav where pbem.budget_entry_method = :$column$.entry_method and pbem.categorization_code = 'R' and nvl(prlav.resource_list_type, 'U') = 'U' and nvl(prlav.migration_code,'-99') <> 'N' union select prl.name value, null description from pa_budget_entry_methods pbem, hr_all_organization_units_vl haouv, pa_resource_lists prl where pbem.budget_entry_method = :$column$.entry_method and pbem.categorization_code = 'N' and haouv.name = :$column$.operating_unit and prl.business_group_id = haouv.business_group_id and prl.uncategorized_flag = 'Y' and trunc(sysdate) between trunc(nvl(prl.start_date_active,sysdate)) and trunc(nvl(prl.end_date_active,sysdate)) ) x order by x.value select prlav.resource_list_name from pa_resource_lists_active_v prlav where prlav.resource_list_id = nvl( (select pbv.resource_list_id from hr_all_organization_units_vl haouv, pa_projects_all ppa, pa_budget_versions pbv, pa_budget_types pbt where haouv.name = :$column$.operating_unit and ppa.segment1 = :$column$.project_number and pbt.budget_type = :$column$.budget_type and haouv.organization_id = ppa.org_id and ppa.project_id = pbv.project_id and pbv.budget_status_code = 'B' and pbv.version_number = (select max(pbv2.version_number) from pa_budget_versions pbv2 where pbv2.project_id = pbv.project_id and pbv2.budget_type_code = pbv.budget_type_code and pbv2.budget_status_code = 'B' ) and pbv.budget_type_code = pbt.budget_type_code ), (select decode(pbt.budget_amount_code,'C',ppta.cost_budget_resource_list_id,'R',ppta.rev_budget_resource_list_id,null) from hr_all_organization_units_vl haouv, pa_projects_all ppa, pa_project_types_all ppta, pa_budget_types pbt where haouv.name = :$column$.operating_unit and ppa.segment1 = :$column$.project_number and pbt.budget_type = :$column$.budget_type and ppa.project_type = ppta.project_type and nvl(ppa.org_id,-99) = nvl(ppta.org_id,-99) ) ) Y 18 BASELINE_BUDGET LOV varchar2 Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual select fl.lookup_code id, fl.meaning value from fnd_lookups fl where fl.lookup_type = 'YES_NO' 19 CHANGE_REASON LOV custom varchar2 Y select pl.meaning value, pl.description from pa_lookups pl where pl.lookup_type = 'BUDGET CHANGE REASON' order by value select pl.lookup_code id, pl.meaning value from pa_lookups pl where pl.lookup_type = 'BUDGET CHANGE REASON' 20 TASK_NUMBER LOV custom varchar2 Y select pt.task_number value, pt.task_name description from pa_tasks pt, pa_projects_all ppa, hr_all_organization_units_vl haouv where haouv.organization_id = ppa.org_id and pt.project_id = ppa.project_id and haouv.name = :$column$.operating_unit and ppa.segment1 = :$column$.project_number and exists (select null from pa_budget_entry_methods pbem where pbem.budget_entry_method = :$column$.entry_method and ( pbem.entry_level_code = 'M' or (pbem.entry_level_code = 'T' and pt.parent_task_id is null) or (pbem.entry_level_code = 'L' and not exists (select null from pa_tasks pt2 where pt2.parent_task_id = pt.task_id)) ) ) order by value Y 21 TASK_NAME LOV custom varchar2 Y select pt.task_name value, pt.task_number description from pa_tasks pt, pa_projects_all ppa, hr_all_organization_units_vl haouv where haouv.organization_id = ppa.org_id and pt.project_id = ppa.project_id and haouv.name = :$column$.operating_unit and ppa.segment1 = :$column$.project_number and pt.task_number = :$column$.task_number order by value select pt.task_name from pa_tasks pt, pa_projects_all ppa, hr_all_organization_units_vl haouv where haouv.organization_id = ppa.org_id and pt.project_id = ppa.project_id and haouv.name = :$column$.operating_unit and ppa.segment1 = :$column$.project_number and pt.task_number = :$column$.task_number Y 22 PERIOD_NAME LOV custom varchar2 Y select pbpv.period_name value, trunc(pbpv.period_start_date) || ' - ' || trunc(pbpv.period_end_date) description from hr_all_organization_units_vl haouv, pa_projects_all ppa, pa_tasks pt, pa_budget_entry_methods pbem, pa_budget_periods_v2 pbpv where haouv.name = :$column$.operating_unit and haouv.organization_id = ppa.org_id and ppa.segment1 = :$column$.project_number and ppa.project_id = pt.project_id (+) and pt.task_number (+) = :$column$.task_number and pbem.budget_entry_method = :$column$.entry_method and ppa.org_id = pbpv.org_id and pbem.time_phased_type_code = pbpv.period_type_code and trunc(coalesce(pt.start_date,ppa.start_date,pbpv.period_start_date)) <= pbpv.period_end_date and trunc(coalesce(pt.completion_date,ppa.completion_date,pbpv.period_end_date)) >= pbpv.period_start_date order by trunc(pbpv.period_start_date) Y 23 START_DATE Date date Y 24 END_DATE Date date 25 RESOURCE_ALIAS LOV custom varchar2 Y select x.value, x.description from ( select substr(sys_connect_by_path (prlm.alias,'|'),2) value, substr(pa_resources_pkg.get_resource_name(prlm.resource_id, prlm.resource_type_id),1,30) description from pa_resource_list_members prlm where prlm.display_flag = 'Y' and prlm.enabled_flag = 'Y' and nvl(prlm.migration_code, '-99') <> 'N' connect by prior prlm.resource_list_member_id = prlm.parent_member_id and prior prlm.resource_list_id = prlm.resource_list_id start with prlm.resource_list_id = (select prlav.resource_list_id from pa_resource_lists_active_v prlav where prlav.resource_list_name = :$column$.resource_list and nvl(prlav.resource_list_type, 'U') = 'U' and nvl(prlav.migration_code,'-99') <> 'N' ) and prlm.parent_member_id is null union select prlm.alias value, substr(pa_resources_pkg.get_resource_name(prlm.resource_id, prlm.resource_type_id),1,30) description from hr_all_organization_units_vl haouv, pa_resource_lists prl, pa_resource_list_members prlm where haouv.name = :$column$.operating_unit and haouv.business_group_id = prl.business_group_id and prl.resource_list_id = prlm.resource_list_id and prl.name = :$column$.resource_list and prl.uncategorized_flag = 'Y' and trunc(sysdate) between trunc(nvl(prl.start_date_active,sysdate)) and trunc(nvl(prl.end_date_active,sysdate)) and prlm.resource_type_code = 'UNCATEGORIZED' and prlm.enabled_flag = 'Y' ) x order by value Y Y 26 RAW_COST Number number 27 BURDENED_COST Number number 28 REVENUE Number number 29 QUANTITY Number number 30 UNIT_OF_MEASURE LOV custom varchar2 Y select xxen_util.meaning(pr.unit_of_measure,'UNIT',275) value, pr.unit_of_measure description from pa_resources pr where pr.resource_id = (select prlm2.resource_id from (select substr(sys_connect_by_path (prlm.alias,'|'),2) resource_alias_path, prlm.resource_id from pa_resource_list_members prlm where prlm.display_flag = 'Y' and prlm.enabled_flag = 'Y' and nvl(prlm.migration_code, '-99') <> 'N' connect by prior prlm.resource_list_member_id = prlm.parent_member_id and prior prlm.resource_list_id = prlm.resource_list_id start with prlm.resource_list_id = (select prlav.resource_list_id from pa_resource_lists_active_v prlav where prlav.resource_list_name = :$column$.resource_list and nvl(prlav.resource_list_type, 'U') = 'U' and nvl(prlav.migration_code,'-99') <> 'N' ) and prlm.parent_member_id is null ) prlm2 where prlm2.resource_alias_path = :$column$.resource_alias ) select xxen_util.meaning(pr.unit_of_measure,'UNIT',275) from pa_resources pr where pr.resource_id = (select prlm2.resource_id from (select substr(sys_connect_by_path (prlm.alias,'|'),2) resource_alias_path, prlm.resource_id from pa_resource_list_members prlm where prlm.display_flag = 'Y' and prlm.enabled_flag = 'Y' and nvl(prlm.migration_code, '-99') <> 'N' connect by prior prlm.resource_list_member_id = prlm.parent_member_id and prior prlm.resource_list_id = prlm.resource_list_id start with prlm.resource_list_id = (select prlav.resource_list_id from pa_resource_lists_active_v prlav where prlav.resource_list_name = :$column$.resource_list and nvl(prlav.resource_list_type, 'U') = 'U' and nvl(prlav.migration_code,'-99') <> 'N' ) and prlm.parent_member_id is null ) prlm2 where prlm2.resource_alias_path = :$column$.resource_alias ) Y 31 LINE_DESCRIPTION Char varchar2 32 DELETE_THIS_LINE LOV custom varchar2 Y select xxen_util.meaning('Y','YES_NO',0) value, null description from dual where :$flex$.upload_mode = xxen_upload.action_meaning(xxen_upload.action_update) select fl.lookup_code id, fl.meaning value from fnd_lookups fl where fl.lookup_type = 'YES_NO' 33 BUDGET_ATTRIBUTE_CATEGORY Char varchar2 34 BUDGET_ATTRIBUTE1 Char varchar2 35 BUDGET_ATTRIBUTE2 Char varchar2 36 BUDGET_ATTRIBUTE3 Char varchar2 37 BUDGET_ATTRIBUTE4 Char varchar2 38 BUDGET_ATTRIBUTE5 Char varchar2 39 BUDGET_ATTRIBUTE6 Char varchar2 40 BUDGET_ATTRIBUTE7 Char varchar2 41 BUDGET_ATTRIBUTE8 Char varchar2 42 BUDGET_ATTRIBUTE9 Char varchar2 43 BUDGET_ATTRIBUTE10 Char varchar2 44 BUDGET_ATTRIBUTE11 Char varchar2 45 BUDGET_ATTRIBUTE12 Char varchar2 46 BUDGET_ATTRIBUTE13 Char varchar2 47 BUDGET_ATTRIBUTE14 Char varchar2 48 BUDGET_ATTRIBUTE15 Char varchar2 49 LINE_ATTRIBUTE_CATEGORY Char varchar2 50 LINE_ATTRIBUTE1 Char varchar2 51 LINE_ATTRIBUTE2 Char varchar2 52 LINE_ATTRIBUTE3 Char varchar2 53 LINE_ATTRIBUTE4 Char varchar2 54 LINE_ATTRIBUTE5 Char varchar2 55 LINE_ATTRIBUTE6 Char varchar2 56 LINE_ATTRIBUTE7 Char varchar2 57 LINE_ATTRIBUTE8 Char varchar2 58 LINE_ATTRIBUTE9 Char varchar2 59 LINE_ATTRIBUTE10 Char varchar2 60 LINE_ATTRIBUTE11 Char varchar2 61 LINE_ATTRIBUTE12 Char varchar2 62 LINE_ATTRIBUTE13 Char varchar2 63 LINE_ATTRIBUTE14 Char varchar2 64 LINE_ATTRIBUTE15 Char varchar2 65 MARK_AS_ORIGINAL LOV varchar2 Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual select fl.lookup_code id, fl.meaning value from fnd_lookups fl where fl.lookup_type = 'YES_NO' Y U 1 action_ in Char ACTION_CODE_ U 2 status_ out Char STATUS_CODE_ U 3 message_ out Char MESSAGE_ U 4 request_id_ out Number REQUEST_ID_ U 5 p_budget_line_id in/out Number BUDGET_LINE_ID U 6 p_upload_mode in Char UPLOAD_MODE_ U 7 p_pm_product_code in Char PRODUCT_SOURCE U 8 p_operating_unit in Char OPERATING_UNIT U 9 p_project_number in Char PROJECT_NUMBER U 10 p_task_number in Char TASK_NUMBER U 11 p_b_pm_budget_reference in Char Y U 12 p_b_budget_version_name in Char Y VERSION_NAME U 13 p_b_pa_project_id in Number Y U 14 p_b_pm_project_reference in Char Y U 15 p_b_budget_type_code in Char Y BUDGET_TYPE U 16 p_b_change_reason_code in Char Y CHANGE_REASON U 17 p_b_description in Char Y DESCRIPTION U 18 p_b_entry_method_code in Char Y ENTRY_METHOD U 19 p_b_resource_list_name in Char Y RESOURCE_LIST U 20 p_b_resource_list_id in Number Y U 21 p_b_attribute_category in Char Y BUDGET_ATTRIBUTE_CATEGORY U 22 p_b_attribute1 in Char Y BUDGET_ATTRIBUTE1 U 23 p_b_attribute2 in Char Y BUDGET_ATTRIBUTE2 U 24 p_b_attribute3 in Char Y BUDGET_ATTRIBUTE3 U 25 p_b_attribute4 in Char Y BUDGET_ATTRIBUTE4 U 26 p_b_attribute5 in Char Y BUDGET_ATTRIBUTE5 U 27 p_b_attribute6 in Char Y BUDGET_ATTRIBUTE6 U 28 p_b_attribute7 in Char Y BUDGET_ATTRIBUTE7 U 29 p_b_attribute8 in Char Y BUDGET_ATTRIBUTE8 U 30 p_b_attribute9 in Char Y BUDGET_ATTRIBUTE9 U 31 p_b_attribute10 in Char Y BUDGET_ATTRIBUTE10 U 32 p_b_attribute11 in Char Y BUDGET_ATTRIBUTE11 U 33 p_b_attribute12 in Char Y BUDGET_ATTRIBUTE12 U 34 p_b_attribute13 in Char Y BUDGET_ATTRIBUTE13 U 35 p_b_attribute14 in Char Y BUDGET_ATTRIBUTE14 U 36 p_b_attribute15 in Char Y BUDGET_ATTRIBUTE15 U 37 p_bl_delete_line_flag in Char Y DELETE_THIS_LINE U 38 p_bl_pa_task_id in Number Y U 39 p_bl_pm_task_reference in Char Y U 40 p_bl_resource_alias in Char Y RESOURCE_ALIAS U 41 p_bl_resource_list_member_id in Number Y U 42 p_bl_cost_code in Char Y U 43 p_bl_cbs_element_id in Number Y U 44 p_bl_budget_start_date in Date Y START_DATE U 45 p_bl_budget_end_date in Date Y END_DATE U 46 p_bl_period_name in Char Y PERIOD_NAME U 47 p_bl_description in Char Y LINE_DESCRIPTION U 48 p_bl_raw_cost in Number Y RAW_COST U 49 p_bl_burdened_cost in Number Y BURDENED_COST U 50 p_bl_revenue in Number Y REVENUE U 51 p_bl_quantity in Number Y QUANTITY U 52 p_bl_pm_budget_line_reference in Char Y U 53 p_bl_attribute_category in Char Y LINE_ATTRIBUTE_CATEGORY U 54 p_bl_attribute1 in Char Y LINE_ATTRIBUTE1 U 55 p_bl_attribute2 in Char Y LINE_ATTRIBUTE2 U 56 p_bl_attribute3 in Char Y LINE_ATTRIBUTE3 U 57 p_bl_attribute4 in Char Y LINE_ATTRIBUTE4 U 58 p_bl_attribute5 in Char Y LINE_ATTRIBUTE5 U 59 p_bl_attribute6 in Char Y LINE_ATTRIBUTE6 U 60 p_bl_attribute7 in Char Y LINE_ATTRIBUTE7 U 61 p_bl_attribute8 in Char Y LINE_ATTRIBUTE8 U 62 p_bl_attribute9 in Char Y LINE_ATTRIBUTE9 U 63 p_bl_attribute10 in Char Y LINE_ATTRIBUTE10 U 64 p_bl_attribute11 in Char Y LINE_ATTRIBUTE11 U 65 p_bl_attribute12 in Char Y LINE_ATTRIBUTE12 U 66 p_bl_attribute13 in Char Y LINE_ATTRIBUTE13 U 67 p_bl_attribute14 in Char Y LINE_ATTRIBUTE14 U 68 p_bl_attribute15 in Char Y LINE_ATTRIBUTE15 P 1 status_ out Char STATUS_CODE_ P 2 message_ out Char BASELINE_MESSAGE_ P 3 request_id_ out Number REQUEST_ID_ P 4 p_pm_product_code in Char PRODUCT_SOURCE P 5 p_operating_unit in Char OPERATING_UNIT P 6 p_project_number in Char PROJECT_NUMBER P 7 p_budget_type_code in Char BUDGET_TYPE P 8 p_baseline_budget in Char BASELINE_BUDGET P 9 p_mark_as_original in Char MARK_AS_ORIGINAL Lexical &not_use_first_block and 1=0 Lexical &processed_errors_query union all select xm.action_, xxen_upload.status_meaning(nvl(xm.status_code_,xxen_upload.status_error)) status_, xm.message_, xm.baseline_message_, xm.request_id_, xm.modified_columns_, xm.upload_mode_, xm.budget_line_id, -- -- Budget -- xm.product_source, xm.operating_unit, xm.project_number, xm.project_name, xm.budget_type, xm.version_name, --xm.version_number, --xm.status, xm.description, xm.entry_method, xm.resource_list, xm.baseline_budget, xm.change_reason, -- -- Budget line -- xm.task_number, xm.task_name, xm.period_name, xm.start_date, xm.end_date, xm.resource_alias, xm.raw_cost, xm.burdened_cost, xm.revenue, xm.quantity, xm.unit_of_measure, xm.line_description, --xm.line_change_reason, --xm.track_as_labor, xm.delete_this_line, -- -- DFF Columns xm.budget_attribute_category, xm.budget_attribute1, xm.budget_attribute2, xm.budget_attribute3, xm.budget_attribute4, xm.budget_attribute5, xm.budget_attribute6, xm.budget_attribute7, xm.budget_attribute8, xm.budget_attribute9, xm.budget_attribute10, xm.budget_attribute11, xm.budget_attribute12, xm.budget_attribute13, xm.budget_attribute14, xm.budget_attribute15, xm.line_attribute_category, xm.line_attribute1, xm.line_attribute2, xm.line_attribute3, xm.line_attribute4, xm.line_attribute5, xm.line_attribute6, xm.line_attribute7, xm.line_attribute8, xm.line_attribute9, xm.line_attribute10, xm.line_attribute11, xm.line_attribute12, xm.line_attribute13, xm.line_attribute14, xm.line_attribute15, -- xm.mark_as_original from &report_table_name xm where nvl(xm.status_code_,xxen_upload.status_error) != xxen_upload.status_success Lexical &processed_run and 'Y'='Y' Lexical &processed_success_query union all select xxen_upload.action_meaning(xxen_upload.action_update) action_, xxen_upload.status_meaning(xxen_upload.status_success) status_, case when xm.delete_this_line = xxen_util.meaning('Y','YES_NO',0) and pbl.budget_line_id is null then 'Budget Line Deleted' else nvl(xm.message_,xm.baseline_message_) end message_, null baseline_message_, xm.request_id_, xm.modified_columns_, xm.upload_mode_, xm.budget_line_id, -- -- Budget -- nvl(xxen_util.meaning(pbl.pm_product_code,'PM_PRODUCT_CODE',275),xm.product_source) product_source, nvl(haouv.name,xm.operating_unit) operating_unit, nvl(ppa.segment1,xm.project_number) project_number, nvl(ppa.name,xm.project_name) project_name, nvl(pbt.budget_type,xm.budget_type) budget_type, nvl(pbv.version_name,xm.version_name) version_name, --nvl(pbv.version_number,xm.version_number) version_number, --nvl(pbv.budget_status_m,xm.status) status, nvl(pbv.description,xm.description) description, nvl(pbem.budget_entry_method,xm.entry_method) entry_method, nvl(prl.name,xm.resource_list) resource_list, null baseline_budget, nvl(xxen_util.meaning(pbv.change_reason_code,'BUDGET CHANGE REASON',275),xm.change_reason) change_reason, -- -- Budget line -- nvl(pt.task_number,xm.task_number) task_number, nvl(pt.task_name,xm.task_name) task_name, nvl(pbl.period_name,xm.period_name) period_name, nvl(pbl.start_date,xm.start_date) start_date, nvl(pbl.end_date,xm.end_date) end_date, nvl(prlm.alias_path,xm.resource_alias) resource_alias, nvl(pbl.raw_cost,xm.raw_cost) raw_cost, nvl(pbl.burdened_cost,xm.burdened_cost) burdened_cost, nvl(pbl.revenue,xm.revenue) revenue, nvl(pbl.quantity,xm.quantity) quantity, nvl(xxen_util.meaning(pra.unit_of_measure,'UNIT',275),xm.unit_of_measure) unit_of_measure, nvl(pbl.description,xm.line_description) line_description, --nvl(xxen_util.meaning(pbl.change_reason_code,'BUDGET CHANGE REASON',275) line_change_reason, --nvl(xxen_util.meaning(pra.track_as_labor_flag,'YES_NO',0) track_as_labor, xm.delete_this_line, -- -- DFF Columns nvl(pbv.attribute_category,xm.budget_attribute_category) budget_attribute_category, nvl(pbv.attribute1,xm.budget_attribute1) budget_attribute1, nvl(pbv.attribute2,xm.budget_attribute2) budget_attribute2, nvl(pbv.attribute3,xm.budget_attribute3) budget_attribute3, nvl(pbv.attribute4,xm.budget_attribute4) budget_attribute4, nvl(pbv.attribute5,xm.budget_attribute5) budget_attribute5, nvl(pbv.attribute6,xm.budget_attribute6) budget_attribute6, nvl(pbv.attribute7,xm.budget_attribute7) budget_attribute7, nvl(pbv.attribute8,xm.budget_attribute8) budget_attribute8, nvl(pbv.attribute9,xm.budget_attribute9) budget_attribute9, nvl(pbv.attribute10,xm.budget_attribute10) budget_attribute10, nvl(pbv.attribute11,xm.budget_attribute11) budget_attribute11, nvl(pbv.attribute12,xm.budget_attribute12) budget_attribute12, nvl(pbv.attribute13,xm.budget_attribute13) budget_attribute13, nvl(pbv.attribute14,xm.budget_attribute14) budget_attribute14, nvl(pbv.attribute15,xm.budget_attribute15) budget_attribute15, nvl(pbl.attribute_category,xm.line_attribute_category) line_attribute_category, nvl(pbl.attribute1,xm.line_attribute1) line_attribute1, nvl(pbl.attribute2,xm.line_attribute2) line_attribute2, nvl(pbl.attribute3,xm.line_attribute3) line_attribute3, nvl(pbl.attribute4,xm.line_attribute4) line_attribute4, nvl(pbl.attribute5,xm.line_attribute5) line_attribute5, nvl(pbl.attribute6,xm.line_attribute6) line_attribute6, nvl(pbl.attribute7,xm.line_attribute7) line_attribute7, nvl(pbl.attribute8,xm.line_attribute8) line_attribute8, nvl(pbl.attribute9,xm.line_attribute9) line_attribute9, nvl(pbl.attribute10,xm.line_attribute10) line_attribute10, nvl(pbl.attribute11,xm.line_attribute11) line_attribute11, nvl(pbl.attribute12,xm.line_attribute12) line_attribute12, nvl(pbl.attribute13,xm.line_attribute13) line_attribute13, nvl(pbl.attribute14,xm.line_attribute14) line_attribute14, nvl(pbl.attribute15,xm.line_attribute15) line_attribute15, -- xm.mark_as_original from &report_table_name xm, pa_budget_lines pbl, pa_resource_assignments pra, pa_budget_versions pbv, pa_projects_all ppa, pa_tasks pt, pa_budget_types pbt, pa_budget_entry_methods pbem, pa_resource_lists prl, (select prlm.resource_list_id, prlm.resource_list_member_id, prlm.alias alias, substr(sys_connect_by_path (prlm.alias,'|'),2) alias_path from pa_resource_list_members prlm where nvl(prlm.migration_code, '-99') <> 'N' connect by prior prlm.resource_list_member_id = prlm.parent_member_id and prior prlm.resource_list_id = prlm.resource_list_id start with prlm.parent_member_id is null ) prlm, hr_all_organization_units_vl haouv where nvl(xm.status_code_,xxen_upload.status_error) = xxen_upload.status_success and xm.budget_line_id = pbl.budget_line_id (+) and pbl.resource_assignment_id = pra.resource_assignment_id (+) and pra.budget_version_id = pbv.budget_version_id (+) and pra.project_id = pbv.project_id (+) and pra.project_id = ppa.project_id (+) and ppa.org_id = haouv.organization_id (+) and pra.task_id = pt.task_id (+) and pra.resource_list_member_id = prlm.resource_list_member_id (+) and pbv.budget_type_code = pbt.budget_type_code (+) and pbv.budget_entry_method_code = pbem.budget_entry_method_code (+) and pbv.resource_list_id = prl.resource_list_id (+) Lexical &report_table_name xxen_pa_project_budget_0272_u LOV query :$column$.operating_unit OPERATING_UNIT BUDGET_TYPE LOV query :$column$.project_number PROJECT_NUMBER BUDGET_TYPE LOV query :$flex$.upload_mode Upload Mode|:p_upload_mode| DELETE_THIS_LINE LOV query :$column$.budget_type BUDGET_TYPE ENTRY_METHOD Default value :$column$.budget_type BUDGET_TYPE ENTRY_METHOD Default value :$column$.operating_unit OPERATING_UNIT ENTRY_METHOD LOV query :$column$.project_number PROJECT_NUMBER ENTRY_METHOD Default value :$column$.project_number PROJECT_NUMBER ENTRY_METHOD Default value :$flex$.operating_unit Operating Unit|:p_operating_unit| OPERATING_UNIT LOV query :$flex$.operating_unit Operating Unit|:p_operating_unit| OPERATING_UNIT LOV query :$column$.entry_method ENTRY_METHOD PERIOD_NAME LOV query :$column$.operating_unit OPERATING_UNIT PERIOD_NAME LOV query :$column$.project_number PROJECT_NUMBER PERIOD_NAME LOV query :$column$.task_number TASK_NUMBER PERIOD_NAME Default value :$flex$.product_source Product Source|:p_pm_product_code| PRODUCT_SOURCE LOV query :$flex$.product_source Product Source|:p_pm_product_code| PRODUCT_SOURCE LOV query :$column$.operating_unit OPERATING_UNIT PROJECT_NAME Default value :$column$.operating_unit OPERATING_UNIT PROJECT_NAME LOV query :$column$.project_number PROJECT_NUMBER PROJECT_NAME Default value :$column$.project_number PROJECT_NUMBER PROJECT_NAME LOV query :$column$.operating_unit OPERATING_UNIT PROJECT_NUMBER LOV query :$column$.operating_unit OPERATING_UNIT RESOURCE_ALIAS LOV query :$column$.resource_list RESOURCE_LIST RESOURCE_ALIAS Default value :$column$.budget_type BUDGET_TYPE RESOURCE_LIST LOV query :$column$.entry_method ENTRY_METHOD RESOURCE_LIST Default value :$column$.operating_unit OPERATING_UNIT RESOURCE_LIST LOV query :$column$.operating_unit OPERATING_UNIT RESOURCE_LIST Default value :$column$.project_number PROJECT_NUMBER RESOURCE_LIST LOV query :$column$.operating_unit OPERATING_UNIT TASK_NAME Default value :$column$.operating_unit OPERATING_UNIT TASK_NAME Default value :$column$.project_number PROJECT_NUMBER TASK_NAME LOV query :$column$.project_number PROJECT_NUMBER TASK_NAME LOV query :$column$.task_number TASK_NUMBER TASK_NAME Default value :$column$.task_number TASK_NUMBER TASK_NAME LOV query :$column$.entry_method ENTRY_METHOD TASK_NUMBER LOV query :$column$.operating_unit OPERATING_UNIT TASK_NUMBER LOV query :$column$.project_number PROJECT_NUMBER TASK_NUMBER Default value :$column$.resource_alias RESOURCE_ALIAS UNIT_OF_MEASURE LOV query :$column$.resource_alias RESOURCE_ALIAS UNIT_OF_MEASURE Default value :$column$.resource_list RESOURCE_LIST UNIT_OF_MEASURE LOV query :$column$.resource_list RESOURCE_LIST UNIT_OF_MEASURE Default value :$flex$.upload_mode Upload Mode|:p_upload_mode| UPLOAD_MODE_ Excel validation :$column$.budget_type BUDGET_TYPE Excel validation :$column$.burdened_cost BURDENED_COST Excel validation :$column$.end_date END_DATE Excel validation :$column$.entry_method ENTRY_METHOD Excel validation :$column$.operating_unit OPERATING_UNIT Excel validation :$column$.period_name PERIOD_NAME Excel validation :$column$.project_number PROJECT_NUMBER Excel validation :$column$.quantity QUANTITY Excel validation :$column$.raw_cost RAW_COST Excel validation :$column$.revenue REVENUE Excel validation :$column$.start_date START_DATE Excel validation :$column$.task_number TASK_NUMBER