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_LINE_DETAILS

Line 342: FROM so_line_details sld,

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

Line 357: FROM so_line_details sld,

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

Line 405: FROM so_line_details ld,

401:
402: CURSOR dpw_loose_ato(x_dep_id NUMBER) IS
403: SELECT l.line_id ato_line_id,
404: sum(ld.quantity) qty
405: FROM so_line_details ld,
406: so_lines_all l
407: WHERE ld.departure_id = x_dep_id
408: AND ld.delivery_id IS NULL
409: AND ld.included_item_flag = 'N'

Line 438: so_line_details ld,

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
442: WHERE pld.departure_id = x_dep_id

Line 536: so_line_details ld,

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
540: WHERE pld.departure_id = x_dep_id

Line 974: FROM so_line_details sld,

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

Line 1005: FROM so_line_details ld,

1001:
1002: CURSOR dpw_unpacked_ato(x_del_id NUMBER) IS
1003: SELECT l.line_id ato_line_id,
1004: sum(NVL(ld.quantity, 0)) qty
1005: FROM so_line_details ld,
1006: so_lines_all l
1007: WHERE ld.delivery_id = x_del_id
1008: AND ld.master_container_item_id IS NULL -- no default containers may
1009: AND ld.detail_container_item_id IS NULL -- mean that it is unpacked.

Line 1021: so_line_details ld,

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
1025: WHERE pld.delivery_id = x_del_id

Line 1073: so_line_details ld,

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
1077: WHERE pld.delivery_id = x_del_id

Line 1227: FROM so_line_details sld,

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

Line 1254: FROM so_line_details ld,

1250:
1251: CURSOR ato(x_del_id NUMBER) IS
1252: SELECT l.line_id ato_line_id,
1253: sum(ld.quantity) qty
1254: FROM so_line_details ld,
1255: so_lines_all l
1256: WHERE ld.delivery_id = x_del_id
1257: AND ld.included_item_flag = 'N'
1258: AND l.line_id = ld.line_id

Line 1268: so_line_details ld,

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
1272: WHERE pld.delivery_id = x_del_id

Line 1688: so_line_details ld,

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
1692: WHERE pld.delivery_id = x_del_id

Line 1860: so_line_details ld,

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
1864: WHERE pld.delivery_id = x_del_id

Line 1973: FROM so_line_details dl,

1969: dl.inventory_item_id)
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

Line 2026: load_seq_number SO_LINE_DETAILS.load_seq_number%TYPE := NULL;

2022: AND cont_msi.inventory_item_id = wcl.container_item_id
2023: AND cont_msi.organization_id = x_o_id
2024: ORDER BY 1, 2;
2025:
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 := '';