ERP-PO

/* Report os */
POQTYOS.view  <=  pobody.view


/* print  */
detail.amount = PRINT_PO_LINE.amount , (poDetail3.java)
amount = PURCHASE_HEADER_VIEW0.PO_AMT = POTATAMT.PO_AMOUNT (allDocGenPDF.java)




/* table */

grnqty= grnqty.view (GRNQTY, PO_RECORDID)








/* trigger */

delimiter $$
drop trigger if exists GRN_LINE_UpdateActionAfterUpdate;
CREATE TRIGGER GRN_LINE_UpdateActionAfterUpdate
After Update ON GRN_LINE
FOR EACH ROW
BEGIN
declare mqty double;
select GRNQTY FROM GRNQTY WHERE PO_RECORDID=NEW.RECORDID INTO mqty;
UPDATE PO SET GRNQTY=mqty;
END;
$$
delimiter ;