DBA Data[Home] [Help]

APPS.EGO_IMPORT_UTIL_PVT dependencies on EGO_DATA_LEVEL_VL

Line 98: FROM EGO_DATA_LEVEL_VL edlv

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: )

Line 119: FROM EGO_DATA_LEVEL_VL edlv

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: )