Agile PLM Fetch Redline Items

Question

In Agile PLM instance (9.3), how can I fetch the “Red line” BOM values of an affected item in a change using DB query. I have been searching, and found that details of such items can be found in table.

redline_attribute

Moreover, I have been using following query to get that. But it does not seems to be correct.

 select i.item_number, ra.* from redline_attribute ra
 left outer join item i
 on ra.object_id = i.id
 where change_id in 
 (select id from change where change_number = 'Change Number');

Does anyone knows, how to get what I am trying to fetch. Thank you in advance.

Answer 1

Go through this - 4.17 Identifying Redlined Rows and Redlined Cells https://docs.oracle.com/cd/E83928_04/otn/pdf/integration/html_agaap/output/chapter_4.htm#sthref228