Order Management - EBS (MOSC)

MOSC Banner

Sales Order Form Personalization

edited Mar 30, 2021 1:09PM in Order Management - EBS (MOSC) 1 commentAnswered

Hi All,

Working in OPM Ver: 12.1.3

In Sales Order form personalization the list price 4.2 and cost is 4.26

the condition is

4.26 greater than 4.2 the message is not showing due to decimal

when i put same 4.26 greater than 4.1 then it is displaying message

below script

-------------

:ORDER.SOLD_TO_ORG_ID NOT IN(64642,64667,65003) and (select trunc(scsa_actc_cost(:line.inventory_item_id,:line.org_id) /(1- 

to_char((case when (iim.attribute2 in ('SBIN', 'WBIN')) then 25 

   when (iim.attribute2 not in ('SBIN', 'WBIN')) then 20

    end

 )) /100),2) sp

 from mtl_system_items_b iim

 where iim.organization_id = 94

 and iim.inventory_item_id = :line.inventory_item_id) > :LINE.UNIT_SELLING_PRICE

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