Categories
- All Categories
- 127 Oracle Analytics News
- 23 Oracle Analytics Videos
- 14.5K Oracle Analytics Forums
- 5.5K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 47 Oracle Analytics Trainings
- 7 Oracle Analytics Data Visualizations Challenge
- 4 Oracle Analytics Career
- 8 Oracle Analytics Industry
- Find Partners
- For Partners
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Identifying Reference Designators for items in ECO pending state

Shifa Nazumudeen
Rank 2 - Community Beginner
Hi,
I am generating a report to access the reference designator for an item in ECO pending state. I am able to pull the latest revision for the item but between EGP_Components _B and the EGP_Reference_Designators there is only the component_sequence_id that links between the two tables. However linking just by this id will pull all the reference designators as opposed to the ref desig for that item revision. Any advice as to how that can be retrieved would help a lot.
In the attached screenshot, for component item_num 1211146 for revision R there is only one reference designator C244. But my query fetches all the reference designators for the component item even from the previous version.
Thanks
Shifa
0