You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Sql to get the item structure for a particular revision in Oracle fusion cloud

edited Oct 14, 2024 3:31PM in Reporting and Analytics for SCM 2 comments

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

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!