Forum Stats

  • 3,874,176 Users
  • 2,266,677 Discussions
  • 7,911,754 Comments

Discussions

LOVs

Tayyeb
Tayyeb Member Posts: 33 Green Ribbon

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.