Cascading List of Values

1. If you want to show data Master table data wise Details table data. Following this steps...

Step - 1 :
Go to Shared Components and You must Create List of value.
--> SQL Query :

select ID,NAME from NOTIFY where Buyer_id=:P8_BUYER_ID;

Step - 2 : Call LOV and select Cascading List of Values

2. Single Table Cascading system. Following this steps...

--> SQL Query :

SELECT ID,CITY FROM LOC_DTL WHERE LOC_MST_ID=:LOCATION_MST_ID; 

                                                                            ---:P18_LOCATION_MST_ID