+ Reply to Thread + Post New Thread
Results 1 to 1 of 1
  1. #1
    markuh's Avatar
    markuh is offline Junior Member
    Join Date
    04 Feb 2010
    Posts
    1
    Say Thanks
    0
    Thanked 0 Times in 0 Posts
    Documents
    0
    Uploads
    0

    Default Customizing Order Booking Form

    :LINE.ORDERED_ITEM_DSP IS NOT NULL
    AND
    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)
    and :LINE.LINE_CATEGORY_CODE <> 'RETURN'
    and :LINE.FLOW_STATUS_CODE = 'ENTERED'

    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

  2.    Club-Oracle Complementary E-Books and Magazines
    Get your free Complementary Copy of Oracle Magazine

    You can also browse the Free Magazines and E-Books section to see the complete list of free magazines, e-books and Whitepapers.

Similar Threads

  1. Sales Order Return Problem.
    By Rayoons in forum Oracle SCM
    Replies: 0
    Last Post: 01-18-2010, 10:40 AM
  2. Purchase Order Analysis
    By lesterkenou in forum Oracle SCM
    Replies: 3
    Last Post: 08-08-2009, 09:41 AM
  3. Purchase Order Summary
    By mdmx54 in forum Oracle SCM
    Replies: 3
    Last Post: 07-06-2009, 07:51 PM
  4. Prefix in Move Order
    By amitsarkar in forum Oracle SCM
    Replies: 1
    Last Post: 06-08-2009, 12:56 PM

Tags for this Thread