eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WMS_WAVE_PLANNING_PVT dependencies on WMS_WP_WWB_LINES_V

Line 15256: from wms_wp_wwb_lines_v

15252: cursor c_waves is
15253: select wwh.wave_header_id
15254: from wms_wp_wave_headers_vl wwh,
15255: (select wave_header_id, count(1) count_lines
15256: from wms_wp_wwb_lines_v
15257: where nvl(remove_from_wave_flag, 'N') = 'N'
15258: group by wave_header_id) wwlv,
15259: (select count(1) count_completed_lines, wave_header_id
15260: from wms_wp_wwb_lines_v

Line 15260: from wms_wp_wwb_lines_v

15256: from wms_wp_wwb_lines_v
15257: where nvl(remove_from_wave_flag, 'N') = 'N'
15258: group by wave_header_id) wwlv,
15259: (select count(1) count_completed_lines, wave_header_id
15260: from wms_wp_wwb_lines_v
15261: where line_progress_id >= 8
15262: and nvl(remove_from_wave_flag, 'N') = 'N'
15263: group by wave_header_id) wwlv1
15264: where wwh.wave_header_id = wwlv.wave_header_id

Line 15345: from wms_wp_wwb_lines_v

15341: cursor c_completed_waves is
15342: select wwh.wave_header_id
15343: from wms_wp_wave_headers_vl wwh,
15344: (select wave_header_id, count(1) count_lines
15345: from wms_wp_wwb_lines_v
15346: where nvl(remove_from_wave_flag, 'N') = 'N'
15347: group by wave_header_id) wwlv,
15348: (select count(1) count_completed_lines, wave_header_id
15349: from wms_wp_wwb_lines_v

Line 15349: from wms_wp_wwb_lines_v

15345: from wms_wp_wwb_lines_v
15346: where nvl(remove_from_wave_flag, 'N') = 'N'
15347: group by wave_header_id) wwlv,
15348: (select count(1) count_completed_lines, wave_header_id
15349: from wms_wp_wwb_lines_v
15350: where line_progress_id = 11
15351: and nvl(remove_from_wave_flag, 'N') = 'N'
15352: group by wave_header_id) wwlv1
15353: where wwh.wave_header_id = wwlv.wave_header_id

Line 15733: l_progress_stage := 7; -- skipping 6 here, as it is used for partially loaded in wms_wp_wwb_lines_v

15729: l_progress_stage := 4;
15730: ELSIF (p_progress_stage = 'Tasked') THEN
15731: l_progress_stage := 5;
15732: ELSIF (p_progress_stage = 'Picked') THEN
15733: l_progress_stage := 7; -- skipping 6 here, as it is used for partially loaded in wms_wp_wwb_lines_v
15734: ELSIF (p_progress_stage = 'Packed') THEN
15735: l_progress_stage := 9;
15736: ELSIF (p_progress_stage = 'Staged') THEN
15737: l_progress_stage := 8;

Line 15787: FROM wms_wp_wwb_lines_v

15783: ELSE
15784: 0
15785: END)
15786: INTO l_total_lines, l_perfect_lines
15787: FROM wms_wp_wwb_lines_v
15788: WHERE wave_header_id = l_get_waves.wave_header_id
15789: AND organization_id = p_organization_id
15790: and nvl(remove_from_Wave_flag, 'N') <> 'Y';
15791:

Line 15869: FROM wms_wp_wwb_lines_v

15865: ELSE
15866: 0
15867: END)
15868: INTO l_total_lines, l_perfect_lines
15869: FROM wms_wp_wwb_lines_v
15870: WHERE wave_header_id = l_get_waves.wave_header_id
15871: AND TRIP = l_get_trips.trip_id
15872: AND organization_id = p_organization_id
15873: and nvl(remove_from_Wave_flag, 'N') <> 'Y';

Line 15955: FROM wms_wp_wwb_lines_v

15951: ELSE
15952: 0
15953: END)
15954: INTO l_total_lines, l_perfect_lines
15955: FROM wms_wp_wwb_lines_v
15956: WHERE wave_header_id = l_get_waves.wave_header_id
15957: AND delivery_id = l_get_deliveries.delivery_id
15958: AND organization_id = p_organization_id
15959: and nvl(remove_from_Wave_flag, 'N') <> 'Y';

Line 16042: FROM wms_wp_wwb_lines_v

16038: ELSE
16039: 0
16040: END)
16041: INTO l_total_lines, l_perfect_lines
16042: FROM wms_wp_wwb_lines_v
16043: WHERE wave_header_id = l_get_waves.wave_header_id
16044: AND source_header_id = l_get_so.source_header_id
16045: AND organization_id = p_organization_id
16046: and nvl(remove_from_Wave_flag, 'N') <> 'Y';

Line 16136: FROM wms_wp_wwb_lines_v

16132: ELSE
16133: 0
16134: END)
16135: INTO l_total_lines, l_perfect_lines
16136: FROM wms_wp_wwb_lines_v
16137: WHERE wave_header_id = l_get_waves.wave_header_id
16138: AND source_line_id = l_get_lines.source_line_id
16139: AND organization_id = p_organization_id
16140: and nvl(remove_from_Wave_flag, 'N') <> 'Y';

Line 16702: FROM wms_wp_wwb_lines_v

16698: l_staged,
16699: l_packed,
16700: l_loadedtodock,
16701: l_shipped
16702: FROM wms_wp_wwb_lines_v
16703: WHERE wave_header_id = p_wave_id
16704: AND ((p_entity = 'Wave' AND wave_header_id = p_wave_id) OR
16705: (p_entity = 'Trip' AND trip = p_entity_value) OR
16706: (p_entity = 'Delivery' AND delivery_id = p_entity_value) OR

Line 16884: FROM wms_wp_wwb_lines_v

16880: l_staged,
16881: l_packed,
16882: l_loadedtodock,
16883: l_shipped
16884: FROM wms_wp_wwb_lines_v
16885: WHERE wave_header_id = p_wave_id
16886: AND ((p_entity = 'Wave' AND wave_header_id = p_wave_id) OR
16887: (p_entity = 'Trip' AND trip = p_entity_value) OR
16888: (p_entity = 'Delivery' AND delivery_id = p_entity_value) OR

Line 17981: --12371804 query from base tables instead of wms_wp_wwb_lines_v

17977: and ott.LANGUAGE = userenv('LANG');
17978:
17979:
17980: --Lines GTMP
17981: --12371804 query from base tables instead of wms_wp_wwb_lines_v
17982: insert into wms_wp_lines_gtmp
17983: (DELIVER_TO,
17984: DELIVERY,
17985: EXCEPTION_ID,