APPS.EGO_ITEM_WS_PVT dependencies on EGO_PUB_BAT_ENT_OBJS_V

Line 1991: FROM Ego_Pub_Bat_Ent_Objs_v --Find OUT NOCOPY if any other PK's

1987: VALUES (p_session_id,p_odi_session_id,'BATCH_ID',2,NULL,NULL,l_batch_id,SYSDATE,G_CURRENT_USER_ID);
1988:
1989: SELECT pk1_value , pk2_value ,pk3_value
1990: BULK COLLECT INTO l_item_id_tab, l_org_id_tab, l_rev_id_tab
1991: FROM Ego_Pub_Bat_Ent_Objs_v --Find OUT NOCOPY if any other PK's
1992: WHERE batch_id = l_batch_id
1993: AND USER_ENTERED = 'Y';
1994:
1995: -- Bug 8670655

Line 2198: FROM Ego_Pub_Bat_Ent_Objs_v

2194: WHERE session_id = p_session_id
2195: AND nvl(REF1_VALUE, 'Y') = 'Y')
2196: loop
2197: SELECT Count(*) INTO v_count
2198: FROM Ego_Pub_Bat_Ent_Objs_v
2199: WHERE batch_id = l_batch_id
2200: AND pk1_value = k.pk1_value
2201: AND pk2_value = k.pk2_value
2202: AND pk3_value = k.pk3_value;

Line 4774: FROM Ego_Pub_Bat_Ent_Objs_v

4770: ELSE
4771: IF (l_mode = 'BATCH') THEN
4772: SELECT BATCH_ENTITY_OBJECT_ID
4773: INTO l_batch_ent_obj_id
4774: FROM Ego_Pub_Bat_Ent_Objs_v
4775: WHERE batch_id = l_batch_id
4776: AND (PK1_VALUE, PK2_VALUE, PK3_VALUE) in (select pk1_value, pk2_value, pk3_value
4777: from EGO_ODI_WS_ENTITIES
4778: where session_id = p_session_id