APPS.EGO_ITEM_USER_ATTRS_CP_PUB dependencies on MTL_ITEM_CATALOG_GROUPS_B

Line 267: FROM MTL_ITEM_CATALOG_GROUPS_B

263: -- For finding all parent catalog groups for the current catalog group --
264: -------------------------------------------------------------------------
265: CURSOR parent_catalog_group_cursor IS
266: SELECT ITEM_CATALOG_GROUP_ID, PARENT_CATALOG_GROUP_ID
267: FROM MTL_ITEM_CATALOG_GROUPS_B
268: CONNECT BY PRIOR PARENT_CATALOG_GROUP_ID = ITEM_CATALOG_GROUP_ID
269: START WITH ITEM_CATALOG_GROUP_ID = p_catalog_group_id;
270:
271: BEGIN

Line 798: ' FROM MTL_ITEM_CATALOG_GROUPS_B ' ||

794: --------------------------------------------------------
795:
796: l_related_class_codes_query :=
797: ' (SELECT ITEM_CATALOG_GROUP_ID '||
798: ' FROM MTL_ITEM_CATALOG_GROUPS_B ' ||
799: ' CONNECT BY PRIOR ' ||
800: ' PARENT_CATALOG_GROUP_ID = ITEM_CATALOG_GROUP_ID ' ||
801: ' START WITH ' ||
802: ' ITEM_CATALOG_GROUP_ID = UAI2.ITEM_CATALOG_GROUP_ID)' ||

Line 2159: FROM mtl_item_catalog_groups_b ic

2155: ----------------------------------------------
2156: UPDATE EGO_ITM_USR_ATTR_INTRFC UAI
2157: SET UAI.PROG_INT_NUM1 =
2158: (SELECT ic.item_catalog_group_id
2159: FROM mtl_item_catalog_groups_b ic
2160: WHERE EXISTS
2161: ( SELECT olc.object_classification_code CatalogId
2162: FROM ego_obj_type_lifecycles olc
2163: WHERE olc.object_id = G_ITEM_OBJECT_ID