APPS.INV_EBI_ITEM_HELPER dependencies on MTL_ITEM_REVISIONS

Line 227: FROM mtl_item_revisions_vl

223: WHERE proj_element_id = l_pk1;
224: WHEN G_REVISION THEN
225: l_pk1 := ID_COL_VALUE('revision_id',p_pk_col_name_val_pairs);
226: SELECT revision_label INTO l_code
227: FROM mtl_item_revisions_vl
228: WHERE revision_id = l_pk1;
229: WHEN G_HAZARD_CLASS THEN
230: l_pk1 := ID_COL_VALUE('hazard_class_id',p_pk_col_name_val_pairs);
231: SELECT hazard_class INTO l_code

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)

Line 2757: FROM mtl_item_revisions

2753: IF (l_data_lvl = INV_EBI_ITEM_PUB.g_data_level_item_rev ) THEN
2754:
2755: IF p_revision_code IS NOT NULL AND p_revision_code <> fnd_api.g_miss_char THEN
2756: SELECT revision_id INTO l_revision_id
2757: FROM mtl_item_revisions
2758: WHERE inventory_item_id = p_inventory_item_id
2759: AND organization_id = p_organization_id
2760: AND revision = p_revision_code;
2761: ELSE