ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 53B31EFFC6B85470E0630100007F501D Blitz Report DFF Display 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 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 319D7060D13688E3E0630100007F19F4Y select x.* from ( select -- -- Budget -- haouv.name operating_unit, ppa.segment1 project_number, ppa.name project_name, pbt.budget_type, pbv.version_name, pbv.version_number, xxen_util.meaning(pbv.budget_status_code,'BUDGET STATUS',275) status, pbv.description, pbem.budget_entry_method entry_method, prl.name resource_list, 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, -- -- Actuals &actuals_columns -- -- DFF Columns &dff_columns -- pbv.project_id, pbv.budget_version_id, pbl.budget_line_id, pbv.resource_list_id, pra.task_id, pra.resource_assignment_id, 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_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 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 (+) ) x order by x.operating_unit, x.project_number, x.project_name, x.budget_type, x.version_name, x.version_number desc, &lp_sort_col1 &lp_sort_col2 &lp_sort_col3 x.budget_line_id US PA Project Budget Report of Standard Project Budgets. This report does not include Financial Plan Budgets. In addition to the budget details, the report will also display the actuals matching the budget line datapoints. Note: Inclusion of actuals data requires Blitz Report Build Data later than 04-APR-2025 03:21:50 Enginatics &actuals_columns &dff_columns &lp_sort_col1 &lp_sort_col2 &lp_sort_col3 1=1 1 10 1=1 haouv.name=: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 2 20 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 (:$flex$.operating_unit is null or xxen_util.contains(:$flex$.operating_unit,haouv.name) = 'Y') order by value US Project Number 3 30 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 (:$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') order by value US Project Name 4 40 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 (:$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') ) order by value US Budget Type 5 50 1=1 pbv.budget_status_code=:p_budget_status_code LOV custom Y select flvv.lookup_code id, flvv.meaning value, flvv.description from fnd_lookup_values_vl flvv where flvv.lookup_type = 'BUDGET STATUS' and flvv.view_application_id = 275 and flvv.enabled_flag = 'Y' order by value B US Budget Status 6 60 1=1 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 ) LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual Y Y US Latest Budget Version 7 70 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$.budget_status is null or xxen_util.contains(:$flex$.budget_status,pbv.budget_status_code) = 'Y') and :$flex$.Latest_Budget_Version is null order by ppa.segment1, pbt.budget_type, pbv.budget_status_code desc, pbv.version_number desc US Budget Version 8 80 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_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_status is null or xxen_util.contains(:$flex$.budget_status,pbv.budget_status_code) = '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 ) ) US Task Number 9 90 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_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_status is null or xxen_util.contains(:$flex$.budget_status,pbv.budget_status_code) = '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 ) ) US Task Name 10 100 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_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$.budget_type is null or xxen_util.contains(:$flex$.budget_type,pbt.budget_type) = 'Y') and (:$flex$.budget_status is null or xxen_util.contains(:$flex$.budget_status,pbv.budget_status_code) = '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 ) ) US Resource Alias 11 110 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 (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_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$.budget_type is null or xxen_util.contains(:$flex$.budget_type,pbt.budget_type) = 'Y') and (:$flex$.budget_status is null or xxen_util.contains(:$flex$.budget_status,pbv.budget_status_code) = '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 ) ) order by trunc(pbpv.period_start_date), pbpv.period_type_code US Period From 12 120 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 (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_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$.budget_type is null or xxen_util.contains(:$flex$.budget_type,pbt.budget_type) = 'Y') and (:$flex$.budget_status is null or xxen_util.contains(:$flex$.budget_status,pbv.budget_status_code) = '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 ) ) order by trunc(pbpv.period_start_date), pbpv.period_type_code :$flex$.period_from US Period To 13 130 1=1 pbl.start_date=:p_date_start Date US Budget Line Start Date 14 140 1=1 pbl.end_date=:p_date_end Date US Budget Line End Date 15 150 1=1 trunc(:p_date_active) between pbl.start_date and pbl.end_date Date US Budget Line Active On Date 16 160 &dff_columns select x.sql_text from ( select 1 seq, 'pbv.attribute_category budget_attribute_category,' sql_text from dual union select 2 seq, dbms_lob.substr(xxen_util.dff_columns(p_table_name=>'PA_BUDGET_VERSIONS',p_table_alias=>'pbv', p_row_id=>'rowid',p_display_mode=>:dff_display)) sql_text from dual union select 3 seq, 'pbl.attribute_category line_attribute_category,' sql_text from dual union select 4 seq, dbms_lob.substr(xxen_util.dff_columns(p_table_name=>'PA_BUDGET_LINES',p_table_alias=>'pbl', p_row_id=>'rowid',p_display_mode=>:dff_display)) sql_text from dual ) x where x.sql_text is not null order by x.seq 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 17 170 &actuals_columns select 'xxen_pa_upload.get_actuals_datapoint(ppa.org_id, pbv.project_id, pra.task_id, pra.resource_list_member_id, pbem.time_phased_type_code, pbl.period_name, pbl.start_date, pbl.end_date, ''REVENUE'') actual_revenue, xxen_pa_upload.get_actuals_datapoint(ppa.org_id, pbv.project_id, pra.task_id, pra.resource_list_member_id, pbem.time_phased_type_code, pbl.period_name, pbl.start_date, pbl.end_date, ''RAW_COST'') actual_raw_cost, xxen_pa_upload.get_actuals_datapoint(ppa.org_id, pbv.project_id, pra.task_id, pra.resource_list_member_id, pbem.time_phased_type_code, pbl.period_name, pbl.start_date, pbl.end_date, ''BURDENED_COST'') actual_burdened_cost, xxen_pa_upload.get_actuals_datapoint(ppa.org_id, pbv.project_id, pra.task_id, pra.resource_list_member_id, pbem.time_phased_type_code, pbl.period_name, pbl.start_date, pbl.end_date, ''QUANTITY'') actual_quantity, xxen_pa_upload.get_actuals_datapoint(ppa.org_id, pbv.project_id, pra.task_id, pra.resource_list_member_id, pbem.time_phased_type_code, pbl.period_name, pbl.start_date, pbl.end_date, ''LABOR_HOURS'') actual_labor_hours, xxen_pa_upload.get_actuals_datapoint(ppa.org_id, pbv.project_id, pra.task_id, pra.resource_list_member_id, pbem.time_phased_type_code, pbl.period_name, pbl.start_date, pbl.end_date, ''BILLABLE_RAW_COST'') actual_billable_raw_cost, xxen_pa_upload.get_actuals_datapoint(ppa.org_id, pbv.project_id, pra.task_id, pra.resource_list_member_id, pbem.time_phased_type_code, pbl.period_name, pbl.start_date, pbl.end_date, ''BILLABLE_BURDENED_COST'') actual_billable_burdened_cost, xxen_pa_upload.get_actuals_datapoint(ppa.org_id, pbv.project_id, pra.task_id, pra.resource_list_member_id, pbem.time_phased_type_code, pbl.period_name, pbl.start_date, pbl.end_date, ''BILLABLE_QUANTITY'') actual_billable_quantity, xxen_pa_upload.get_actuals_datapoint(ppa.org_id, pbv.project_id, pra.task_id, pra.resource_list_member_id, pbem.time_phased_type_code, pbl.period_name, pbl.start_date, pbl.end_date, ''BILLABLE_LABOR_HOURS'') actual_billable_labor_hours, xxen_pa_upload.get_actuals_datapoint(ppa.org_id, pbv.project_id, pra.task_id, pra.resource_list_member_id, pbem.time_phased_type_code, pbl.period_name, pbl.start_date, pbl.end_date, ''CMT_RAW_COST'') actual_cmt_raw_cost, xxen_pa_upload.get_actuals_datapoint(ppa.org_id, pbv.project_id, pra.task_id, pra.resource_list_member_id, pbem.time_phased_type_code, pbl.period_name, pbl.start_date, pbl.end_date, ''CMT_BURDENED_COST'') actual_cmt_burdened_cost, xxen_util.meaning(xxen_pa_upload.get_actuals_uom(ppa.org_id, pbv.project_id, pra.task_id, pra.resource_list_member_id, pbem.time_phased_type_code, pbl.period_name, pbl.start_date, pbl.end_date),''UNIT'',275) actual_uom,' from dual where exists (select null from dba_source where owner = 'APPS' and type = 'PACKAGE' and name = 'XXEN_PA_UPLOAD' and lower(text) like '%get_actuals_datapoint%') union select '''Actuals cannot be reported in this version of Blitz Report. Please upgrade Blitz Report to use this functionality'' actuals_status,' from dual where not exists (select null from dba_source where owner = 'APPS' and type = 'PACKAGE' and name = 'XXEN_PA_UPLOAD' and lower(text) like '%get_actuals_datapoint%') LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual select 'Y' from dual where exists (select null from dba_source where owner = 'APPS' and type = 'PACKAGE' and name = 'XXEN_PA_UPLOAD' and lower(text) like '%get_actuals_datapoint%') US Show Actuals 18 180 &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 US Sort Precedence 1 19 &lp_sort_col1 x.resource_alias, Resource Alias US Sort Precedence 1 20 &lp_sort_col1 x.task_name, Task Name US Sort Precedence 1 21 &lp_sort_col1 x.task_number, Task Number US Sort Precedence 1 22 190 &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 US Sort Precedence 2 23 &lp_sort_col2 x.resource_alias, Resource Alias US Sort Precedence 2 24 &lp_sort_col2 x.task_name, Task Name US Sort Precedence 2 25 &lp_sort_col2 x.task_number, Task Number US Sort Precedence 2 26 200 &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 US Sort Precedence 3 27 &lp_sort_col3 x.resource_alias, Resource Alias US Sort Precedence 3 28 &lp_sort_col3 x.task_name, Task Name US Sort Precedence 3 29 &lp_sort_col3 x.task_number, Task Number US Sort Precedence 3 :$flex$.Latest_Budget_Version Latest Budget Version Budget Version :$flex$.budget_status Budget Status Budget Version :$flex$.budget_status Budget Status Period From :$flex$.budget_status Budget Status Period To :$flex$.budget_status Budget Status Resource Alias :$flex$.budget_status Budget Status Task Name :$flex$.budget_status Budget Status Task Number :$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$.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