Is it usually used as a part of some application’s codebase?
No, Juypter notebooks are primarily used for education and research and collaboration. It’s not a very efficient platform for practical use.
I have heard there are 3rd party tools that will turn a notebook into a standalone application. But I do not know much about them.
I see. That makes sense to me.