APPS.EGO_ITEM_WS_PVT dependencies on EGO_DATA_LEVEL_VL

Line 72: v_data_level_name EGO_DATA_LEVEL_VL.user_data_level_name%TYPE;

68: v_extension_id EGO_MTL_SY_ITEMS_EXT_B.extension_id%TYPE;
69: v_data_level_id EGO_MTL_SY_ITEMS_EXT_B.data_level_id%TYPE;
70: v_pk1_value EGO_MTL_SY_ITEMS_EXT_B.pk1_value%TYPE;
71: v_pk2_value EGO_MTL_SY_ITEMS_EXT_B.pk2_value%TYPE;
72: v_data_level_name EGO_DATA_LEVEL_VL.user_data_level_name%TYPE;
73: v_sequence_id EGO_PUB_WS_FLAT_RECS.sequence_id%TYPE;
74: v_pk3_value EGO_ODI_WS_ENTITIES.pk3_value%TYPE;
75: v_org_id EGO_PUB_WS_FLAT_RECS.PK2_VALUE%TYPE;
76:

Line 262: ' EGO_DATA_LEVEL_VL edlv , EGO_ODI_WS_ENTITIES ent, EGO_PUB_WS_FLAT_RECS flat '||

258: ' flat.SEQUENCE_ID , '||
259: ' ent.PK3_VALUE AS "PK3_VALUE" , '||
260: ' flat.PK2_VALUE AS "ORG_ID" '||
261: ' FROM EGO_MTL_SY_ITEMS_EXT_B egob, EGO_ATTR_GROUPS_V AG, '||
262: ' EGO_DATA_LEVEL_VL edlv , EGO_ODI_WS_ENTITIES ent, EGO_PUB_WS_FLAT_RECS flat '||
263: ' WHERE egob.DATA_LEVEL_ID = edlv.DATA_LEVEL_ID '||
264: ' AND AG.APPLICATION_ID = edlv.APPLICATION_ID '||
265: ' AND egob.ATTR_GROUP_ID = AG.ATTR_GROUP_ID '||
266: ' AND ent.SESSION_ID = :session_id '||

Line 289: ' EGO_DATA_LEVEL_VL edlv , EGO_ODI_WS_ENTITIES ent, EGO_PUB_WS_FLAT_RECS flat '||

285: ' flat.SEQUENCE_ID , '||
286: ' ent.PK3_VALUE AS "PK3_VALUE" , '||
287: ' flat.PK2_VALUE AS "ORG_ID" '||
288: ' FROM EGO_MTL_SY_ITEMS_EXT_B egob, EGO_ATTR_GROUPS_V AG, ego_attr_group_dl AGDL, mtl_system_items_b msib, '||
289: ' EGO_DATA_LEVEL_VL edlv , EGO_ODI_WS_ENTITIES ent, EGO_PUB_WS_FLAT_RECS flat '||
290: ' WHERE egob.DATA_LEVEL_ID = edlv.DATA_LEVEL_ID '||
291: ' AND egob.DATA_LEVEL_ID = AGDL.DATA_LEVEL_ID '||
292: ' AND AG.APPLICATION_ID = edlv.APPLICATION_ID '||
293: ' AND egob.ATTR_GROUP_ID = AG.ATTR_GROUP_ID '||