DBA Data[Home] [Help]

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: