AWO-QA Admin role with: - Organization: US West Coast - Warehouse Issue: US West Coast - Warehouse Receipt: US East Coast Product : Ale Beer CREATE OR REPLACE FUNCTION generateLines() RETURNS VOID AS $func$ BEGIN FOR i IN 1..102 LOOP INSERT INTO obdo_distorderline(obdo_distorderline_id, ad_client_id, ad_org_id, isactive, created, createdby, updated, updatedby, obdo_distorder_id, m_product_id, c_uom_id, line, referenced_distorderline_id, qtyordered, qtyconfirmed, qtyissued, qtyreceived, c_aum, aumqty, m_attributesetinstance_id, em_obdoa_fromscratch) VALUES (MD5(RANDOM()::text), 'A64C68776B544B0DB59C16456C43E608', '582D874E69DE476B967E943E8C5DCA5A', 'Y', '2022-12-27 12:26:49.177', '100', '2022-12-27 12:26:49.177', '100', 'ID OF DO ISSUE HEADER', 'F4901CE835DA4353831DEF0396C9054E', '100', i*10, null, 0, 1, 0, 0, '100', 1, null, 'N'); END LOOP; END $func$ LANGUAGE plpgsql; select generateLines();