APPS.WMS_WAVE_PLANNING_PVT dependencies on WMS_WP_WAVE_EXCEPTIONS_VL

Line 15764: FROM wms_wp_wave_exceptions_vl

15760: -- if it exists fetches the corresponding exception_id else fetches -1.
15761: l_exception_id := -1;
15762: SELECT exception_id
15763: INTO l_exception_id
15764: FROM wms_wp_wave_exceptions_vl
15765: WHERE wave_header_id = l_get_waves.wave_header_id
15766: AND exception_entity = p_exception_entity
15767: AND exception_stage = p_progress_stage
15768: AND LOWER(status) <> 'closed';

Line 15845: FROM wms_wp_wave_exceptions_vl

15841: -- if it exists fetches the corresponding exception_id else fetches -1.
15842: l_exception_id := -1;
15843: SELECT exception_id
15844: INTO l_exception_id
15845: FROM wms_wp_wave_exceptions_vl
15846: WHERE wave_header_id = l_get_waves.wave_header_id
15847: AND exception_entity = p_exception_entity
15848: AND exception_stage = p_progress_stage
15849: AND trip_id = l_get_trips.trip_id

Line 15931: FROM wms_wp_wave_exceptions_vl

15927: -- if it exists fetches the corresponding exception_id else fetches -1.
15928: l_exception_id := -1;
15929: SELECT exception_id
15930: INTO l_exception_id
15931: FROM wms_wp_wave_exceptions_vl
15932: WHERE wave_header_id = l_get_waves.wave_header_id
15933: AND exception_entity = p_exception_entity
15934: AND exception_stage = p_progress_stage
15935: AND delivery_id = l_get_deliveries.delivery_id

Line 16018: FROM wms_wp_wave_exceptions_vl

16014: -- if it exists fetches the corresponding exception_id else fetches -1.
16015: l_exception_id := -1;
16016: SELECT exception_id
16017: INTO l_exception_id
16018: FROM wms_wp_wave_exceptions_vl
16019: WHERE wave_header_id = l_get_waves.wave_header_id
16020: AND exception_entity = p_exception_entity
16021: AND exception_stage = p_progress_stage
16022: AND order_number = l_get_so.source_header_number

Line 16112: FROM wms_wp_wave_exceptions_vl

16108: -- if it exists fetches the corresponding exception_id else fetches -1.
16109: l_exception_id := -1;
16110: SELECT exception_id
16111: INTO l_exception_id
16112: FROM wms_wp_wave_exceptions_vl
16113: WHERE wave_header_id = l_get_waves.wave_header_id
16114: AND exception_entity = p_exception_entity
16115: AND exception_stage = p_progress_stage
16116: AND ORDER_LINE_ID = l_get_lines.source_line_id

Line 16258: /* INSERT INTO wms_wp_wave_exceptions_vl

16254: X_LAST_UPDATE_DATE => sysdate,
16255: X_LAST_UPDATED_BY => fnd_global.user_id,
16256: X_LAST_UPDATE_LOGIN => fnd_global.conc_login_id);
16257:
16258: /* INSERT INTO wms_wp_wave_exceptions_vl
16259: (exception_id,
16260: exception_name,
16261: exception_entity,
16262: exception_stage,

Line 16362: FROM wms_wp_wave_exceptions_vl

16358:
16359: print_debug('In check_so procedure', l_debug);
16360: SELECT exception_id, delivery_id, trip_id
16361: INTO l_exception_id, l_previous_delivery, l_previous_trip
16362: FROM wms_wp_wave_exceptions_vl
16363: WHERE concurrent_request_id = fnd_global.conc_request_id
16364: AND order_number = p_current_order;
16365:
16366: print_debug('exception_id fetched =' || l_exception_id, l_debug);

Line 16465: FROM wms_wp_wave_exceptions_vl

16461:
16462: print_debug('In check_line procedure', l_debug);
16463: SELECT exception_id, delivery_id, trip_id
16464: INTO l_exception_id, l_previous_delivery, l_previous_trip
16465: FROM wms_wp_wave_exceptions_vl
16466: WHERE concurrent_request_id = fnd_global.conc_request_id
16467: AND ORDER_LINE_ID = p_current_line;
16468:
16469: print_debug('exception_id fetched =' || l_exception_id, l_debug);

Line 19245: from wms_wp_wave_exceptions_vl where wave_header_id = p_wave_header_id

19241: packed,
19242: staged,
19243: loaded_to_dock,
19244: shipped
19245: from wms_wp_wave_exceptions_vl where wave_header_id = p_wave_header_id
19246: and lower(status) <> 'closed';
19247:
19248: insert into wms_wp_labor_gtmp_v(
19249: RESOURCE_NAME,