PO_TABLES

--Supply Base > Suppliers
SELECT *
  FROM po_vendors
 WHERE vendor_name = 'Advanced Network Devices';

--Supply Base > Suppliers Sites
SELECT *
  FROM po_vendor_sites_all
 WHERE vendor_id = 21 AND org_id = 204;

--SETUP -> PERSONAL -> BUYER
SELECT *
  FROM per_all_people_f
 WHERE full_name = 'Stock, Ms. Pat';
SELECT *
  FROM po_agents
 WHERE agent_id = 25;

SELECT *
  FROM po_requisition_headers_all
 WHERE segment1 = '5915';

SELECT *
  FROM po_requisition_lines_all
 WHERE requisition_header_id = 57523;

SELECT *
  FROM po_headers_all
 WHERE segment1 = '4701';

SELECT *
  FROM po_lines_all
 WHERE po_header_id = 33434;

SELECT *
  FROM po_distributions_all
 WHERE po_line_id = 38763;

SELECT *
  FROM rcv_shipment_headers
 WHERE receipt_num = 9752 AND ship_to_org_id = 207;
 
SELECT *
  FROM rcv_shipment_lines
 WHERE shipment_header_id = 100460;