DBA Data[Home] [Help]

APPS.EGO_ITEM_BULKLOAD_PKG dependencies on EGO_OBJ_ATTR_GRP_ASSOCS_V

Line 4577: FROM EGO_OBJ_ATTR_GRP_ASSOCS_V

4573: -- of the atr group and populate the REVISION_ID only if the AG --
4574: -- revision level. --
4575: --------------------------------------------------------------------
4576: SELECT DATA_LEVEL_INT_NAME INTO l_attr_group_data_level
4577: FROM EGO_OBJ_ATTR_GRP_ASSOCS_V
4578: WHERE ATTR_GROUP_TYPE in (G_IUD_ATTR_GROUP_TYPE, G_GTN_SNG_ATTR_GROUP_TYPE, G_GTN_MUL_ATTR_GROUP_TYPE)
4579: AND ATTR_GROUP_ID = c_attr_grp_rec.attr_group_id
4580: AND OBJECT_NAME = G_EGO_ITEM_OBJ_NAME
4581: AND ROWNUM = 1;-- The AG cannot have associations at Item level and Revision Level for different Catalogs.