I have a simple form created on a table having columns TPE_ELEMENT_ID, TPE_DOMAIN_ID, TPE_COMPONENT_ID, TPE_ELEMENT_NAME, TPE_ELEMENT_NAME_AR, HIGHLY_EFFECTIVE, EFFECTIVE, IMPROVEMENT_NECESSARY, DOES_NOT_MEET_STANDARDS, HIGHLY_EFFECTIVE_AR, EFFECTIVE_AR, IMPROVEMENT_NECESSARY_AR, DOES_NOT_MEET_STANDARDS_AR .
I have Dynamic LOV for the item (TPE_DOMAIN_ID) using SQL query [SELECT TPE_DOMAIN_NAME D, TPE_DOMAIN_ID R FROM TPE_DOMAINS]. This is working fine.
I have another Dynamic LOV for the item (TPE_COMPONENT_ID) using SQL query [SELECT TPE_COMPONENT_NAME D, TPE_COMPONENT_ID R FROM TPE_COMPONENTS WHERE TPE_DOMAIN_ID=: P104_TPE_DOMAIN_ID]. This one does not show any value. Here I cascade and submit P104_TPE_DOMAIN_ID.
Kindly let me know what mistake I am making; please explain. Thanks in advance
Note: when I just create separate page items (TPE_DOMAIN_ID) and (TPE_COMPONENT_ID) on the same page and have LOVs using both the above-mentioned SQL queries, then both are working fine.