APPS.EGO_ODI_PUB dependencies on EGO_PUB_BAT_ENT_OBJS_V

Line 1370: FROM Ego_Pub_Bat_Ent_Objs_v

1366: --selecting entity_object_id with respect to
1367: --publication framework tables to report the error
1368: SELECT BATCH_ENTITY_OBJECT_ID
1369: INTO l_batch_ent_obj_id
1370: FROM Ego_Pub_Bat_Ent_Objs_v
1371: WHERE batch_id = l_batch_id
1372: AND PK1_VALUE = i.item_id
1373: AND PK2_VALUE = i.item_org_id
1374: AND PK3_VALUE = i.item_rev;

Line 2911: FROM EGO_PUB_BAT_ENT_OBJS_V

2907: CURSOR c_fwk_end_items(p_batch_id NUMBER) IS
2908: SELECT pk1_value,
2909: pk2_value,
2910: pk3_value
2911: FROM EGO_PUB_BAT_ENT_OBJS_V
2912: WHERE batch_id = p_batch_id AND user_entered = 'Y';
2913:
2914: --Cursor to retrieve list of end-items for SUBROUTINE mode
2915: CURSOR c_subroutine_end_items(p_session_id NUMBER) IS

Line 6311: FROM Ego_Pub_Bat_Ent_Objs_v --Find out if any other PK's

6307:
6308:
6309: SELECT pk1_value , nvl(pk2_value,-1)
6310: BULK COLLECT INTO l_dup_icc_id_tab, l_dup_icc_ver_tab
6311: FROM Ego_Pub_Bat_Ent_Objs_v --Find out if any other PK's
6312: WHERE batch_id = l_batch_id AND user_entered = 'Y';
6313:
6314:
6315: /* FIND OUT PARENT AND CHILD ICC's also need to publish

Line 6625: FROM Ego_Pub_Bat_Ent_Objs_v --Find out if any other PK's

6621: G_VS_WEBSERVICE,NULL,NULL,NULL,NULL,NULL);*/
6622:
6623: SELECT pk1_value , Nvl(pk2_value,-1) --Bug 8722729
6624: BULK COLLECT INTO l_dup_vs_id_tab, l_dup_vs_ver_tab
6625: FROM Ego_Pub_Bat_Ent_Objs_v --Find out if any other PK's
6626: WHERE batch_id = l_batch_id AND user_entered = 'Y';
6627:
6628:
6629: ELSE