How To find Drop Ship PO

select * from oe_order_headers_all where order_number = 66526;     -- header_id = 195812
-- flow_status_code , cancelled_flag , open_flag , booked_flag


select * from oe_order_lines_all where header_id = 195812;  -- line_id =391322
-- source_type_code = 'EXTERNAL' line_type_id = 1427

select * from wsh_delivery_details where source_header_id = 195812  ;-- credit_invoice_line_id = 1276889

select * from oe_drop_ship_sources where header_id = 195812 ;
-- requisition_header_id = 182570 , requisition_line_id = 209798 , po_header_id = 112686 , po_line_id = 175495

select * from rcv_transactions where po_header_id = 112686  ;
-- shipment_header_id = 4891907 , shipment_line_id = 4885468

select * from RCV_ACCOUNTING_EVENTS where creation_date like sysdate ;
--rcv_transaction_id = 4986363

select * from rcv_shipment_headers where shipment_header_id = 4891907 ;

select * from rcv_shipment_lines where shipment_line_id = 4885468 ;

select * from  ra_customer_trx_all where creation_date like sysdate ;
-- trx_number = 10038382 , interface_header_attribute1 =66526 (order number )  , interface_header_attribute6 = 391322(order line_id )
--customer_trx_id = 762504 ,

select * from ra_customer_trx_lines_all  where sales_order = 66526 ;
-- interface_line_attribute1 = 66526 , interface_line_attribute6 = 391322 (oe_order_line_id )

select * from AR_CASH_RECEIPTS_ALL where creation_date like sysdate ;
-- receipt_number = 66526  -- cash_receipt_id = 110511

select * from AR_CASH_RECEIPT_HISTORY_ALL where creation_date like sysdate ; -- cash_receipt_id = 110511
select * from AR_PAYMENT_SCHEDULES_ALL where creation_date like sysdate ;



================================================================================
 SELECT prh.segment1 req_num          ,
  prh.interface_source_code           ,
  prl.line_num req_line_num           ,
  poll.line_location_id po_line_loc_id,
  poh.segment1 po_blanket_num         ,
  poh.org_id org                      ,
  hr.name                             ,
  oed.line_location_id oe_line_loc
   FROM po_requisition_headers_all prh,
  po_requisition_lines_all prl        ,
  po_line_locations_all poll          ,
  po_headers_all poh                  ,
  oe_drop_ship_sources oed            ,
  hr_all_organization_units hr
  WHERE prh.requisition_header_id = prl.requisition_header_id
AND hr.organization_id            = poh.org_id
AND prl.line_location_id          = poll.line_location_id
AND poh.po_header_id              = poll.po_header_id
AND oed.line_location_id          = poll.line_location_id
AND poh.org_id                    = '&org_id'
and poh.segment1 = 4195304
ORDER BY poh.creation_date DESC;

4195304