Advanced Pricing - EBS (MOSC)

MOSC Banner

Set the account number as a Qualfifier

edited Jul 16, 2014 12:07PM in Advanced Pricing - EBS (MOSC) 4 commentsAnswered ✓

Hi Experts!

I've configured an additional Qualifier for customer account number. My function produced the right result and the attribute mapping is successful, but the modifiers, link by this qualifier never get used.

That's my funtion:

FUNCTION GET_QP_ACCOUNT_NUMBER RETURN VARCHAR2 AS

      l_rv HZ_CUST_ACCOUNTS.ACCOUNT_NUMBER%TYPE;

      l_message applsys.fnd_log_messages.message_text%type;

      l_module  applsys.fnd_log_messages.module%type:='XX_QP_ORDER_2_CUSTOMER_PKG';

   BEGIN

      SELECT HCA.ACCOUNT_NUMBER

      INTO l_rv

      FROM hz_cust_accounts_all hca

      WHERE hca.cust_account_id=OE_ORDER_PUB.G_HDR.SOLD_TO_ORG_ID;

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