Sql to get the item structure for a particular revision in Oracle fusion cloud
Hi All,
Item structure and component details can be extracted from the following tables - egp_components_b , egp_structures_b.
Each item has multiple revisions like A,B,C,D.
The following sql returns 4 rows for each revisions,
select *
from EGP_ITEM_REVISIONS_B
where organization_ID=<Org id>
AND INVENTORY_ITEM_ID=<Inv Item id>
whereas egp_structures_b has only one row for an item.
is there any link between egp_structures_b and egp_item_revisions_b to get the structure for each revisions?
Regards,
Guru
Tagged:
3