Payables and Cash Management - EBS (MOSC)

MOSC Banner

Payables Invoice form personalization

edited Aug 2, 2013 10:55AM in Payables and Cash Management - EBS (MOSC) 9 commentsAnswered
Hi All,

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center