APPS.WSH_WVX_PVT dependencies on SO_PICKING_LINE_DETAILS

Line 30: FROM so_picking_line_details spld,

26: NVL(spld.shipped_quantity,
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,

Line 56: FROM so_picking_line_details spld,

52: -- if qty is NULL, it must be 0 here.
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

Line 73: FROM so_picking_line_details pld,

69: CURSOR ato(x_del_id NUMBER, x_order_n NUMBER, x_order_t NUMBER) IS
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,

Line 733: FROM so_picking_line_details cc,

729: NVL(cc.shipped_quantity,
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

Line 748: FROM so_picking_line_details pld,

744: CURSOR packed_ato(x_del_id NUMBER, x_cont_id NUMBER, x_ship_f NUMBER) IS
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

Line 892: so_picking_line_details pld,

888: NVL(pld.shipped_quantity,
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

Line 1020: FROM so_picking_line_details pld,

1016: NVL(pld.shipped_quantity,
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