ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F2CD3869E053B46B63588994Y SELECT c.class_category class_category_1 , c.description , m.meaning mandatory_flag , aa.meaning aa_flag , o.meaning pick_one_code_only_flag , c.start_date_active , c.end_date_active FROM pa_class_categories c , fnd_lookups m , fnd_lookups aa , fnd_lookups o WHERE c.class_category = nvl(:p_class_category, c.class_category) and c.mandatory_flag = m.lookup_code(+) and m.lookup_type(+) = 'YES_NO' and c.autoaccounting_flag = aa.lookup_code(+) and aa.lookup_type(+) = 'YES_NO' and c.pick_one_code_only_flag = o.lookup_code(+) and o.lookup_type(+) = 'YES_NO' ORDER BY c.class_category,c.start_date_active PA PAXRWPCC_XML AR PA رموز وفئات الطبقات (بتنسيق XML) Application: المشروعات Source: IMP: رموز وفئات الطبقات (بتنسيق XML) Short Name: PAXRWPCC_XML DB package: PA_PAXRWPCC_XMLP_PKG D PA Klassenkategorien und -schlüssel Application: Projects Source: IMP: Klassenkategorien und -schlüssel (XML) Short Name: PAXRWPCC_XML DB package: PA_PAXRWPCC_XMLP_PKG F PA Catégories de classes et codes Application: Projects Source: IMP : Catégories de classes et codes (XML) Short Name: PAXRWPCC_XML DB package: PA_PAXRWPCC_XMLP_PKG US PA Class Categories and Codes Application: Projects Source: IMP: Class Categories and Codes (XML) Short Name: PAXRWPCC_XML DB package: PA_PAXRWPCC_XMLP_PKG ZHS PA IMP：分类类别和代码 Application: 项目 Source: IMP：分类类别和代码 (XML) Short Name: PAXRWPCC_XML DB package: PA_PAXRWPCC_XMLP_PKG BI Publisher :c_company_name_header :p_class_category :p_conc_request_id 1 10 :p_class_category LOV Oracle PA_SRS_CLASS_CATEGORY Y select class_category id, class_category value, description description from pa_class_categories order by class_category AR فئة الطبقة D Klassenkategorie F Catégorie de classe US Class Category ZHS 分类类别