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）限制的操作单元。 C6E085D471C151A9E05362FB09050512Y SELECT decode(:P_orderby,'RFQ NUMBER',null,poh.buyer_last_name) ,decode(:P_orderby,'RFQ NUMBER',null,poh.buyer_first_name) ,decode(:rfq_num_type,'NUMERIC',null,poh.rfq_num) ,decode(:rfq_num_type,'NUMERIC',decode(rtrim(poh.rfq_num,'0123456789'),NULL,to_number(poh.rfq_num),-1),null) ,poh.rfq_num poh_rfq_num ,poh.revision_num poh_revision_num ,poh.creation_date poh_creation_date ,poh.printed_date poh_printed_date ,poh.revised_date poh_revised_date ,poh.close_date poh_close_date ,poh.reply_by_date poh_reply_by_date ,poh.effective_date poh_effective_date ,poh.expiration_date poh_expiration_date ,poh.note_to_vendor poh_note_to_vendor ,substr(poh.buyer_first_name,1,1) ||' '||poh.buyer_last_name poh_buyer ,poh.ship_via poh_ship_via ,poh.fob poh_fob ,poh.freight_terms poh_freight_terms ,poh.reply_via poh_reply_via ,poh.payment_terms poh_payment_terms ,poh.customer_num poh_customer_num ,poh.vendor_num poh_vendor_num ,poh.vendor_name poh_vendor_name ,poh.vendor_address_line1 poh_vendor_address_line1 ,poh.vendor_address_line2 poh_vendor_address_line2 ,poh.vendor_address_line3 poh_vendor_address_line3 ,poh.vendor_city ||', '||poh.vendor_state ||' '|| poh.vendor_postal_code poh_vendor_adr_info ,poh.vendor_country poh_vendor_country ,poh.vendor_phone poh_vendor_phone ,poh.vendor_contact_first_name ||' '|| poh.vendor_contact_last_name poh_vendor_contact_name ,poh.vendor_contact_phone poh_vendor_contact_phone ,poh.ship_address_line1 poh_ship_address_line1 ,poh.ship_address_line2 poh_ship_address_line2 ,poh.ship_address_line3 poh_ship_address_line3 ,poh.ship_city ||', '||poh.ship_state_province||' '|| poh.ship_postal_code poh_ship_adr_info ,poh.ship_country poh_ship_country ,poh.bill_address_line1 poh_bill_address_line1 ,poh.bill_address_line2 poh_bill_address_line2 ,poh.bill_address_line3 poh_bill_address_line3 ,poh.bill_city ||', '||poh.bill_state_province||' '|| poh.bill_postal_code poh_bill_adr_info ,poh.bill_city poh_bill_city ,poh.bill_state_province poh_bill_state_province ,poh.bill_postal_code poh_bill_postal_code ,poh.bill_country poh_bill_country ,poh.bill_to_location_id poh_bill_to_location_id ,poh.ship_to_location_id poh_ship_to_location_id ,poh.agent_id poh_agent_id ,poh.po_header_id poh_po_header_id ,poh.agent_id poh_agent_id ,poh.currency_code c_header_currency ,poh.sequence_num poh_sequence_num, PO_POXPRRFP_XMLP_PKG.c_fax_trailerformula(:poh_no_of_lines,:C_last_sum,:CS_poh_vendor_name,:CS_poh_rfq_num,:CS_poh_buyer,:CS_poh_agent_id) C_fax_trailer, PO_POXPRRFP_XMLP_PKG.c_fax_headerformula(:C_first_page) C_fax_header FROM po_rfq_headers_print poh WHERE poh.agent_id=nvl(:P_agent_id,poh.agent_id) AND :P_single_rfq_print=1 AND poh.rfq_num=:P_rfq_num_from &where_clause &p_language_where UNION ALL SELECT decode(:P_orderby,'RFQ NUMBER',null,poh.buyer_last_name) ,decode(:P_orderby,'RFQ NUMBER',null,poh.buyer_first_name) ,decode(:rfq_num_type,'NUMERIC',null,poh.rfq_num) ,decode(:rfq_num_type,'NUMERIC',decode(rtrim(poh.rfq_num,'0123456789'),NULL,to_number(poh.rfq_num),-1),null) ,poh.rfq_num poh_rfq_num ,poh.revision_num poh_revision_num ,poh.creation_date poh_creation_date ,poh.printed_date poh_printed_date ,poh.revised_date poh_revised_date ,poh.close_date poh_close_date ,poh.reply_by_date poh_reply_by_date ,poh.effective_date poh_effective_date ,poh.expiration_date poh_expiration_date ,poh.note_to_vendor poh_note_to_vendor ,substr(poh.buyer_first_name,1,1) ||' '||poh.buyer_last_name poh_buyer ,poh.ship_via poh_ship_via ,poh.fob poh_fob ,poh.freight_terms poh_freight_terms ,poh.reply_via poh_reply_via ,poh.payment_terms poh_payment_terms ,poh.customer_num poh_customer_num ,poh.vendor_num poh_vendor_num ,poh.vendor_name poh_vendor_name ,poh.vendor_address_line1 poh_vendor_address_line1 ,poh.vendor_address_line2 poh_vendor_address_line2 ,poh.vendor_address_line3 poh_vendor_address_line3 ,poh.vendor_city ||', '||poh.vendor_state ||' '|| poh.vendor_postal_code poh_vendor_adr_info ,poh.vendor_country poh_vendor_country ,poh.vendor_phone poh_vendor_phone ,poh.vendor_contact_first_name ||' '|| poh.vendor_contact_last_name poh_vendor_contact_name ,poh.vendor_contact_phone poh_vendor_contact_phone ,poh.ship_address_line1 poh_ship_address_line1 ,poh.ship_address_line2 poh_ship_address_line2 ,poh.ship_address_line3 poh_ship_address_line3 ,poh.ship_city ||', '||poh.ship_state_province||' '|| poh.ship_postal_code poh_ship_adr_info ,poh.ship_country poh_ship_country ,poh.bill_address_line1 poh_bill_address_line1 ,poh.bill_address_line2 poh_bill_address_line2 ,poh.bill_address_line3 poh_bill_address_line3 ,poh.bill_city ||', '||poh.bill_state_province||' '|| poh.bill_postal_code poh_bill_adr_info ,poh.bill_city poh_bill_city ,poh.bill_state_province poh_bill_state_province ,poh.bill_postal_code poh_bill_postal_code ,poh.bill_country poh_bill_country ,poh.bill_to_location_id poh_bill_to_location_id ,poh.ship_to_location_id poh_ship_to_location_id ,poh.agent_id poh_agent_id ,poh.po_header_id poh_po_header_id ,poh.agent_id poh_agent_id ,poh.currency_code c_header_currency ,poh.sequence_num poh_sequence_num, PO_POXPRRFP_XMLP_PKG.c_fax_trailerformula(:poh_no_of_lines,:C_last_sum,:CS_poh_vendor_name,:CS_poh_rfq_num,:CS_poh_buyer,:CS_poh_agent_id) C_fax_trailer, PO_POXPRRFP_XMLP_PKG.c_fax_headerformula(:C_first_page) C_fax_header FROM po_rfq_headers_print poh WHERE poh.agent_id=nvl(:P_agent_id,poh.agent_id) AND :P_single_rfq_print!=1 AND :rfq_num_type='NUMERIC' AND decode(rtrim(poh.rfq_num,'0123456789'),NULL,to_number(poh.rfq_num),-1) BETWEEN decode(rtrim(nvl(:P_rfq_num_from,poh.rfq_num),'0123456789'),NULL, to_number(nvl(:P_rfq_num_from,poh.rfq_num)),-1) AND decode(rtrim(nvl(:P_rfq_num_to,poh.rfq_num),'0123456789'),NULL, to_number(nvl(:P_rfq_num_to,poh.rfq_num)),-1) &where_clause &p_language_where UNION ALL SELECT decode(:P_orderby,'RFQ NUMBER',null,poh.buyer_last_name) ,decode(:P_orderby,'RFQ NUMBER',null,poh.buyer_first_name) ,decode(:rfq_num_type,'NUMERIC',null,poh.rfq_num) ,decode(:rfq_num_type,'NUMERIC',decode(rtrim(poh.rfq_num,'0123456789'),NULL,to_number(poh.rfq_num),-1),null) ,poh.rfq_num poh_rfq_num ,poh.revision_num poh_revision_num ,poh.creation_date poh_creation_date ,poh.printed_date poh_printed_date ,poh.revised_date poh_revised_date ,poh.close_date poh_close_date ,poh.reply_by_date poh_reply_by_date ,poh.effective_date poh_effective_date ,poh.expiration_date poh_expiration_date ,poh.note_to_vendor poh_note_to_vendor ,substr(poh.buyer_first_name,1,1) ||' '||poh.buyer_last_name poh_buyer ,poh.ship_via poh_ship_via ,poh.fob poh_fob ,poh.freight_terms poh_freight_terms ,poh.reply_via poh_reply_via ,poh.payment_terms poh_payment_terms ,poh.customer_num poh_customer_num ,poh.vendor_num poh_vendor_num ,poh.vendor_name poh_vendor_name ,poh.vendor_address_line1 poh_vendor_address_line1 ,poh.vendor_address_line2 poh_vendor_address_line2 ,poh.vendor_address_line3 poh_vendor_address_line3 ,poh.vendor_city ||', '||poh.vendor_state ||' '|| poh.vendor_postal_code poh_vendor_adr_info ,poh.vendor_country poh_vendor_country ,poh.vendor_phone poh_vendor_phone ,poh.vendor_contact_first_name ||' '|| poh.vendor_contact_last_name poh_vendor_contact_name ,poh.vendor_contact_phone poh_vendor_contact_phone ,poh.ship_address_line1 poh_ship_address_line1 ,poh.ship_address_line2 poh_ship_address_line2 ,poh.ship_address_line3 poh_ship_address_line3 ,poh.ship_city ||', '||poh.ship_state_province||' '|| poh.ship_postal_code poh_ship_adr_info ,poh.ship_country poh_ship_country ,poh.bill_address_line1 poh_bill_address_line1 ,poh.bill_address_line2 poh_bill_address_line2 ,poh.bill_address_line3 poh_bill_address_line3 ,poh.bill_city ||', '||poh.bill_state_province||' '|| poh.bill_postal_code poh_bill_adr_info ,poh.bill_city poh_bill_city ,poh.bill_state_province poh_bill_state_province ,poh.bill_postal_code poh_bill_postal_code ,poh.bill_country poh_bill_country ,poh.bill_to_location_id poh_bill_to_location_id ,poh.ship_to_location_id poh_ship_to_location_id ,poh.agent_id poh_agent_id ,poh.po_header_id poh_po_header_id ,poh.agent_id poh_agent_id ,poh.currency_code c_header_currency ,poh.sequence_num poh_sequence_num, PO_POXPRRFP_XMLP_PKG.c_fax_trailerformula(:poh_no_of_lines,:C_last_sum,:CS_poh_vendor_name,:CS_poh_rfq_num,:CS_poh_buyer,:CS_poh_agent_id) C_fax_trailer, PO_POXPRRFP_XMLP_PKG.c_fax_headerformula(:C_first_page) C_fax_header FROM po_rfq_headers_print poh WHERE poh.agent_id=nvl(:P_agent_id,poh.agent_id) AND :P_single_rfq_print!=1 AND :rfq_num_type='ALPHANUMERIC' AND :P_rfq_num_from IS NOT NULL AND :P_rfq_num_to IS NOT NULL AND poh.rfq_num>=:P_rfq_num_from AND poh.rfq_num<=:P_rfq_num_to &where_clause &p_language_where UNION ALL SELECT decode(:P_orderby,'RFQ NUMBER',null,poh.buyer_last_name) ,decode(:P_orderby,'RFQ NUMBER',null,poh.buyer_first_name) ,decode(:rfq_num_type,'NUMERIC',null,poh.rfq_num) ,decode(:rfq_num_type,'NUMERIC',decode(rtrim(poh.rfq_num,'0123456789'),NULL,to_number(poh.rfq_num),-1),null) ,poh.rfq_num poh_rfq_num ,poh.revision_num poh_revision_num ,poh.creation_date poh_creation_date ,poh.printed_date poh_printed_date ,poh.revised_date poh_revised_date ,poh.close_date poh_close_date ,poh.reply_by_date poh_reply_by_date ,poh.effective_date poh_effective_date ,poh.expiration_date poh_expiration_date ,poh.note_to_vendor poh_note_to_vendor ,substr(poh.buyer_first_name,1,1) ||' '||poh.buyer_last_name poh_buyer ,poh.ship_via poh_ship_via ,poh.fob poh_fob ,poh.freight_terms poh_freight_terms ,poh.reply_via poh_reply_via ,poh.payment_terms poh_payment_terms ,poh.customer_num poh_customer_num ,poh.vendor_num poh_vendor_num ,poh.vendor_name poh_vendor_name ,poh.vendor_address_line1 poh_vendor_address_line1 ,poh.vendor_address_line2 poh_vendor_address_line2 ,poh.vendor_address_line3 poh_vendor_address_line3 ,poh.vendor_city ||', '||poh.vendor_state ||' '|| poh.vendor_postal_code poh_vendor_adr_info ,poh.vendor_country poh_vendor_country ,poh.vendor_phone poh_vendor_phone ,poh.vendor_contact_first_name ||' '|| poh.vendor_contact_last_name poh_vendor_contact_name ,poh.vendor_contact_phone poh_vendor_contact_phone ,poh.ship_address_line1 poh_ship_address_line1 ,poh.ship_address_line2 poh_ship_address_line2 ,poh.ship_address_line3 poh_ship_address_line3 ,poh.ship_city ||', '||poh.ship_state_province||' '|| poh.ship_postal_code poh_ship_adr_info ,poh.ship_country poh_ship_country ,poh.bill_address_line1 poh_bill_address_line1 ,poh.bill_address_line2 poh_bill_address_line2 ,poh.bill_address_line3 poh_bill_address_line3 ,poh.bill_city ||', '||poh.bill_state_province||' '|| poh.bill_postal_code poh_bill_adr_info ,poh.bill_city poh_bill_city ,poh.bill_state_province poh_bill_state_province ,poh.bill_postal_code poh_bill_postal_code ,poh.bill_country poh_bill_country ,poh.bill_to_location_id poh_bill_to_location_id ,poh.ship_to_location_id poh_ship_to_location_id ,poh.agent_id poh_agent_id ,poh.po_header_id poh_po_header_id ,poh.agent_id poh_agent_id ,poh.currency_code c_header_currency ,poh.sequence_num poh_sequence_num, PO_POXPRRFP_XMLP_PKG.c_fax_trailerformula(:poh_no_of_lines,:C_last_sum,:CS_poh_vendor_name,:CS_poh_rfq_num,:CS_poh_buyer,:CS_poh_agent_id) C_fax_trailer, PO_POXPRRFP_XMLP_PKG.c_fax_headerformula(:C_first_page) C_fax_header FROM po_rfq_headers_print poh WHERE poh.agent_id=nvl(:P_agent_id,poh.agent_id) AND :P_single_rfq_print!=1 AND :rfq_num_type='ALPHANUMERIC' AND :P_rfq_num_from IS NOT NULL AND :P_rfq_num_to IS NULL AND poh.rfq_num>=:P_rfq_num_from &where_clause &p_language_where UNION ALL SELECT decode(:P_orderby,'RFQ NUMBER',null,poh.buyer_last_name) ,decode(:P_orderby,'RFQ NUMBER',null,poh.buyer_first_name) ,decode(:rfq_num_type,'NUMERIC',null,poh.rfq_num) ,decode(:rfq_num_type,'NUMERIC',decode(rtrim(poh.rfq_num,'0123456789'),NULL,to_number(poh.rfq_num),-1),null) ,poh.rfq_num poh_rfq_num ,poh.revision_num poh_revision_num ,poh.creation_date poh_creation_date ,poh.printed_date poh_printed_date ,poh.revised_date poh_revised_date ,poh.close_date poh_close_date ,poh.reply_by_date poh_reply_by_date ,poh.effective_date poh_effective_date ,poh.expiration_date poh_expiration_date ,poh.note_to_vendor poh_note_to_vendor ,substr(poh.buyer_first_name,1,1) ||' '||poh.buyer_last_name poh_buyer ,poh.ship_via poh_ship_via ,poh.fob poh_fob ,poh.freight_terms poh_freight_terms ,poh.reply_via poh_reply_via ,poh.payment_terms poh_payment_terms ,poh.customer_num poh_customer_num ,poh.vendor_num poh_vendor_num ,poh.vendor_name poh_vendor_name ,poh.vendor_address_line1 poh_vendor_address_line1 ,poh.vendor_address_line2 poh_vendor_address_line2 ,poh.vendor_address_line3 poh_vendor_address_line3 ,poh.vendor_city ||', '||poh.vendor_state ||' '|| poh.vendor_postal_code poh_vendor_adr_info ,poh.vendor_country poh_vendor_country ,poh.vendor_phone poh_vendor_phone ,poh.vendor_contact_first_name ||' '|| poh.vendor_contact_last_name poh_vendor_contact_name ,poh.vendor_contact_phone poh_vendor_contact_phone ,poh.ship_address_line1 poh_ship_address_line1 ,poh.ship_address_line2 poh_ship_address_line2 ,poh.ship_address_line3 poh_ship_address_line3 ,poh.ship_city ||', '||poh.ship_state_province||' '|| poh.ship_postal_code poh_ship_adr_info ,poh.ship_country poh_ship_country ,poh.bill_address_line1 poh_bill_address_line1 ,poh.bill_address_line2 poh_bill_address_line2 ,poh.bill_address_line3 poh_bill_address_line3 ,poh.bill_city ||', '||poh.bill_state_province||' '|| poh.bill_postal_code poh_bill_adr_info ,poh.bill_city poh_bill_city ,poh.bill_state_province poh_bill_state_province ,poh.bill_postal_code poh_bill_postal_code ,poh.bill_country poh_bill_country ,poh.bill_to_location_id poh_bill_to_location_id ,poh.ship_to_location_id poh_ship_to_location_id ,poh.agent_id poh_agent_id ,poh.po_header_id poh_po_header_id ,poh.agent_id poh_agent_id ,poh.currency_code c_header_currency ,poh.sequence_num poh_sequence_num, PO_POXPRRFP_XMLP_PKG.c_fax_trailerformula(:poh_no_of_lines,:C_last_sum,:CS_poh_vendor_name,:CS_poh_rfq_num,:CS_poh_buyer,:CS_poh_agent_id) C_fax_trailer, PO_POXPRRFP_XMLP_PKG.c_fax_headerformula(:C_first_page) C_fax_header FROM po_rfq_headers_print poh WHERE poh.agent_id=nvl(:P_agent_id,poh.agent_id) AND :P_single_rfq_print!=1 AND :rfq_num_type='ALPHANUMERIC' AND :P_rfq_num_from IS NULL AND :P_rfq_num_to IS NOT NULL AND poh.rfq_num<=:P_rfq_num_to &where_clause &p_language_where UNION ALL SELECT decode(:P_orderby,'RFQ NUMBER',null,poh.buyer_last_name) ,decode(:P_orderby,'RFQ NUMBER',null,poh.buyer_first_name) ,decode(:rfq_num_type,'NUMERIC',null,poh.rfq_num) ,decode(:rfq_num_type,'NUMERIC',decode(rtrim(poh.rfq_num,'0123456789'),NULL,to_number(poh.rfq_num),-1),null) ,poh.rfq_num poh_rfq_num ,poh.revision_num poh_revision_num ,poh.creation_date poh_creation_date ,poh.printed_date poh_printed_date ,poh.revised_date poh_revised_date ,poh.close_date poh_close_date ,poh.reply_by_date poh_reply_by_date ,poh.effective_date poh_effective_date ,poh.expiration_date poh_expiration_date ,poh.note_to_vendor poh_note_to_vendor ,substr(poh.buyer_first_name,1,1) ||' '||poh.buyer_last_name poh_buyer ,poh.ship_via poh_ship_via ,poh.fob poh_fob ,poh.freight_terms poh_freight_terms ,poh.reply_via poh_reply_via ,poh.payment_terms poh_payment_terms ,poh.customer_num poh_customer_num ,poh.vendor_num poh_vendor_num ,poh.vendor_name poh_vendor_name ,poh.vendor_address_line1 poh_vendor_address_line1 ,poh.vendor_address_line2 poh_vendor_address_line2 ,poh.vendor_address_line3 poh_vendor_address_line3 ,poh.vendor_city ||', '||poh.vendor_state ||' '|| poh.vendor_postal_code poh_vendor_adr_info ,poh.vendor_country poh_vendor_country ,poh.vendor_phone poh_vendor_phone ,poh.vendor_contact_first_name ||' '|| poh.vendor_contact_last_name poh_vendor_contact_name ,poh.vendor_contact_phone poh_vendor_contact_phone ,poh.ship_address_line1 poh_ship_address_line1 ,poh.ship_address_line2 poh_ship_address_line2 ,poh.ship_address_line3 poh_ship_address_line3 ,poh.ship_city ||', '||poh.ship_state_province||' '|| poh.ship_postal_code poh_ship_adr_info ,poh.ship_country poh_ship_country ,poh.bill_address_line1 poh_bill_address_line1 ,poh.bill_address_line2 poh_bill_address_line2 ,poh.bill_address_line3 poh_bill_address_line3 ,poh.bill_city ||', '||poh.bill_state_province||' '|| poh.bill_postal_code poh_bill_adr_info ,poh.bill_city poh_bill_city ,poh.bill_state_province poh_bill_state_province ,poh.bill_postal_code poh_bill_postal_code ,poh.bill_country poh_bill_country ,poh.bill_to_location_id poh_bill_to_location_id ,poh.ship_to_location_id poh_ship_to_location_id ,poh.agent_id poh_agent_id ,poh.po_header_id poh_po_header_id ,poh.agent_id poh_agent_id ,poh.currency_code c_header_currency ,poh.sequence_num poh_sequence_num, PO_POXPRRFP_XMLP_PKG.c_fax_trailerformula(:poh_no_of_lines,:C_last_sum,:CS_poh_vendor_name,:CS_poh_rfq_num,:CS_poh_buyer,:CS_poh_agent_id) C_fax_trailer, PO_POXPRRFP_XMLP_PKG.c_fax_headerformula(:C_first_page) C_fax_header FROM po_rfq_headers_print poh WHERE poh.agent_id=nvl(:P_agent_id,poh.agent_id) AND :P_single_rfq_print!=1 AND :rfq_num_type='ALPHANUMERIC' AND :P_rfq_num_from IS NULL AND :P_rfq_num_to IS NULL &where_clause &p_language_where ORDER BY 1,2,3,4 PO POXPRRFP_XML AR PO تقرير طلب عرض أسعار مطبوع (بتنسيق XML) Imported from BI Publisher Description: تقرير طلب أسعار مطبوع (عمودي) Application: المشتريات Source: تقرير طلب عرض أسعار مطبوع (بتنسيق XML) Short Name: POXPRRFP_XML DB package: PO_POXPRRFP_XMLP_PKG D PO Angebotsanfragen - gedruckt Imported from BI Publisher Description: Angebotsanfragen - gedruckt (Hochformat) Application: Einkauf Source: Angebotsanfragen - gedruckt (XML) Short Name: POXPRRFP_XML DB package: PO_POXPRRFP_XMLP_PKG E PO Informe Impresión de Peticiones de Oferta Imported from BI Publisher Description: Impresión de Peticiones de Oferta (Vertical) Application: Purchasing Source: Informe Impresión de Peticiones de Oferta (XML) Short Name: POXPRRFP_XML DB package: PO_POXPRRFP_XMLP_PKG F PO Etat d'impression des appels d'offres Imported from BI Publisher Description: Etat d'impression des appels d'offres (portrait) Application: Purchasing Source: Etat d'impression des appels d'offres (XML) Short Name: POXPRRFP_XML DB package: PO_POXPRRFP_XMLP_PKG I PO Rapporto RP stampato Imported from BI Publisher Description: Rapporto RP stampate (verticale) Application: Purchasing Source: Rapporto RP stampato (XML) Short Name: POXPRRFP_XML DB package: PO_POXPRRFP_XMLP_PKG JA PO 印刷済見積依頼レポート Imported from BI Publisher Description: 印刷済見積依頼レポート(縦長) Application: Purchasing Source: 印刷済見積依頼レポート(XML) Short Name: POXPRRFP_XML DB package: PO_POXPRRFP_XMLP_PKG KO PO 인쇄된 견적 요청 보고서 Imported from BI Publisher Description: 인쇄된 견적요청 보고서 (세로) Application: Purchasing Source: 인쇄된 견적 요청 보고서(XML) Short Name: POXPRRFP_XML DB package: PO_POXPRRFP_XMLP_PKG PTB PO Relatório de SDC Impresso Imported from BI Publisher Description: Relatório de SDC Impresso(Retrato) Application: Compra Source: Relatório de SDC Impresso (XML) Short Name: POXPRRFP_XML DB package: PO_POXPRRFP_XMLP_PKG RU PO Печатный отчет о ЗаК Imported from BI Publisher Description: Отчет о печати ЗаК (книжная ориентация) Application: Закупки Source: Печатный отчет о ЗаК (XML) Short Name: POXPRRFP_XML DB package: PO_POXPRRFP_XMLP_PKG S PO Utskrift av offertförfrågan Imported from BI Publisher Description: Utskrift av offertförfrågan (stående) Application: Purchasing Source: Utskrift av offertförfrågan (XML) Short Name: POXPRRFP_XML DB package: PO_POXPRRFP_XMLP_PKG TR PO Yazdırılmış Fiyat Teklif Talebi Raporu Imported from BI Publisher Description: Yazdırılmış RFQ Raporu (Dikey) Application: Satın Alma Yönetimi Source: Yazdırılmış Fiyat Teklif Talebi Raporu (XML) Short Name: POXPRRFP_XML DB package: PO_POXPRRFP_XMLP_PKG US PO Printed RFQ Imported from BI Publisher Description: Printed RFQ Report(Portrait) Application: Purchasing Source: Printed RFQ Report (XML) Short Name: POXPRRFP_XML DB package: PO_POXPRRFP_XMLP_PKG ZHS PO 已打印的询价报表 Imported from BI Publisher Description: 已打印的询价报表（纵向） Application: 采购管理系统 Source: 已打印的询价报表 (XML) Short Name: POXPRRFP_XML DB package: PO_POXPRRFP_XMLP_PKG BI Publisher &p_language_where &where_clause :c_address_at_top :c_first_page :c_last_sum :cs_poh_agent_id :cs_poh_buyer :cs_poh_rfq_num :cs_poh_vendor_name :mls_flag :operating_unit :p_agent_id :p_conc_request_id :p_description :p_fax_enable :p_fax_num :p_flex_item :p_language_where :p_orderby :p_qty_ordered :p_qty_precision :p_release_date_from :p_release_date_to :p_release_num_from :p_release_num_to :p_report_type :p_rfq_num_from :p_rfq_num_to :p_single_rfq_print :p_test_flag :p_uom_col_pll :p_uom_col_pol :p_uom_join_pll :p_uom_join_pol :p_user_id :po_header_id :po_item :poh_no_of_lines :rfq_num_type :temp_col_name 1 -20 :p_user_id Number fnd_profile.value('USER_ID') Y AR معرف المستخدم معرف المستخدم D Benutzerkennung Benutzerkennung E Id Usuario Id Usuario F ID utilisateur ID utilisateur I ID utente ID utente JA ユーザーID ユーザーID KO 사용자 ID 사용자 ID PTB Id do Usuário Id do Usuário RU Идентификатор пользователя Идентификатор пользователя S Användar-id Användar-id TR Kullanıcı No Kullanıcı No US User Id User Id ZHS 用户标识 用户标识 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_report_type LOV Oracle PO_SRS_POXPRPOP_PRINT_OPTION Y select lookup_code id, displayed_field value, null description from po_lookup_codes where lookup_type='PRINT CHOICE' order by displayed_field Y AR نوع التقرير اختيار الطباعة D Auswertungsart Druckauswahl E Tipo de Informe Imprimir Selección F Type d'état Sélection pour impression I Tipo di rapporto Stampa selezione JA レポート・タイプ 印刷選択 KO 보고서 유형 인쇄 선택 PTB Tipo de relatório Imprimir Seleção RU Тип отчета Печать выборки S Rapporttyp Utskriftsurval TR Rapor Tipi Seçimi Yazdır US Report Type Print Selection ZHS 报表类型 打印选择 4 20 :p_agent_id 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äufer, Personalnummer Einkäufer, Personalnummer (Kennung) E Nombre de Comprador, Número de Empleado Nombre de Comprador, Número de Empleado (Id Transferencia) F Nom de l'acheteur, matricule de l'employé Nom de l'acheteur, matricule de l'employé (transmet l'ID) I Nome buyer, numero dipendente Nome buyer, numero dipendente (ID passante) JA 購買担当名、従業員番号 購買担当名、従業員番号(パスID) KO 구매자명, 사원 번호 구매자명, 사원 번호 (통과 ID) PTB Nome do Comprador, Número do Funcionário Nome do Comprador, Número do Funcionário (ID de aprovação) RU Имя покупателя, номер работника Имя покупателя, номер работника (передается идентификатор) S Namn på inköpare, anställningsnummer Namn på inköpare, anställningsnummer (godkänt id) TR Satın Alan Adı, Çalışan Numarası Satın Alan Adı, Çalışan Numarası (iletim No) US Buyer Name, Employee Number Buyer Name, Employee Number (passing ID) ZHS 采购员姓名；员工编号 采购员姓名；员工编号（通行标识） 5 30 :p_rfq_num_from LOV Oracle PO_SRS_SECURITY_RFQ_NUMBER Y select ph.segment1 id, ph.segment1 value, null description from po_headers ph,po_document_types podt,fnd_user fnd,po_system_parameters psp where fnd.user_id=fnd_global.user_id and fnd.employee_id is not null and ph.type_lookup_code='RFQ' and ph.status_lookup_code in ('A','P') and podt.document_type_code=ph.type_lookup_code and podt.document_subtype='STANDARD' and (ph.agent_id=fnd.employee_id or podt.security_level_code='PUBLIC' or (podt.security_level_code='PURCHASING' and exists (select 'Is the user an agent' from po_agents poa where poa.agent_id= fnd.employee_id and sysdate between nvl(poa.start_date_active, sysdate) and nvl(poa.end_date_active, sysdate+1) ) ) or (podt.security_level_code='HIERARCHY' and fnd.employee_id in (select poeh.superior_id from po_employee_hierarchies poeh where poeh.employee_id= ph.agent_id and poeh.position_structure_id= psp.security_position_structure_id ) ) ) order by decode(psp.manual_rfq_num_type,'ALPHANUMERIC', segment1,null), decode(psp.manual_rfq_num_type,'NUMERIC', to_number(segment1),null) AR أرقام طلبات الأسعار من أرقام طلبات الأسعار من D Von Angebotsanfragenummer Von Angebotsanfragenummer E De Número de Petición de Oferta De Número de Petición de Oferta F Numéros d'appel d'offres - De Numéros d'appel d'offres - De I Numeri RP - Da Numeri RP - Da JA 見積依頼番号:自 見積依頼番号:自 KO 견적요청 번호: 부터 견적요청 번호: 부터 PTB Números de SDC - De Números de SDC - De RU Номера ЗаК с Номера ЗаК с S Offertförfrågannr från Offertförfrågannr från TR RFQ Numaraları: İlk RFQ Numaraları: İlk US RFQ Numbers From RFQ Numbers From ZHS 询价编号自 询价编号自 6 40 :p_rfq_num_to LOV Oracle PO_SRS_SECURITY_RFQ_NUMBER Y select ph.segment1 id, ph.segment1 value, null description from po_headers ph,po_document_types podt,fnd_user fnd,po_system_parameters psp where fnd.user_id=fnd_global.user_id and fnd.employee_id is not null and ph.type_lookup_code='RFQ' and ph.status_lookup_code in ('A','P') and podt.document_type_code=ph.type_lookup_code and podt.document_subtype='STANDARD' and (ph.agent_id=fnd.employee_id or podt.security_level_code='PUBLIC' or (podt.security_level_code='PURCHASING' and exists (select 'Is the user an agent' from po_agents poa where poa.agent_id= fnd.employee_id and sysdate between nvl(poa.start_date_active, sysdate) and nvl(poa.end_date_active, sysdate+1) ) ) or (podt.security_level_code='HIERARCHY' and fnd.employee_id in (select poeh.superior_id from po_employee_hierarchies poeh where poeh.employee_id= ph.agent_id and poeh.position_structure_id= psp.security_position_structure_id ) ) ) order by decode(psp.manual_rfq_num_type,'ALPHANUMERIC', segment1,null), decode(psp.manual_rfq_num_type,'NUMERIC', to_number(segment1),null) AR إلى إلى D Bis Bis E A A F A A I A A JA 至 至 KO 까지 까지 PTB Até Até RU По По S Till Till TR Son Son US To To ZHS 至 至 7 50 :p_test_flag LOV Oracle AP_SRS_YES_NO_OPT Y select lookup_code id, meaning value, null description from fnd_lookups where lookup_type='YES_NO' order by value,description AR اختبار اختبار D Testen Testen E Prueba Prueba F Tester Tester I Prova Prova JA テスト テスト KO 테스트 테스트 PTB Teste Teste RU Проверка Проверка S Testa Testa US Test Test ZHS 测试 测试 8 60 :p_orderby LOV Oracle PO_SRS_POXPRRFL_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 ('RFQ NUMBER','BUYER') order by value,description 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 排序依据 排序依据 9 70 :p_fax_enable LOV Oracle FAX_ENABLE_Y_N Y select ffvv.flex_value id, ffvv.flex_value value, ffvv.flex_value_meaning||nvl2(ffvv.description,': '||ffvv.description,null) description from fnd_flex_values_vl ffvv where ffvv.flex_value_set_id=109260 order by ffvv.flex_value N AR تمكين الفاكس تمكين الفاكس D Fax aktivieren Fax aktivieren E Fax Activado Fax Activado F Fax activé Fax activé I Abilita fax Abilita fax JA FAX使用可能 FAX使用可能 KO 팩스 사용가능 팩스 사용가능 PTB Ativar Fax Ativar Fax RU Факс включен Факс включен S Utskrift till fax Utskrift till fax TR Faks Etkin Faks Etkin US Fax Enable Fax Enable ZHS 启用传真 启用传真 10 80 :p_fax_num Char AR رقم الفاكس رقم الفاكس D Faxnummer Faxnummer E Número de Fax Número de Fax F Numéro de fax Numéro de fax I Numero fax Numero fax JA FAX番号 FAX番号 KO 팩스 번호 팩스 번호 PTB Nº do Fax Nº do Fax RU Номер факса Номер факса S Faxnummer Faxnummer TR Faks Numarası Faks Numarası US Fax Number Fax Number ZHS 传真号码 传真号码