...
Let us assume a scenario where a bank currently offers 2 loans - Home Loan and Personal Loan and is planning to offer Car Loan and Venture Loan after testing the response in the pilot stage. The response for the Car Loan was good and hence, the bank decides to launch the product and adds 'Y' in the LAUNCHED column of the master table maintained for loans (for example, LOAN_TYPE_MASTER). The LOAN_TYPE_MASTER table also consists of an entry for Venture Loan which has not been launched yet.
The table used for the view (for example, LOAN_SUMMARY_DATA) consists of an entry for Venture Loan and Car Loan.
Initially the app showed only Home Loan and Personal Loan details to Williams - the Loan Department Head. However, now it must also show Car Loan details to William. That is, all the loans that have been launched must be shown in the app for William.Note:
| Info |
|---|
It is assumed that you will be maintaining master tables to make any updates with respect to addition or deletion of products or services. |
The sample screen shot of the master table for loans named LOAN_TYPE_MASTER is as follows: 
The sample screen shot of the LOAN_SUMMARY_DATA used for the view is as follows:
ALL keyword with source type Q - In scenarios like these, it is best to fetch data through a query.
...