SELECT
iop.organization_code,
po_hdr.segment1 AS po_number,
po_hdr.comments,
hp.party_name AS supplier,
pvsa.vendor_site_code AS supplier_site,
po_hdr.document_status AS order_status,
po_hdr.creation_date AS order_creation_date,
po_hdr.revision_num,
po_line.line_num,
esib.item_number,
esib.item_type,
(SELECT gcc.segment1 || '.' || gcc.segment2 || '.' || gcc.segment3 || '.' || gcc.segment4 || '.' || gcc.segment5 || '.' || gcc.segment6 || '.' || gcc.segment7
FROM gl_code_combinations gcc
JOIN po_distributions_all pda ON pda.code_combination_id = gcc.code_combination_id
WHERE pda.po_line_id = po_line.po_line_id
AND rownum = 1) AS inv_exp_default_acct,
(SELECT gcc.segment1 || '.' || gcc.segment2 || '.' || gcc.segment3 || '.' || gcc.segment4 || '.' || gcc.segment5 || '.' || gcc.segment6 || '.' || gcc.segment7
FROM gl_code_combinations gcc
JOIN po_distributions_all pda ON pda.code_combination_id = gcc.accrural_account_id
WHERE pda.po_line_id = po_line.po_line_id
AND rownum = 1) AS accrual_default_acct,
(SELECT gcc.segment1 || '.' || gcc.segment2 || '.' || gcc.segment3 || '.' || gcc.segment4 || '.' || gcc.segment5 || '.' || gcc.segment6 || '.' || gcc.segment7
FROM gl_code_combinations gcc
JOIN po_distributions_all pda ON pda.code_combination_id = gcc.variance_account_id
WHERE pda.po_line_id = po_line.po_line_id
AND rownum = 1) AS variance_default_acct,
po_line.item_description,
po_line.quantity AS order_qty,
po_line.unit_price,
line_loc.requested_ship_date,
line_loc.need_by_date,
po_line.line_status,
po_hdr.agent_id AS buyer_id,
(SELECT ppf.full_name
FROM per_person_names_f ppf
WHERE ppf.person_name_id = po_hdr.agent_id
AND TRUNC(SYSDATE) BETWEEN TRUNC(ppf.effective_start_date) AND TRUNC(ppf.effective_end_date)) AS buyer,
rsh.shipment_num,
rsh.receipt_num,
rsl.quantity_received,
rsl.quantity_delivered,
rsl.quantity_shipped,
rsh.creation_date AS receipt_date,
po_hdr.created_by,
line_loc.destination_type_code,
line_loc.sales_order_number AS customer_sales_order,
(SELECT prha.requisition_number
FROM por_req_distributions_all prda
JOIN por_requisition_lines_all prla ON prda.requisition_line_id = prla.requisition_line_id
JOIN por_requisition_headers_all prha ON prla.requisition_header_id = prha.requisition_header_id
JOIN po_distributions_all pda ON prda.distribution_id = pda.req_distribution_id
WHERE pda.line_location_id = line_loc.line_location_id) AS requisition,
rsl.shipment_line_status_code
FROM po_headers_all po_hdr
JOIN poz_suppliers pv ON pv.vendor_id = po_hdr.vendor_id
JOIN hz_parties hp ON pv.party_id = hp.party_id
JOIN poz_supplier_sites_all_m pvsa ON pvsa.vendor_site_id = po_hdr.vendor_site_id
JOIN po_lines_all po_line ON po_hdr.po_header_id = po_line.po_header_id
JOIN po_line_locations_all line_loc ON po_line.po_line_id = line_loc.po_line_id
JOIN egp_system_items_b esib ON po_line.item_id = esib.inventory_item_id
JOIN inv_org_parameters iop ON line_loc.ship_to_organization_id = esib.organization_id
JOIN hr_operating_units hou ON hou.organization_id = po_hdr.PRC_BU_ID
LEFT JOIN rcv_shipment_headers rsh ON rsh.shipment_header_id = rsl.shipment_header_id
LEFT JOIN rcv_shipment_lines rsl ON line_loc.po_line_id = rsl.po_line_id
AND line_loc.po_header_id = rsl.po_header_id
AND line_loc.line_location_id = rsl.po_line_location_id
AND rsl.source_document_code = 'PO';
Please help me to rectify this code.