94: AND uai.DATA_LEVEL_ID IS NULL;
95:
96: UPDATE EGO_ITM_USR_ATTR_INTRFC uai
97: SET uai.DATA_LEVEL_ID = (SELECT edlv.DATA_LEVEL_ID
98: FROM EGO_DATA_LEVEL_VL edlv
99: WHERE edlv.USER_DATA_LEVEL_NAME = uai.USER_DATA_LEVEL_NAME
100: AND edlv.APPLICATION_ID = 431
101: AND edlv.ATTR_GROUP_TYPE = NVL(uai.ATTR_GROUP_TYPE, 'EGO_ITEMMGMT_GROUP')
102: )
115: AND edlb.APPLICATION_ID = 431
116: AND edlb.ATTR_GROUP_TYPE = NVL(uai.ATTR_GROUP_TYPE, 'EGO_ITEMMGMT_GROUP')
117: ),
118: (SELECT edlv.DATA_LEVEL_ID
119: FROM EGO_DATA_LEVEL_VL edlv
120: WHERE edlv.USER_DATA_LEVEL_NAME = uai.USER_DATA_LEVEL_NAME
121: AND edlv.APPLICATION_ID = 431
122: AND edlv.ATTR_GROUP_TYPE = NVL(uai.ATTR_GROUP_TYPE, 'EGO_ITEMMGMT_GROUP')
123: )