ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F3EC3869E053B46B63588994 SELECT mum1.uom_class Unit_Class , mum1.uom_code Abbr , mum1.unit_of_measure Unit , mum1.description Description , muc.conversion_rate Rate , mum2.uom_code Abbr1 , mum2.unit_of_measure Unit1 , mum2.description Description1 , mum2.disable_date Date1 FROM mtl_units_of_measure mum1 , mtl_units_of_measure mum2 , mtl_uom_conversions muc WHERE mum1.uom_class = mum2.uom_class AND mum1.uom_class = muc.uom_class AND mum1.uom_code = muc.uom_code AND mum2.base_uom_flag = 'Y' AND ((:P_ACTIVE_INACTIVE = 'BOTH') OR (decode(:P_active_inactive ,'ACTIVE',(nvl(muc.disable_date,sysdate+1)-sysdate) ) > 0 AND decode(:P_active_inactive , 'ACTIVE', (nvl(mum1.disable_date, sysdate+1) - sysdate) ) > 0) OR (decode(:P_active_inactive ,'INACTIVE',(sysdate-nvl(muc.disable_date,sysdate+1)) ) > 0 OR decode(:P_active_inactive , 'INACTIVE',(sysdate-nvl(mum1.disable_date, sysdate+1)) ) >0)) ORDER BY mum1.unit_of_measure , mum2.unit_of_measure Y PO POXSURUM_XML AR PO قائمة وحدات القياس (بتنسيق XML) Application: المشتريات Source: قائمة وحدات القياس (بتنسيق XML) Short Name: POXSURUM_XML DB package: PO_POXSURUM_XMLP_PKG D PO Maßeinheiten Application: Einkauf Source: Maßeinheiten (XML) Short Name: POXSURUM_XML DB package: PO_POXSURUM_XMLP_PKG F PO Liste des unités de mesure Application: Purchasing Source: Liste des unités de mesure (XML) Short Name: POXSURUM_XML DB package: PO_POXSURUM_XMLP_PKG US PO Unit of Measure Listing Application: Purchasing Source: Unit of Measure Listing (XML) Short Name: POXSURUM_XML DB package: PO_POXSURUM_XMLP_PKG ZHS PO 单位列表 Application: 采购管理系统 Source: 单位列表 (XML) Short Name: POXSURUM_XML DB package: PO_POXSURUM_XMLP_PKG BI Publisher :operating_unit :p_active_inactive :p_active_inactive_disp :p_conc_request_id :p_qty_precision :p_title 1 10 :p_title Char AR العنوان D Titel F Titre US Title ZHS 标题 2 20 :p_active_inactive LOV Oracle PO_SRS_ACTIVE_OPTIONS Y select lookup_code id, displayed_field value, null description from po_lookup_codes where lookup_type='ACTIVE_INACTIVE' order by displayed_field Y AR ساري/غير ساري D Gültig/Ungültig F Activé/Désactivé US Active/Inactive ZHS 有效/无效 3 30 :p_qty_precision LOV Oracle INV_SRS_PRECISION Y select lookup_code id, lookup_code value, meaning description from mfg_lookups where lookup_type='INV_SRS_PRECISION' and enabled_flag='Y' order by lookup_code select fnd_profile.value('REPORT_QUANTITY_PREICISION') from dual Y AR خيار الدقة الديناميكية D Option Nachkommastellen F Option précision dynamique US Dynamic Precision Option ZHS 动态精确度选项