ORACLE PO采购订单界面

最新推荐文章于 2023-02-16 17:51:08 发布

夏日青草

最新推荐文章于 2023-02-16 17:51:08 发布

阅读量3.6k

点赞数

分类专栏： ORACLE EBS PO

本文链接：https://blog.csdn.net/xiariqingcao/article/details/8768834

版权

这篇博客主要展示了如何通过SQL查询Oracle中的采购订单（PO）信息，包括头信息和行信息。查询涉及了多个字段，如供应商名称、状态、金额、日期、商品描述等，以及订单的各种详细属性。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

--PO界面头查询SQL
SELECT org_id,
       attribute15,
       segment1,
       revision_num,
       doc_type_name,
       creation_date_disp,
       vendor_name,
       vendor_site_code,
       vendor_contact,
       ship_to_location,
       bill_to_location,
       currency_code,
       agent_name,
       status,
       comments,
       pcard_id,
       global_agreement_flag,
       payment_terms,
       freight_terms_dsp,
       ship_via_lookup_code,
       fob_dsp,
       pay_on_dsp,
       shipping_control,
       confirming_order_flag,
       firm_status_lookup_code,
       acceptance_required_flag,
       acceptance_due_date,
       supply_agreement_flag,
       note_to_vendor,
       note_to_receiver,
       start_date,
       end_date,
       user_hold_flag,
       cancel_flag,
       frozen_flag,
       row_id,
       attribute1,
       attribute2,
       attribute3,
       attribute5,
       attribute7,
       attribute8,
       attribute10,
       attribute11,
       attribute13,
       attribute14,
       amount_limit,
       min_release_amount,
       price_update_tolerance,
       quotation_class_code,
       attribute12,
       approval_required_flag,
       closed_code,
       rate_type,
       rate,
       from_type_lookup_code,
       authorization_status,
       revised_date,
       note_to_authorizer,
       print_count,
       vendor_order_num,
       reply_date,
       last_update_date,
       segment2,
       segment4,
       end_date_active,
       creation_date,
       created_by,
       vendor_id,
       vendor_site_id,
       attribute6,
       attribute9,
       vendor_contact_id,
       ship_to_location_id,
       bill_to_location_id,
       terms_id,
       status_lookup_code,
       rate_date,
       from_header_id,
       blanket_total_amount,
       approved_flag,
       approved_date,
       printed_date,
       reply_method_lookup_code,
       po_header_id,
       agent_id,
       last_updated_by,
       summary_flag,
       enabled_flag,
       segment3,
       segment5,
       start_date_active,
       last_update_login,
       government_context,
       program_ap

最低0.47元/天解锁文章