DBA Data[Home] [Help]

APPS.EGO_ITEM_CATALOG_PVT dependencies on MTL_ITEM_CATALOG_GROUPS_V

Line 69: l_parent_group_name mtl_item_catalog_groups_v.catalog_concat_segs%TYPE;

65: p_parent_group_id IN NUMBER,
66: p_parent_group_name IN VARCHAR2) RETURN BOOLEAN IS
67:
68: l_parent_group_id mtl_item_catalog_groups_b.parent_catalog_group_id%TYPE;
69: l_parent_group_name mtl_item_catalog_groups_v.catalog_concat_segs%TYPE;
70:
71: CURSOR c IS
72: SELECT parent.item_catalog_group_id, parent.catalog_concat_segs
73: FROM mtl_item_catalog_groups_b cat,

Line 74: mtl_item_catalog_groups_v parent

70:
71: CURSOR c IS
72: SELECT parent.item_catalog_group_id, parent.catalog_concat_segs
73: FROM mtl_item_catalog_groups_b cat,
74: mtl_item_catalog_groups_v parent
75: WHERE cat.item_catalog_group_id = p_catalog_group_id
76: AND cat.parent_catalog_group_id = parent.item_catalog_group_id ;
77:
78: BEGIN