select mbucfprename.prename_desc , mbmembmaster.memb_name , mbmembmaster.memb_surname, lnnplreqtrnmavcoll.* from mbmembmaster , mbucfprename, lnnplreqtrnmavcoll where ( lnnplreqtrnmavcoll.memcoop_id = mbmembmaster.coop_id ) and ( lnnplreqtrnmavcoll.member_no = mbmembmaster.member_no ) and ( mbucfprename.prename_code = mbmembmaster.prename_code ) DELETE FROM "LNNPLREQTRNMAVCOLLDET" WHERE (("COOP_ID" = :Original_COOP_ID) AND ("TRNMAVCOLL_DOCNO" = :Original_TRNMAVCOLL_DOCNO) AND ("COLLMEM_NO" = :Original_COLLMEM_NO)) INSERT INTO "LNNPLREQTRNMAVCOLLDET" ("COOP_ID", "TRNMAVCOLL_DOCNO", "COLLMEM_NO", "MAVTRN_AMT") VALUES (:COOP_ID, :TRNMAVCOLL_DOCNO, :COLLMEM_NO, :MAVTRN_AMT) select * from lnnplreqtrnmavcolldet UPDATE "LNNPLREQTRNMAVCOLLDET" SET "COOP_ID" = :COOP_ID, "TRNMAVCOLL_DOCNO" = :TRNMAVCOLL_DOCNO, "COLLMEM_NO" = :COLLMEM_NO, "MAVTRN_AMT" = :MAVTRN_AMT WHERE (("COOP_ID" = :Original_COOP_ID) AND ("TRNMAVCOLL_DOCNO" = :Original_TRNMAVCOLL_DOCNO) AND ("COLLMEM_NO" = :Original_COLLMEM_NO))