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 SO_PICKING_LINE_DETAILS

Line 373: FROM so_picking_line_details sld,

369: msi.primary_uom_code,
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

Line 391: FROM so_picking_line_details sld,

387: msi.primary_uom_code,
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

Line 436: FROM so_picking_line_details pld,

432: i_msi.volume_uom_code, decode(m_msi.unit_volume,
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

Line 482: FROM so_picking_line_details sld,

478: NVL(sld.shipped_quantity,
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

Line 501: FROM so_picking_line_details sld,

497: NVL(sld.shipped_quantity,
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

Line 534: FROM so_picking_line_details pld,

530: i_msi.volume_uom_code, decode(m_msi.unit_volume,
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

Line 990: FROM so_picking_line_details sld,

986: msi.primary_uom_code,
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

Line 1019: FROM so_picking_line_details pld,

1015:
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

Line 1056: FROM so_picking_line_details sld,

1052: NVL(sld.shipped_quantity,
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

Line 1071: FROM so_picking_line_details pld,

1067: CURSOR sc_unpacked_ato(x_del_id NUMBER, x_wv_mode NUMBER) IS
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

Line 1241: FROM so_picking_line_details sld,

1237: msi.primary_uom_code,
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

Line 1266: FROM so_picking_line_details pld,

1262:
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

Line 1422: FROM so_picking_line_details spld,

1418: IS
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...

Line 1671: FROM so_picking_line_details cc,

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

Line 1686: FROM so_picking_line_details pld,

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

Line 1843: FROM so_picking_line_details spld,

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

Line 1858: FROM so_picking_line_details pld,

1854: CURSOR unpacked_ato(x_del_id NUMBER, x_wv_mode NUMBER) IS
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

Line 2003: FROM so_picking_line_details dl,

1999: spl.inventory_item_id)
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