thanks for the feedback it worked great to retrieve Customer_Order.note_text and CUST_ORD_CUSTOMER_ENT.note_text directly. I did also locate an API for Customer Order Notes that works just as well (&AO.CUSTOMER_ORDER_API.Get_note_text(CO.ORDER_NO) "CO_NoteText"), but could not find a similar API for CUSTOMER notes.
Thanks I appreciate the quick feedback. I tried the above for LU’s CustomerOrder and CustomerInfo and it did work for both of them… if only we could get past the copy/paste to notepad, save as .rtf then open document to get straight to the text we care about to allow analysis of the relevant text content. select DBMS_LOB.Substr( text, 4000, 1 ) from &AO.FND_NOTE_BOOK t1,&AO.FND_NOTE_PAGE t2where t1.note_id = t2.note_idand t1.lu_name ='CustomerOrder'and t1.key_ref like '%ORDER_NO=B126469%' Copy/paste to notepad, save as .rtf then open this is what you see when open the .rtf:
BAF recently applied solution 278027 to our Apps 10 TEST environment so we can test it. Can you please direct us to where we can locate documentation/help on the specific changes made for the 1099-NEC for 2020 so we can be clear on what changes were made in IFS or what the new process looks like (i.e. are there updates to suppliers, how to create the different 1099’s and IRS upload files, etc.).
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.