I have a page with a Form region that includes fields that are Popup LOV types.
My LOV Type is a SQL Query -
SELECT
VPR.VERICRED_PRICING_PK AS RETURN_VALUE,
VPL.DISPLAY_NAME AS DISPLAY_VALUE
FROM
VERICRED_PLANS VPL INNER JOIN
VERICRED_PRICINGS VPR ON VPL.VERICRED_PLAN_PK = VPR.VERICRED_PLAN_FK INNER JOIN
VERICRED_SERVICE_AREA_ZIP_COUNTIES VSAZC ON VPL.VERICRED_SERVICE_AREA_FK = VSAZC.VERICRED_SERVICE_AREA_FK
When I run the page the LOV only shows the Return Values, not the Display Values in the LOV. The Source Column is a Data Type of Number.
Am I missing a setting somewhere?
I've had great success using a Shared Component but this SQL will use several Page Item values in the WHERE clause so I assumed using a SQL Query would be ideal.
Thanks!