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

Line 467: l_conversion_factor := inv_convert.inv_um_convert(item_id => l_inventory_item_id,

463:
464: IF p_transaction_uom = l_transaction_uom1 THEN
465: l_conversion_factor := l_conversion_factor1;
466: ELSE
467: l_conversion_factor := inv_convert.inv_um_convert(item_id => l_inventory_item_id,
468: precision => l_g_decimal_precision,
469: from_quantity => 1,
470: from_unit => l_primary_uom,
471: to_unit => p_transaction_uom,

Line 2100: l_lot_sec_qty := inv_convert.inv_um_convert

2096: mydebug ('Primary Qty :' || l_qoh || ' Secondary Qty :' || l_sqoh || ' Primary ATT :' || l_att || ' Secondary ATT :' || l_satt);
2097:
2098: IF p_confirmed_sec_uom <> p_confirmed_uom THEN
2099: l_progress := '120';
2100: l_lot_sec_qty := inv_convert.inv_um_convert
2101: (item_id => p_inventory_item_id
2102: ,lot_number => l_lot_number
2103: ,organization_id => p_organization_id
2104: ,precision => l_g_decimal_precision

Line 2161: l_lot_prim_qty := inv_convert.inv_um_convert

2157: ELSE --fulfillment base is 'P'
2158:
2159: IF p_primary_uom <> p_confirmed_uom THEN
2160: l_progress := '120';
2161: l_lot_prim_qty := inv_convert.inv_um_convert
2162: (item_id => p_inventory_item_id
2163: ,lot_number => l_lot_number
2164: ,organization_id => p_organization_id
2165: ,precision => l_g_decimal_precision

Line 2191: l_lot_sugg_qty := inv_convert.inv_um_convert

2187:
2188:
2189: IF p_suggested_uom <> p_confirmed_uom THEN
2190: l_progress := '120';
2191: l_lot_sugg_qty := inv_convert.inv_um_convert
2192: (item_id => p_inventory_item_id
2193: ,lot_number => l_lot_number
2194: ,organization_id => p_organization_id
2195: ,precision => l_g_decimal_precision

Line 2310: x_confirmed_sec_qty := inv_convert.inv_um_convert(

2306: mydebug ('Quantities in MOQD for inventory_item_id ' || p_inventory_item_id || ' are:');
2307: mydebug ('Primary Qty :' || l_qoh || ' Secondary Qty :' || l_sqoh || ' Primary ATT :' || l_att || ' Secondary ATT :' || l_satt);
2308:
2309: IF p_confirmed_sec_uom <> p_confirmed_uom THEN
2310: x_confirmed_sec_qty := inv_convert.inv_um_convert(
2311: item_id => p_inventory_item_id,
2312: precision => l_g_decimal_precision,
2313: from_quantity => p_confirmed_trx_qty,
2314: from_unit => p_confirmed_uom,

Line 2344: x_confirmed_prim_qty := inv_convert.inv_um_convert

2340: RAISE fnd_api.g_exc_error;
2341: END IF;--}
2342: ELSE --fulfillment base is 'P'
2343: IF p_primary_uom <> p_confirmed_uom THEN
2344: x_confirmed_prim_qty := inv_convert.inv_um_convert
2345: (item_id => p_inventory_item_id
2346: ,precision => l_g_decimal_precision
2347: ,from_quantity => p_confirmed_trx_qty
2348: ,from_unit => p_confirmed_uom

Line 2363: x_confirmed_sugg_qty := inv_convert.inv_um_convert

2359: END IF; --}
2360: x_confirmed_pri_qty_string := NULL; --For non lot controlled items we do not need to track pri qty separately. It is already stored in x_confirmed_prim_qty
2361:
2362: IF p_suggested_uom <> p_confirmed_uom THEN
2363: x_confirmed_sugg_qty := inv_convert.inv_um_convert
2364: (item_id => p_inventory_item_id
2365: ,precision => l_g_decimal_precision
2366: ,from_quantity => p_confirmed_trx_qty
2367: ,from_unit => p_confirmed_uom

Line 3251: l_calc_mmtt_pri_qty := inv_convert.inv_um_convert(

3247: l_calc_mmtt_pri_qty := l_orig_mmtt_pri_qty - l_confirmed_prim_qty;
3248:
3249: IF(l_calc_mmtt_pri_qty <= 0) THEN
3250: mydebug ('l_calc_mmtt_pri_qty came out to be ' || l_calc_mmtt_pri_qty || 'which is less that zero so recalculating');
3251: l_calc_mmtt_pri_qty := inv_convert.inv_um_convert(
3252: item_id => p_inventory_item_id,
3253: precision => l_g_decimal_precision,
3254: from_quantity => (l_orig_mmtt_sec_qty - l_confirmed_sec_qty),
3255: from_unit => p_confirmed_sec_uom,

Line 3268: l_calc_mmtt_txn_qty := l_orig_mmtt_txn_qty - inv_convert.inv_um_convert(

3264: ELSIF(p_primary_uom = l_orig_mmtt_txn_uom) THEN
3265: l_calc_mmtt_txn_qty := l_calc_mmtt_pri_qty;
3266:
3267: ELSE
3268: l_calc_mmtt_txn_qty := l_orig_mmtt_txn_qty - inv_convert.inv_um_convert(
3269: item_id => p_inventory_item_id,
3270: precision => l_g_decimal_precision,
3271: from_quantity => l_confirmed_sec_qty,
3272: from_unit => p_confirmed_sec_uom,

Line 3280: l_calc_mmtt_txn_qty := inv_convert.inv_um_convert(

3276: END IF;
3277:
3278: IF(l_calc_mmtt_txn_qty <= 0) THEN
3279: mydebug ('l_calc_mmtt_txn_qty came out to be ' || l_calc_mmtt_txn_qty || 'which is less that zero so recalculating - Unless Overpick scenario this should not happen');
3280: l_calc_mmtt_txn_qty := inv_convert.inv_um_convert(
3281: item_id => p_inventory_item_id,
3282: precision => l_g_decimal_precision,
3283: from_quantity => (l_orig_mmtt_sec_qty - l_confirmed_sec_qty),
3284: from_unit => p_confirmed_sec_uom,

Line 3742: l_calc_lot_txn_qty := l_rec_mtlt_to_copy_from.transaction_quantity - inv_convert.inv_um_convert(

3738:
3739: IF(p_fulfillment_base = 'P' OR (p_fulfillment_base = 'S' AND p_confirmed_uom = p_orig_mmtt_txn_uom)) THEN
3740: l_calc_lot_txn_qty := l_rec_mtlt_to_copy_from.transaction_quantity - rec_confirmed_lots_serials.suggested_quantity;
3741: ELSE
3742: l_calc_lot_txn_qty := l_rec_mtlt_to_copy_from.transaction_quantity - inv_convert.inv_um_convert(
3743: item_id => p_inventory_item_id,
3744: lot_number => rec_confirmed_lots_serials.lot_number, -- 16070349
3745: organization_id => p_organization_id, -- 16070349
3746: precision => l_g_decimal_precision,

Line 3753: l_calc_lot_txn_qty := inv_convert.inv_um_convert(

3749: to_unit => p_orig_mmtt_txn_uom,
3750: from_name => NULL,
3751: to_name => NULL);
3752: IF(l_calc_lot_txn_qty <= 0) THEN
3753: l_calc_lot_txn_qty := inv_convert.inv_um_convert(
3754: item_id => p_inventory_item_id,
3755: lot_number => rec_confirmed_lots_serials.lot_number, -- 16070349
3756: organization_id => p_organization_id, -- 16070349
3757: precision => l_g_decimal_precision,

Line 5675: l_suggested_mmtt_qty := inv_convert.inv_um_convert

5671: IF(p_suggested_uom = rec_mmtt1.SECONDARY_UOM_CODE) THEN
5672: l_suggested_mmtt_qty := rec_mmtt1.mmtt_secondary_quantity;
5673: ELSE
5674: IF(NVL(rec_mmtt1.fulfillment_base, 'P') = 'S') THEN
5675: l_suggested_mmtt_qty := inv_convert.inv_um_convert
5676: (item_id => rec_mmtt1.inventory_item_id
5677: ,precision => l_g_decimal_precision
5678: ,from_quantity => rec_mmtt1.mmtt_secondary_quantity
5679: ,from_unit => rec_mmtt1.SECONDARY_UOM_CODE

Line 5684: l_suggested_mmtt_qty := inv_convert.inv_um_convert

5680: ,to_unit => p_suggested_uom
5681: ,from_name => NULL
5682: ,to_name => NULL);
5683: ELSE
5684: l_suggested_mmtt_qty := inv_convert.inv_um_convert
5685: (item_id => rec_mmtt1.inventory_item_id
5686: ,precision => l_g_decimal_precision
5687: ,from_quantity => rec_mmtt1.mmtt_primary_quantity
5688: ,from_unit => rec_mmtt1.item_primary_uom_code

Line 5806: l_suggested_mtlt_qty := inv_convert.inv_um_convert

5802: IF(p_suggested_uom = rec_mmtt1.SECONDARY_UOM_CODE) THEN
5803: l_suggested_mtlt_qty := rec_mtlt1.group_lot_secondary_quantity;
5804: ELSE
5805: IF(NVL(rec_mmtt1.fulfillment_base, 'P') = 'S') THEN
5806: l_suggested_mtlt_qty := inv_convert.inv_um_convert
5807: (item_id => rec_mmtt1.inventory_item_id
5808: ,lot_number => rec_mtlt1.lot_number --BUG12622871LSC
5809: ,organization_id => p_organization_id
5810: ,precision => l_g_decimal_precision

Line 5817: l_suggested_mtlt_qty := inv_convert.inv_um_convert

5813: ,to_unit => p_suggested_uom
5814: ,from_name => NULL
5815: ,to_name => NULL);
5816: ELSE
5817: l_suggested_mtlt_qty := inv_convert.inv_um_convert
5818: (item_id => rec_mmtt1.inventory_item_id
5819: ,lot_number => rec_mtlt1.lot_number --BUG12622871LSC
5820: ,organization_id => p_organization_id
5821: ,precision => l_g_decimal_precision

Line 6630: INV_Convert.inv_um_convert

6626:
6627: IF (rec_mmtt_to_del.item_primary_uom_code <> rec_cancelled_mols.uom_code)
6628: THEN
6629: l_deleted_mmtt_qty := l_deleted_mmtt_qty +
6630: INV_Convert.inv_um_convert
6631: ( item_id => rec_mmtt_to_del.inventory_item_id
6632: ,precision => 5
6633: ,from_quantity => rec_mmtt_to_del.primary_quantity
6634: ,from_unit => rec_mmtt_to_del.item_primary_uom_code

Line 7298: l_lot_prim_qty := inv_convert.inv_um_convert

7294: ELSE
7295: IF p_primary_uom <> p_confirmed_uom
7296: THEN
7297: l_progress := '120';
7298: l_lot_prim_qty := inv_convert.inv_um_convert
7299: (item_id => p_inventory_item_id
7300: ,lot_number => l_lot_number
7301: ,organization_id => p_organization_id
7302: ,precision => l_g_decimal_precision

Line 7319: l_lot_sugg_qty := inv_convert.inv_um_convert

7315:
7316: IF p_suggested_uom <> p_confirmed_uom
7317: THEN
7318: l_progress := '120';
7319: l_lot_sugg_qty := inv_convert.inv_um_convert
7320: (item_id => p_inventory_item_id
7321: ,lot_number => l_lot_number
7322: ,organization_id => p_organization_id
7323: ,precision => l_g_decimal_precision

Line 8097: l_mmtt_sec_qty_in_mol_uom := inv_convert.inv_um_convert(item_id => p_item_id,

8093: IF l_fulfillment_base = 'S' THEN -- muom:sk
8094: IF p_confirmed_sec_uom = l_sec_mol_uom THEN
8095: l_mmtt_sec_qty_in_mol_uom := l_sum_mmtt_sec_txn_qty;
8096: ELSE
8097: l_mmtt_sec_qty_in_mol_uom := inv_convert.inv_um_convert(item_id => p_item_id,
8098: precision => l_g_decimal_precision,
8099: from_quantity => l_sum_mmtt_sec_txn_qty,
8100: from_unit => p_confirmed_sec_uom,
8101: to_unit => l_sec_mol_uom,

Line 8109: l_mmtt_qty_in_mol_uom := inv_convert.inv_um_convert(item_id => p_item_id,

8105: ELSE
8106: IF p_primary_uom = l_mol_uom THEN
8107: l_mmtt_qty_in_mol_uom := l_sum_mmtt_qty;
8108: ELSE
8109: l_mmtt_qty_in_mol_uom := inv_convert.inv_um_convert(item_id => p_item_id,
8110: precision => l_g_decimal_precision,
8111: from_quantity => l_sum_mmtt_qty,
8112: from_unit => p_primary_uom,
8113: to_unit => l_mol_uom,

Line 8571: l_sec_qty := inv_convert.inv_um_convert(

8567: END IF;
8568:
8569: IF l_fulfillment_base = 'S' THEN --{
8570: IF (p_trx_uom <> l_secondary_uom) THEN
8571: l_sec_qty := inv_convert.inv_um_convert(
8572: item_id => p_item_id
8573: ,precision => null
8574: ,from_quantity => p_trx_qty
8575: ,from_unit => p_trx_uom

Line 8591: l_pr_qty := inv_convert.inv_um_convert(

8587: l_lpn_sec_qty := p_trx_qty; -- muom:sk
8588: mydebug('In lpn_match Fulfillment basis is S and transaction UOM is same than secondary UOM');
8589: mydebug('p_trx_qty/l_sec_qty in secondary uom is :'|| l_sec_qty);
8590: END IF;
8591: l_pr_qty := inv_convert.inv_um_convert(
8592: item_id => p_item_id
8593: ,precision => null
8594: ,from_quantity => l_sec_qty
8595: ,from_unit => l_secondary_uom

Line 8603: l_pr_qty := inv_convert.inv_um_convert(

8599:
8600: l_lpn_pr_qty := l_pr_qty; -- muom:sk
8601: ELSE
8602: IF (p_trx_uom <> l_primary_uom) THEN
8603: l_pr_qty := inv_convert.inv_um_convert(
8604: item_id => p_item_id
8605: ,precision => null
8606: ,from_quantity => p_trx_qty
8607: ,from_unit => p_trx_uom

Line 9266: t_lpn_lot_qty_table(l_table_index).trx_qty := inv_convert.inv_um_convert(

9262: t_lpn_lot_qty_table(l_table_index).trx_qty := l_satt;
9263: ELSIF(l_primary_uom = p_trx_uom) THEN
9264: t_lpn_lot_qty_table(l_table_index).trx_qty := l_att;
9265: ELSE
9266: t_lpn_lot_qty_table(l_table_index).trx_qty := inv_convert.inv_um_convert(
9267: item_id => p_item_id
9268: ,lot_number => l_mtlt_lot_number
9269: ,organization_id=> p_org_id
9270: ,precision => null

Line 9284: t_lpn_lot_qty_table(l_table_index).trx_qty := inv_convert.inv_um_convert(

9280: ELSE
9281: IF(p_trx_uom = l_secondary_uom) THEN
9282: t_lpn_lot_qty_table(l_table_index).trx_qty := l_satt;
9283: ELSE
9284: t_lpn_lot_qty_table(l_table_index).trx_qty := inv_convert.inv_um_convert(
9285: item_id => p_item_id
9286: ,lot_number => l_mtlt_lot_number
9287: ,organization_id=> p_org_id
9288: ,precision => null

Line 10034: t_lpn_lot_qty_table(l_table_index).trx_qty := inv_convert.inv_um_convert(

10030: t_lpn_lot_qty_table(l_table_index).trx_qty := l_satt;
10031: ELSIF (l_primary_uom = p_trx_uom) THEN
10032: t_lpn_lot_qty_table(l_table_index).trx_qty := l_att;
10033: ELSE
10034: t_lpn_lot_qty_table(l_table_index).trx_qty := inv_convert.inv_um_convert(
10035: item_id => p_item_id
10036: ,lot_number => l_mtlt_lot_number
10037: ,organization_id=> p_org_id
10038: ,precision => null

Line 10051: t_lpn_lot_qty_table(l_table_index).trx_qty := inv_convert.inv_um_convert(

10047: t_lpn_lot_qty_table(l_table_index).trx_qty := l_att;
10048: ELSIF (l_secondary_uom = p_trx_uom) THEN
10049: t_lpn_lot_qty_table(l_table_index).trx_qty := l_satt;
10050: ELSE
10051: t_lpn_lot_qty_table(l_table_index).trx_qty := inv_convert.inv_um_convert(
10052: item_id => p_item_id
10053: ,lot_number => l_mtlt_lot_number
10054: ,organization_id=> p_org_id
10055: ,precision => null

Line 11051: t_lpn_lot_qty_table(l_table_index).trx_qty := inv_convert.inv_um_convert(

11047: IF(l_fulfillment_base = 'S') THEN
11048: IF (l_secondary_uom = p_trx_uom) THEN
11049: t_lpn_lot_qty_table(l_table_index).trx_qty := l_satt;
11050: ELSE
11051: t_lpn_lot_qty_table(l_table_index).trx_qty := inv_convert.inv_um_convert(
11052: item_id => p_item_id
11053: ,lot_number => l_mtlt_lot_number
11054: ,organization_id=> p_org_id
11055: ,precision => null

Line 11066: t_lpn_lot_qty_table(l_table_index).trx_qty := inv_convert.inv_um_convert(

11062: ELSE
11063: IF (l_primary_uom = p_trx_uom) THEN
11064: t_lpn_lot_qty_table(l_table_index).trx_qty := l_att;
11065: ELSE
11066: t_lpn_lot_qty_table(l_table_index).trx_qty := inv_convert.inv_um_convert(
11067: item_id => p_item_id
11068: ,lot_number => l_mtlt_lot_number
11069: ,organization_id=> p_org_id
11070: ,precision => null

Line 11460: l_lpn_trx_qty := inv_convert.inv_um_convert(

11456: END IF;
11457:
11458: IF l_fulfillment_base = 'S' THEN --We are not comparing trx uom with primary for fulfillment basis 'S' as deviation quantities might result in irrelvant primary.
11459: IF (p_trx_uom <> l_secondary_uom) THEN --for fulfillment based on secondary we care only about the transactable sec present in LPN no matter what primary is.
11460: l_lpn_trx_qty := inv_convert.inv_um_convert(
11461: item_id => p_item_id
11462: ,lot_number => l_mtlt_lot_number
11463: ,organization_id=> p_org_id
11464: ,precision => null

Line 11480: l_lpn_trx_qty := inv_convert.inv_um_convert(

11476: IF (p_trx_uom <> l_primary_uom) THEN
11477: IF(p_trx_uom = l_secondary_uom) THEN
11478: l_lpn_trx_qty := l_lpn_sec_qty;
11479: ELSE
11480: l_lpn_trx_qty := inv_convert.inv_um_convert(
11481: item_id => p_item_id
11482: ,lot_number => l_mtlt_lot_number
11483: ,organization_id=> p_org_id
11484: ,precision => null

Line 11818: x_lpn_qoh := inv_convert.inv_um_convert(

11814: IF l_fulfillment_base = 'S' THEN
11815: IF(p_trx_uom = l_secondary_uom) THEN
11816: x_lpn_qoh := l_sqoh;
11817: ELSE
11818: x_lpn_qoh := inv_convert.inv_um_convert(
11819: item_id => p_item_id
11820: ,precision => null
11821: ,from_quantity => l_sqoh
11822: ,from_unit => l_secondary_uom

Line 11834: x_lpn_qoh := inv_convert.inv_um_convert(

11830: --x_lpn_qoh := l_lpn_sec_qty;--Bug 14127418 --commented this code as l_lpn_sec_qty is the Sec ATT
11831: --and we need to assign the sec on hand which is l_sqoh returned from above query
11832: x_lpn_qoh := l_sqoh;
11833: ELSE
11834: x_lpn_qoh := inv_convert.inv_um_convert(
11835: item_id => p_item_id
11836: ,precision => null
11837: ,from_quantity => l_qoh
11838: ,from_unit => l_primary_uom

Line 12332: l_att_trx_qty := inv_convert.inv_um_convert(

12328: l_att_trx_qty := l_satt;
12329: l_trx_qoh := l_sqoh;
12330: ELSE
12331: IF (l_fulfillment_base = 'S') THEN
12332: l_att_trx_qty := inv_convert.inv_um_convert(
12333: item_id => p_item_id
12334: ,precision => null
12335: ,from_quantity => l_satt
12336: ,from_unit => p_sec_uom

Line 12340: l_trx_qoh := inv_convert.inv_um_convert(

12336: ,from_unit => p_sec_uom
12337: ,to_unit => p_trx_uom
12338: ,from_name => null
12339: ,to_name => null);
12340: l_trx_qoh := inv_convert.inv_um_convert(
12341: item_id => p_item_id
12342: ,precision => null
12343: ,from_quantity => l_sqoh
12344: ,from_unit => p_sec_uom

Line 12351: l_att_trx_qty := inv_convert.inv_um_convert(

12347: ,to_name => null);
12348:
12349: ELSE
12350:
12351: l_att_trx_qty := inv_convert.inv_um_convert(
12352: item_id => p_item_id
12353: ,precision => null
12354: ,from_quantity => l_att
12355: ,from_unit => p_pri_uom

Line 12359: l_trx_qoh := inv_convert.inv_um_convert(

12355: ,from_unit => p_pri_uom
12356: ,to_unit => p_trx_uom
12357: ,from_name => null
12358: ,to_name => null);
12359: l_trx_qoh := inv_convert.inv_um_convert(
12360: item_id => p_item_id
12361: ,precision => null
12362: ,from_quantity => l_qoh
12363: ,from_unit => p_pri_uom

Line 15016: t_lpn_lot_qty_table(l_table_index).trx_qty := inv_convert.inv_um_convert(

15012:
15013: IF (l_primary_uom = p_trx_uom) THEN
15014: t_lpn_lot_qty_table(l_table_index).trx_qty := l_att;
15015: ELSE
15016: t_lpn_lot_qty_table(l_table_index).trx_qty := inv_convert.inv_um_convert(
15017: item_id => p_item_id
15018: ,precision => null
15019: ,from_quantity => l_att
15020: ,from_unit => l_primary_uom

Line 15098: t_lpn_lot_qty_table(l_table_index).trx_qty := inv_convert.inv_um_convert(

15094:
15095: IF (l_primary_uom = p_trx_uom) THEN
15096: t_lpn_lot_qty_table(l_table_index).trx_qty := l_att;
15097: ELSE
15098: t_lpn_lot_qty_table(l_table_index).trx_qty := inv_convert.inv_um_convert(
15099: item_id => p_item_id
15100: ,precision => null
15101: ,from_quantity => l_att
15102: ,from_unit => l_primary_uom

Line 15279: l_sec_qty := inv_convert.inv_um_convert

15275: mydebug ('fulfillment_base :' || l_fulfillment_base);
15276:
15277: IF l_fulfillment_base = 'S' THEN --{
15278: IF p_confirmed_uom <> l_suom THEN
15279: l_sec_qty := inv_convert.inv_um_convert
15280: (item_id => l_item_id
15281: ,precision => l_g_decimal_precision
15282: ,from_quantity => l_subs_lot_qty
15283: ,from_unit => p_confirmed_uom

Line 15291: l_prim_qty := inv_convert.inv_um_convert

15287: ELSE
15288: l_sec_qty := l_subs_lot_qty;
15289: END IF;
15290:
15291: l_prim_qty := inv_convert.inv_um_convert
15292: (item_id => l_item_id
15293: ,lot_number => l_lot_number
15294: ,organization_id => l_organization_id
15295: ,precision => l_g_decimal_precision

Line 15307: l_txn_qty := inv_convert.inv_um_convert

15303: l_txn_qty := l_prim_qty;
15304: ELSIF (l_tuom = l_suom) THEN
15305: l_txn_qty := l_sec_qty;
15306: ELSE
15307: l_txn_qty := inv_convert.inv_um_convert
15308: (item_id => l_item_id
15309: ,precision => l_g_decimal_precision
15310: ,from_quantity => l_subs_lot_qty
15311: ,from_unit => p_confirmed_uom

Line 15319: l_prim_qty := inv_convert.inv_um_convert

15315: END IF;
15316:
15317: ELSE
15318: IF p_confirmed_uom <> l_puom THEN
15319: l_prim_qty := inv_convert.inv_um_convert
15320: (item_id => l_item_id
15321: ,precision => l_g_decimal_precision
15322: ,from_quantity => l_subs_lot_qty
15323: ,from_unit => p_confirmed_uom

Line 15333: l_sec_qty := inv_convert.inv_um_convert

15329: END IF;
15330:
15331: IF(l_suom IS NOT NULL) THEN
15332: IF p_confirmed_uom <> l_suom THEN
15333: l_sec_qty := inv_convert.inv_um_convert
15334: (item_id => l_item_id
15335: ,precision => l_g_decimal_precision
15336: ,from_quantity => l_subs_lot_qty
15337: ,from_unit => p_confirmed_uom

Line 15352: l_txn_qty := inv_convert.inv_um_convert

15348: l_txn_qty := l_prim_qty;
15349: ELSIF (l_tuom = l_suom) THEN
15350: l_txn_qty := l_sec_qty;
15351: ELSE
15352: l_txn_qty := inv_convert.inv_um_convert
15353: (item_id => l_item_id
15354: ,precision => l_g_decimal_precision
15355: ,from_quantity => l_subs_lot_qty
15356: ,from_unit => p_confirmed_uom

Line 15857: l_sec_qty := inv_convert.inv_um_convert(

15853: where parameter = 'NLS_NUMERIC_CHARACTERS';
15854:
15855: IF p_fulfillment_base = 'S' THEN --{
15856: IF (p_trx_uom <> p_sec_uom) THEN
15857: l_sec_qty := inv_convert.inv_um_convert(
15858: item_id => p_item_id
15859: ,precision => null
15860: ,from_quantity => p_trx_qty
15861: ,from_unit => p_trx_uom

Line 15874: l_pr_qty := inv_convert.inv_um_convert(

15870: mydebug('In Update_Tree_Flex_Lot Fulfillment basis is S and transaction UOM is same than secondary UOM');
15871: mydebug('p_trx_qty/l_sec_qty in secondary uom is :'|| l_sec_qty);
15872:
15873: END IF;
15874: l_pr_qty := inv_convert.inv_um_convert(
15875: item_id => p_item_id
15876: ,precision => null
15877: ,from_quantity => l_sec_qty
15878: ,from_unit => p_sec_uom

Line 15885: l_pr_qty := inv_convert.inv_um_convert(

15881: ,to_name => null);
15882:
15883: ELSE
15884: IF (p_trx_uom <> l_primary_uom) THEN
15885: l_pr_qty := inv_convert.inv_um_convert(
15886: item_id => p_item_id
15887: ,precision => null
15888: ,from_quantity => p_trx_qty
15889: ,from_unit => p_trx_uom

Line 15905: l_sec_qty := inv_convert.inv_um_convert(

15901: mydebug('In Update_Tree_Flex_Lot Fulfillment basis is P and transaction UOM is same as Primary UOM');
15902: mydebug('l_pr_qty is the same as p_trx_qty :'|| l_pr_qty);
15903: END IF;
15904: END IF;
15905: l_sec_qty := inv_convert.inv_um_convert(
15906: item_id => p_item_id
15907: ,precision => null
15908: ,from_quantity => l_pr_qty
15909: ,from_unit => l_primary_uom

Line 16117: t_lpn_lot_qty_table(l_table_index).trx_qty := inv_convert.inv_um_convert(

16113: t_lpn_lot_qty_table(l_table_index).trx_qty := l_satt;
16114: ELSIF(l_primary_uom = p_trx_uom) THEN
16115: t_lpn_lot_qty_table(l_table_index).trx_qty := l_att;
16116: ELSE
16117: t_lpn_lot_qty_table(l_table_index).trx_qty := inv_convert.inv_um_convert(
16118: item_id => p_item_id
16119: ,lot_number => p_lot
16120: ,organization_id=> p_org_id
16121: ,precision => null

Line 16135: t_lpn_lot_qty_table(l_table_index).trx_qty := inv_convert.inv_um_convert(

16131: ELSE
16132: IF(p_trx_uom = p_sec_uom) THEN
16133: t_lpn_lot_qty_table(l_table_index).trx_qty := l_satt;
16134: ELSE
16135: t_lpn_lot_qty_table(l_table_index).trx_qty := inv_convert.inv_um_convert(
16136: item_id => p_item_id
16137: ,lot_number => p_lot
16138: ,organization_id=> p_org_id
16139: ,precision => null