APPS.BOM_VALIDATE_BOM_REVISION dependencies on MTL_ITEM_REVISIONS
Line 37: FROM mtl_item_revisions
33: )
34: IS
35: CURSOR c_Get_Revision IS
36: SELECT revision, effectivity_date 37: FROM mtl_item_revisions 38: WHERE inventory_item_id = p_bom_rev_unexp_rec.assembly_item_id
39: AND organization_id = p_bom_rev_unexp_rec.organization_id
40: ORDER BY effectivity_date desc, revision desc;
41: