DBA Data[Home] [Help]

APPS.OE_VALIDATE_LINE dependencies on MTL_ITEM_REVISIONS

Line 4207: FROM mtl_item_revisions

4203: THEN
4204: BEGIN
4205: SELECT 1
4206: INTO l_dummy
4207: FROM mtl_item_revisions
4208: WHERE inventory_item_id=p_line_rec.inventory_item_id
4209: AND organization_id=p_line_rec.ship_from_org_id
4210: AND effectivity_date<=sysdate
4211: AND revision= p_line_rec.item_revision;