[Home] [Help]
370: sld.requested_quantity,
371: sl.inventory_item_id) ) weight,
372: msi.weight_uom_code uom
373: FROM so_picking_line_details sld,
374: so_picking_lines_all sl,
375: mtl_system_items msi
376: WHERE sld.departure_id = x_dep_id
377: AND sld.delivery_id IS NULL
378: AND sl.picking_line_id = sld.picking_line_id
388: sld.requested_quantity,
389: sl.inventory_item_id) ) volume,
390: msi.volume_uom_code uom
391: FROM so_picking_line_details sld,
392: so_picking_lines_all sl,
393: mtl_system_items msi
394: WHERE sld.departure_id = x_dep_id
395: AND sld.delivery_id IS NULL
396: AND sl.picking_line_id = sld.picking_line_id
433: i_msi.unit_volume, x_v_uom,
434: NULL),
435: NULL) volume_uom
436: FROM so_picking_line_details pld,
437: so_picking_lines_all pl,
438: so_line_details ld,
439: so_lines_all l,
440: mtl_system_items i_msi, -- configuration item
441: mtl_system_items m_msi -- model
479: x_wv_mode*sld.requested_quantity),
480: sl.inventory_item_id) ) weight,
481: msi.weight_uom_code uom
482: FROM so_picking_line_details sld,
483: so_picking_lines_all sl,
484: mtl_system_items msi
485: WHERE sld.departure_id = x_dep_id
486: AND sld.delivery_id IS NULL
487: AND sl.picking_line_id = sld.picking_line_id
498: x_wv_mode*sld.requested_quantity),
499: sl.inventory_item_id) ) volume,
500: msi.volume_uom_code uom
501: FROM so_picking_line_details sld,
502: so_picking_lines_all sl,
503: mtl_system_items msi
504: WHERE sld.departure_id = x_dep_id
505: AND sld.delivery_id IS NULL
506: AND sl.picking_line_id = sld.picking_line_id
531: i_msi.unit_volume, x_v_uom,
532: NULL),
533: NULL) volume_uom
534: FROM so_picking_line_details pld,
535: so_picking_lines_all pl,
536: so_line_details ld,
537: so_lines_all l,
538: mtl_system_items i_msi, -- configuration item
539: mtl_system_items m_msi -- model
987: sld.requested_quantity,
988: sl.inventory_item_id) ) volume,
989: msi.volume_uom_code uom
990: FROM so_picking_line_details sld,
991: so_picking_lines_all sl,
992: mtl_system_items msi
993: WHERE sld.delivery_id = x_del_id
994: AND sl.picking_line_id = sld.picking_line_id
995: AND sld.master_container_item_id IS NULL -- no default containers may
1016: CURSOR dpw_unpacked_bo_ato(x_del_id NUMBER) IS
1017: SELECT l.line_id ato_line_id,
1018: sum(NVL(pld.requested_quantity, 0)) qty
1019: FROM so_picking_line_details pld,
1020: so_picking_lines_all pl,
1021: so_line_details ld,
1022: so_lines_all l,
1023: mtl_system_items i_msi, -- configuration item
1024: mtl_system_items m_msi -- model
1053: x_wv_mode*sld.requested_quantity),
1054: sl.inventory_item_id) ) volume,
1055: msi.volume_uom_code uom
1056: FROM so_picking_line_details sld,
1057: so_picking_lines_all sl,
1058: mtl_system_items msi
1059: WHERE sld.delivery_id = x_del_id
1060: AND sl.picking_line_id = sld.picking_line_id
1061: AND sld.container_id IS NULL -- definitely unpacked.
1068: SELECT l.line_id ato_line_id,
1069: sum(NVL(pld.shipped_quantity,
1070: x_wv_mode * pld.requested_quantity)) qty
1071: FROM so_picking_line_details pld,
1072: so_picking_lines_all pl,
1073: so_line_details ld,
1074: so_lines_all l,
1075: mtl_system_items i_msi, -- configuration item
1076: mtl_system_items m_msi -- model
1238: sld.requested_quantity,
1239: sl.inventory_item_id) ) weight,
1240: msi.weight_uom_code uom
1241: FROM so_picking_line_details sld,
1242: so_picking_lines_all sl,
1243: mtl_system_items msi
1244: WHERE sld.delivery_id = x_del_id
1245: AND sl.picking_line_id = sld.picking_line_id
1246: AND sl.picking_header_id = 0 -- backordered
1263: CURSOR bo_ato(x_del_id NUMBER) IS
1264: SELECT l.line_id ato_line_id,
1265: sum(NVL(pld.requested_quantity, 0)) qty
1266: FROM so_picking_line_details pld,
1267: so_picking_lines_all pl,
1268: so_line_details ld,
1269: so_lines_all l,
1270: mtl_system_items i_msi, -- configuration item
1271: mtl_system_items m_msi -- model
1419: CURSOR unpacked_items(x_del_id NUMBER, x_ship_all_flag NUMBER) IS
1420: SELECT spl.inventory_item_id id,
1421: spl.warehouse_id o_id
1422: FROM so_picking_line_details spld,
1423: so_picking_lines_all spl
1424: WHERE spld.delivery_id = x_del_id
1425: AND spld.container_id IS NULL -- not packed.
1426: -- but this item will be shipped...
1427: AND NVL(spld.shipped_quantity, x_ship_all_flag) > 0
1668: x_wv_mode*cc.requested_quantity),
1669: pl.inventory_item_id) ) weight,
1670: msi.weight_uom_code uom_code
1671: FROM so_picking_line_details cc,
1672: so_picking_lines_all pl,
1673: mtl_system_items msi
1674: WHERE cc.container_id = x_cont_id
1675: AND cc.delivery_id = x_del_id
1676: AND pl.picking_line_id = cc.picking_line_id
1683: SELECT l.line_id ato_line_id,
1684: sum(NVL(pld.shipped_quantity,
1685: x_wv_mode * pld.requested_quantity)) qty
1686: FROM so_picking_line_details pld,
1687: so_picking_lines_all pl,
1688: so_line_details ld,
1689: so_lines_all l,
1690: mtl_system_items i_msi, -- configuration item
1691: mtl_system_items m_msi -- model
1840: x_wv_mode*spld.requested_quantity),
1841: spl.inventory_item_id) ) weight,
1842: msi.weight_uom_code uom
1843: FROM so_picking_line_details spld,
1844: so_picking_lines_all spl,
1845: mtl_system_items msi
1846: WHERE spld.delivery_id = x_del_id
1847: AND spld.container_id IS NULL -- not packed in any container
1848: AND spld.picking_line_id = spl.picking_line_id
1855: SELECT l.line_id ato_line_id,
1856: sum(NVL(pld.shipped_quantity,
1857: x_wv_mode * pld.requested_quantity)) qty
1858: FROM so_picking_line_details pld,
1859: so_picking_lines_all pl,
1860: so_line_details ld,
1861: so_lines_all l,
1862: mtl_system_items i_msi, -- configuration item
1863: mtl_system_items m_msi -- model
2000: / wcl.max_load_quantity raw_qty,
2001: 0.01*NVL(cont_msi.minimum_fill_percent, 0) min_fill,
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