Requirement:
Need to modify the ship method LOV in Ship confirm screen to restrict values based on org similar to the ship method LOV on delivery tab in shipping transactions form.
Issue:
Developed solution using Form Personalization as per the Metalink docs, which is not working:
How to Replace Record Group with Form Personalization [763410.1]
How to Use Forms Personalization to Restrict Values in Customer Number LOV in Sales Order Form OEXOEORD [862066.1
Solution:
SQL query:
select SHIP_METHOD_MEANING "SHIP METHOD",
(SELECT DESCRIPTION FROM OE_SHIP_METHODS_V WHERE LOOKUP_TYPE = 'SHIP_METHOD' AND LOOKUP_CODE = SHIP_METHOD_CODE) "DESCRIPTION"
from WSH_CARRIER_SERVICES wcs,
WSH_ORG_CARRIER_SERVICES_v wocs
where wcs.CARRIER_SERVICE_ID = wocs.CARRIER_SERVICE_ID
and wocs.ORGANIZATION_ID = :DLVY.ORGANIZATION_ID
Request to please guide if any pre-req is required for this solution or pls do suggest an alternate approach
Thanks up front