How to personalize the lov field in the form

Business Requirement:-

Customer name field is getting duplicated, 1 record with status as 'Active' and another record with status as 'InActive'. Now the requirement is to get the 'Active' records for the Customer Name field.

To Restrict Inactive Customers in GatePass Form through Personalization:-

Navigation:-

Order Management Super User GatePass Form

Query:

SELECT party_name CUSTOMER_NAME, account_number CUSTOMER_NUMBER, cust_account_id CUSTOMER_ID

FROM hz_parties hp, hz_cust_accounts hca

WHERE hp.party_id = hca.party_id AND party_type = 'ORGANIZATION'

and hca.status = 'A'

ORDER BY party_name

Added one extra condition status = ‘A’

Now the Active Customer name is displaying. Thanks for seeing my post. Share your comment.