Search 800 + Posts

Jan 27, 2011

Workflow Query to Check if Order Header is Eligible forBooking or Not

SELECT  'Eligible for Booking '
   FROM WF_ITEM_ACTIVITY_STATUSES WIAS
       , WF_PROCESS_ACTIVITIES WPA
   WHERE WIAS.item_type = 'OEOH'
     AND WIAS.item_key = to_char(&Enter_order_header_id)
     AND WIAS.activity_status = 'NOTIFIED'
     AND WPA.activity_name = 'BOOK_ELIGIBLE'


   SELECT  'Error - Order Header not Eligible for Booking'
     FROM WF_ITEM_ACTIVITY_STATUSES WIAS
       , WF_PROCESS_ACTIVITIES WPA
      WHERE WIAS.item_type = 'OEOH'
      AND WIAS.item_key = to_char(&Enter_order_header_id)
      AND WIAS.activity_status = 'ERROR'
      AND WPA.activity_name = 'BOOK_ORDER'
      AND WPA.instance_id = WIAS.process_activity;

No comments:

Post a Comment