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 681: inv_convert.inv_um_convert( item_id => p_inventory_item_id,

677: IF (l_item_primary_uom_code <> p_transaction_uom_code)
678: and (p_primary_uom_flag <> 'Y') then
679:
680: l_primary_quantity :=
681: inv_convert.inv_um_convert( item_id => p_inventory_item_id,
682: precision => null,
683: from_quantity => l_quantity,
684: from_unit => p_transaction_uom_code,
685: to_unit => l_item_primary_uom_code,

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

703: l_transacted_weight := l_primary_quantity * l_item_unit_weight;
704:
705: IF (l_item_weight_uom_code <> l_location_weight_uom_code) then
706: l_loc_uom_xacted_weight :=
707: inv_convert.inv_um_convert( item_id => p_inventory_item_id,
708: precision => null,
709: from_quantity => l_transacted_weight,
710: from_unit => l_item_weight_uom_code,
711: to_unit => l_location_weight_uom_code,

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

728:
729: l_transacted_volume := l_primary_quantity * l_item_unit_volume;
730: IF (l_item_volume_uom_code <> l_volume_uom_code) then
731: l_loc_uom_xacted_volume :=
732: inv_convert.inv_um_convert( item_id => p_inventory_item_id,
733: precision => null,
734: from_quantity => l_transacted_volume,
735: from_unit => l_item_volume_uom_code,
736: to_unit => l_volume_uom_code,

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

1353: IF (l_item_primary_uom_code <> p_transaction_uom_code)
1354: and (p_primary_uom_flag <> 'Y') then
1355:
1356: l_primary_quantity :=
1357: inv_convert.inv_um_convert( item_id => p_inventory_item_id,
1358: precision => null,
1359: from_quantity => l_quantity,
1360: from_unit => p_transaction_uom_code,
1361: to_unit => l_item_primary_uom_code,

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

1378: l_transacted_weight := l_primary_quantity * l_item_unit_weight;
1379:
1380: IF (l_item_weight_uom_code <> l_location_weight_uom_code) then
1381: l_loc_uom_xacted_weight :=
1382: inv_convert.inv_um_convert( item_id => p_inventory_item_id,
1383: precision => null,
1384: from_quantity => l_transacted_weight,
1385: from_unit => l_item_weight_uom_code,
1386: to_unit => l_location_weight_uom_code,

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

1404: l_transacted_volume := l_primary_quantity * l_item_unit_volume;
1405: -- make sure that transcated_volume > 0
1406: IF (l_item_volume_uom_code <> l_volume_uom_code) then
1407: l_loc_uom_xacted_volume :=
1408: inv_convert.inv_um_convert( item_id => p_inventory_item_id,
1409: precision => null,
1410: from_quantity => l_transacted_volume,
1411: from_unit => l_item_volume_uom_code,
1412: to_unit => l_volume_uom_code,

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

1906: IF (l_item_primary_uom_code <> p_transaction_uom_code)
1907: and (p_primary_uom_flag <> 'Y') then
1908:
1909: l_primary_quantity :=
1910: inv_convert.inv_um_convert( item_id => p_inventory_item_id,
1911: precision => null,
1912: from_quantity => l_quantity,
1913: from_unit => p_transaction_uom_code,
1914: to_unit => l_item_primary_uom_code,

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

1928: l_transacted_weight := l_primary_quantity * l_item_unit_weight;
1929:
1930: IF (l_item_weight_uom_code <> l_location_weight_uom_code) then
1931: l_loc_uom_xacted_weight :=
1932: inv_convert.inv_um_convert( item_id => p_inventory_item_id,
1933: precision => null,
1934: from_quantity => l_transacted_weight,
1935: from_unit => l_item_weight_uom_code,
1936: to_unit => l_location_weight_uom_code,

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

1954: l_transacted_volume := l_primary_quantity * l_item_unit_volume;
1955: -- make sure that transcated_volume > 0
1956: IF (l_item_volume_uom_code <> l_volume_uom_code) then
1957: l_loc_uom_xacted_volume :=
1958: inv_convert.inv_um_convert( item_id => p_inventory_item_id,
1959: precision => null,
1960: from_quantity => l_transacted_volume,
1961: from_unit => l_item_volume_uom_code,
1962: to_unit => l_volume_uom_code,

Line 2269: inv_convert.inv_um_convert(

2265: if (l_lpn_gross_weight_uom_code <>
2266: p_locator_weight_uom) then
2267:
2268: l_gross_weight :=
2269: inv_convert.inv_um_convert(
2270: item_id => NULL,
2271: precision => null,
2272: from_quantity => nvl(l_lpn_gross_weight,0),
2273: from_unit => l_lpn_gross_weight_uom_code,

Line 2292: inv_convert.inv_um_convert(

2288: if (l_lpn_content_volume_uom_code <>
2289: p_locator_volume_uom) then
2290:
2291: l_content_volume :=
2292: inv_convert.inv_um_convert(
2293: item_id => NULL,
2294: precision => null,
2295: from_quantity => nvl(l_lpn_content_volume,0),
2296: from_unit => l_lpn_content_volume_uom_code,

Line 2315: inv_convert.inv_um_convert(

2311: if (l_lpn_gross_weight_uom_code <>
2312: p_locator_weight_uom) then
2313:
2314: l_lpn_weight :=
2315: inv_convert.inv_um_convert(
2316: item_id => NULL,
2317: precision => null,
2318: from_quantity => nvl(l_lpn_container_item_weight,0),
2319: from_unit => l_lpn_gross_weight_uom_code,

Line 2338: inv_convert.inv_um_convert(

2334: if (l_lpn_content_volume_uom_code <>
2335: p_locator_volume_uom) then
2336:
2337: l_lpn_volume :=
2338: inv_convert.inv_um_convert(
2339: item_id => NULL,
2340: precision => null,
2341: from_quantity => nvl(l_lpn_container_item_vol,0),
2342: from_unit => l_lpn_content_volume_uom_code,

Line 2784: inv_convert.inv_um_convert(

2780: if (t_item_info(l_inventory_item_id).item_weight_uom_code <>
2781: t_location_weight_uom_code(i)) then
2782:
2783: l_transacted_weight :=
2784: inv_convert.inv_um_convert(
2785: item_id => l_inventory_item_id,
2786: precision => null,
2787: from_quantity => l_transacted_weight,
2788: from_unit => t_item_info(l_inventory_item_id).item_weight_uom_code,

Line 2811: inv_convert.inv_um_convert(

2807: if (t_item_info(l_inventory_item_id).item_volume_uom_code <>
2808: t_volume_uom_code(i)) then
2809:
2810: l_transacted_volume :=
2811: inv_convert.inv_um_convert(
2812: item_id => l_inventory_item_id,
2813: precision => null,
2814: from_quantity => l_transacted_volume,
2815: from_unit => t_item_info(l_inventory_item_id).item_volume_uom_code,

Line 3826: l_lpn_content_volume := inv_convert.inv_um_convert(

3822: IF l_lpn_content_volume_uom_code IS NOT NULL AND
3823: p_locator_volume_uom_code IS NOT NULL AND
3824: l_lpn_content_volume >0 THEN
3825: IF (l_lpn_content_volume_uom_code <> p_locator_volume_uom_code) THEN
3826: l_lpn_content_volume := inv_convert.inv_um_convert(
3827: item_id => null
3828: , precision => null
3829: , from_quantity => l_lpn_content_volume
3830: , from_unit => l_lpn_content_volume_uom_code

Line 3858: l_lpn_container_item_vol := inv_convert.inv_um_convert(

3854: IF l_lpn_content_volume_uom_code IS NOT NULL
3855: AND p_locator_volume_uom_code IS NOT NULL
3856: AND l_lpn_container_item_vol >0 THEN
3857: IF (l_lpn_content_volume_uom_code <> p_locator_volume_uom_code) THEN
3858: l_lpn_container_item_vol := inv_convert.inv_um_convert(
3859: item_id => null
3860: , precision => null
3861: , from_quantity => l_lpn_container_item_vol
3862: , from_unit => l_lpn_content_volume_uom_code

Line 3890: l_lpn_gross_weight := inv_convert.inv_um_convert(

3886: IF l_lpn_gross_weight_uom_code IS NOT NULL AND
3887: p_locator_weight_uom_code IS NOT NULL AND
3888: l_lpn_gross_weight >0 THEN
3889: IF (p_locator_weight_uom_code<> l_lpn_gross_weight_uom_code) THEN
3890: l_lpn_gross_weight := inv_convert.inv_um_convert(
3891: item_id => null
3892: , precision => null
3893: , from_quantity => l_lpn_gross_weight
3894: , from_unit => l_lpn_gross_weight_uom_code

Line 3918: l_lpn_container_item_weight := inv_convert.inv_um_convert(

3914: IF l_lpn_gross_weight_uom_code IS NOT NULL AND
3915: p_locator_weight_uom_code IS NOT NULL AND
3916: l_lpn_container_item_weight >0 THEN
3917: IF (p_locator_weight_uom_code<> l_lpn_gross_weight_uom_code) THEN
3918: l_lpn_container_item_weight := inv_convert.inv_um_convert(
3919: item_id => null
3920: , precision => null
3921: , from_quantity => l_lpn_container_item_weight
3922: , from_unit => l_lpn_gross_weight_uom_code

Line 4007: l_trn_content_volume := inv_convert.inv_um_convert(

4003: IF l_trn_content_volume_uom_code IS NOT NULL AND
4004: p_locator_volume_uom_code is not null AND
4005: l_trn_content_volume >0 THEN
4006: IF (l_trn_content_volume_uom_code <> p_locator_volume_uom_code) THEN
4007: l_trn_content_volume := inv_convert.inv_um_convert(
4008: item_id => null
4009: , precision => null
4010: , from_quantity => l_trn_content_volume
4011: , from_unit => l_trn_content_volume_uom_code

Line 4039: l_trn_gross_weight := inv_convert.inv_um_convert(

4035: IF l_trn_gross_weight_uom_code IS NOT NULL AND
4036: p_locator_weight_uom_code IS NOT NULL AND
4037: l_trn_gross_weight >0 THEN
4038: IF (l_trn_gross_weight_uom_code <> p_locator_weight_uom_code) THEN
4039: l_trn_gross_weight := inv_convert.inv_um_convert(
4040: item_id => null
4041: , precision => null
4042: , from_quantity => l_trn_gross_weight
4043: , from_unit => l_trn_gross_weight_uom_code

Line 4071: l_trn_container_item_weight := inv_convert.inv_um_convert(

4067: IF l_trn_gross_weight_uom_code IS NOT NULL AND
4068: p_locator_weight_uom_code IS NOT NULL AND
4069: l_trn_container_item_weight >0 THEN
4070: IF (l_trn_gross_weight_uom_code <> p_locator_weight_uom_code) THEN
4071: l_trn_container_item_weight := inv_convert.inv_um_convert(
4072: item_id => null
4073: , precision => null
4074: , from_quantity => l_trn_container_item_weight
4075: , from_unit => l_trn_gross_weight_uom_code

Line 4103: l_trn_container_item_vol := inv_convert.inv_um_convert(

4099: IF l_trn_content_volume_uom_code IS NOT NULL AND
4100: p_locator_volume_uom_code IS NOT NULL AND
4101: l_trn_container_item_vol >0 THEN
4102: IF (l_trn_content_volume_uom_code <> p_locator_volume_uom_code) THEN
4103: l_trn_container_item_vol := inv_convert.inv_um_convert(
4104: item_id => null
4105: , precision => null
4106: , from_quantity => l_trn_container_item_vol
4107: , from_unit => l_trn_content_volume_uom_code

Line 4186: l_cnt_content_volume := inv_convert.inv_um_convert(

4182: IF l_cnt_content_volume_uom_code IS NOT NULL AND
4183: p_locator_volume_uom_code IS NOT NULL AND
4184: l_cnt_content_volume >0 THEN
4185: IF (l_cnt_content_volume_uom_code <> p_locator_volume_uom_code) THEN
4186: l_cnt_content_volume := inv_convert.inv_um_convert(
4187: item_id => null
4188: , precision => null
4189: , from_quantity => l_cnt_content_volume
4190: , from_unit => l_cnt_content_volume_uom_code

Line 4218: l_cnt_container_item_vol := inv_convert.inv_um_convert(

4214: IF l_cnt_content_volume_uom_code IS NOT NULL
4215: AND p_locator_volume_uom_code IS NOT NULL
4216: AND l_cnt_container_item_vol >0 THEN
4217: IF (l_cnt_content_volume_uom_code <> p_locator_volume_uom_code) THEN
4218: l_cnt_container_item_vol := inv_convert.inv_um_convert(
4219: item_id => null
4220: , precision => null
4221: , from_quantity => l_cnt_container_item_vol
4222: , from_unit => l_cnt_content_volume_uom_code

Line 4250: l_cnt_gross_weight := inv_convert.inv_um_convert(

4246: IF l_cnt_gross_weight_uom_code IS NOT NULL AND
4247: p_locator_weight_uom_code IS NOT NULL AND
4248: l_cnt_gross_weight >0 THEN
4249: IF (p_locator_weight_uom_code<> l_cnt_gross_weight_uom_code) THEN
4250: l_cnt_gross_weight := inv_convert.inv_um_convert(
4251: item_id => null
4252: , precision => null
4253: , from_quantity => l_cnt_gross_weight
4254: , from_unit => l_cnt_gross_weight_uom_code

Line 4278: l_cnt_container_item_weight := inv_convert.inv_um_convert(

4274: IF l_cnt_gross_weight_uom_code IS NOT NULL AND
4275: p_locator_weight_uom_code IS NOT NULL AND
4276: l_cnt_container_item_weight >0 THEN
4277: IF (p_locator_weight_uom_code<> l_cnt_gross_weight_uom_code) THEN
4278: l_cnt_container_item_weight := inv_convert.inv_um_convert(
4279: item_id => null
4280: , precision => null
4281: , from_quantity => l_cnt_container_item_weight
4282: , from_unit => l_cnt_gross_weight_uom_code

Line 6380: l_container_item_xacted_weight := inv_convert.inv_um_convert(

6376:
6377: IF (l_debug = 1) THEN
6378: INV_TRX_UTIL_PUB.TRACE('Gross_weight_uom_weight code different from container item weight uom code', 'LPN-ATTRIBUTE-UPDATE_LPN_LOC',4);
6379: END IF;
6380: l_container_item_xacted_weight := inv_convert.inv_um_convert(
6381: item_id => null,
6382: precision => null,
6383: from_quantity => l_container_item_unit_weight,
6384: from_unit => L_CONTAINER_ITEM_WT_UOM_CODE,

Line 6406: l_container_item_xacted_volume := inv_convert.inv_um_convert(

6402: l_container_item_vol_uom_code is not null AND
6403: l_container_item_unit_volume >0 THEN
6404: IF (l_content_volume_uom_code <> l_container_item_vol_uom_code) THEN
6405:
6406: l_container_item_xacted_volume := inv_convert.inv_um_convert(
6407: item_id => null,
6408: precision => null,
6409: from_quantity => l_container_item_unit_volume,
6410: from_unit => l_container_item_vol_uom_code,

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

6570: p_locator_weight_uom_code is not null AND
6571: l_item_unit_weight >0 THEN
6572: IF (p_locator_weight_uom_code <> l_weight_uom_code) THEN
6573:
6574: l_item_unit_weight := inv_convert.inv_um_convert( item_id => p_inventory_item_id,
6575: precision => null,
6576: from_quantity => l_item_unit_weight,
6577: from_unit => l_item_weight_uom_code,
6578: to_unit => p_locator_weight_uom_code,

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

6591: p_locator_volume_uom_code is not null AND
6592: l_item_unit_volume >0 THEN
6593:
6594: IF (p_locator_volume_uom_code<> l_volume_uom_code) THEN
6595: l_item_unit_volume := inv_convert.inv_um_convert(item_id => p_inventory_item_id,
6596: precision => null,
6597: from_quantity => l_item_unit_volume,
6598: from_unit => l_item_volume_uom_code,
6599: to_unit => p_locator_volume_uom_code,

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

6628: IF (l_debug = 1) THEN
6629: 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);
6630: END IF;
6631:
6632: l_quantity := inv_convert.inv_um_convert(item_id => p_inventory_item_id,
6633: precision => null,
6634: from_quantity =>p_quantity,
6635: from_unit => p_transaction_uom_code,
6636: to_unit => l_item_primary_uom_code,

Line 6671: l_item_xacted_weight := inv_convert.inv_um_convert(

6667: IF (l_debug = 1) THEN
6668: 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);
6669: END IF;
6670:
6671: l_item_xacted_weight := inv_convert.inv_um_convert(
6672: item_id => p_inventory_item_id,
6673: precision => null,
6674: from_quantity => l_item_xacted_weight ,
6675: from_unit => l_item_weight_uom_code,

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

6698: IF (l_debug = 1) THEN
6699: 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);
6700: END IF;
6701:
6702: l_item_xacted_volume := inv_convert.inv_um_convert(item_id => p_inventory_item_id,
6703: precision => null,
6704: from_quantity => l_item_xacted_volume,
6705: from_unit => l_item_volume_uom_code,
6706: to_unit => p_locator_volume_uom_code,

Line 7772: GREATEST(INV_CONVERT.INV_UM_CONVERT(

7768: CURSOR current_cpty is
7769: SELECT WLPN.locator_id,
7770: nvl(sum(DECODE(MIL.LOCATION_WEIGHT_UOM_CODE,WLPN.GROSS_WEIGHT_UOM_CODE,
7771: WLPN.gross_weight,
7772: GREATEST(INV_CONVERT.INV_UM_CONVERT(
7773: null
7774: ,null
7775: ,WLPN.GROSS_WEIGHT
7776: ,WLPN.GROSS_WEIGHT_UOM_CODE

Line 7783: GREATEST(INV_CONVERT.INV_UM_CONVERT(

7779: ,null),0))),0) gross_weight,
7780:
7781: nvl(sum(DECODE(MIL.VOLUME_UOM_CODE,WLPN.CONTENT_VOLUME_UOM_CODE,
7782: WLPN.content_volume,
7783: GREATEST(INV_CONVERT.INV_UM_CONVERT(
7784: null
7785: ,null
7786: ,WLPN.CONTENT_VOLUME
7787: ,WLPN.CONTENT_VOLUME_UOM_CODE

Line 7804: GREATEST(INV_CONVERT.INV_UM_CONVERT(

7800: CURSOR curr_cpty_mixed_flg is
7801: SELECT WLPN.locator_id,
7802: nvl(sum(DECODE(MIL.LOCATION_WEIGHT_UOM_CODE,WLPN.GROSS_WEIGHT_UOM_CODE,
7803: WLPN.gross_weight,
7804: GREATEST(INV_CONVERT.INV_UM_CONVERT(
7805: null
7806: ,null
7807: ,WLPN.GROSS_WEIGHT
7808: ,WLPN.GROSS_WEIGHT_UOM_CODE

Line 7815: GREATEST(INV_CONVERT.INV_UM_CONVERT(

7811: ,null),0))),0) gross_weight,
7812:
7813: nvl(sum(DECODE(MIL.VOLUME_UOM_CODE,WLPN.CONTENT_VOLUME_UOM_CODE,
7814: WLPN.content_volume,
7815: GREATEST(INV_CONVERT.INV_UM_CONVERT(
7816: null
7817: ,null
7818: ,WLPN.CONTENT_VOLUME
7819: ,WLPN.CONTENT_VOLUME_UOM_CODE