DBA Data[Home] [Help]

APPS.EGO_ITEM_USER_ATTRS_CP_PUB dependencies on EGO_DATA_LEVEL_VL

Line 1593: FROM EGO_DATA_LEVEL_VL edlv

1589: ----------------------------------------------------------
1590:
1591: UPDATE EGO_ITM_USR_ATTR_INTRFC uai
1592: SET uai.DATA_LEVEL_ID = (SELECT edlv.DATA_LEVEL_ID
1593: FROM EGO_DATA_LEVEL_VL edlv
1594: WHERE edlv.USER_DATA_LEVEL_NAME = uai.USER_DATA_LEVEL_NAME
1595: AND edlv.APPLICATION_ID = 431
1596: AND edlv.ATTR_GROUP_TYPE = NVL(uai.ATTR_GROUP_TYPE, 'EGO_ITEMMGMT_GROUP')
1597: )

Line 1614: FROM EGO_DATA_LEVEL_VL edlv

1610: AND edlb.APPLICATION_ID = 431
1611: AND edlb.ATTR_GROUP_TYPE = NVL(uai.ATTR_GROUP_TYPE, 'EGO_ITEMMGMT_GROUP')
1612: ),
1613: (SELECT edlv.DATA_LEVEL_ID
1614: FROM EGO_DATA_LEVEL_VL edlv
1615: WHERE edlv.USER_DATA_LEVEL_NAME = uai.USER_DATA_LEVEL_NAME
1616: AND edlv.APPLICATION_ID = 431
1617: AND edlv.ATTR_GROUP_TYPE = NVL(uai.ATTR_GROUP_TYPE, 'EGO_ITEMMGMT_GROUP')
1618: )