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 WSH_WV_PVT

Line 24: WSH_WV_PVT.convert_uom(spl.unit_code,

20: RETURN NUMBER IS
21:
22: CURSOR items_weight(x_del_id NUMBER, x_order_n NUMBER, x_order_t NUMBER) IS
23: SELECT SUM( NVL(msi.unit_weight, 0) *
24: WSH_WV_PVT.convert_uom(spl.unit_code,
25: msi.primary_uom_code,
26: NVL(spld.shipped_quantity,
27: spld.requested_quantity),
28: spl.inventory_item_id) ) weight,

Line 50: WSH_WV_PVT.convert_uom(spl.unit_code,

46: GROUP BY msi.weight_uom_code;
47:
48: CURSOR delivery_weight(x_del_id NUMBER) IS
49: SELECT SUM( NVL(msi.unit_weight, 0) *
50: WSH_WV_PVT.convert_uom(spl.unit_code,
51: msi.primary_uom_code,
52: -- if qty is NULL, it must be 0 here.
53: NVL(spld.shipped_quantity, 0),
54: spl.inventory_item_id) ) weight,

Line 113: + WSH_WV_PVT.convert_uom(w.uom, weight_uom, w.weight);

109:
110: if order_number is not null then
111: for w in items_weight(delivery_id, order_number, order_type_id) loop
112: net_weight := net_weight
113: + WSH_WV_PVT.convert_uom(w.uom, weight_uom, w.weight);
114: end loop;
115: else
116: for w in delivery_weight(delivery_id) loop
117: net_weight := net_weight

Line 118: + WSH_WV_PVT.convert_uom(w.uom, weight_uom, w.weight);

114: end loop;
115: else
116: for w in delivery_weight(delivery_id) loop
117: net_weight := net_weight
118: + WSH_WV_PVT.convert_uom(w.uom, weight_uom, w.weight);
119: end loop;
120: end if;
121:
122: FOR a in ato(delivery_id, order_number, order_type_id) LOOP

Line 191: WSH_WV_PVT.convert_uom(sld.unit_code,

187: -- same WHERE clause. The only difference is weight vs. volume.
188:
189: CURSOR ato_weight(x_a_line_id NUMBER) IS
190: SELECT SUM( NVL(msi.unit_weight, 0) *
191: WSH_WV_PVT.convert_uom(sld.unit_code,
192: msi.primary_uom_code,
193: sld.quantity,
194: sld.inventory_item_id) ) weight,
195: msi.weight_uom_code uom

Line 209: WSH_WV_PVT.convert_uom(sld.unit_code,

205: GROUP BY msi.weight_uom_code;
206:
207: CURSOR ato_volume(x_a_line_id NUMBER) IS
208: SELECT SUM( NVL(msi.unit_volume, 0) *
209: WSH_WV_PVT.convert_uom(sld.unit_code,
210: msi.primary_uom_code,
211: sld.quantity,
212: sld.inventory_item_id) ) volume,
213: msi.volume_uom_code uom

Line 260: + WSH_WV_PVT.convert_uom(aw.uom, weight_uom, aw.weight);

256:
257: IF weight_uom IS NOT NULL THEN
258: FOR aw IN ato_weight(ato_line_id) LOOP
259: model_weight := model_weight
260: + WSH_WV_PVT.convert_uom(aw.uom, weight_uom, aw.weight);
261: END LOOP;
262: weight := model_weight * ratio;
263: END IF;
264:

Line 268: + WSH_WV_PVT.convert_uom(av.uom, volume_uom, av.volume);

264:
265: IF volume_uom IS NOT NULL THEN
266: FOR av IN ato_volume(ato_line_id) LOOP
267: model_volume := model_volume
268: + WSH_WV_PVT.convert_uom(av.uom, volume_uom, av.volume);
269: END LOOP;
270: volume := model_volume * ratio;
271: END IF;
272:

Line 328: WSH_WV_PVT.convert_uom(wpc.weight_uom_code,

324: wpc.container_id container_id,
325: wpc.container_inventory_item_id inventory_item_id,
326: wpc.quantity quantity,
327: -- net_weight = gross_weight - tare_weight
328: WSH_WV_PVT.convert_uom(wpc.weight_uom_code,
329: msi.weight_uom_code,
330: NVL(wpc.gross_weight, 0),
331: msi.inventory_item_id)
332: - wpc.quantity * NVL(msi.unit_weight,0) net_weight,

Line 450: excess := WSH_WV_PVT.convert_uom(container.weight_uom,

446: w_uom := container.weight_uom;
447: END IF;
448:
449: -- calculate the absolute excess
450: excess := WSH_WV_PVT.convert_uom(container.weight_uom,
451: w_uom,
452: (container.net_weight
453: - container.max_weight));
454:

Line 497: excess := WSH_WV_PVT.convert_uom(container.volume_uom,

493: v_uom := container.volume_uom;
494: END IF;
495:
496: -- calculate the absolute excess
497: excess := WSH_WV_PVT.convert_uom(container.volume_uom,
498: v_uom,
499: (net_volume
500: - container.max_volume));
501:

Line 727: WSH_WV_PVT.convert_uom(pl.unit_code,

723: CURSOR contents_volume(x_del_id NUMBER, x_o_id NUMBER,
724: x_cont_id NUMBER, x_ship_f NUMBER) IS
725: SELECT pl.inventory_item_id,
726: SUM( NVL(msi.unit_volume, 0) *
727: WSH_WV_PVT.convert_uom(pl.unit_code,
728: msi.primary_uom_code,
729: NVL(cc.shipped_quantity,
730: x_ship_f*cc.requested_quantity),
731: pl.inventory_item_id) ) volume,

Line 790: + WSH_WV_PVT.convert_uom(container.uom_code, master_uom,

786:
787: FOR container IN container_volume(delivery_id, organization_id,
788: sequence_number) LOOP
789: net_volume := net_volume
790: + WSH_WV_PVT.convert_uom(container.uom_code, master_uom,
791: container.volume,
792: container.inventory_item_id);
793: END LOOP;
794:

Line 798: + WSH_WV_PVT.convert_uom(item.uom_code, master_uom,

794:
795: FOR item IN contents_volume(delivery_id, organization_id,
796: container_id, ship_factor) LOOP
797: net_volume := net_volume
798: + WSH_WV_PVT.convert_uom(item.uom_code, master_uom,
799: item.volume,
800: item.inventory_item_id);
801: END LOOP;
802:

Line 886: SELECT SUM( WSH_WV_PVT.convert_uom(pl.unit_code,

882:
883: CURSOR contents_fill(x_del_id NUMBER, x_o_id NUMBER,
884: x_container_item_id NUMBER,
885: x_cont_id NUMBER, x_ship_f NUMBER) IS
886: SELECT SUM( WSH_WV_PVT.convert_uom(pl.unit_code,
887: msi.primary_uom_code,
888: NVL(pld.shipped_quantity,
889: x_ship_f*pld.requested_quantity))
890: / cl.max_load_quantity) fill

Line 1013: SELECT NVL(wsh_wv_pvt.convert_uom(msi.weight_uom_code,

1009: P_organization_id NUMBER,
1010: P_to_uom VARCHAR2,
1011: P_pack_flag NUMBER)
1012: IS
1013: SELECT NVL(wsh_wv_pvt.convert_uom(msi.weight_uom_code,
1014: P_to_uom,
1015: NVL(msi.unit_weight, 0)) *
1016: NVL(pld.shipped_quantity,
1017: P_pack_flag *

Line 1086: SELECT NVL(wsh_wv_pvt.convert_uom(msi.weight_uom_code,

1082: P_container_id NUMBER,
1083: P_to_uom VARCHAR2,
1084: p_org_id NUMBER)
1085: IS
1086: SELECT NVL(wsh_wv_pvt.convert_uom(msi.weight_uom_code,
1087: P_to_uom,
1088: NVL(msi.unit_weight, 0)) * pc.quantity,
1089: 0) cont_tare_weight
1090: FROM wsh_packed_containers pc,

Line 1134: SELECT NVL(wsh_wv_pvt.convert_uom(msi.weight_uom_code,

1130: P_container_id NUMBER,
1131: P_org_id NUMBER,
1132: P_to_uom VARCHAR2)
1133: IS
1134: SELECT NVL(wsh_wv_pvt.convert_uom(msi.weight_uom_code,
1135: P_to_uom,
1136: NVL(msi.unit_weight, 0)) * pc.quantity,
1137: 0) cont_tare_weight
1138: FROM wsh_packed_containers pc,

Line 1162: SELECT NVL(wsh_wv_pvt.convert_uom(msi.weight_uom_code,

1158: P_container_id NUMBER,
1159: P_org_id NUMBER,
1160: P_to_uom VARCHAR2)
1161: IS
1162: SELECT NVL(wsh_wv_pvt.convert_uom(msi.weight_uom_code,
1163: P_to_uom,
1164: NVL(msi.unit_weight, 0)) * pc.quantity,
1165: 0) cont_tare_weight
1166: FROM wsh_packed_containers pc,

Line 1292: l_tmp_max_v := wsh_wv_pvt.convert_uom(container.msi_v_uom,

1288: ELSIF x_fill_base = 'V' THEN
1289: IF (l_volume = -99) THEN
1290: l_volume := container.v;
1291: END IF;
1292: l_tmp_max_v := wsh_wv_pvt.convert_uom(container.msi_v_uom,
1293: container.v_uom,
1294: container.max_v);
1295: l_fill_percent := l_volume /
1296: (l_tmp_max_v * container.quantity);

Line 1307: l_tmp_max_wt := wsh_wv_pvt.convert_uom(container.msi_wt_uom,

1303: IF (l_tare_wt = -99) THEN
1304: l_tare_wt := container.gross_wt - container.net_wt;
1305: END IF;
1306:
1307: l_tmp_max_wt := wsh_wv_pvt.convert_uom(container.msi_wt_uom,
1308: container.wt_uom,
1309: container.max_wt);
1310: containers_tare_weight_self(container.id,
1311: x_org_id,