DBA Data[Home] [Help]

APPS.XDP_CANCEL_ORDER dependencies on XDP_FULFILL_WORKLIST

Line 358: FROM XDP_FULFILL_WORKLIST FulfillWorklist,

354: RETURN BOOLEAN IS
355: l_error_progress_state BOOLEAN := TRUE ;
356: CURSOR CheckIfCancellable IS
357: SELECT 'Y'
358: FROM XDP_FULFILL_WORKLIST FulfillWorklist,
359: XDP_FA_RUNTIME_LIST FARuntimeList
360: WHERE FulfillWorklist.order_id = p_order_id
361: AND FulfillWorklist.workitem_instance_id = FARuntimeList.workitem_instance_id
362: AND FARuntimeList.status_code IN ('IN PROGRESS', 'ERROR', 'SUCCESS',