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