APPS.INV_EBI_ITEM_HELPER dependencies on MTL_ITEM_REV_HIGHDATE_V

Line 145: SELECT revision_id INTO l_id from mtl_item_rev_highdate_v MIRVH

141: AND parent_structure_id = l_pk2;
142: WHEN G_REVISION THEN
143: l_pk1 := ID_COL_VALUE('organization_id',p_pk_col_name_val_pairs);
144: l_pk2 := ID_COL_VALUE('inventory_item_id',p_pk_col_name_val_pairs);
145: SELECT revision_id INTO l_id from mtl_item_rev_highdate_v MIRVH
146: WHERE organization_id = l_pk1
147: AND inventory_item_id = l_pk2
148: AND MIRVH.EFFECTIVITY_DATE < SYSDATE
149: AND decode(MIRVH.HIGH_DATE,SYSDATE,SYSDATE+1) > SYSDATE;