APPS.INV_EBI_ITEM_HELPER dependencies on MTL_ITEM_REVISIONS

Line 205: FROM mtl_item_revisions

201: WHERE proj_element_id = l_pk1;
202: WHEN G_REVISION THEN
203: l_pk1 := ID_COL_VALUE('revision_id',p_pk_col_name_val_pairs);
204: SELECT revision_label INTO l_code
205: FROM mtl_item_revisions
206: WHERE revision_id = l_pk1;
207: WHEN G_HAZARD_CLASS THEN
208: l_pk1 := ID_COL_VALUE('hazard_class_id',p_pk_col_name_val_pairs);
209: SELECT hazard_class INTO l_code

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)

Line 1992: FROM mtl_item_revisions

1988: IF (l_data_level = INV_EBI_ITEM_PUB.g_data_level_item_rev ) THEN
1989:
1990: IF p_revision_code IS NOT NULL AND p_revision_code <> fnd_api.g_miss_char THEN
1991: SELECT revision_id INTO l_revision_id
1992: FROM mtl_item_revisions
1993: WHERE inventory_item_id = p_inventory_item_id
1994: AND organization_id = p_organization_id
1995: AND revision = p_revision_code;
1996: ELSE