in which table I am able to find the list of subobjects related to the master object of a portlet? I want to be able to add a column list of all the subobjects of the application object. If you can provide the table name it will be great.
Is there any relationship between the object table (i.e: odf_ca_application) and the odf_objects table?
ODF_OBJECTS will tell you the objects defined as subobjects of the application object.
I suspect however, that you are asking a question about the data though (the instances, not the definition).
You should look at the entity relationship diagram to see how the data relates;
Retrieving data ...