Is there any way through which I can find from which ODI client host name/Ip address a particular scenario was called?
Host ip is stored in SNP_HOST table of master repository schema but which scenario is executed by which host this could be very typical but you can find by other way which USER executed which scenario by analyzing of SNP_SESSION.
Does ODI store any execution plan or anything similar to this that would keep the execution details in detail?
if you are asking for scheduling then, for this you can check SNP_PLAN_AGENT table in work repository.
let me know