1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Customizing Order Booking Form

Discussion in 'Oracle Apps Technical' started by markuh, Feb 4, 2010.

  1. markuh

    markuh Guest

    0 = (select COUNT(ol.ordered_item)
    from oe_order_lines_all ol, XX_ITEM_CARE_LEVEL_V xx
    where ol.header_id = :LINE.HEADER_ID
    and ol.line_id = :LINE.LINE_ID
    and xx.ordered_item = ol.ordered_item
    and xx.party_site_name = :LINE.ORDERED_ITEM_DSP
    and xx.party_site_name = :LINE.SALESREP)

    is the code i have used to stop orders to be booked for certain customer levels.
    i.e. in my view XX items are assinged to customers and therefore if the item has no record in XX, the order must be cancelled and user ginev that message.
    how should i make this work, when user wants to move to Book order stage