I need PL_SQl to do the following

When the stock level drops below LowestQty a new buying request should be issued to the default seller in the table Req_lssue.

here the stock Table

And Seller Tabel

STOCK Nested No Show All Table Attributes Columns Indexes Triggers Constraints Owne SOL Columns # Column Type 1 STID NUMBER 2 STNAME VARCHAR2 3 DESCRIPTION VARCHAR2 4 STCOST NUMBER 5 QUANTITY NUMBER 6 LOWESTCOST NUMBER 7 PRICE NUMBER 8 SEID NUMBER 9 CATID NUMBER SELLER Show All Table Attributes Columns Indexes Triggers Constraints Columns # Column Type 1 SEID NUMBER 2 SELLERNAME VARCHAR2 3 SADDRESS VARCHAR2 4 SPHONE CHAR STOCK Nested No Show All Table Attributes Columns Indexes Triggers Constraints Owne SOL Columns # Column Type 1 STID NUMBER 2 STNAME VARCHAR2 3 DESCRIPTION VARCHAR2 4 STCOST NUMBER 5 QUANTITY NUMBER 6 LOWESTCOST NUMBER 7 PRICE NUMBER 8 SEID NUMBER 9 CATID NUMBER SELLER Show All Table Attributes Columns Indexes Triggers Constraints Columns # Column Type 1 SEID NUMBER 2 SELLERNAME VARCHAR2 3 SADDRESS VARCHAR2 4 SPHONE CHAR