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.INV_LOC_WMS_UTILS dependencies on INV_CONVERT

Line 714: inv_convert.inv_um_convert( item_id => p_inventory_item_id,

710: IF (l_item_primary_uom_code <> p_transaction_uom_code)
711: and (p_primary_uom_flag <> 'Y') then
712:
713: l_primary_quantity :=
714: inv_convert.inv_um_convert( item_id => p_inventory_item_id,
715: precision => null,
716: from_quantity => l_quantity,
717: from_unit => p_transaction_uom_code,
718: to_unit => l_item_primary_uom_code,

Line 740: inv_convert.inv_um_convert( item_id => p_inventory_item_id,

736: l_transacted_weight := l_primary_quantity * l_item_unit_weight;
737:
738: IF (l_item_weight_uom_code <> l_location_weight_uom_code) then
739: l_loc_uom_xacted_weight :=
740: inv_convert.inv_um_convert( item_id => p_inventory_item_id,
741: precision => null,
742: from_quantity => l_transacted_weight,
743: from_unit => l_item_weight_uom_code,
744: to_unit => l_location_weight_uom_code,

Line 765: inv_convert.inv_um_convert( item_id => p_inventory_item_id,

761:
762: l_transacted_volume := l_primary_quantity * l_item_unit_volume;
763: IF (l_item_volume_uom_code <> l_volume_uom_code) then
764: l_loc_uom_xacted_volume :=
765: inv_convert.inv_um_convert( item_id => p_inventory_item_id,
766: precision => null,
767: from_quantity => l_transacted_volume,
768: from_unit => l_item_volume_uom_code,
769: to_unit => l_volume_uom_code,

Line 1422: inv_convert.inv_um_convert( item_id => p_inventory_item_id,

1418: IF (l_item_primary_uom_code <> p_transaction_uom_code)
1419: and (p_primary_uom_flag <> 'Y') then
1420:
1421: l_primary_quantity :=
1422: inv_convert.inv_um_convert( item_id => p_inventory_item_id,
1423: precision => null,
1424: from_quantity => l_quantity,
1425: from_unit => p_transaction_uom_code,
1426: to_unit => l_item_primary_uom_code,

Line 1447: inv_convert.inv_um_convert( item_id => p_inventory_item_id,

1443: l_transacted_weight := l_primary_quantity * l_item_unit_weight;
1444:
1445: IF (l_item_weight_uom_code <> l_location_weight_uom_code) then
1446: l_loc_uom_xacted_weight :=
1447: inv_convert.inv_um_convert( item_id => p_inventory_item_id,
1448: precision => null,
1449: from_quantity => l_transacted_weight,
1450: from_unit => l_item_weight_uom_code,
1451: to_unit => l_location_weight_uom_code,

Line 1473: inv_convert.inv_um_convert( item_id => p_inventory_item_id,

1469: l_transacted_volume := l_primary_quantity * l_item_unit_volume;
1470: -- make sure that transcated_volume > 0
1471: IF (l_item_volume_uom_code <> l_volume_uom_code) then
1472: l_loc_uom_xacted_volume :=
1473: inv_convert.inv_um_convert( item_id => p_inventory_item_id,
1474: precision => null,
1475: from_quantity => l_transacted_volume,
1476: from_unit => l_item_volume_uom_code,
1477: to_unit => l_volume_uom_code,

Line 1980: inv_convert.inv_um_convert( item_id => p_inventory_item_id,

1976: IF (l_item_primary_uom_code <> p_transaction_uom_code)
1977: and (p_primary_uom_flag <> 'Y') then
1978:
1979: l_primary_quantity :=
1980: inv_convert.inv_um_convert( item_id => p_inventory_item_id,
1981: precision => null,
1982: from_quantity => l_quantity,
1983: from_unit => p_transaction_uom_code,
1984: to_unit => l_item_primary_uom_code,

Line 2002: inv_convert.inv_um_convert( item_id => p_inventory_item_id,

1998: l_transacted_weight := l_primary_quantity * l_item_unit_weight;
1999:
2000: IF (l_item_weight_uom_code <> l_location_weight_uom_code) then
2001: l_loc_uom_xacted_weight :=
2002: inv_convert.inv_um_convert( item_id => p_inventory_item_id,
2003: precision => null,
2004: from_quantity => l_transacted_weight,
2005: from_unit => l_item_weight_uom_code,
2006: to_unit => l_location_weight_uom_code,

Line 2028: inv_convert.inv_um_convert( item_id => p_inventory_item_id,

2024: l_transacted_volume := l_primary_quantity * l_item_unit_volume;
2025: -- make sure that transcated_volume > 0
2026: IF (l_item_volume_uom_code <> l_volume_uom_code) then
2027: l_loc_uom_xacted_volume :=
2028: inv_convert.inv_um_convert( item_id => p_inventory_item_id,
2029: precision => null,
2030: from_quantity => l_transacted_volume,
2031: from_unit => l_item_volume_uom_code,
2032: to_unit => l_volume_uom_code,

Line 2375: inv_convert.inv_um_convert(

2371: if (l_lpn_gross_weight_uom_code <>
2372: p_locator_weight_uom) then
2373:
2374: l_gross_weight :=
2375: inv_convert.inv_um_convert(
2376: item_id => NULL,
2377: precision => null,
2378: from_quantity => nvl(l_lpn_gross_weight,0),
2379: from_unit => l_lpn_gross_weight_uom_code,

Line 2398: inv_convert.inv_um_convert(

2394: if (l_lpn_content_volume_uom_code <>
2395: p_locator_volume_uom) then
2396:
2397: l_content_volume :=
2398: inv_convert.inv_um_convert(
2399: item_id => NULL,
2400: precision => null,
2401: from_quantity => nvl(l_lpn_content_volume,0),
2402: from_unit => l_lpn_content_volume_uom_code,

Line 2421: inv_convert.inv_um_convert(

2417: if (l_lpn_gross_weight_uom_code <>
2418: p_locator_weight_uom) then
2419:
2420: l_lpn_weight :=
2421: inv_convert.inv_um_convert(
2422: item_id => NULL,
2423: precision => null,
2424: from_quantity => nvl(l_lpn_container_item_weight,0),
2425: from_unit => l_lpn_gross_weight_uom_code,

Line 2444: inv_convert.inv_um_convert(

2440: if (l_lpn_content_volume_uom_code <>
2441: p_locator_volume_uom) then
2442:
2443: l_lpn_volume :=
2444: inv_convert.inv_um_convert(
2445: item_id => NULL,
2446: precision => null,
2447: from_quantity => nvl(l_lpn_container_item_vol,0),
2448: from_unit => l_lpn_content_volume_uom_code,

Line 3079: l_transacted_weight := inv_convert.inv_um_convert(item_id => t_inventory_item_id(i),PRECISION => NULL,

3075: AND (t_item_info(t_inventory_item_id(i)).item_unit_weight > 0)) THEN
3076: l_transacted_weight := t_transaction_quantity(i) * t_item_info(t_inventory_item_id(i)).item_unit_weight;
3077:
3078: IF (t_item_info(t_inventory_item_id(i)).item_weight_uom_code <> t_location_weight_uom_code(i)) THEN
3079: l_transacted_weight := inv_convert.inv_um_convert(item_id => t_inventory_item_id(i),PRECISION => NULL,
3080: from_quantity => l_transacted_weight,from_unit => t_item_info(t_inventory_item_id(i)).item_weight_uom_code,
3081: to_unit => t_location_weight_uom_code(i),
3082: from_name => NULL,to_name => NULL);
3083: END IF;

Line 3097: l_transacted_volume := inv_convert.inv_um_convert(item_id => t_inventory_item_id(i),PRECISION => NULL,

3093: AND (t_item_info(t_inventory_item_id(i)).item_unit_volume > 0)) THEN
3094: l_transacted_volume := t_transaction_quantity(i) * t_item_info(t_inventory_item_id(i)).item_unit_volume;
3095:
3096: IF (t_item_info(t_inventory_item_id(i)).item_volume_uom_code <> t_volume_uom_code(i)) THEN
3097: l_transacted_volume := inv_convert.inv_um_convert(item_id => t_inventory_item_id(i),PRECISION => NULL,
3098: from_quantity => l_transacted_volume,from_unit => t_item_info(t_inventory_item_id(i)).item_volume_uom_code,
3099: to_unit => t_volume_uom_code(i),from_name => NULL,
3100: to_name => NULL);
3101: END IF;

Line 4254: l_lpn_content_volume := inv_convert.inv_um_convert(

4250: IF l_lpn_content_volume_uom_code IS NOT NULL AND
4251: p_locator_volume_uom_code IS NOT NULL AND
4252: l_lpn_content_volume >0 THEN
4253: IF (l_lpn_content_volume_uom_code <> p_locator_volume_uom_code) THEN
4254: l_lpn_content_volume := inv_convert.inv_um_convert(
4255: item_id => null
4256: , precision => null
4257: , from_quantity => l_lpn_content_volume
4258: , from_unit => l_lpn_content_volume_uom_code

Line 4286: l_lpn_container_item_vol := inv_convert.inv_um_convert(

4282: IF l_lpn_content_volume_uom_code IS NOT NULL
4283: AND p_locator_volume_uom_code IS NOT NULL
4284: AND l_lpn_container_item_vol >0 THEN
4285: IF (l_lpn_content_volume_uom_code <> p_locator_volume_uom_code) THEN
4286: l_lpn_container_item_vol := inv_convert.inv_um_convert(
4287: item_id => null
4288: , precision => null
4289: , from_quantity => l_lpn_container_item_vol
4290: , from_unit => l_lpn_content_volume_uom_code

Line 4318: l_lpn_gross_weight := inv_convert.inv_um_convert(

4314: IF l_lpn_gross_weight_uom_code IS NOT NULL AND
4315: p_locator_weight_uom_code IS NOT NULL AND
4316: l_lpn_gross_weight >0 THEN
4317: IF (p_locator_weight_uom_code<> l_lpn_gross_weight_uom_code) THEN
4318: l_lpn_gross_weight := inv_convert.inv_um_convert(
4319: item_id => null
4320: , precision => null
4321: , from_quantity => l_lpn_gross_weight
4322: , from_unit => l_lpn_gross_weight_uom_code

Line 4346: l_lpn_container_item_weight := inv_convert.inv_um_convert(

4342: IF l_lpn_gross_weight_uom_code IS NOT NULL AND
4343: p_locator_weight_uom_code IS NOT NULL AND
4344: l_lpn_container_item_weight >0 THEN
4345: IF (p_locator_weight_uom_code<> l_lpn_gross_weight_uom_code) THEN
4346: l_lpn_container_item_weight := inv_convert.inv_um_convert(
4347: item_id => null
4348: , precision => null
4349: , from_quantity => l_lpn_container_item_weight
4350: , from_unit => l_lpn_gross_weight_uom_code

Line 4435: l_trn_content_volume := inv_convert.inv_um_convert(

4431: IF l_trn_content_volume_uom_code IS NOT NULL AND
4432: p_locator_volume_uom_code is not null AND
4433: l_trn_content_volume >0 THEN
4434: IF (l_trn_content_volume_uom_code <> p_locator_volume_uom_code) THEN
4435: l_trn_content_volume := inv_convert.inv_um_convert(
4436: item_id => null
4437: , precision => null
4438: , from_quantity => l_trn_content_volume
4439: , from_unit => l_trn_content_volume_uom_code

Line 4467: l_trn_gross_weight := inv_convert.inv_um_convert(

4463: IF l_trn_gross_weight_uom_code IS NOT NULL AND
4464: p_locator_weight_uom_code IS NOT NULL AND
4465: l_trn_gross_weight >0 THEN
4466: IF (l_trn_gross_weight_uom_code <> p_locator_weight_uom_code) THEN
4467: l_trn_gross_weight := inv_convert.inv_um_convert(
4468: item_id => null
4469: , precision => null
4470: , from_quantity => l_trn_gross_weight
4471: , from_unit => l_trn_gross_weight_uom_code

Line 4499: l_trn_container_item_weight := inv_convert.inv_um_convert(

4495: IF l_trn_gross_weight_uom_code IS NOT NULL AND
4496: p_locator_weight_uom_code IS NOT NULL AND
4497: l_trn_container_item_weight >0 THEN
4498: IF (l_trn_gross_weight_uom_code <> p_locator_weight_uom_code) THEN
4499: l_trn_container_item_weight := inv_convert.inv_um_convert(
4500: item_id => null
4501: , precision => null
4502: , from_quantity => l_trn_container_item_weight
4503: , from_unit => l_trn_gross_weight_uom_code

Line 4531: l_trn_container_item_vol := inv_convert.inv_um_convert(

4527: IF l_trn_content_volume_uom_code IS NOT NULL AND
4528: p_locator_volume_uom_code IS NOT NULL AND
4529: l_trn_container_item_vol >0 THEN
4530: IF (l_trn_content_volume_uom_code <> p_locator_volume_uom_code) THEN
4531: l_trn_container_item_vol := inv_convert.inv_um_convert(
4532: item_id => null
4533: , precision => null
4534: , from_quantity => l_trn_container_item_vol
4535: , from_unit => l_trn_content_volume_uom_code

Line 4614: l_cnt_content_volume := inv_convert.inv_um_convert(

4610: IF l_cnt_content_volume_uom_code IS NOT NULL AND
4611: p_locator_volume_uom_code IS NOT NULL AND
4612: l_cnt_content_volume >0 THEN
4613: IF (l_cnt_content_volume_uom_code <> p_locator_volume_uom_code) THEN
4614: l_cnt_content_volume := inv_convert.inv_um_convert(
4615: item_id => null
4616: , precision => null
4617: , from_quantity => l_cnt_content_volume
4618: , from_unit => l_cnt_content_volume_uom_code

Line 4646: l_cnt_container_item_vol := inv_convert.inv_um_convert(

4642: IF l_cnt_content_volume_uom_code IS NOT NULL
4643: AND p_locator_volume_uom_code IS NOT NULL
4644: AND l_cnt_container_item_vol >0 THEN
4645: IF (l_cnt_content_volume_uom_code <> p_locator_volume_uom_code) THEN
4646: l_cnt_container_item_vol := inv_convert.inv_um_convert(
4647: item_id => null
4648: , precision => null
4649: , from_quantity => l_cnt_container_item_vol
4650: , from_unit => l_cnt_content_volume_uom_code

Line 4678: l_cnt_gross_weight := inv_convert.inv_um_convert(

4674: IF l_cnt_gross_weight_uom_code IS NOT NULL AND
4675: p_locator_weight_uom_code IS NOT NULL AND
4676: l_cnt_gross_weight >0 THEN
4677: IF (p_locator_weight_uom_code<> l_cnt_gross_weight_uom_code) THEN
4678: l_cnt_gross_weight := inv_convert.inv_um_convert(
4679: item_id => null
4680: , precision => null
4681: , from_quantity => l_cnt_gross_weight
4682: , from_unit => l_cnt_gross_weight_uom_code

Line 4706: l_cnt_container_item_weight := inv_convert.inv_um_convert(

4702: IF l_cnt_gross_weight_uom_code IS NOT NULL AND
4703: p_locator_weight_uom_code IS NOT NULL AND
4704: l_cnt_container_item_weight >0 THEN
4705: IF (p_locator_weight_uom_code<> l_cnt_gross_weight_uom_code) THEN
4706: l_cnt_container_item_weight := inv_convert.inv_um_convert(
4707: item_id => null
4708: , precision => null
4709: , from_quantity => l_cnt_container_item_weight
4710: , from_unit => l_cnt_gross_weight_uom_code

Line 6808: l_container_item_xacted_weight := inv_convert.inv_um_convert(

6804:
6805: IF (l_debug = 1) THEN
6806: INV_TRX_UTIL_PUB.TRACE('Gross_weight_uom_weight code different from container item weight uom code', 'LPN-ATTRIBUTE-UPDATE_LPN_LOC',4);
6807: END IF;
6808: l_container_item_xacted_weight := inv_convert.inv_um_convert(
6809: item_id => null,
6810: precision => null,
6811: from_quantity => l_container_item_unit_weight,
6812: from_unit => L_CONTAINER_ITEM_WT_UOM_CODE,

Line 6834: l_container_item_xacted_volume := inv_convert.inv_um_convert(

6830: l_container_item_vol_uom_code is not null AND
6831: l_container_item_unit_volume >0 THEN
6832: IF (l_content_volume_uom_code <> l_container_item_vol_uom_code) THEN
6833:
6834: l_container_item_xacted_volume := inv_convert.inv_um_convert(
6835: item_id => null,
6836: precision => null,
6837: from_quantity => l_container_item_unit_volume,
6838: from_unit => l_container_item_vol_uom_code,

Line 7021: l_item_unit_weight := inv_convert.inv_um_convert( item_id => p_inventory_item_id,

7017: p_locator_weight_uom_code is not null AND
7018: l_item_unit_weight >0 THEN
7019: IF (p_locator_weight_uom_code <> l_weight_uom_code) THEN
7020:
7021: l_item_unit_weight := inv_convert.inv_um_convert( item_id => p_inventory_item_id,
7022: precision => null,
7023: from_quantity => l_item_unit_weight,
7024: from_unit => l_item_weight_uom_code,
7025: to_unit => p_locator_weight_uom_code,

Line 7042: l_item_unit_volume := inv_convert.inv_um_convert(item_id => p_inventory_item_id,

7038: p_locator_volume_uom_code is not null AND
7039: l_item_unit_volume >0 THEN
7040:
7041: IF (p_locator_volume_uom_code<> l_volume_uom_code) THEN
7042: l_item_unit_volume := inv_convert.inv_um_convert(item_id => p_inventory_item_id,
7043: precision => null,
7044: from_quantity => l_item_unit_volume,
7045: from_unit => l_item_volume_uom_code,
7046: to_unit => p_locator_volume_uom_code,

Line 7079: l_quantity := inv_convert.inv_um_convert(item_id => p_inventory_item_id,

7075: IF (l_debug = 1) THEN
7076: INV_TRX_UTIL_PUB.TRACE('The value of primary_uom_flag <>y or PUOM is not equal to Transaction UOM', 'UPDATE_LPN_LOC_CURR_CAPACITY',9);
7077: END IF;
7078:
7079: l_quantity := inv_convert.inv_um_convert(item_id => p_inventory_item_id,
7080: precision => null,
7081: from_quantity =>p_quantity,
7082: from_unit => p_transaction_uom_code,
7083: to_unit => l_item_primary_uom_code,

Line 7118: l_item_xacted_weight := inv_convert.inv_um_convert(

7114: IF (l_debug = 1) THEN
7115: INV_TRX_UTIL_PUB.TRACE('p_locator_weight_uom_code and l_item_weight_uom_code are not same', 'UPD_LPN_LOC-ITEM_ATTRIBUTES',4);
7116: END IF;
7117:
7118: l_item_xacted_weight := inv_convert.inv_um_convert(
7119: item_id => p_inventory_item_id,
7120: precision => null,
7121: from_quantity => l_item_xacted_weight ,
7122: from_unit => l_item_weight_uom_code,

Line 7149: l_item_xacted_volume := inv_convert.inv_um_convert(item_id => p_inventory_item_id,

7145: IF (l_debug = 1) THEN
7146: INV_TRX_UTIL_PUB.TRACE('p_locator_volume_uom_code and l_item_volume_uom_code are same or not', 'UPD_LPN_LOC-ITEM_ATTRIBUTES',4);
7147: END IF;
7148:
7149: l_item_xacted_volume := inv_convert.inv_um_convert(item_id => p_inventory_item_id,
7150: precision => null,
7151: from_quantity => l_item_xacted_volume,
7152: from_unit => l_item_volume_uom_code,
7153: to_unit => p_locator_volume_uom_code,

Line 8292: GREATEST(INV_CONVERT.INV_UM_CONVERT(

8288: CURSOR current_cpty is
8289: SELECT WLPN.locator_id,
8290: nvl(sum(DECODE(MIL.LOCATION_WEIGHT_UOM_CODE,WLPN.GROSS_WEIGHT_UOM_CODE,
8291: WLPN.gross_weight,
8292: GREATEST(INV_CONVERT.INV_UM_CONVERT(
8293: null
8294: ,null
8295: ,WLPN.GROSS_WEIGHT
8296: ,WLPN.GROSS_WEIGHT_UOM_CODE

Line 8303: GREATEST(INV_CONVERT.INV_UM_CONVERT(

8299: ,null),0))),0) gross_weight,
8300:
8301: nvl(sum(DECODE(MIL.VOLUME_UOM_CODE,WLPN.CONTENT_VOLUME_UOM_CODE,
8302: WLPN.content_volume,
8303: GREATEST(INV_CONVERT.INV_UM_CONVERT(
8304: null
8305: ,null
8306: ,WLPN.CONTENT_VOLUME
8307: ,WLPN.CONTENT_VOLUME_UOM_CODE

Line 8324: GREATEST(INV_CONVERT.INV_UM_CONVERT(

8320: CURSOR curr_cpty_mixed_flg is
8321: SELECT WLPN.locator_id,
8322: nvl(sum(DECODE(MIL.LOCATION_WEIGHT_UOM_CODE,WLPN.GROSS_WEIGHT_UOM_CODE,
8323: WLPN.gross_weight,
8324: GREATEST(INV_CONVERT.INV_UM_CONVERT(
8325: null
8326: ,null
8327: ,WLPN.GROSS_WEIGHT
8328: ,WLPN.GROSS_WEIGHT_UOM_CODE

Line 8335: GREATEST(INV_CONVERT.INV_UM_CONVERT(

8331: ,null),0))),0) gross_weight,
8332:
8333: nvl(sum(DECODE(MIL.VOLUME_UOM_CODE,WLPN.CONTENT_VOLUME_UOM_CODE,
8334: WLPN.content_volume,
8335: GREATEST(INV_CONVERT.INV_UM_CONVERT(
8336: null
8337: ,null
8338: ,WLPN.CONTENT_VOLUME
8339: ,WLPN.CONTENT_VOLUME_UOM_CODE