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
Tagged:
0