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.WSH_WV_PVT dependencies on WSH_CONTAINER_LOAD

Line 705: FROM wsh_container_load cl,

701: status IN OUT NUMBER)
702: IS
703: CURSOR container_fill(x_dep_id NUMBER, x_o_id NUMBER, x_veh_id NUMBER) IS
704: SELECT SUM(pc.quantity / cl.max_load_quantity) * 100
705: FROM wsh_container_load cl,
706: wsh_packed_containers pc,
707: wsh_deliveries d
708: WHERE d.actual_departure_id = x_dep_id
709: AND d.delivery_id = pc.delivery_id

Line 1975: wsh_container_load wcl,

1971: 0.01*NVL(cont_msi.minimum_fill_percent, 0) min_fill,
1972: cont_msi.weight_uom_code
1973: FROM so_line_details dl,
1974: mtl_system_items item_msi,
1975: wsh_container_load wcl,
1976: mtl_system_items cont_msi
1977: WHERE
1978: dl.delivery_id = x_del_id
1979: AND item_msi.inventory_item_id = dl.inventory_item_id

Line 2006: wsh_container_load wcl,

2002: cont_msi.weight_uom_code
2003: FROM so_picking_line_details dl,
2004: so_picking_lines_all spl,
2005: mtl_system_items item_msi,
2006: wsh_container_load wcl,
2007: mtl_system_items cont_msi
2008: WHERE
2009: spl.picking_line_id = dl.picking_line_id
2010: AND spl.picking_header_id = 0 -- backordered

Line 2027: current_container_item_id WSH_CONTAINER_LOAD.container_item_id%TYPE := NULL;

2023: AND cont_msi.organization_id = x_o_id
2024: ORDER BY 1, 2;
2025:
2026: load_seq_number SO_LINE_DETAILS.load_seq_number%TYPE := NULL;
2027: current_container_item_id WSH_CONTAINER_LOAD.container_item_id%TYPE := NULL;
2028: raw_qty NUMBER := 0;
2029: min_fill NUMBER := 0;
2030: weight_code MTL_SYSTEM_ITEMS.weight_uom_code%TYPE := '';
2031: x_del_id NUMBER := del_id;