I have a drop down / select list of months.
SELECT MONTHCD val, TO_CHAR(TO_DATE(MONTHCD, 'MM'), 'MON') label
FROM PS_AP_MTCH_EXP_DTL@FINRPT
where YEAR_FROM = NVL(:P2_YEAR, NVL(:P2_YEARFROM, YEAR_FROM))
GROUP BY MONTHCD;
The list shows the VAL not the Label.
All examples show it in this order and I have other list on another page where the label is show.
I have no idea why it’s doing this.
I’ve changed it around thinking that was why the value was not getting passed but that didn’t fix it either.
Looking for suggestions
Thanks