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