APPS.WMS_WCS_DIAGNOSTICS dependencies on WMS_CAROUSEL_DIRECTIVE_QUEUE

Line 1083: FROM wms_carousel_directive_queue

1079:
1080: -- Look for the answer
1081: SELECT status, attempts
1082: INTO v_status_code, v_status
1083: FROM wms_carousel_directive_queue
1084: WHERE request_id = v_request_id AND directive = p_directive;
1085:
1086: IF v_status_code <> 'S'
1087: THEN

Line 1122: DELETE FROM wms_carousel_directive_queue

1118:
1119: -- Get rid of the test request
1120: -- DELETE FROM wms_wcs_request_test;
1121:
1122: DELETE FROM wms_carousel_directive_queue
1123: WHERE request_id = v_request_id;
1124:
1125: COMMIT;
1126: EXCEPTION