Uninvoiced Receipts: SELECT pha.segment1 po_number, TO_CHAR (pha.creation_date, 'DD-MON-RRRR') po_date, (SELECT vendor_name FROM ap_suppliers ap WHERE ap.vendor_id = pha.vendor_id) supplier_name, pla.quantity, pla.unit_price, pla.quantity * pla.unit_price AS line_amount, (SELECT concatenated_segments FROM gl_code_combinations_kfv gcc WHERE gcc.code_combination_id = pda.code_combination_id) charge_account, rsh...