ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F2CC3869E053B46B63588994Y SELECT substr(o.name,1,60) name , nlr.expenditure_type ex_type , et.expenditure_category ex_category , nlr.non_labor_resource , nlr.start_date_active , nlr.end_date_active , nlr.description FROM hr_organization_units o , pa_expenditure_types et , pa_non_labor_resources nlr , pa_non_labor_resource_orgs nlro WHERE nlro.organization_id = nvl(:p_organization_id, nlro.organization_id) and nlr.non_labor_resource = nlro.non_labor_resource and nlr.expenditure_type = nvl(:p_expenditure_type, nlr.expenditure_type) and nlr.expenditure_type = et.expenditure_type and et.expenditure_category = nvl(:p_expenditure_category, et.expenditure_category) and nlro.organization_id = o.organization_id ORDER BY o.name , et.expenditure_category , nlr.expenditure_type , nlr.non_labor_resource , nlr.start_date_active , nlr.end_date_active , nlr.description PA PAXRWNLR_XML AR PA موارد بدون عمالة حسب التنظيم (بتنسيق XML) Application: المشروعات Source: IMP: موارد بدون عمالة حسب التنظيم (بتنسيق XML) Short Name: PAXRWNLR_XML DB package: PA_PAXRWNLR_XMLP_PKG D PA Sonstige Ressourcen nach Organisation Application: Projects Source: IMP: Sonstige Ressourcen nach Organisation (XML) Short Name: PAXRWNLR_XML DB package: PA_PAXRWNLR_XMLP_PKG F PA Ressources hors main-d'oeuvre par organisation Application: Projects Source: IMP : Ressources hors main-d'oeuvre par organisation (XML) Short Name: PAXRWNLR_XML DB package: PA_PAXRWNLR_XMLP_PKG US PA Non-Labor Resources By Organization Application: Projects Source: IMP: Non-Labor Resources By Organization (XML) Short Name: PAXRWNLR_XML DB package: PA_PAXRWNLR_XMLP_PKG ZHS PA IMP：按组织列出的非人工资源 Application: 项目 Source: IMP：按组织列出的非人工资源 (XML) Short Name: PAXRWNLR_XML DB package: PA_PAXRWNLR_XMLP_PKG BI Publisher :c_company_name_header :c_org_name :operating_unit :p_conc_request_id :p_expenditure_category :p_expenditure_type :p_organization_id 1 10 :p_organization_id LOV Oracle PA_SRS_REPORTING_ORGANIZATION Y select organization_id id, name value, null description from pa_organizations_v where organization_id in (select se.organization_id_child from per_org_structure_elements se where org_structure_version_id= pa_org_utils.get_org_version_id('REPORTING') connect by prior se.organization_id_child =se.organization_id_parent and org_structure_version_id= pa_org_utils.get_org_version_id('REPORTING') start with se.organization_id_parent= pa_org_utils.get_start_org_id('REPORTING') and org_structure_version_id= pa_org_utils.get_org_version_id('REPORTING') union select pa_org_utils.get_start_org_id('REPORTING') from sys.dual ) order by value,description AR المنشأة D Organisation F Organisation US Organization ZHS 组织 2 20 :p_expenditure_category LOV Oracle PA_SRS_EXPENDITURE_CATEGORY Y select expenditure_category id, expenditure_category value, null description from pa_expenditure_categories order by expenditure_category AR فئة المصروفات D Aufwandskategorie F Catégorie de dépenses US Expenditure Category ZHS 支出类别 3 30 :p_expenditure_type LOV Oracle PA_SRS_EXPENDITURE_TYPE Y select expenditure_type id, expenditure_type value, description description from pa_expenditure_types order by expenditure_type AR نوع المصروفات D Aufwandsart F Type de dépense US Expenditure Type ZHS 支出类型