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 670: ' FROM MTL_ITEM_CATALOG_GROUPS_B ' ||

666: --------------------------------------------------------
667:
668: l_related_class_codes_query :=
669: ' (SELECT ITEM_CATALOG_GROUP_ID '||
670: ' FROM MTL_ITEM_CATALOG_GROUPS_B ' ||
671: ' CONNECT BY PRIOR ' ||
672: ' PARENT_CATALOG_GROUP_ID = ITEM_CATALOG_GROUP_ID ' ||
673: ' START WITH ' ||
674: ' ITEM_CATALOG_GROUP_ID = UAI2.ITEM_CATALOG_GROUP_ID)' ||

Line 1729: FROM mtl_item_catalog_groups_b ic

1725: ----------------------------------------------
1726: UPDATE EGO_ITM_USR_ATTR_INTRFC UAI
1727: SET UAI.PROG_INT_NUM1 =
1728: (SELECT ic.item_catalog_group_id
1729: FROM mtl_item_catalog_groups_b ic
1730: WHERE EXISTS
1731: ( SELECT olc.object_classification_code CatalogId
1732: FROM ego_obj_type_lifecycles olc
1733: WHERE olc.object_id = G_ITEM_OBJECT_ID