Thread: Customizing Order Booking Form
- 02-04-2010 01:54 PM #1
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
- 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
-
Sales Order Return Problem.
By Rayoons in forum Oracle SCMReplies: 0Last Post: 01-18-2010, 10:40 AM -
Purchase Order Analysis
By lesterkenou in forum Oracle SCMReplies: 3Last Post: 08-08-2009, 09:41 AM -
Purchase Order Summary
By mdmx54 in forum Oracle SCMReplies: 3Last Post: 07-06-2009, 07:51 PM -
Prefix in Move Order
By amitsarkar in forum Oracle SCMReplies: 1Last Post: 06-08-2009, 12:56 PM


LinkBack URL
About LinkBacks
Reply With Quote
