Payables Invoice form personalization
I am trying to personalize supplier sites lov on the payables invoice form. The LOV behind the supplier_site field on the invoice form is INV_ACTIVE_SITES and the record group for the LOV is ACTIVE_SITES.
The original query of ACTIVE_SITES record group is :
select vendor_site_code, vendor_site_id , pov.org_id,
mo_global.get_ou_name(pov.org_id) operating_unit
, address_line1
, city, state,
zip, province,
county, country, pov.party_site_id
from po_vendor_sites pov,
financials_system_params_all fsp, hz_party_sites h ,po_vendors pv
where
pov.vendor_id = :inv_sum_folder.vendor_id and pov.vendor_id=pv.vendor_id and