Purchasing. Receiving, MTL Accts Queries

SQL1> select * from po_line_locations_all where po_header_id in (<po header id>);

SQL2> select * from po_distributions_all where po_header_id in (<po header id>);

SQL3> select * from rcv_transactions where po_header_id in (<po header id>);
SQL4> select * from mtl_material_transactions where rcv_transaction_id in (select transaction_id from rcv_transactions where po_header_id in (<po header id>);

SQL5> select * from rcv_receiving_sub_ledger where reference4 in (<po number>) and set_of_books_id = &SOB id;

SQL6> select * from mtl_transaction_accounts where transaction_id in (select transaction_id from mtl_material_transactions where rcv_transaction_id in (select transaction_id from rcv_transactions where po_header_id in (<po header id>)));