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 MTL_SYSTEM_ITEMS

Line 150: mtl_system_items msi

146: NVL(msi.unit_weight, 0))
147: * pc.quantity),
148: 0) tare_weight
149: FROM wsh_packed_containers pc,
150: mtl_system_items msi
151: WHERE msi.inventory_item_id = pc.container_inventory_item_id
152: AND pc.delivery_id = x_del_id
153: AND msi.organization_id = x_o_id;
154:

Line 343: mtl_system_items msi

339: sld.quantity,
340: sld.inventory_item_id) ) weight,
341: msi.weight_uom_code uom
342: FROM so_line_details sld,
343: mtl_system_items msi
344: WHERE sld.departure_id = x_dep_id
345: AND sld.delivery_id IS NULL
346: AND msi.inventory_item_id = sld.inventory_item_id
347: AND msi.organization_id = x_o_id

Line 358: mtl_system_items msi

354: sld.quantity,
355: sld.inventory_item_id) ) volume,
356: msi.volume_uom_code uom
357: FROM so_line_details sld,
358: mtl_system_items msi
359: WHERE sld.departure_id = x_dep_id
360: AND sld.delivery_id IS NULL
361: AND msi.inventory_item_id = sld.inventory_item_id
362: AND msi.organization_id = x_o_id

Line 375: mtl_system_items msi

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
379: AND sl.picking_header_id = 0 -- backordered

Line 393: mtl_system_items msi

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
397: AND sl.picking_header_id = 0 -- backordered

Line 440: mtl_system_items i_msi, -- configuration item

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
442: WHERE pld.departure_id = x_dep_id
443: AND pld.delivery_id IS NULL
444: AND pl.picking_line_id = pld.picking_line_id

Line 441: mtl_system_items m_msi -- model

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
442: WHERE pld.departure_id = x_dep_id
443: AND pld.delivery_id IS NULL
444: AND pl.picking_line_id = pld.picking_line_id
445: AND pl.picking_header_id+0 = 0 -- backordered

Line 484: mtl_system_items msi

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
488: AND sl.picking_header_id+0 > 0 -- NOT backordered

Line 503: mtl_system_items msi

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
507: AND sl.picking_header_id+0 > 0 -- NOT backordered

Line 538: mtl_system_items i_msi, -- configuration item

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
540: WHERE pld.departure_id = x_dep_id
541: AND pld.delivery_id IS NULL
542: AND pl.picking_line_id = pld.picking_line_id

Line 539: mtl_system_items m_msi -- model

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
540: WHERE pld.departure_id = x_dep_id
541: AND pld.delivery_id IS NULL
542: AND pl.picking_line_id = pld.picking_line_id
543: AND pl.picking_header_id+0 > 0 -- NOT backordered

Line 957: mtl_system_items msi

953: CURSOR delivery_volumes(x_del_id NUMBER, x_o_id NUMBER) IS
954: SELECT SUM(NVL(msi.unit_volume, 0) * pc.quantity) volume,
955: msi.volume_uom_code uom
956: FROM wsh_packed_containers pc,
957: mtl_system_items msi
958: WHERE msi.inventory_item_id = pc.container_inventory_item_id
959: AND pc.delivery_id = x_del_id
960: AND msi.organization_id = x_o_id
961: AND (pc.parent_sequence_number IS NULL

Line 975: mtl_system_items msi

971: sld.quantity,
972: sld.inventory_item_id) ) volume,
973: msi.volume_uom_code uom
974: FROM so_line_details sld,
975: mtl_system_items msi
976: WHERE sld.delivery_id = x_del_id
977: AND sld.master_container_item_id IS NULL -- no default containers may
978: AND sld.detail_container_item_id IS NULL -- mean that it is unpacked.
979: AND msi.inventory_item_id = sld.inventory_item_id

Line 992: mtl_system_items msi

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
996: AND sld.detail_container_item_id IS NULL -- mean that it is unpacked.

Line 1023: mtl_system_items i_msi, -- configuration item

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
1025: WHERE pld.delivery_id = x_del_id
1026: AND pld.container_id IS NULL
1027: AND pl.picking_line_id = pld.picking_line_id

Line 1024: mtl_system_items m_msi -- model

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
1025: WHERE pld.delivery_id = x_del_id
1026: AND pld.container_id IS NULL
1027: AND pl.picking_line_id = pld.picking_line_id
1028: AND pl.picking_header_id+0 = 0 -- backordered

Line 1058: mtl_system_items msi

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.
1062: AND sl.picking_header_id+0 > 0 -- NOT backordered

Line 1075: mtl_system_items i_msi, -- configuration item

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
1077: WHERE pld.delivery_id = x_del_id
1078: AND pld.container_id IS NULL
1079: AND pl.picking_line_id = pld.picking_line_id

Line 1076: mtl_system_items m_msi -- model

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
1077: WHERE pld.delivery_id = x_del_id
1078: AND pld.container_id IS NULL
1079: AND pl.picking_line_id = pld.picking_line_id
1080: AND pl.picking_header_id+0 > 0 -- NOT backordered

Line 1212: mtl_system_items msi

1208: CURSOR delivery_weights(x_del_id NUMBER, x_o_id NUMBER) IS
1209: SELECT SUM(NVL(msi.unit_weight, 0) * pc.quantity) weight,
1210: msi.weight_uom_code uom
1211: FROM wsh_packed_containers pc,
1212: mtl_system_items msi
1213: WHERE msi.inventory_item_id = pc.container_inventory_item_id
1214: AND pc.delivery_id = x_del_id
1215: AND msi.organization_id = x_o_id
1216: GROUP BY msi.weight_uom_code;

Line 1228: mtl_system_items msi

1224: sld.quantity,
1225: sld.inventory_item_id) ) weight,
1226: msi.weight_uom_code uom
1227: FROM so_line_details sld,
1228: mtl_system_items msi
1229: WHERE sld.delivery_id = x_del_id
1230: AND msi.inventory_item_id = sld.inventory_item_id
1231: AND msi.organization_id = x_o_id
1232: GROUP BY msi.weight_uom_code;

Line 1243: mtl_system_items msi

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
1247: AND msi.inventory_item_id = sl.inventory_item_id

Line 1270: mtl_system_items i_msi, -- configuration item

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
1272: WHERE pld.delivery_id = x_del_id
1273: AND pl.picking_line_id = pld.picking_line_id
1274: AND pl.picking_header_id+0 = 0 -- backordered

Line 1271: mtl_system_items m_msi -- model

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
1272: WHERE pld.delivery_id = x_del_id
1273: AND pl.picking_line_id = pld.picking_line_id
1274: AND pl.picking_header_id+0 = 0 -- backordered
1275: AND ld.line_detail_id = pl.line_detail_id

Line 1551: mtl_system_items msi

1547: pc.weight_uom_code w_uom_code,
1548: msi.maximum_load_weight max_weight,
1549: msi.weight_uom_code mw_uom_code
1550: FROM wsh_packed_containers pc,
1551: mtl_system_items msi
1552: WHERE pc.delivery_id = x_del_id
1553: AND msi.inventory_item_id = pc.container_inventory_item_id
1554: AND msi.organization_id = x_o_id
1555: AND NVL(msi.maximum_load_weight, 0) > 0

Line 1655: mtl_system_items msi

1651: pc.rowid rid,
1652: msi.unit_weight unit_weight,
1653: msi.weight_uom_code uom_code
1654: FROM wsh_packed_containers pc,
1655: mtl_system_items msi
1656: WHERE pc.delivery_id = x_del_id
1657: AND pc.container_inventory_item_id = msi.inventory_item_id
1658: AND msi.organization_id = x_o_id
1659: AND NVL(pc.parent_sequence_number, -1) = NVL(x_seq_num, -1);

Line 1673: mtl_system_items msi

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
1677: AND pl.picking_header_id+0 > 0

Line 1690: mtl_system_items i_msi, -- configuration item

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
1692: WHERE pld.delivery_id = x_del_id
1693: AND pld.container_id = x_cont_id
1694: AND pl.picking_line_id = pld.picking_line_id

Line 1691: mtl_system_items m_msi -- model

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
1692: WHERE pld.delivery_id = x_del_id
1693: AND pld.container_id = x_cont_id
1694: AND pl.picking_line_id = pld.picking_line_id
1695: AND pl.picking_header_id+0 > 0 -- NOT backordered

Line 1845: mtl_system_items msi

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
1849: AND spl.picking_header_id+0 > 0

Line 1862: mtl_system_items i_msi, -- configuration item

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
1864: WHERE pld.delivery_id = x_del_id
1865: AND pld.container_id IS NULL -- not packed in any container
1866: AND pl.picking_line_id = pld.picking_line_id

Line 1863: mtl_system_items m_msi -- model

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
1864: WHERE pld.delivery_id = x_del_id
1865: AND pld.container_id IS NULL -- not packed in any container
1866: AND pl.picking_line_id = pld.picking_line_id
1867: AND pl.picking_header_id+0 > 0

Line 1974: mtl_system_items item_msi,

1970: / wcl.max_load_quantity raw_qty,
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

Line 1976: mtl_system_items cont_msi

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
1980: AND item_msi.organization_id = x_o_id

Line 2005: mtl_system_items item_msi,

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
2009: spl.picking_line_id = dl.picking_line_id

Line 2007: mtl_system_items cont_msi

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
2011: AND dl.delivery_id = x_del_id

Line 2030: weight_code MTL_SYSTEM_ITEMS.weight_uom_code%TYPE := '';

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;
2032:
2033: BEGIN
2034: