APPS.INV_EBI_ITEM_HELPER dependencies on MTL_ITEM_REVISIONS_B

Line 1379: mtl_item_revisions_b mir ,

1375: BEGIN
1376:
1377: SELECT COUNT(1) INTO l_count
1378: FROM
1379: mtl_item_revisions_b mir ,
1380: mtl_system_items_kfv msi
1381: WHERE
1382: msi.concatenated_segments = p_item_number AND
1383: msi.organization_id = p_organization_id AND

Line 1687: FROM mtl_item_revisions_b ir

1683: );
1684: END IF;
1685:
1686: SELECT COUNT(1) into l_revised_item_exists
1687: FROM mtl_item_revisions_b ir
1688: WHERE ir.inventory_item_id = l_item.main_obj_type.inventory_item_id
1689: AND ir.organization_id = l_item.main_obj_type.organization_id
1690: AND ir.revision = l_item.main_obj_type.revision_code
1691: AND(ir.effectivity_date IN

Line 1693: FROM mtl_item_revisions_b ir2

1689: AND ir.organization_id = l_item.main_obj_type.organization_id
1690: AND ir.revision = l_item.main_obj_type.revision_code
1691: AND(ir.effectivity_date IN
1692: (SELECT first_value(ir2.effectivity_date) over(ORDER BY ir2.effectivity_date DESC)
1693: FROM mtl_item_revisions_b ir2
1694: WHERE ir2.organization_id = ir.organization_id
1695: AND ir2.inventory_item_id = ir.inventory_item_id
1696: AND ir2.effectivity_date <= sysdate
1697: AND ir2.implementation_date IS NOT NULL)