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_WVX_PVT dependencies on MTL_SYSTEM_ITEMS

Line 34: mtl_system_items msi,

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,
35: wsh_deliveries wd
36: WHERE spld.delivery_id = x_del_id
37: AND wd.delivery_id = x_del_id
38: AND spl.picking_line_id = spld.picking_line_id

Line 58: mtl_system_items msi,

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
61: AND wd.delivery_id = x_del_id
62: AND spl.picking_line_id = spld.picking_line_id

Line 78: mtl_system_items i_msi, -- configuration item

74: so_picking_lines_all pl,
75: so_line_details ld,
76: so_lines_all l,
77: so_headers_all h,
78: mtl_system_items i_msi, -- configuration item
79: mtl_system_items m_msi -- model
80: WHERE pld.delivery_id = x_del_id
81: AND pl.picking_line_id = pld.picking_line_id
82: AND pl.picking_header_id+0 > 0 -- NOT backordered

Line 79: mtl_system_items m_msi -- model

75: so_line_details ld,
76: so_lines_all l,
77: so_headers_all h,
78: mtl_system_items i_msi, -- configuration item
79: mtl_system_items m_msi -- model
80: WHERE pld.delivery_id = x_del_id
81: AND pl.picking_line_id = pld.picking_line_id
82: AND pl.picking_header_id+0 > 0 -- NOT backordered
83: AND ld.line_detail_id = pl.line_detail_id

Line 198: mtl_system_items msi

194: sld.inventory_item_id) ) weight,
195: msi.weight_uom_code uom
196: FROM so_line_details sld,
197: so_lines_all sl,
198: mtl_system_items msi
199: WHERE sl.ato_line_id = x_a_line_id
200: AND sld.line_id = sl.line_id
201: AND sld.included_item_flag = 'N'
202: AND NVL(sld.configuration_item_flag, 'N') = 'N'

Line 216: mtl_system_items msi

212: sld.inventory_item_id) ) volume,
213: msi.volume_uom_code uom
214: FROM so_line_details sld,
215: so_lines_all sl,
216: mtl_system_items msi
217: WHERE sl.ato_line_id = x_a_line_id
218: AND sld.line_id = sl.line_id
219: AND sld.included_item_flag = 'N'
220: AND NVL(sld.configuration_item_flag, 'N') = 'N'

Line 229: w_uom MTL_SYSTEM_ITEMS.weight_uom_code%TYPE;

225: model_quantity NUMBER;
226: ratio NUMBER;
227: model_weight NUMBER := 0;
228: model_volume NUMBER := 0;
229: w_uom MTL_SYSTEM_ITEMS.weight_uom_code%TYPE;
230: v_uom MTL_SYSTEM_ITEMS.volume_uom_code%TYPE;
231:
232: BEGIN
233: weight := 0;

Line 230: v_uom MTL_SYSTEM_ITEMS.volume_uom_code%TYPE;

226: ratio NUMBER;
227: model_weight NUMBER := 0;
228: model_volume NUMBER := 0;
229: w_uom MTL_SYSTEM_ITEMS.weight_uom_code%TYPE;
230: v_uom MTL_SYSTEM_ITEMS.volume_uom_code%TYPE;
231:
232: BEGIN
233: weight := 0;
234: volume := 0;

Line 339: mtl_system_items msi

335: msi.internal_volume * wpc.quantity max_volume,
336: msi.volume_uom_code volume_uom,
337: msi.minimum_fill_percent min_fill_percent
338: from wsh_packed_containers wpc,
339: mtl_system_items msi
340: where wpc.delivery_id = x_delivery_id
341: and msi.inventory_item_id = wpc.container_inventory_item_id
342: and msi.organization_id = wpc.organization_id
343: order by wpc.sequence_number;

Line 717: mtl_system_items msi

713: SELECT pc.container_inventory_item_id inventory_item_id,
714: NVL(msi.unit_volume, 0) * pc.quantity volume,
715: msi.volume_uom_code uom_code
716: FROM wsh_packed_containers pc,
717: mtl_system_items msi
718: WHERE pc.delivery_id = x_del_id
719: AND pc.container_inventory_item_id = msi.inventory_item_id
720: AND msi.organization_id = x_o_id
721: AND NVL(pc.parent_sequence_number, -1) = NVL(x_seq_num, -1);

Line 735: mtl_system_items msi

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
738: AND pl.picking_line_id = cc.picking_line_id
739: AND pl.picking_header_id+0 > 0

Line 752: mtl_system_items i_msi, -- configuration item

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
753: mtl_system_items m_msi -- model
754: WHERE pld.delivery_id = x_del_id
755: AND pld.container_id = x_cont_id
756: AND pl.picking_line_id = pld.picking_line_id

Line 753: mtl_system_items m_msi -- model

749: so_picking_lines_all pl,
750: so_line_details ld,
751: so_lines_all l,
752: mtl_system_items i_msi, -- configuration item
753: mtl_system_items m_msi -- model
754: WHERE pld.delivery_id = x_del_id
755: AND pld.container_id = x_cont_id
756: AND pl.picking_line_id = pld.picking_line_id
757: AND pl.picking_header_id+0 > 0 -- NOT backordered

Line 894: mtl_system_items msi

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
897: AND pl.picking_line_id = pld.picking_line_id
898: AND msi.inventory_item_id = pl.inventory_item_id

Line 1022: mtl_system_items msi

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
1025: AND msi.organization_id = P_organization_id
1026: AND pld.container_id = P_container_id;

Line 1091: mtl_system_items msi

1087: P_to_uom,
1088: NVL(msi.unit_weight, 0)) * pc.quantity,
1089: 0) cont_tare_weight
1090: FROM wsh_packed_containers pc,
1091: mtl_system_items msi
1092: WHERE msi.inventory_item_id = pc.container_inventory_item_id
1093: AND container_id = P_container_id
1094: AND msi.organization_id = p_org_id;
1095:

Line 1139: mtl_system_items msi

1135: P_to_uom,
1136: NVL(msi.unit_weight, 0)) * pc.quantity,
1137: 0) cont_tare_weight
1138: FROM wsh_packed_containers pc,
1139: mtl_system_items msi
1140: WHERE msi.inventory_item_id = pc.container_inventory_item_id
1141: AND container_id = P_container_id
1142: AND msi.organization_id = P_org_id;
1143:

Line 1167: mtl_system_items msi

1163: P_to_uom,
1164: NVL(msi.unit_weight, 0)) * pc.quantity,
1165: 0) cont_tare_weight
1166: FROM wsh_packed_containers pc,
1167: mtl_system_items msi
1168: WHERE msi.inventory_item_id = pc.container_inventory_item_id
1169: AND container_id = P_container_id
1170: AND msi.organization_id = P_org_id;
1171:

Line 1222: mtl_system_items msi

1218: msi.weight_uom_code msi_wt_uom,
1219: msi.volume_uom_code msi_v_uom,
1220: pc.fill_percent fill
1221: FROM wsh_packed_containers pc,
1222: mtl_system_items msi
1223: WHERE pc.delivery_id = p_del_id
1224: AND msi.inventory_item_id = pc.container_inventory_item_id
1225: AND msi.organization_id = p_org_id;
1226: