DBA Data[Home] [Help]

APPS.EGO_LIFECYCLE_USER_PUB dependencies on MTL_ITEM_CATALOG_GROUPS_B

Line 342: -- MTL_ITEM_CATALOG_GROUPS_B

338: -- ) IS
339: -- SELECT
340: -- ITEM_CATALOG_GROUP_ID
341: -- FROM
342: -- MTL_ITEM_CATALOG_GROUPS_B
343: -- CONNECT BY PRIOR PARENT_CATALOG_GROUP_ID = ITEM_CATALOG_GROUP_ID
344: -- START WITH ITEM_CATALOG_GROUP_ID = cp_catalog_category_id;
345: --
346: CURSOR c_get_assoc_category_id (cp_catalog_category_id IN NUMBER

Line 350: FROM MTL_ITEM_CATALOG_GROUPS_B ic

346: CURSOR c_get_assoc_category_id (cp_catalog_category_id IN NUMBER
347: ,cp_lifecycle_id IN NUMBER
348: ) IS
349: SELECT ic.item_catalog_group_id
350: FROM MTL_ITEM_CATALOG_GROUPS_B ic
351: WHERE EXISTS (
352: SELECT olc.object_classification_code CatalogId
353: FROM ego_obj_type_lifecycles olc, fnd_objects o
354: WHERE o.obj_name = 'EGO_ITEM'