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_WVX_PVT dependencies on SO_PICKING_LINES_ALL

Line 31: so_picking_lines_all spl,

27: spld.requested_quantity),
28: spl.inventory_item_id) ) weight,
29: msi.weight_uom_code uom
30: FROM so_picking_line_details spld,
31: so_picking_lines_all spl,
32: so_lines_all sl,
33: so_headers_all sh,
34: mtl_system_items msi,
35: wsh_deliveries wd

Line 57: so_picking_lines_all spl,

53: NVL(spld.shipped_quantity, 0),
54: spl.inventory_item_id) ) weight,
55: msi.weight_uom_code uom
56: FROM so_picking_line_details spld,
57: so_picking_lines_all spl,
58: mtl_system_items msi,
59: wsh_deliveries wd
60: WHERE spld.delivery_id = x_del_id
61: AND wd.delivery_id = x_del_id

Line 74: so_picking_lines_all pl,

70: SELECT l.line_id ato_line_id,
71: -- if qty is NULL, it must be 0 here.
72: sum(NVL(pld.shipped_quantity, 0)) qty
73: FROM so_picking_line_details pld,
74: so_picking_lines_all pl,
75: so_line_details ld,
76: so_lines_all l,
77: so_headers_all h,
78: mtl_system_items i_msi, -- configuration item

Line 734: so_picking_lines_all pl,

730: x_ship_f*cc.requested_quantity),
731: pl.inventory_item_id) ) volume,
732: msi.volume_uom_code uom_code
733: FROM so_picking_line_details cc,
734: so_picking_lines_all pl,
735: mtl_system_items msi
736: WHERE cc.container_id = x_cont_id
737: AND cc.delivery_id = x_del_id
738: AND pl.picking_line_id = cc.picking_line_id

Line 749: so_picking_lines_all pl,

745: SELECT l.line_id ato_line_id,
746: sum(NVL(pld.shipped_quantity,
747: x_ship_f*pld.requested_quantity)) qty
748: FROM so_picking_line_details pld,
749: so_picking_lines_all pl,
750: so_line_details ld,
751: so_lines_all l,
752: mtl_system_items i_msi, -- configuration item
753: mtl_system_items m_msi -- model

Line 893: so_picking_lines_all pl,

889: x_ship_f*pld.requested_quantity))
890: / cl.max_load_quantity) fill
891: FROM wsh_container_load cl,
892: so_picking_line_details pld,
893: so_picking_lines_all pl,
894: mtl_system_items msi
895: WHERE pld.delivery_id = x_del_id
896: AND pld.container_id = x_cont_id
897: AND pl.picking_line_id = pld.picking_line_id

Line 1021: so_picking_lines_all pl,

1017: P_pack_flag *
1018: pld.requested_quantity),
1019: 0) cont_net_weight
1020: FROM so_picking_line_details pld,
1021: so_picking_lines_all pl,
1022: mtl_system_items msi
1023: WHERE pl.picking_line_id = pld.picking_line_id
1024: AND msi.inventory_item_id = pl.inventory_item_id
1025: AND msi.organization_id = P_organization_id