Order Management - EBS (MOSC)

MOSC Banner

To check low margin while booking the order getting error

edited Sep 6, 2021 12:24PM in Order Management - EBS (MOSC) 2 commentsAnswered

Hi All,

Working in EBS Version : 12.2.10

i have requirement to check low margin while booking the order

if it is multiple lines it shows errors

kindly see the screen shot below

this is my below query

 (select trunc(scsa_actc_cost(oel.inventory_item_id,oel.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 oe_order_lines_all oel, mtl_system_items_b iim

 where iim.organization_id = 94

 and iim.inventory_item_id = oel.inventory_item_id

 and oel.header_id = :line.header_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