You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Pricing Starteggy Assignment Matrix - Value set for Header.BillToCustomerAccountSiteUseID

Summary:

Hi,

We are trying to add Header.BillToCustomerAccountSiteUseID to the Matrix of Pricing Strategy Assignment

trying to create Value set for LOV but without Success

select

hcas.CUST_ACCT_SITE_ID,
hps.party_site_number,
hps.PARTY_SITE_ID,
hcsua.SITE_USE_ID
from

hz_party_sites hps,
hz_cust_acct_sites_all hcas,
HZ_CUST_SITE_USES_ALL hcsua
where
hp.party_id= hps.PARTY_ID and
hps.PARTY_SITE_ID(+)=hcas.party_site_id and
hcsua.cust_acct_site_id(+) =hcas.cust_acct_site_id
and hcsua.SITE_USE_CODE(+)='BILL_TO' and

The value is hps.party_site_number

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!