Hi all, I am new to creating custom events and a novice when it comes to PL/SQL. I am trying to achieve when a Purchase Requisition is turned into a Request for Order Quotation that the Supplier on the Purchase Requisition Line is transferred to the Supplier tab in the Request for Order Quotation LU. My code isn’t erroring out but I feel I am missing something as the supplier is not transferring over. As always, thank you for your help and time. -EliCode: DECLAREINQUIRY_NO_ VARCHAR2(32000) := '&NEW:INQUIRY_NO';VENDOR_NO_ VARCHAR2(32000);attr_ VARCHAR2(32000);CURSOR get_vendor_no ISSELECT VENDOR_NOFROM PURCHASE_REQ_LINE_PARTWHERE vendor_no = vendor_no_; BEGINOPEN get_vendor_no;FETCH get_vendor_no INTO vendor_no_;CLOSE get_vendor_no;Client_SYS.clear_attr(attr_);Client_SYS.add_to_attr('VENDOR_NO', vendor_no_, attr_);END;
Already have an account? Login
No account yet? Create an account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.