I have a table (A) with multiple columns and want to create a LOV to be used for other table (B).
ColumnS in Tabel (A=CURRICULUM) are: CURRICULUM_ID, SUBJECT_ID, GRADE_ID, DOMAIN_ID, CATEGORY_ID, STANDARD_CODE, STANADARD_STATEMENT, LEARNING_TARGETS.
My query is as below:
SELECT CURRICULUM_ID CI, STANDARD_CODE SC FROM CURRICULUM
WHERE
SUBJECT=:P48_SUBJECT_ID
AND GRADE_ID=:P48_GRADE_ID
AND DOMAIN_ID=:P48_DOMAIN_ID
AND CATEGORY_ID=:P48_CATEGORY_ID
Its working fine if I use one parameter. but If I use more than one parameter its not working for me. Anyone please elaborate and thanks in advance.