APPS.INV_EBI_ITEM_HELPER dependencies on MTL_ITEM_REVISIONS_B

Line 1104: mtl_item_revisions_b mir ,

1100: BEGIN
1101:
1102: SELECT COUNT(1) INTO l_count
1103: FROM
1104: mtl_item_revisions_b mir ,
1105: mtl_system_items_kfv msi
1106: WHERE
1107: msi.concatenated_segments = p_item_number AND
1108: msi.organization_id = p_organization_id AND

Line 1276: FROM mtl_item_revisions_b ir

1272: );
1273: END IF;
1274:
1275: SELECT COUNT(1) into l_revised_item_exists
1276: FROM mtl_item_revisions_b ir
1277: WHERE ir.inventory_item_id = l_item.main_obj_type.inventory_item_id
1278: AND ir.organization_id = l_item.main_obj_type.organization_id
1279: AND ir.revision = l_item.main_obj_type.revision_code
1280: AND(ir.effectivity_date IN

Line 1282: FROM mtl_item_revisions_b ir2

1278: AND ir.organization_id = l_item.main_obj_type.organization_id
1279: AND ir.revision = l_item.main_obj_type.revision_code
1280: AND(ir.effectivity_date IN
1281: (SELECT first_value(ir2.effectivity_date) over(ORDER BY ir2.effectivity_date DESC)
1282: FROM mtl_item_revisions_b ir2
1283: WHERE ir2.organization_id = ir.organization_id
1284: AND ir2.inventory_item_id = ir.inventory_item_id
1285: AND ir2.effectivity_date <= sysdate
1286: AND ir2.implementation_date IS NOT NULL)