ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F3B83869E053B46B63588994 SELECT gsb.name Set_of_Books , fsp.user_defined_vendor_num_code Vendor_Number_Entry , fsp.manual_vendor_num_type Vendor_Number_Type , (puc.current_max_unique_identifier + 1) Next_Automatic_Vendor_Number , decode(fsp.rfq_only_site_flag,'Y',:yes,'N',:no,null) RFQ_Only_Site , lot1.location_code Ship_to_Location , lot2.location_code Bill_to_Location , fsp.ship_via_lookup_code Ship_via , fsp.fob_lookup_code FOB , fsp.freight_terms_lookup_code Freight_Terms , to_number('') Quantity_Received_Tolerance , ood.organization_name Inventory_Organization , apt.name Terms , decode(fsp.req_encumbrance_flag,'Y',:yes,'N',:no,null) Use_Requisition_Encumbrance , get1.encumbrance_type Requisition_Encumbrance_Type , decode(fsp.purch_encumbrance_flag,'Y',:yes,'N',:no,null) Use_Purchase_Order_Encumbrance , get2.encumbrance_type Purchase_Order_Encumbrance_Ty , decode(fsp.reserve_at_completion_flag,'Y',:yes,'N',:no,null) Reserve_at_Completion , pbg.name Business_Group , decode(fsp.use_positions_flag,'Y',:yes,'N',:no,null) Use_Approval_Hierarchies , fsp.receipt_acceptance_days &select_rev FROM financials_system_parameters fsp , gl_sets_of_books gsb , po_unique_identifier_control puc , hr_locations_all_tl lot1 , hr_locations_all_tl lot2 , org_organization_definitions ood , ap_terms apt , gl_encumbrance_types get1 , gl_encumbrance_types get2 , per_business_groups pbg , hr_lookups hlo &from_rev WHERE puc.table_name = 'PO_VENDORS' AND fsp.ship_to_location_id = lot1.location_id(+) AND fsp.bill_to_location_id = lot2.location_id(+) AND LOT1.LANGUAGE(+) = USERENV('LANG') AND LOT2.LANGUAGE(+) = USERENV('LANG') AND fsp.inventory_organization_id = ood.organization_id (+) AND fsp.terms_id = apt.term_id(+) AND fsp.req_encumbrance_type_id = get1.encumbrance_type_id (+) AND fsp.purch_encumbrance_type_id = get2.encumbrance_type_id (+) AND (fsp.business_group_id = pbg.business_group_id AND hlo.lookup_type = 'EMP_NUM_GEN_METHOD' AND pbg.method_of_generation_emp_num = hlo.lookup_code) AND gsb.set_of_books_id = fsp.set_of_books_id &where_rev Y PO POXFIPOL_XML AR PO قائمة خيارات المشتريات/الماليات (بتنسيق XML) Application: المشتريات Source: قائمة خيارات المشتريات/الماليات (بتنسيق XML) Short Name: POXFIPOL_XML DB package: PO_POXFIPOL_XMLP_PKG D PO Einkauf - Optionen Application: Einkauf Source: Einkauf - Optionen (XML) Short Name: POXFIPOL_XML DB package: PO_POXFIPOL_XMLP_PKG F PO Liste des options Financials/Purchasing Application: Purchasing Source: Liste des options Financials/Purchasing (XML) Short Name: POXFIPOL_XML DB package: PO_POXFIPOL_XMLP_PKG US PO Financials/Purchasing Options Listing Application: Purchasing Source: Financials/Purchasing Options Listing (XML) Short Name: POXFIPOL_XML DB package: PO_POXFIPOL_XMLP_PKG ZHS PO 财务/采购选项列表 Application: 采购管理系统 Source: 财务/采购选项列表 (XML) Short Name: POXFIPOL_XML DB package: PO_POXFIPOL_XMLP_PKG BI Publisher &from_rev &select_rev &where_rev :no :operating_unit :p_conc_request_id :p_flex_acc :p_oe_status :p_title :yes 1 10 :p_title Char AR العنوان D Titel F Titre US Title ZHS 标题