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 243: l_primary_uom := inv_rcv_cache.get_primary_uom_code(p_organization_id,p_inventory_item_id);

239: if ( ( p_quantity IS NULL ) OR (p_quantity = 0) ) then
240: return 0;
241: end if;
242:
243: l_primary_uom := inv_rcv_cache.get_primary_uom_code(p_organization_id,p_inventory_item_id);
244:
245: return( inv_rcv_cache.convert_qty(p_inventory_item_id => p_inventory_item_id
246: ,p_from_qty => p_quantity
247: ,p_from_uom_code => p_uom

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

241: end if;
242:
243: l_primary_uom := inv_rcv_cache.get_primary_uom_code(p_organization_id,p_inventory_item_id);
244:
245: return( inv_rcv_cache.convert_qty(p_inventory_item_id => p_inventory_item_id
246: ,p_from_qty => p_quantity
247: ,p_from_uom_code => p_uom
248: ,p_to_uom_code => l_primary_uom
249: ,p_precision => 5--BUG 4939647

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

2517:
2518: l_progress := 'WMSINB-11933';
2519:
2520: IF (l_wlpnci_rec.uom_code <> l_prim_uom_code) THEN
2521: l_prim_qty := inv_rcv_cache.convert_qty(p_inventory_item_id => l_rti_rec.item_id
2522: ,p_from_qty => l_wlpnci_rec.quantity
2523: ,p_from_uom_code => l_wlpnci_rec.uom_code
2524: ,p_to_uom_code => l_prim_uom_code);
2525: ELSE

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

5473: --BUG 4766810: Always add before rounding. Also, when comparing
5474: -- for equality, check if the two number differs by 0.000005
5475: -- (round to 5 digits).
5476: IF (l_mol_rec.uom_code <> p_primary_uom_code) THEN
5477: l_conversion_rate := inv_rcv_cache.get_conversion_rate(l_mol_rec.inventory_item_id,
5478: l_mol_rec.uom_code,
5479: p_primary_uom_code);
5480: l_mol_qty_in_puom := l_mol_rec.quantity * l_conversion_rate;
5481: ELSE

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

5558: --Update quantity with the quantity converted to the UOM in the RTI. This is changed so
5559: --that the we honor the UOM entered by the user during
5560: --Transfer
5561: IF (l_mol_rec.uom_code <> p_uom_code) THEN
5562: l_tmp_qty := inv_rcv_cache.convert_qty(l_mol_rec.inventory_item_id
5563: ,l_mol_rec.txn_qty
5564: ,l_mol_rec.uom_code
5565: ,p_uom_code);
5566: l_tmp_qty_dtld := inv_rcv_cache.convert_qty(l_mol_rec.inventory_item_id

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

5562: l_tmp_qty := inv_rcv_cache.convert_qty(l_mol_rec.inventory_item_id
5563: ,l_mol_rec.txn_qty
5564: ,l_mol_rec.uom_code
5565: ,p_uom_code);
5566: l_tmp_qty_dtld := inv_rcv_cache.convert_qty(l_mol_rec.inventory_item_id
5567: ,l_mol_rec.quantity_detailed
5568: ,l_mol_rec.uom_code
5569: ,p_uom_code);
5570: l_tmp_qty_dlvd := inv_rcv_cache.convert_qty(l_mol_rec.inventory_item_id

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

5566: l_tmp_qty_dtld := inv_rcv_cache.convert_qty(l_mol_rec.inventory_item_id
5567: ,l_mol_rec.quantity_detailed
5568: ,l_mol_rec.uom_code
5569: ,p_uom_code);
5570: l_tmp_qty_dlvd := inv_rcv_cache.convert_qty(l_mol_rec.inventory_item_id
5571: ,l_mol_rec.quantity_delivered
5572: ,l_mol_rec.uom_code
5573: ,p_uom_code);
5574: l_tmp_uom_code := p_uom_code;

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

5640: --Update quantity with the quantity converted to the UOM in the RTI. This is changed so
5641: --that the we honor the UOM entered by the user during
5642: --Transfer
5643: IF (l_mol_rec.uom_code <> p_uom_code) THEN
5644: l_tmp_qty := inv_rcv_cache.convert_qty(l_mol_rec.inventory_item_id
5645: ,l_mol_rec.txn_qty
5646: ,l_mol_rec.uom_code
5647: ,p_uom_code);
5648: l_tmp_qty_dtld := inv_rcv_cache.convert_qty(l_mol_rec.inventory_item_id

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

5644: l_tmp_qty := inv_rcv_cache.convert_qty(l_mol_rec.inventory_item_id
5645: ,l_mol_rec.txn_qty
5646: ,l_mol_rec.uom_code
5647: ,p_uom_code);
5648: l_tmp_qty_dtld := inv_rcv_cache.convert_qty(l_mol_rec.inventory_item_id
5649: ,l_mol_rec.quantity_detailed
5650: ,l_mol_rec.uom_code
5651: ,p_uom_code);
5652: l_tmp_qty_dlvd := inv_rcv_cache.convert_qty(l_mol_rec.inventory_item_id

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

5648: l_tmp_qty_dtld := inv_rcv_cache.convert_qty(l_mol_rec.inventory_item_id
5649: ,l_mol_rec.quantity_detailed
5650: ,l_mol_rec.uom_code
5651: ,p_uom_code);
5652: l_tmp_qty_dlvd := inv_rcv_cache.convert_qty(l_mol_rec.inventory_item_id
5653: ,l_mol_rec.quantity_delivered
5654: ,l_mol_rec.uom_code
5655: ,p_uom_code);
5656: l_tmp_uom_code := p_uom_code;

Line 5865: ,inv_rcv_cache.convert_qty(inventory_item_id

5861: , lpn_id = p_transfer_lpn_id
5862: , quantity = Decode(uom_code
5863: ,p_uom_code
5864: ,quantity
5865: ,inv_rcv_cache.convert_qty(inventory_item_id
5866: ,quantity
5867: ,uom_code
5868: ,p_uom_code)
5869: )

Line 5875: ,inv_rcv_cache.convert_qty(inventory_item_id

5871: ,'TRANSFER'
5872: ,Decode(uom_code
5873: ,p_uom_code
5874: ,quantity_detailed
5875: ,inv_rcv_cache.convert_qty(inventory_item_id
5876: ,quantity_detailed
5877: ,uom_code
5878: ,p_uom_code))
5879: ,NULL)

Line 5885: ,inv_rcv_cache.convert_qty(inventory_item_id

5881: ,'TRANSFER'
5882: ,Decode(uom_code
5883: ,p_uom_code
5884: ,quantity_delivered
5885: ,inv_rcv_cache.convert_qty(inventory_item_id
5886: ,quantity_delivered
5887: ,uom_code
5888: ,p_uom_code))
5889: ,NULL)

Line 5929: ,inv_rcv_cache.convert_qty(inventory_item_id

5925: , lpn_id = p_transfer_lpn_id
5926: , quantity = Decode(uom_code
5927: ,p_uom_code
5928: ,quantity
5929: ,inv_rcv_cache.convert_qty(inventory_item_id
5930: ,quantity
5931: ,uom_code
5932: ,p_uom_code)
5933: )

Line 5939: ,inv_rcv_cache.convert_qty(inventory_item_id

5935: ,'TRANSFER'
5936: ,Decode(uom_code
5937: ,p_uom_code
5938: ,quantity_detailed
5939: ,inv_rcv_cache.convert_qty(inventory_item_id
5940: ,quantity_detailed
5941: ,uom_code
5942: ,p_uom_code))
5943: ,NULL)

Line 5949: ,inv_rcv_cache.convert_qty(inventory_item_id

5945: ,'TRANSFER'
5946: ,Decode(uom_code
5947: ,p_uom_code
5948: ,quantity_delivered
5949: ,inv_rcv_cache.convert_qty(inventory_item_id
5950: ,quantity_delivered
5951: ,uom_code
5952: ,p_uom_code))
5953: ,NULL)

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

6427: --BUG 4766810: Always add before rounding. Also, when comparing
6428: -- for equality, check if the two number differs by 0.000005
6429: -- (round to 5 digits).
6430: IF (l_mol_rec.uom_code <> p_primary_uom_code) THEN
6431: l_conversion_rate := inv_rcv_cache.get_conversion_rate(l_mol_rec.inventory_item_id,
6432: l_mol_rec.uom_code,
6433: p_primary_uom_code);
6434: l_mol_qty_in_puom := l_mol_rec.quantity * l_conversion_rate;
6435: ELSE

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

6436: l_mol_qty_in_puom := l_mol_rec.quantity;
6437: l_conversion_rate := 1;
6438: END IF;
6439:
6440: l_quantity_delivered := inv_rcv_cache.convert_qty(p_inventory_item_id => l_mol_rec.inventory_item_id
6441: ,p_from_qty => l_remaining_primary_quantity
6442: ,p_from_uom_code => p_primary_uom_code
6443: ,p_to_uom_code => l_mol_rec.uom_code);
6444:

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

6445: -- OPMConvergence
6446:
6447: IF l_mol_rec.secondary_uom_code <> p_sec_uom THEN
6448:
6449: l_sec_quantity_delivered := inv_rcv_cache.convert_qty(p_inventory_item_id => l_mol_rec.inventory_item_id
6450: ,p_from_qty => l_remaining_primary_quantity
6451: ,p_from_uom_code => p_sec_uom
6452: ,p_to_uom_code => l_mol_rec.secondary_uom_code);
6453: ELSE

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

10493: print_debug('create_rti_for_lpn:p_mmtt_temp_id = '|| p_mmtt_temp_id , 4);
10494: END IF;
10495:
10496: IF (p_txn_uom_code <> l_primary_uom) THEN
10497: l_primary_qty := inv_rcv_cache.convert_qty(p_inventory_item_id => p_item_id
10498: ,p_from_qty => p_quantity
10499: ,p_from_uom_code => p_txn_uom_code
10500: ,p_to_uom_code => l_primary_uom
10501: );

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

11017: group by lot_number, uom_code )
11018: Loop
11019:
11020: IF (l_lot_rec.uom_code <> l_primary_uom) THEN
11021: l_primary_lot_qty := inv_rcv_cache.convert_qty(p_inventory_item_id => p_item_id
11022: ,p_from_qty => l_lot_rec.quantity
11023: ,p_from_uom_code => l_lot_rec.uom_code
11024: ,p_to_uom_code => l_primary_uom
11025: );

Line 11393: l_prim_uom_code := inv_rcv_cache.get_primary_uom_code

11389: l_rs_index := l_rs_tb.first;
11390: l_rti_tb.DELETE;
11391: l_rti_serial_tb.DELETE;
11392:
11393: l_prim_uom_code := inv_rcv_cache.get_primary_uom_code
11394: (l_mol_mmtt_ctnt_tb(i).organization_id
11395: ,l_mol_mmtt_ctnt_tb(i).inventory_item_id);
11396: l_sn_ctrl := inv_rcv_cache.get_sn_ctrl_code
11397: (l_mol_mmtt_ctnt_tb(i).organization_id

Line 11396: l_sn_ctrl := inv_rcv_cache.get_sn_ctrl_code

11392:
11393: l_prim_uom_code := inv_rcv_cache.get_primary_uom_code
11394: (l_mol_mmtt_ctnt_tb(i).organization_id
11395: ,l_mol_mmtt_ctnt_tb(i).inventory_item_id);
11396: l_sn_ctrl := inv_rcv_cache.get_sn_ctrl_code
11397: (l_mol_mmtt_ctnt_tb(i).organization_id
11398: ,l_mol_mmtt_ctnt_tb(i).inventory_item_id);
11399:
11400: LOOP

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

11443: RAISE fnd_api.g_exc_error;
11444: END;
11445:
11446: IF l_mol_mmtt_ctnt_tb(i).txn_uom_code <> l_rs_uom_code THEN
11447: l_avail_rs_qty := inv_rcv_cache.convert_qty(l_rs_tb(l_rs_index).inventory_item_id
11448: ,l_rs_tb(l_rs_index).quantity
11449: ,l_rs_uom_code
11450: ,l_mol_mmtt_ctnt_tb(i).txn_uom_code);
11451: ELSE

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

11455: IF l_qty_to_match > l_avail_rs_qty THEN
11456:
11457: IF (l_mol_mmtt_ctnt_tb(i).txn_tmp_id IS NOT NULL) then
11458: IF (l_mol_mmtt_ctnt_tb(i).txn_uom_code <> l_prim_uom_code) THEN
11459: l_avail_rs_prim_qty := inv_rcv_cache.convert_qty(l_rs_tb(l_rs_index).inventory_item_id
11460: ,l_avail_rs_qty
11461: ,l_mol_mmtt_ctnt_tb(i).txn_uom_code
11462: ,l_prim_uom_code);
11463: ELSE

Line 11491: inv_rcv_cache.convert_qty

11487: l_qty_to_match := 0;
11488:
11489: IF l_mol_mmtt_ctnt_tb(i).txn_uom_code <> l_rs_uom_code THEN
11490: l_rs_tb(l_rs_index).quantity := l_rs_tb(l_rs_index).quantity -
11491: inv_rcv_cache.convert_qty
11492: (l_rs_tb(l_rs_index).inventory_item_id
11493: ,l_qty_to_match
11494: ,l_mol_mmtt_ctnt_tb(i).txn_uom_code
11495: ,l_rs_uom_code);

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

11547: FROM DUAL;
11548: END IF;
11549:
11550: IF (l_mol_mmtt_ctnt_tb(i).txn_uom_code <> l_prim_uom_code) THEN
11551: l_prim_qty_to_insert := inv_rcv_cache.convert_qty(l_rs_tb(l_rs_index).inventory_item_id
11552: ,l_qty_to_insert
11553: ,l_mol_mmtt_ctnt_tb(i).txn_uom_code
11554: ,l_prim_uom_code);
11555: ELSE