Cancel
Showing results for 
Search instead for 
Did you mean: 

Updating BOMLine Notes/Attributes using SQL

Solution Partner Legend Solution Partner Legend
Solution Partner Legend

Hello,

 

We are using Oracle DB.

In which table are the BOMLine notes saved ?

2 REPLIES

Re: Updating BOMLine Notes/Attributes using SQL

Phenom
Phenom

Good afternoon, I think you need this:

select RNOTES_REFU from ppsoccurrence where puid = uidOcc
select PVAL_0 from PNOTE_TEXTS_0 where puid = RNOTES_REFU

Re: Updating BOMLine Notes/Attributes using SQL

Solution Partner Legend Solution Partner Legend
Solution Partner Legend
Thanks! We needed table name for BOMLine Notes and we are able to go ahead now.