APPS.INV_EBI_ITEM_HELPER dependencies on MTL_ITEM_REV_HIGHDATE_V

Line 126: SELECT revision_id INTO l_id from mtl_item_rev_highdate_v MIRVH

122: AND parent_structure_id = l_pk2;
123: WHEN G_REVISION THEN
124: l_pk1 := ID_COL_VALUE('organization_id',p_pk_col_name_val_pairs);
125: l_pk2 := ID_COL_VALUE('inventory_item_id',p_pk_col_name_val_pairs);
126: SELECT revision_id INTO l_id from mtl_item_rev_highdate_v MIRVH
127: WHERE organization_id = l_pk1
128: AND inventory_item_id = l_pk2
129: AND MIRVH.EFFECTIVITY_DATE < SYSDATE
130: AND decode(MIRVH.HIGH_DATE,SYSDATE,SYSDATE+1) > SYSDATE;