[Home] [Help]
582: ' fnd_menus_tl granted_menu_tl ' ||
583: ' WHERE granted_menu.menu_id = grants.menu_id ' ||
584: ' AND grants.instance_type = ''SET'' AND grants.instance_pk1_value = ''*NULL*''' ||
585: ' AND grants.instance_set_id IN ( select instance_set.instance_set_id ' ||
586: ' from fnd_object_instance_sets instance_set, mtl_system_items_b item ' ||
587: ' where instance_set.object_id = grants.object_id and ' ||
588: ' (instance_set.instance_set_name = ''EGO_ORG_ITEM_'' || ' ||
589: ' to_char(item.organization_id) or instance_set.instance_set_name = ''EGO_ORG_CAT_ITEM_'' || ' ||
590: ' to_char(item.organization_id) || ''_'' || to_char(item.ITEM_CATALOG_GROUP_ID)) ' ||
632: ' fnd_menus_tl granted_menu_tl ' ||
633: ' WHERE grants.menu_id = granted_menu.menu_id ' ||
634: ' AND grants.instance_type= ''SET'' AND grants.instance_pk1_value = ''*NULL*'' AND ' ||
635: ' grants.instance_set_id IN ( select instance_set.instance_set_id from ' ||
636: ' fnd_object_instance_sets instance_set, mtl_system_items_b item ' ||
637: ' where instance_set.object_id = grants.object_id and (instance_set.instance_set_name = ''EGO_ORG_ITEM_'' || to_char(item.organization_id) ' ||
638: ' or instance_set.instance_set_name = ''EGO_ORG_CAT_ITEM_'' || to_char(item.organization_id) || ''_'' || to_char(item.ITEM_CATALOG_GROUP_ID)) ' ||
639: ' and obj.obj_name = ''EGO_ITEM'' AND item.inventory_item_id = ' || l_pk1_value || ' AND item.organization_id = ' || l_pk2_value ||
640: ' AND grants.grantee_type = ''GROUP'' ' ||
788: sets.instance_set_id instance_set_id ,
789: sets.instance_set_name instance_set_name,
790: sets.predicate predicate
791: FROM fnd_grants grants,
792: fnd_object_instance_sets sets,
793: fnd_objects obj
794: WHERE obj.obj_name = p_obj_name
795: AND grants.object_id = obj.object_id
796: AND grants.instance_type='SET'