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_RCV_INTEGRATION_PVT dependencies on INV_RCV_CACHE

Line 251: l_primary_uom := inv_rcv_cache.get_primary_uom_code(p_organization_id,p_inventory_item_id);

247: if ( ( p_quantity IS NULL ) OR (p_quantity = 0) ) then
248: return 0;
249: end if;
250:
251: l_primary_uom := inv_rcv_cache.get_primary_uom_code(p_organization_id,p_inventory_item_id);
252:
253: return( inv_rcv_cache.convert_qty(p_inventory_item_id => p_inventory_item_id
254: ,p_from_qty => p_quantity
255: ,p_from_uom_code => p_uom

Line 253: return( inv_rcv_cache.convert_qty(p_inventory_item_id => p_inventory_item_id

249: end if;
250:
251: l_primary_uom := inv_rcv_cache.get_primary_uom_code(p_organization_id,p_inventory_item_id);
252:
253: return( inv_rcv_cache.convert_qty(p_inventory_item_id => p_inventory_item_id
254: ,p_from_qty => p_quantity
255: ,p_from_uom_code => p_uom
256: ,p_to_uom_code => l_primary_uom
257: ,p_precision => 5--BUG 4939647

Line 2550: l_prim_qty := inv_rcv_cache.convert_qty(p_inventory_item_id => l_rti_rec.item_id

2546:
2547: l_progress := 'WMSINB-11933';
2548:
2549: IF (l_wlpnci_rec.uom_code <> l_prim_uom_code) THEN
2550: l_prim_qty := inv_rcv_cache.convert_qty(p_inventory_item_id => l_rti_rec.item_id
2551: ,p_from_qty => l_wlpnci_rec.quantity
2552: ,p_from_uom_code => l_wlpnci_rec.uom_code
2553: ,p_to_uom_code => l_prim_uom_code);
2554: ELSE

Line 5590: l_conversion_rate := inv_rcv_cache.get_conversion_rate(l_mol_rec.inventory_item_id,

5586: IF (l_mol_rec.uom_code <> p_primary_uom_code) THEN
5587: --commenting below code for bug 13484877--Here the primary mol qty is derived by multiplying the conv factor with trx qty
5588: --But if the trx qty is a rounded off qty, then qty mistmatch will happen. So to avoid that,the l_mol_qty_in_puom
5589: --can be direectly derived from l_mol_rec.primary_quantity
5590: l_conversion_rate := inv_rcv_cache.get_conversion_rate(l_mol_rec.inventory_item_id,
5591: l_mol_rec.uom_code,
5592: p_primary_uom_code);
5593: --l_mol_qty_in_puom := l_mol_rec.quantity * l_conversion_rate;
5594: --Added for bug 13484877 START

Line 5681: l_tmp_qty := inv_rcv_cache.convert_qty(l_mol_rec.inventory_item_id

5677: --Update quantity with the quantity converted to the UOM in the RTI. This is changed so
5678: --that the we honor the UOM entered by the user during
5679: --Transfer
5680: IF (l_mol_rec.uom_code <> p_uom_code) THEN
5681: l_tmp_qty := inv_rcv_cache.convert_qty(l_mol_rec.inventory_item_id
5682: ,l_mol_rec.txn_qty
5683: ,l_mol_rec.uom_code
5684: ,p_uom_code);
5685: l_tmp_qty_dtld := inv_rcv_cache.convert_qty(l_mol_rec.inventory_item_id

Line 5685: l_tmp_qty_dtld := inv_rcv_cache.convert_qty(l_mol_rec.inventory_item_id

5681: l_tmp_qty := inv_rcv_cache.convert_qty(l_mol_rec.inventory_item_id
5682: ,l_mol_rec.txn_qty
5683: ,l_mol_rec.uom_code
5684: ,p_uom_code);
5685: l_tmp_qty_dtld := inv_rcv_cache.convert_qty(l_mol_rec.inventory_item_id
5686: ,l_mol_rec.quantity_detailed
5687: ,l_mol_rec.uom_code
5688: ,p_uom_code);
5689: l_tmp_qty_dlvd := inv_rcv_cache.convert_qty(l_mol_rec.inventory_item_id

Line 5689: l_tmp_qty_dlvd := inv_rcv_cache.convert_qty(l_mol_rec.inventory_item_id

5685: l_tmp_qty_dtld := inv_rcv_cache.convert_qty(l_mol_rec.inventory_item_id
5686: ,l_mol_rec.quantity_detailed
5687: ,l_mol_rec.uom_code
5688: ,p_uom_code);
5689: l_tmp_qty_dlvd := inv_rcv_cache.convert_qty(l_mol_rec.inventory_item_id
5690: ,l_mol_rec.quantity_delivered
5691: ,l_mol_rec.uom_code
5692: ,p_uom_code);
5693: l_tmp_uom_code := p_uom_code;

Line 5770: l_tmp_qty := inv_rcv_cache.convert_qty(l_mol_rec.inventory_item_id

5766: IF (l_debug = 1) THEN
5767: print_debug('MAINTAIN_MO_CON - l_tmp_qty derived from l_mol_rec.primary_quantity'|| l_tmp_qty,1);
5768: END IF;
5769: ELSE -- End Bug 13484877
5770: l_tmp_qty := inv_rcv_cache.convert_qty(l_mol_rec.inventory_item_id
5771: ,l_mol_rec.txn_qty
5772: ,l_mol_rec.uom_code
5773: ,p_uom_code);
5774: END IF; -- 13484877

Line 5775: l_tmp_qty_dtld := inv_rcv_cache.convert_qty(l_mol_rec.inventory_item_id

5771: ,l_mol_rec.txn_qty
5772: ,l_mol_rec.uom_code
5773: ,p_uom_code);
5774: END IF; -- 13484877
5775: l_tmp_qty_dtld := inv_rcv_cache.convert_qty(l_mol_rec.inventory_item_id
5776: ,l_mol_rec.quantity_detailed
5777: ,l_mol_rec.uom_code
5778: ,p_uom_code);
5779: l_tmp_qty_dlvd := inv_rcv_cache.convert_qty(l_mol_rec.inventory_item_id

Line 5779: l_tmp_qty_dlvd := inv_rcv_cache.convert_qty(l_mol_rec.inventory_item_id

5775: l_tmp_qty_dtld := inv_rcv_cache.convert_qty(l_mol_rec.inventory_item_id
5776: ,l_mol_rec.quantity_detailed
5777: ,l_mol_rec.uom_code
5778: ,p_uom_code);
5779: l_tmp_qty_dlvd := inv_rcv_cache.convert_qty(l_mol_rec.inventory_item_id
5780: ,l_mol_rec.quantity_delivered
5781: ,l_mol_rec.uom_code
5782: ,p_uom_code);
5783: l_tmp_uom_code := p_uom_code;

Line 6002: ,inv_rcv_cache.convert_qty(inventory_item_id

5998: , lpn_id = p_transfer_lpn_id
5999: , quantity = Decode(uom_code
6000: ,p_uom_code
6001: ,quantity
6002: ,inv_rcv_cache.convert_qty(inventory_item_id
6003: ,quantity
6004: ,uom_code
6005: ,p_uom_code)
6006: )

Line 6012: ,inv_rcv_cache.convert_qty(inventory_item_id

6008: ,'TRANSFER'
6009: ,Decode(uom_code
6010: ,p_uom_code
6011: ,quantity_detailed
6012: ,inv_rcv_cache.convert_qty(inventory_item_id
6013: ,quantity_detailed
6014: ,uom_code
6015: ,p_uom_code))
6016: ,NULL)

Line 6022: ,inv_rcv_cache.convert_qty(inventory_item_id

6018: ,'TRANSFER'
6019: ,Decode(uom_code
6020: ,p_uom_code
6021: ,quantity_delivered
6022: ,inv_rcv_cache.convert_qty(inventory_item_id
6023: ,quantity_delivered
6024: ,uom_code
6025: ,p_uom_code))
6026: ,NULL)

Line 6066: ,inv_rcv_cache.convert_qty(inventory_item_id

6062: , lpn_id = p_transfer_lpn_id
6063: , quantity = Decode(p_uom_code,p_primary_uom_code,primary_quantity,uom_code--bug 13484877
6064: --commenting for bug 13484877,p_uom_code
6065: ,quantity
6066: ,inv_rcv_cache.convert_qty(inventory_item_id
6067: ,quantity
6068: ,uom_code
6069: ,p_uom_code)
6070: )

Line 6076: ,inv_rcv_cache.convert_qty(inventory_item_id

6072: ,'TRANSFER'
6073: ,Decode(uom_code
6074: ,p_uom_code
6075: ,quantity_detailed
6076: ,inv_rcv_cache.convert_qty(inventory_item_id
6077: ,quantity_detailed
6078: ,uom_code
6079: ,p_uom_code))
6080: ,NULL)

Line 6086: ,inv_rcv_cache.convert_qty(inventory_item_id

6082: ,'TRANSFER'
6083: ,Decode(uom_code
6084: ,p_uom_code
6085: ,quantity_delivered
6086: ,inv_rcv_cache.convert_qty(inventory_item_id
6087: ,quantity_delivered
6088: ,uom_code
6089: ,p_uom_code))
6090: ,NULL)

Line 6178: l_mol_res_in(1).quantity := inv_rcv_cache.convert_qty(p_inventory_item_id => p_item_id

6174:
6175: END IF;
6176: --started changes for bug8283511
6177: IF(l_transfer_mol_rec.uom_code <> l_mol_rec.uom_code) THEN
6178: l_mol_res_in(1).quantity := inv_rcv_cache.convert_qty(p_inventory_item_id => p_item_id
6179: ,p_from_qty => l_mol_rec.quantity
6180: ,p_from_uom_code => l_mol_rec.uom_code
6181: ,p_to_uom_code => l_transfer_mol_rec.uom_code
6182: ,p_precision => 5--BUG 4939647

Line 6203: l_mol_res_in(1).quantity := inv_rcv_cache.convert_qty(p_inventory_item_id => p_item_id

6199: print_debug('l_split_qty '||l_split_qty,1);
6200: END IF;
6201: --started changes for bug8283511
6202: IF(l_transfer_mol_rec.uom_code <>l_uom_code) THEN
6203: l_mol_res_in(1).quantity := inv_rcv_cache.convert_qty(p_inventory_item_id => p_item_id
6204: ,p_from_qty => l_split_qty
6205: ,p_from_uom_code => l_uom_code
6206: ,p_to_uom_code => l_transfer_mol_rec.uom_code
6207: ,p_precision => 5--BUG 4939647

Line 6606: l_conversion_rate := inv_rcv_cache.get_conversion_rate(l_mol_rec.inventory_item_id,

6602: --BUG 4766810: Always add before rounding. Also, when comparing
6603: -- for equality, check if the two number differs by 0.000005
6604: -- (round to 5 digits).
6605: IF (l_mol_rec.uom_code <> p_primary_uom_code) THEN
6606: l_conversion_rate := inv_rcv_cache.get_conversion_rate(l_mol_rec.inventory_item_id,
6607: l_mol_rec.uom_code,
6608: p_primary_uom_code);
6609: l_mol_qty_in_puom := l_mol_rec.quantity * l_conversion_rate;
6610: ELSE

Line 6615: l_quantity_delivered := inv_rcv_cache.convert_qty(p_inventory_item_id => l_mol_rec.inventory_item_id

6611: l_mol_qty_in_puom := l_mol_rec.quantity;
6612: l_conversion_rate := 1;
6613: END IF;
6614:
6615: l_quantity_delivered := inv_rcv_cache.convert_qty(p_inventory_item_id => l_mol_rec.inventory_item_id
6616: ,p_from_qty => l_remaining_primary_quantity
6617: ,p_from_uom_code => p_primary_uom_code
6618: ,p_to_uom_code => l_mol_rec.uom_code);
6619:

Line 6624: l_sec_quantity_delivered := inv_rcv_cache.convert_qty(p_inventory_item_id => l_mol_rec.inventory_item_id

6620: -- OPMConvergence
6621:
6622: IF l_mol_rec.secondary_uom_code <> p_sec_uom THEN
6623:
6624: l_sec_quantity_delivered := inv_rcv_cache.convert_qty(p_inventory_item_id => l_mol_rec.inventory_item_id
6625: ,p_from_qty => l_remaining_primary_quantity
6626: ,p_from_uom_code => p_sec_uom
6627: ,p_to_uom_code => l_mol_rec.secondary_uom_code);
6628: ELSE

Line 10974: l_primary_qty := inv_rcv_cache.convert_qty(p_inventory_item_id => p_item_id

10970: print_debug('create_rti_for_lpn:p_mmtt_temp_id = '|| p_mmtt_temp_id , 4);
10971: END IF;
10972:
10973: IF (p_txn_uom_code <> l_primary_uom) THEN
10974: l_primary_qty := inv_rcv_cache.convert_qty(p_inventory_item_id => p_item_id
10975: ,p_from_qty => p_quantity
10976: ,p_from_uom_code => p_txn_uom_code
10977: ,p_to_uom_code => l_primary_uom
10978: );

Line 11498: l_primary_lot_qty := inv_rcv_cache.convert_qty(p_inventory_item_id => p_item_id

11494: group by lot_number, uom_code )
11495: Loop
11496:
11497: IF (l_lot_rec.uom_code <> l_primary_uom) THEN
11498: l_primary_lot_qty := inv_rcv_cache.convert_qty(p_inventory_item_id => p_item_id
11499: ,p_from_qty => l_lot_rec.quantity
11500: ,p_from_uom_code => l_lot_rec.uom_code
11501: ,p_to_uom_code => l_primary_uom
11502: );

Line 11870: l_prim_uom_code := inv_rcv_cache.get_primary_uom_code

11866: l_rs_index := l_rs_tb.first;
11867: l_rti_tb.DELETE;
11868: l_rti_serial_tb.DELETE;
11869:
11870: l_prim_uom_code := inv_rcv_cache.get_primary_uom_code
11871: (l_mol_mmtt_ctnt_tb(i).organization_id
11872: ,l_mol_mmtt_ctnt_tb(i).inventory_item_id);
11873: l_sn_ctrl := inv_rcv_cache.get_sn_ctrl_code
11874: (l_mol_mmtt_ctnt_tb(i).organization_id

Line 11873: l_sn_ctrl := inv_rcv_cache.get_sn_ctrl_code

11869:
11870: l_prim_uom_code := inv_rcv_cache.get_primary_uom_code
11871: (l_mol_mmtt_ctnt_tb(i).organization_id
11872: ,l_mol_mmtt_ctnt_tb(i).inventory_item_id);
11873: l_sn_ctrl := inv_rcv_cache.get_sn_ctrl_code
11874: (l_mol_mmtt_ctnt_tb(i).organization_id
11875: ,l_mol_mmtt_ctnt_tb(i).inventory_item_id);
11876:
11877: LOOP

Line 11932: l_avail_rs_qty := inv_rcv_cache.convert_qty(l_rs_tb(l_rs_index).inventory_item_id

11928: RAISE fnd_api.g_exc_error;
11929: END;
11930:
11931: IF l_mol_mmtt_ctnt_tb(i).txn_uom_code <> l_rs_uom_code THEN
11932: l_avail_rs_qty := inv_rcv_cache.convert_qty(l_rs_tb(l_rs_index).inventory_item_id
11933: ,l_rs_tb(l_rs_index).quantity
11934: ,l_rs_uom_code
11935: ,l_mol_mmtt_ctnt_tb(i).txn_uom_code);
11936: ELSE

Line 11944: l_avail_rs_prim_qty := inv_rcv_cache.convert_qty(l_rs_tb(l_rs_index).inventory_item_id

11940: IF l_qty_to_match > l_avail_rs_qty THEN
11941:
11942: IF (l_mol_mmtt_ctnt_tb(i).txn_tmp_id IS NOT NULL) then
11943: IF (l_mol_mmtt_ctnt_tb(i).txn_uom_code <> l_prim_uom_code) THEN
11944: l_avail_rs_prim_qty := inv_rcv_cache.convert_qty(l_rs_tb(l_rs_index).inventory_item_id
11945: ,l_avail_rs_qty
11946: ,l_mol_mmtt_ctnt_tb(i).txn_uom_code
11947: ,l_prim_uom_code);
11948: ELSE

Line 11976: inv_rcv_cache.convert_qty

11972: l_qty_to_match := 0;
11973:
11974: IF l_mol_mmtt_ctnt_tb(i).txn_uom_code <> l_rs_uom_code THEN
11975: l_rs_tb(l_rs_index).quantity := l_rs_tb(l_rs_index).quantity -
11976: inv_rcv_cache.convert_qty
11977: (l_rs_tb(l_rs_index).inventory_item_id
11978: ,l_qty_to_match
11979: ,l_mol_mmtt_ctnt_tb(i).txn_uom_code
11980: ,l_rs_uom_code);

Line 12036: l_prim_qty_to_insert := inv_rcv_cache.convert_qty(l_rs_tb(l_rs_index).inventory_item_id

12032: FROM DUAL;
12033: END IF;
12034:
12035: IF (l_mol_mmtt_ctnt_tb(i).txn_uom_code <> l_prim_uom_code) THEN
12036: l_prim_qty_to_insert := inv_rcv_cache.convert_qty(l_rs_tb(l_rs_index).inventory_item_id
12037: ,l_qty_to_insert
12038: ,l_mol_mmtt_ctnt_tb(i).txn_uom_code
12039: ,l_prim_uom_code);
12040: ELSE