ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 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）限制的操作单元。 C6E085D471BA51A9E05362FB09050512Y SELECT DECODE(:P_SORT, 'VENDOR', pov.vendor_name, 'BUYER', hre.full_name, pov.vendor_name) break_group_column , DECODE(:P_SORT, 'VENDOR', hre.full_name, 'BUYER', pov.vendor_name,hre.full_name ) other_group_column, poh.segment1||decode(por.release_num,null,'','-'||por.release_num) PO_Number, decode( mod(glp.period_num,12), mod(:P_period_num,12), decode(poh.closed_code, 'FINALLY CLOSED', SUM (DECODE (POL.order_type_lookup_code, 'RATE', GREATEST (PLL.amount_received, PLL.amount_billed), 'FIXED PRICE', GREATEST (PLL.amount_received, PLL.amount_billed), GREATEST (PLL.quantity_received, PLL.quantity_billed) * PLL.price_override)), SUM (DECODE (POL.order_type_lookup_code, 'RATE', PLL.amount - NVL(PLL.amount_cancelled, 0), 'FIXED PRICE', PLL.amount - NVL(PLL.amount_cancelled, 0), (PLL.quantity - NVL(PLL.quantity_cancelled, 0)) * PLL.price_override))) * NVL(POH.rate, 1) ) C_AMOUNT_PER1, decode( mod(glp.period_num,12), mod(:P_period_num + 1,12), decode(poh.closed_code, 'FINALLY CLOSED', SUM (DECODE (POL.order_type_lookup_code, 'RATE', GREATEST (PLL.amount_received, PLL.amount_billed), 'FIXED PRICE', GREATEST (PLL.amount_received, PLL.amount_billed), GREATEST (PLL.quantity_received, PLL.quantity_billed) * PLL.price_override)), SUM (DECODE (POL.order_type_lookup_code, 'RATE', PLL.amount - NVL(PLL.amount_cancelled, 0), 'FIXED PRICE', PLL.amount - NVL(PLL.amount_cancelled, 0), (PLL.quantity - NVL(PLL.quantity_cancelled, 0)) * PLL.price_override))) * NVL(POH.rate, 1) ) C_AMOUNT_PER2, decode( mod(glp.period_num,12), mod(:P_period_num + 2,12), decode(poh.closed_code, 'FINALLY CLOSED', SUM (DECODE (POL.order_type_lookup_code, 'RATE', GREATEST (PLL.amount_received, PLL.amount_billed), 'FIXED PRICE', GREATEST (PLL.amount_received, PLL.amount_billed), GREATEST (PLL.quantity_received, PLL.quantity_billed) * PLL.price_override)), SUM (DECODE (POL.order_type_lookup_code, 'RATE', PLL.amount - NVL(PLL.amount_cancelled, 0), 'FIXED PRICE', PLL.amount - NVL(PLL.amount_cancelled, 0), (PLL.quantity - NVL(PLL.quantity_cancelled, 0)) * PLL.price_override))) * NVL(POH.rate, 1) ) C_AMOUNT_PER3, decode( mod(glp.period_num,12), mod(:P_period_num + 3,12), decode(poh.closed_code, 'FINALLY CLOSED', SUM (DECODE (POL.order_type_lookup_code, 'RATE', GREATEST (PLL.amount_received, PLL.amount_billed), 'FIXED PRICE', GREATEST (PLL.amount_received, PLL.amount_billed), GREATEST (PLL.quantity_received, PLL.quantity_billed) * PLL.price_override)), SUM (DECODE (POL.order_type_lookup_code, 'RATE', PLL.amount - NVL(PLL.amount_cancelled, 0), 'FIXED PRICE', PLL.amount - NVL(PLL.amount_cancelled, 0), (PLL.quantity - NVL(PLL.quantity_cancelled, 0)) * PLL.price_override))) * NVL(POH.rate, 1), mod(:P_period_num + 4,12), decode(poh.closed_code, 'FINALLY CLOSED', SUM (DECODE (POL.order_type_lookup_code, 'RATE', GREATEST (PLL.amount_received, PLL.amount_billed), 'FIXED PRICE', GREATEST (PLL.amount_received, PLL.amount_billed), GREATEST (PLL.quantity_received, PLL.quantity_billed) * PLL.price_override)), SUM (DECODE (POL.order_type_lookup_code, 'RATE', PLL.amount - NVL(PLL.amount_cancelled, 0), 'FIXED PRICE', PLL.amount - NVL(PLL.amount_cancelled, 0), (PLL.quantity - NVL(PLL.quantity_cancelled, 0)) * PLL.price_override))) * NVL(POH.rate, 1), mod(:P_period_num + 5,12), decode(poh.closed_code, 'FINALLY CLOSED', SUM (DECODE (POL.order_type_lookup_code, 'RATE', GREATEST (PLL.amount_received, PLL.amount_billed), 'FIXED PRICE', GREATEST (PLL.amount_received, PLL.amount_billed), GREATEST (PLL.quantity_received, PLL.quantity_billed) * PLL.price_override)), SUM (DECODE (POL.order_type_lookup_code, 'RATE', PLL.amount - NVL(PLL.amount_cancelled, 0), 'FIXED PRICE', PLL.amount - NVL(PLL.amount_cancelled, 0), (PLL.quantity - NVL(PLL.quantity_cancelled, 0)) * PLL.price_override))) * NVL(POH.rate, 1) ) C_AMOUNT_PER4, mca.segment1 seg1, PO_POXPOCOM_XMLP_PKG.c_sum_allformula(:C_break_per1, :C_break_per2, :C_break_per3, :C_break_per4, :C_PRECISION) C_sum_all, PO_POXPOCOM_XMLP_PKG.c_break_per1_round(:C_break_per1, :C_PRECISION) C_break_per1_round, PO_POXPOCOM_XMLP_PKG.c_break_per2_round(:C_break_per2, :C_PRECISION) C_break_per2_round, PO_POXPOCOM_XMLP_PKG.c_break_per3_round(:C_break_per3, :C_PRECISION) C_break_per3_round, PO_POXPOCOM_XMLP_PKG.c_break_per4_round(:C_break_per4, :C_PRECISION) C_break_per4_round, PO_POXPOCOM_XMLP_PKG.c_amt_per1_round(decode ( mod ( glp.period_num , 12 ) , mod ( :P_period_num , 12 ) , decode ( poh.closed_code , 'FINALLY CLOSED' , SUM ( DECODE ( POL.order_type_lookup_code , 'RATE' , GREATEST ( PLL.amount_received , PLL.amount_billed ) , 'FIXED PRICE' , GREATEST ( PLL.amount_received , PLL.amount_billed ) , GREATEST ( PLL.quantity_received , PLL.quantity_billed ) * PLL.price_override ) ) , SUM ( DECODE ( POL.order_type_lookup_code , 'RATE' , PLL.amount - NVL ( PLL.amount_cancelled , 0 ) , 'FIXED PRICE' , PLL.amount - NVL ( PLL.amount_cancelled , 0 ) , ( PLL.quantity - NVL ( PLL.quantity_cancelled , 0 ) ) * PLL.price_override ) ) ) * NVL ( POH.rate , 1 ) ), :C_PRECISION) C_amount_per1_round, PO_POXPOCOM_XMLP_PKG.c_amt_per2_round(decode ( mod ( glp.period_num , 12 ) , mod ( :P_period_num + 1 , 12 ) , decode ( poh.closed_code , 'FINALLY CLOSED' , SUM ( DECODE ( POL.order_type_lookup_code , 'RATE' , GREATEST ( PLL.amount_received , PLL.amount_billed ) , 'FIXED PRICE' , GREATEST ( PLL.amount_received , PLL.amount_billed ) , GREATEST ( PLL.quantity_received , PLL.quantity_billed ) * PLL.price_override ) ) , SUM ( DECODE ( POL.order_type_lookup_code , 'RATE' , PLL.amount - NVL ( PLL.amount_cancelled , 0 ) , 'FIXED PRICE' , PLL.amount - NVL ( PLL.amount_cancelled , 0 ) , ( PLL.quantity - NVL ( PLL.quantity_cancelled , 0 ) ) * PLL.price_override ) ) ) * NVL ( POH.rate , 1 ) ), :C_PRECISION) C_amount_per2_round, PO_POXPOCOM_XMLP_PKG.c_amt_per3_round(decode ( mod ( glp.period_num , 12 ) , mod ( :P_period_num + 2 , 12 ) , decode ( poh.closed_code , 'FINALLY CLOSED' , SUM ( DECODE ( POL.order_type_lookup_code , 'RATE' , GREATEST ( PLL.amount_received , PLL.amount_billed ) , 'FIXED PRICE' , GREATEST ( PLL.amount_received , PLL.amount_billed ) , GREATEST ( PLL.quantity_received , PLL.quantity_billed ) * PLL.price_override ) ) , SUM ( DECODE ( POL.order_type_lookup_code , 'RATE' , PLL.amount - NVL ( PLL.amount_cancelled , 0 ) , 'FIXED PRICE' , PLL.amount - NVL ( PLL.amount_cancelled , 0 ) , ( PLL.quantity - NVL ( PLL.quantity_cancelled , 0 ) ) * PLL.price_override ) ) ) * NVL ( POH.rate , 1 ) ), :C_PRECISION) C_amount_per3_round, PO_POXPOCOM_XMLP_PKG.c_amt_per4_round( decode( mod(glp.period_num,12), mod(:P_period_num + 3,12), decode(poh.closed_code, 'FINALLY CLOSED', SUM (DECODE (POL.order_type_lookup_code, 'RATE', GREATEST (PLL.amount_received, PLL.amount_billed), 'FIXED PRICE', GREATEST (PLL.amount_received, PLL.amount_billed), GREATEST (PLL.quantity_received, PLL.quantity_billed) * PLL.price_override)), SUM (DECODE (POL.order_type_lookup_code, 'RATE', PLL.amount - NVL(PLL.amount_cancelled, 0), 'FIXED PRICE', PLL.amount - NVL(PLL.amount_cancelled, 0), (PLL.quantity - NVL(PLL.quantity_cancelled, 0)) * PLL.price_override))) * NVL(POH.rate, 1), mod(:P_period_num + 4,12), decode(poh.closed_code, 'FINALLY CLOSED', SUM (DECODE (POL.order_type_lookup_code, 'RATE', GREATEST (PLL.amount_received, PLL.amount_billed), 'FIXED PRICE', GREATEST (PLL.amount_received, PLL.amount_billed), GREATEST (PLL.quantity_received, PLL.quantity_billed) * PLL.price_override)), SUM (DECODE (POL.order_type_lookup_code, 'RATE', PLL.amount - NVL(PLL.amount_cancelled, 0), 'FIXED PRICE', PLL.amount - NVL(PLL.amount_cancelled, 0), (PLL.quantity - NVL(PLL.quantity_cancelled, 0)) * PLL.price_override))) * NVL(POH.rate, 1), mod(:P_period_num + 5,12), decode(poh.closed_code, 'FINALLY CLOSED', SUM (DECODE (POL.order_type_lookup_code, 'RATE', GREATEST (PLL.amount_received, PLL.amount_billed), 'FIXED PRICE', GREATEST (PLL.amount_received, PLL.amount_billed), GREATEST (PLL.quantity_received, PLL.quantity_billed) * PLL.price_override)), SUM (DECODE (POL.order_type_lookup_code, 'RATE', PLL.amount - NVL(PLL.amount_cancelled, 0), 'FIXED PRICE', PLL.amount - NVL(PLL.amount_cancelled, 0), (PLL.quantity - NVL(PLL.quantity_cancelled, 0)) * PLL.price_override))) * NVL(POH.rate, 1) ),:C_PRECISION) C_amount_per4_round FROM po_line_locations pll , po_lines pol , po_releases por , po_headers poh , po_vendors pov , hr_employees hre , gl_period_statuses glp , financials_system_parameters fsp , po_system_parameters psp , mtl_categories mca WHERE poh.po_header_id = pll.po_header_id AND por.po_release_id (+) = pll.po_release_id AND pll.po_line_id = pol.po_line_id AND pol.category_id = mca.category_id AND poh.vendor_id = pov.vendor_id AND hre.employee_id = poh.agent_id AND nvl(nvl(pll.promised_date,pll.need_by_date),sysdate) BETWEEN nvl(glp.start_date, nvl(nvl(pll.promised_date,pll.need_by_date),sysdate) - 1 ) AND nvl(glp.end_date, nvl(nvl(pll.promised_date,pll.need_by_date),sysdate) + 1) AND application_id = 201 AND glp.set_of_books_id = fsp.set_of_books_id AND (( (glp.period_num BETWEEN :P_period_num AND decode ( sign (((:P_period_num +5)/12)-1), -1, :P_period_num+5, 12)) AND glp.period_year = :P_period_year) OR ((glp.period_num BETWEEN 1 AND decode ( sign (((:P_period_num+5)/12)-1), -1,0, mod(:P_period_num+5,12))) AND glp.period_year = :P_period_year + 1)) AND pll.shipment_type in ('STANDARD', 'SCHEDULED', 'BLANKET') AND pov.vendor_name BETWEEN nvl(:P_vendor_from,pov.vendor_name) AND nvl(:P_vendor_to, pov.vendor_name) AND ((decode(psp.manual_po_num_type,'NUMERIC',poh.segment1,NULL) BETWEEN decode(psp.manual_po_num_type,'NUMERIC', to_number(nvl(:P_po_number_from, poh.segment1)),NULL) AND decode(psp.manual_po_num_type,'NUMERIC', to_number(nvl(:P_po_number_to, poh.segment1)),NULL)) OR (poh.segment1 BETWEEN decode(psp.manual_po_num_type,'ALPHANUMERIC', nvl(:P_po_number_from,poh.segment1),NULL) AND decode(psp.manual_po_num_type,'ALPHANUMERIC', nvl(:P_po_number_to,poh.segment1),NULL))) AND hre.employee_id = nvl(:P_buyer, hre.employee_id) AND ( ( NVL(POH.closed_code, 'OPEN') <> 'FINALLY CLOSED' AND ( DECODE (POL.order_type_lookup_code, 'RATE', PLL.amount - NVL(PLL.amount_cancelled, 0), 'FIXED PRICE', PLL.amount - NVL(PLL.amount_cancelled, 0), PLL.quantity - NVL(PLL.quantity_cancelled,0)) > 0) ) OR ( POH.closed_code = 'FINALLY CLOSED' AND ( DECODE (POL.order_type_lookup_code, 'RATE', NVL(GREATEST (PLL.amount_received, PLL.amount_billed), 0), 'FIXED PRICE', NVL(GREATEST (PLL.amount_received, PLL.amount_billed), 0), NVL(GREATEST (PLL.quantity_received, PLL.quantity_billed), 0)) > 0) ) ) AND ( DECODE (POL.order_type_lookup_code, 'RATE', PLL.amount - NVL(PLL.amount_cancelled, 0) - NVL( GREATEST (PLL.amount_received, PLL.amount_billed), 0), 'FIXED PRICE', PLL.amount - NVL(PLL.amount_cancelled, 0) - NVL( GREATEST (PLL.amount_received, PLL.amount_billed), 0), PLL.quantity - NVL(PLL.quantity_cancelled, 0) - NVL( GREATEST (PLL.quantity_received, PLL.quantity_billed), 0)) > 0) AND &P_WHERE_CAT GROUP BY pov.vendor_name , hre.full_name , poh.segment1||decode(por.release_num,null,'','-'||por.release_num) , glp.period_year, glp.period_num , glp.period_year, glp.period_num , glp.period_year, glp.period_num , glp.period_year, glp.period_num , decode(psp.manual_po_num_type,'NUMERIC', to_number(poh.segment1),NULL), decode(psp.manual_po_num_type,'NUMERIC', NULL,poh.segment1), por.release_num , mca.segment1 , poh.closed_code, NVL(poh.rate, 1) ORDER BY 1 ASC,2 ASC , decode ( psp.manual_po_num_type , 'NUMERIC' , to_number ( poh.segment1 ) , NULL ) , decode ( psp.manual_po_num_type , 'NUMERIC' , NULL , poh.segment1 ) , por.release_num PO POXPOCOM_XML AR PO تقرير ارتباط أمر شراء حسب الفترة (بتنسيق XML) Imported from BI Publisher Description: تقرير ارتباط أمر شراء حسب الفترة Application: المشتريات Source: تقرير ارتباط أمر شراء حسب الفترة (بتنسيق XML) Short Name: POXPOCOM_XML DB package: PO_POXPOCOM_XMLP_PKG D PO Bestellungen - Verpflichtungen nach Perioden Imported from BI Publisher Description: Bestellungen - Verpflichtungen nach Perioden Application: Einkauf Source: Bestellungen - Verpflichtungen nach Perioden (XML) Short Name: POXPOCOM_XML DB package: PO_POXPOCOM_XMLP_PKG E PO Informe Pedidos Comprometidos por Período Imported from BI Publisher Description: Informe de pedidos comprometidos por período Application: Purchasing Source: Informe Pedidos Comprometidos por Período (XML) Short Name: POXPOCOM_XML DB package: PO_POXPOCOM_XMLP_PKG F PO Etat des pré-engagements sur commandes par période Imported from BI Publisher Description: Etat des pré-engagements sur commandes par période Application: Purchasing Source: Etat des pré-engagements sur commandes par période (XML) Short Name: POXPOCOM_XML DB package: PO_POXPOCOM_XMLP_PKG I PO Rapporto Impegno ordine di acquisto per periodo Imported from BI Publisher Description: Rapporto Impegno ordine di acquisto per periodo Application: Purchasing Source: Rapporto Impegno ordine di acquisto per periodo (XML) Short Name: POXPOCOM_XML DB package: PO_POXPOCOM_XMLP_PKG JA PO 期間別発注確定レポート Imported from BI Publisher Description: 期間別発注確定レポート Application: Purchasing Source: 期間別発注確定レポート(XML) Short Name: POXPOCOM_XML DB package: PO_POXPOCOM_XMLP_PKG KO PO 기간별 구매 발주 약정 보고서 Imported from BI Publisher Description: 기간별 구매 발주 약정 보고서 Application: Purchasing Source: 기간별 구매 발주 약정 보고서(XML) Short Name: POXPOCOM_XML DB package: PO_POXPOCOM_XMLP_PKG PTB PO Relatório de Compromissos de Ordens de Compra por Período Imported from BI Publisher Description: Relatório Compromissos de OCs por Período Application: Compra Source: Relatório de Compromissos de Ordens de Compra por Período (XML) Short Name: POXPOCOM_XML DB package: PO_POXPOCOM_XMLP_PKG RU PO Отчет об обязательствах по заказам на приобретение по периодам Imported from BI Publisher Description: Отчет об обязательствах по заказам на приобретение по периодам Application: Закупки Source: Отчет об обязательствах по заказам на приобретение по периодам (XML) Short Name: POXPOCOM_XML DB package: PO_POXPOCOM_XMLP_PKG S PO Inköpsorderåtaganden per period - rapport Imported from BI Publisher Description: Inköpsorderåtaganden per period - rapport Application: Purchasing Source: Inköpsorderåtaganden per period - rapport (XML) Short Name: POXPOCOM_XML DB package: PO_POXPOCOM_XMLP_PKG TR PO Dönem Bazında Satın Alma Siparişi Taahhüt Raporu Imported from BI Publisher Description: Dönem Bazında Satın Alma Siparişi Taahhüt Raporu Application: Satın Alma Yönetimi Source: Dönem Bazında Satın Alma Siparişi Taahhüt Raporu (XML) Short Name: POXPOCOM_XML DB package: PO_POXPOCOM_XMLP_PKG US PO Purchase Order Commitment By Period Imported from BI Publisher Description: Purchase Order Commitment By Period Report Application: Purchasing Source: Purchase Order Commitment By Period Report (XML) Short Name: POXPOCOM_XML DB package: PO_POXPOCOM_XMLP_PKG ZHS PO 按期间列出的采购订单承付款报表 Imported from BI Publisher Description: 按期间报表的采购订单承付款 Application: 采购管理系统 Source: 按期间列出的采购订单承付款报表 (XML) Short Name: POXPOCOM_XML DB package: PO_POXPOCOM_XMLP_PKG BI Publisher &p_where_cat :c_break_per1 :c_break_per2 :c_break_per3 :c_break_per4 :c_precision :operating_unit :p_alt_orderby_displayed :p_buyer :p_category_from :p_category_to :p_conc_request_id :p_orderby_displayed :p_period :p_period_num :p_period_year :p_po_number_from :p_po_number_to :p_sort :p_sort_1 :p_struct_num :p_title :p_vendor_from :p_vendor_to :p_where_cat 1 -20 :p_struct_num Number select structure_id from mtl_default_sets_view where functional_area_id = 2 Y AR P_STRUCT_NUM رقم هيكل الفئة D P_STRUCT_NUM Kategoriestruktur-Nummer E P_STRUCT_NUM Número de Estructura de Categoría F P_STRUCT_NUM Numéro de structure de catégorie I P_STRUCT_NUM Numero struttura categoria JA P_STRUCT_NUM カテゴリ体系番号 KO P_STRUCT_NUM 범주 구조번호 PTB P_STRUCT_NUM Número da Estrutura da Categoria RU P_STRUCT_NUM Номер структуры категории S P_STRUCT_NUM Kategoristrukturnummer TR P_STRUCT_NUM Kategori Yapı Numarası US P_STRUCT_NUM Category Structure Number ZHS P_STRUCT_NUM 类别结构编号 2 0 :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 select haouv.name from hr_all_organization_units_vl haouv where haouv.organization_id=nvl((select mgoat.organization_id from mo_glob_org_access_tmp mgoat where mgoat.organization_id=nvl(fnd_profile.value('DEFAULT_ORG_ID'),mgoat.organization_id) and rownum=1),fnd_global.org_id) Y US Operating Unit Required Operating Unit restriction for reports working in single operating unit mode only 3 10 :p_title Char AR العنوان العنوان D Titel Titel E Título Título F Titre Titre I Titolo Titolo JA タイトル タイトル KO 제목 제목 PTB Título Título RU Название Название S Titel Titel TR Başlık Başlık US Title Title ZHS 标题 标题 4 20 :p_period LOV Oracle PO_SRS_PERIOD_NAME Y select gl.period_name id, gl.period_name value, null description from gl_period_statuses gl,financials_system_parameters fsp where gl.application_id=201 and gl.set_of_books_id=fsp.set_of_books_id order by value,description Y AR الفترة الفترة D Periode Periode E Período Período F Période Période I Periodo Periodo JA 期間 期間 KO 기간 기간 PTB Período Período RU Период Период TR Dönem Dönem US Period Period ZHS 期间 期间 5 30 :p_po_number_from LOV Oracle PO_SRS_PO_NUMBER Y select poh.segment1 id, poh.segment1 value, null description from po_headers poh,po_system_parameters posp where poh.type_lookup_code in ('STANDARD','PLANNED', 'BLANKET','CONTRACT') order by decode(posp.manual_po_num_type,'NUMERIC', to_number(poh.segment1)), decode(posp.manual_po_num_type,'ALPHANUMERIC', poh.segment1) AR أرقام أوامر الشراء من أرقام أوامر الشراء من D Von Bestellnummer Von Bestellnummer E De Número de Pedido De Número de Pedido F Numéros de commande - De Numéros de commande - De I Numeri OA - Da Numeri OA - Da JA 発注番号:自 発注番号:自 KO PO 번호-부터: PO 번호-부터: PTB Números de OC - De Números de OC - De RU Номера ЗП с Номера ЗП с S Från IO-nummer Från IO-nummer TR SS Numaraları, İlk SS Numaraları, İlk US PO Numbers From PO Numbers From ZHS PO 编号自 PO 编号自 6 40 :p_po_number_to LOV Oracle PO_SRS_PO_NUMBER Y select poh.segment1 id, poh.segment1 value, null description from po_headers poh,po_system_parameters posp where poh.type_lookup_code in ('STANDARD','PLANNED', 'BLANKET','CONTRACT') order by decode(posp.manual_po_num_type,'NUMERIC', to_number(poh.segment1)), decode(posp.manual_po_num_type,'ALPHANUMERIC', poh.segment1) AR إلى أرقام أوامر الشراء إلى D Bis Bis Bestellnummer E A A Número de Pedido F A Numéros de commande - A I A Numeri OA - A JA 至 発注番号:至 KO 까지 PO 번호: 까지 PTB Até Números de OC - Até RU По Номера ЗП по S Till IO-nummer till TR Son SS Numaraları: Son US To PO Numbers To ZHS 至 PO 编号至 7 50 :p_vendor_from LOV Oracle PO_SRS_VENDOR_NAME Y Y select vendor_name id, vendor_name value, null description from po_vendors order by vendor_name AR الموردون من الموردون من D Von Lieferant Von Lieferant E De Proveedor De Proveedor F Fournisseurs - De Fournisseurs - De I Fornitori - Da Fornitori - Da JA 仕入先:自 仕入先:自 KO 공급자: 부터 공급자: 부터 PTB Fornecedores - De Fornecedores - De RU Поставщики с Поставщики с S Från leverantörer Från leverantörer TR Tedarikçiler, İlk Tedarikçiler, İlk US Vendors From Vendors From ZHS 供应商自 供应商自 8 60 :p_vendor_to LOV Oracle PO_SRS_VENDOR_NAME Y Y select vendor_name id, vendor_name value, null description from po_vendors order by vendor_name AR إلى 2 موردون إلى D Bis 2 Bis Lieferant E A 2 A Proveedor F A 2 Fournisseurs - A I A 2 Fornitori - A JA 至 2 仕入先:至 KO 까지 2 공급자: 까지 PTB Até 2 Fornecedores - Até RU По 2 Поставщики по S Till 2 Leverantörer till TR Son 2 Tedarikçiler: Son US To 2 Vendors To ZHS 至 2 供应商至 9 70 :p_buyer LOV Oracle PO_SRS_BUYER_NAME_NUM Y select buyer_id id, buyer_info value, null description from po_buyer_name_num_v order by buyer_info AR اسم المشتري اسم المشتري D Einkäufername Einkäufername E Nombre de Comprador Nombre de Comprador F Nom de l'acheteur Nom de l'acheteur I Nome buyer Nome buyer JA 購買担当名 購買担当名 KO 구매자명 구매자명 PTB Nome do Comprador Nome do Comprador RU Имя покупателя Имя покупателя S Köpare Köpare TR Satın Alan Adı Satın Alan Adı US Buyer Name Buyer Name ZHS 采购员姓名 采购员姓名 10 80 :p_category_from Char AR الفئات من الفئات من D Von Kategorie Von Kategorie E De Categoría De Categoría F Catégories - De Catégories - De I Categorie - Da Categorie - Da JA カテゴリ:自 カテゴリ:自 KO 범주: 부터 범주: 부터 PTB Categorias - De Categorias - De RU Категории с Категории с S Från kategorier Från kategorier TR Kategoriler, İlk Kategoriler, İlk US Categories From Categories From ZHS 类别自 类别自 11 90 :p_category_to Char AR إلى 3 الفئات إلى D Bis 3 Bis Kategorie E A 3 A Categoría F A 3 Catégories - A I A 3 Categorie - A JA 至 3 カテゴリ:至 KO 까지 3 범주: 까지 PTB Até 3 Categorias - Até RU По 3 Категории по S Till 3 Till kategorier TR Son 3 Kategoriler: Son US To 3 Categories To ZHS 至 3 类别至 12 100 :p_sort LOV Oracle PO_SRS_POXPOCOM_SORT Y select lookup_code id, displayed_field value, null description from po_lookup_codes where lookup_type='SRS ORDER BY' and lookup_code in ('VENDOR','BUYER') order by displayed_field AR فرز بواسطة فرز بواسطة D Sortieren nach Sortieren nach E Ordenar por Ordenar por F Tri par Tri par I Ordina per Ordina per JA ソート・キー ソート・キー KO 정렬 기준 정렬 기준 PTB Classificar por Classificar por RU Сортировка Сортировка S Sortera efter Sortera efter TR Sıralama Esası Sıralama Esası US Sort By Sort By ZHS 排序依据 排序依据