ap_invoice_distributions_all与PO表关联代码,OracleEBS代码库,德仔网

代码语言

代码分类

【OracleEBS】 ap_invoice_distributions_all与PO表关联

作者:专注Oracle EBS / 发布于2012/11/29/ 1240

select ai.invoice_num,
       rsh.receipt_num,
       ph.segment1,
       aid.distribution_line_number,
       aid.rcv_transaction_id,
       aid.po_distribution_id
  from ap_invoices_all              ai,
       ap_invoice_distributions_all aid,
       po_distributions_all         pd,
       rcv_transactions             rt,
       rcv_shipment_lines           rsl,
       rcv_shipment_headers         rsh,
       po_headers_all               ph
 where ai.invoice_id = aid.invoice_id
   and aid.set_of_books_id = '&sob'
   and aid.period_name = '&period_name'
   and aid.po_distribution_id = pd.po_distribution_id
   and pd.po_distribution_id = rt.po_distribution_id
   and rt.po_distribution_id = rsl.po_distribution_id
   and rsl.shipment_line_id = rt.shipment_line_id
   and rsh.shipment_header_id = rsl.shipment_header_id
   and rt.destination_type_code = 'RECEIVING'
   and rt.po_header_id = ph.po_header_id
 order by 1,

试试其它关键字

　PO表关联　

同语言下

可能有用的

专注Oracle EBS贡献的其它代码(66)