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_REPLENISHMENT_PVT dependencies on INV_CACHE

Line 845: IF inv_cache.set_item_rec(L_ORG_ID, L_item_id) THEN

841: l_item_id := x_consol_item_repl_tbl(i).item_id;
842: l_org_id := x_consol_item_repl_tbl(i).organization_id;
843:
844: -- Get all item details
845: IF inv_cache.set_item_rec(L_ORG_ID, L_item_id) THEN
846:
847: IF inv_cache.item_rec.revision_qty_control_code = 2 THEN
848: l_is_revision_ctrl := TRUE;
849: ELSE

Line 847: IF inv_cache.item_rec.revision_qty_control_code = 2 THEN

843:
844: -- Get all item details
845: IF inv_cache.set_item_rec(L_ORG_ID, L_item_id) THEN
846:
847: IF inv_cache.item_rec.revision_qty_control_code = 2 THEN
848: l_is_revision_ctrl := TRUE;
849: ELSE
850: l_is_revision_ctrl := FALSE;
851: END IF;

Line 853: IF inv_cache.item_rec.lot_control_code = 2 THEN

849: ELSE
850: l_is_revision_ctrl := FALSE;
851: END IF;
852:
853: IF inv_cache.item_rec.lot_control_code = 2 THEN
854: l_is_lot_ctrl := TRUE;
855: ELSE
856: l_is_lot_ctrl := FALSE;
857: END IF;

Line 859: IF inv_cache.item_rec.serial_number_control_code NOT IN (1,6) THEN

855: ELSE
856: l_is_lot_ctrl := FALSE;
857: END IF;
858:
859: IF inv_cache.item_rec.serial_number_control_code NOT IN (1,6) THEN
860: l_is_serial_ctrl := FALSE;
861: ELSE
862: l_is_serial_ctrl := TRUE;
863: END IF;

Line 872: END IF; -- for inv_cache.set_item_rec

868: print_debug('Error: Item detail not found');
869: END IF ;
870:
871: RAISE no_data_found;
872: END IF; -- for inv_cache.set_item_rec
873:
874:
875: --uom conversio would already be defined, otherwise it will not come here
876: -- get the final repl qty in the primary UOM

Line 880: inv_cache.item_rec.primary_uom_code

876: -- get the final repl qty in the primary UOM
877: l_prim_repl_qty :=
878: ROUND((x_consol_item_repl_tbl(i).total_demand_qty * get_conversion_rate(l_Item_id,
879: x_consol_item_repl_tbl(i).repl_uom_code,
880: inv_cache.item_rec.primary_uom_code
881: )),
882: g_conversion_precision);
883:
884:

Line 1207: inv_cache.item_rec.primary_uom_code,

1203:
1204: l_split_wdd_id := l_action_out_rec.result_id_tab(l_action_out_rec.result_id_tab.FIRST);
1205:
1206: l_new_qty_in_repl_uom := ROUND((l_atr * get_conversion_rate(l_item_id,
1207: inv_cache.item_rec.primary_uom_code,
1208: x_consol_item_repl_tbl(i).repl_uom_code )), g_conversion_precision);
1209:
1210: -- update the qty in the existing GTMP record
1211: UPDATE wms_repl_demand_gtmp

Line 1345: inv_cache.item_rec.primary_uom_code,

1341: --3- For the Item, Adjust the QTY in the CONSOLIDATED TABLE
1342: IF l_prim_repl_qty > 0 THEN
1343: x_consol_item_repl_tbl(i).total_demand_qty :=
1344: ROUND((l_prim_repl_qty * get_conversion_rate(l_item_id,
1345: inv_cache.item_rec.primary_uom_code,
1346: x_consol_item_repl_tbl(i).repl_uom_code
1347: )),
1348: g_conversion_precision);
1349:

Line 2763: IF inv_cache.set_item_rec(p_ORGANIZATION_ID, p_inventory_item_id) THEN

2759:
2760:
2761: IF l_source_sub_atr = -9999 THEN
2762: -- Get all item details
2763: IF inv_cache.set_item_rec(p_ORGANIZATION_ID, p_inventory_item_id) THEN
2764: IF (l_debug = 1) THEN
2765: print_debug('Getting Item Attribute Details' );
2766: END IF;
2767: IF inv_cache.item_rec.revision_qty_control_code = 2 THEN

Line 2767: IF inv_cache.item_rec.revision_qty_control_code = 2 THEN

2763: IF inv_cache.set_item_rec(p_ORGANIZATION_ID, p_inventory_item_id) THEN
2764: IF (l_debug = 1) THEN
2765: print_debug('Getting Item Attribute Details' );
2766: END IF;
2767: IF inv_cache.item_rec.revision_qty_control_code = 2 THEN
2768: l_is_revision_ctrl := TRUE;
2769: ELSE
2770: l_is_revision_ctrl := FALSE;
2771: END IF;

Line 2773: IF inv_cache.item_rec.lot_control_code = 2 THEN

2769: ELSE
2770: l_is_revision_ctrl := FALSE;
2771: END IF;
2772:
2773: IF inv_cache.item_rec.lot_control_code = 2 THEN
2774: l_is_lot_ctrl := TRUE;
2775: ELSE
2776: l_is_lot_ctrl := FALSE;
2777: END IF;

Line 2779: IF inv_cache.item_rec.serial_number_control_code NOT IN (1,6) THEN

2775: ELSE
2776: l_is_lot_ctrl := FALSE;
2777: END IF;
2778:
2779: IF inv_cache.item_rec.serial_number_control_code NOT IN (1,6) THEN
2780: l_is_serial_ctrl := FALSE;
2781: ELSE
2782: l_is_serial_ctrl := TRUE;
2783: END IF;

Line 2791: END IF; -- for inv_cache.set_item_rec

2787: print_debug('Error: Item detail not found');
2788: END IF;
2789: x_return_status := fnd_api.g_ret_sts_success;
2790: x_create_qty := 0;
2791: END IF; -- for inv_cache.set_item_rec
2792:
2793: IF (l_debug = 1) THEN
2794: print_debug('Clearing Qty Tree' );
2795: END IF;

Line 3560: IF inv_cache.set_item_rec(p_consol_item_repl_tbl(i).ORGANIZATION_ID, p_consol_item_repl_tbl(i).item_id) THEN

3556:
3557: -- Upp the replenishment qty appropriately
3558:
3559: --set the item info in cache
3560: IF inv_cache.set_item_rec(p_consol_item_repl_tbl(i).ORGANIZATION_ID, p_consol_item_repl_tbl(i).item_id) THEN
3561:
3562: -- for Dynamic replenishment or next level repl, p_Repl_Lot_Size will be passed as NULL
3563: IF p_repl_lot_size IS NULL THEN
3564: IF l_debug = 1 THEN

Line 3582: inv_cache.item_rec.primary_uom_code),

3578: -- The qty should be tracked in src_pick_uom
3579: IF l_src_pick_uom IS NOT NULL THEN -- pushing with bug 7201888
3580: l_conversion := ROUND(get_conversion_rate(p_consol_item_repl_tbl(i).Item_id,
3581: l_src_pick_uom,
3582: inv_cache.item_rec.primary_uom_code),
3583: g_conversion_precision);
3584:
3585: END IF;
3586:

Line 3591: inv_cache.item_rec.primary_uom_code),

3587: ELSIF l_src_pick_uom IS NOT NULL THEN
3588: -- GET THE MULITPLE OF THE "UNIT QTY CONVERSION OF the source sub pick UOM"
3589: l_conversion := ROUND(get_conversion_rate(p_consol_item_repl_tbl(i).Item_id,
3590: l_src_pick_uom,
3591: inv_cache.item_rec.primary_uom_code),
3592: g_conversion_precision);
3593:
3594:
3595: IF l_debug = 1 THEN

Line 3617: inv_cache.item_rec.primary_uom_code)),

3613: -- would not have been marked otherwise
3614: l_txn_prim_qty :=
3615: ROUND((p_consol_item_repl_tbl(i).final_replenishment_qty * get_conversion_rate(p_consol_item_repl_tbl(i).Item_id,
3616: p_consol_item_repl_tbl(i).repl_uom_code,
3617: inv_cache.item_rec.primary_uom_code)),
3618: g_conversion_precision);
3619:
3620: -- UPP the PRIMARY QTY in the INTEGRAL MULITPLE of l_repl_lot_size_prim
3621: -- to habndle the case in which Repl_Lot_Size is exact multiple of repl qty

Line 3633: inv_cache.item_rec.primary_uom_code,

3629: IF l_conversion > 0 THEN
3630: -- convert the final qty into apporopriate qty based on l_src_pick_uom
3631: p_consol_item_repl_tbl(i).final_replenishment_qty :=
3632: ROUND((l_txn_prim_qty * get_conversion_rate(p_consol_item_repl_tbl(i).Item_id,
3633: inv_cache.item_rec.primary_uom_code,
3634: l_src_pick_uom )),
3635: g_conversion_precision);
3636:
3637: -- UPDATE THE UOM CODE AS WELL

Line 3646: inv_cache.item_rec.primary_uom_code,

3642: --ADJUST THE INCREASED QTY IN THE p_consol_item_repl_tbl(i).repl_uom_code uom only
3643: IF l_conversion > 0 THEN
3644: p_consol_item_repl_tbl(i).final_replenishment_qty :=
3645: ROUND((l_txn_prim_qty * get_conversion_rate(p_consol_item_repl_tbl(i).Item_id,
3646: inv_cache.item_rec.primary_uom_code,
3647: p_consol_item_repl_tbl(i).Repl_UOM_Code )),
3648: g_conversion_precision);
3649:
3650: -- UOM_CODE remains same here

Line 3673: END IF; -- FOR inv_cache.set_item_rec

3669: l_Repl_Lot_Size * (1 + FLOOR(p_consol_item_repl_tbl(i).final_replenishment_qty / l_Repl_Lot_Size));
3670: END IF;
3671: END IF; -- for p_repl_lot_size IS NOT NULL
3672:
3673: END IF; -- FOR inv_cache.set_item_rec
3674:
3675: ELSE -- menas final_replenishment_qty <= 0
3676: -- Mark negative qty to avoid further considerations and creating MO
3677: p_consol_item_repl_tbl(i).final_replenishment_qty := -9999;

Line 3734: IF inv_cache.set_item_rec(p_consol_item_repl_tbl(i).ORGANIZATION_ID, p_consol_item_repl_tbl(i).item_id) THEN

3730: l_trolin_tbl(l_order_count).db_flag := FND_API.G_TRUE;
3731: l_trolin_tbl(l_order_count).operation := INV_GLOBALS.G_OPR_CREATE;
3732:
3733: --Begin 12396907
3734: IF inv_cache.set_item_rec(p_consol_item_repl_tbl(i).ORGANIZATION_ID, p_consol_item_repl_tbl(i).item_id) THEN
3735:
3736: IF (inv_cache.item_rec.tracking_quantity_ind = 'PS') THEN
3737: l_trolin_tbl(l_order_count).secondary_uom := inv_cache.item_rec.secondary_uom_code;--12396907
3738: l_trolin_tbl(l_order_count).secondary_quantity := ROUND(

Line 3736: IF (inv_cache.item_rec.tracking_quantity_ind = 'PS') THEN

3732:
3733: --Begin 12396907
3734: IF inv_cache.set_item_rec(p_consol_item_repl_tbl(i).ORGANIZATION_ID, p_consol_item_repl_tbl(i).item_id) THEN
3735:
3736: IF (inv_cache.item_rec.tracking_quantity_ind = 'PS') THEN
3737: l_trolin_tbl(l_order_count).secondary_uom := inv_cache.item_rec.secondary_uom_code;--12396907
3738: l_trolin_tbl(l_order_count).secondary_quantity := ROUND(
3739: (p_consol_item_repl_tbl(i).final_replenishment_qty * get_conversion_rate(p_consol_item_repl_tbl(i).Item_id,
3740: p_consol_item_repl_tbl(i).repl_uom_code,

Line 3737: l_trolin_tbl(l_order_count).secondary_uom := inv_cache.item_rec.secondary_uom_code;--12396907

3733: --Begin 12396907
3734: IF inv_cache.set_item_rec(p_consol_item_repl_tbl(i).ORGANIZATION_ID, p_consol_item_repl_tbl(i).item_id) THEN
3735:
3736: IF (inv_cache.item_rec.tracking_quantity_ind = 'PS') THEN
3737: l_trolin_tbl(l_order_count).secondary_uom := inv_cache.item_rec.secondary_uom_code;--12396907
3738: l_trolin_tbl(l_order_count).secondary_quantity := ROUND(
3739: (p_consol_item_repl_tbl(i).final_replenishment_qty * get_conversion_rate(p_consol_item_repl_tbl(i).Item_id,
3740: p_consol_item_repl_tbl(i).repl_uom_code,
3741: inv_cache.item_rec.secondary_uom_code)),

Line 3741: inv_cache.item_rec.secondary_uom_code)),

3737: l_trolin_tbl(l_order_count).secondary_uom := inv_cache.item_rec.secondary_uom_code;--12396907
3738: l_trolin_tbl(l_order_count).secondary_quantity := ROUND(
3739: (p_consol_item_repl_tbl(i).final_replenishment_qty * get_conversion_rate(p_consol_item_repl_tbl(i).Item_id,
3740: p_consol_item_repl_tbl(i).repl_uom_code,
3741: inv_cache.item_rec.secondary_uom_code)),
3742: g_conversion_precision);--12396907
3743:
3744: END IF;
3745: END IF;

Line 4063: IF inv_cache.set_item_rec(p_consol_item_repl_tbl(i).ORGANIZATION_ID, p_consol_item_repl_tbl(i).item_id) THEN

4059:
4060: -----------------------
4061: -- this is within the loop for each item
4062:
4063: IF inv_cache.set_item_rec(p_consol_item_repl_tbl(i).ORGANIZATION_ID, p_consol_item_repl_tbl(i).item_id) THEN
4064: l_txn_prim_qty :=
4065: ROUND((p_consol_item_repl_tbl(i).final_replenishment_qty * get_conversion_rate(p_consol_item_repl_tbl(i).Item_id,
4066: p_consol_item_repl_tbl(i).repl_uom_code,
4067: inv_cache.item_rec.primary_uom_code)),

Line 4067: inv_cache.item_rec.primary_uom_code)),

4063: IF inv_cache.set_item_rec(p_consol_item_repl_tbl(i).ORGANIZATION_ID, p_consol_item_repl_tbl(i).item_id) THEN
4064: l_txn_prim_qty :=
4065: ROUND((p_consol_item_repl_tbl(i).final_replenishment_qty * get_conversion_rate(p_consol_item_repl_tbl(i).Item_id,
4066: p_consol_item_repl_tbl(i).repl_uom_code,
4067: inv_cache.item_rec.primary_uom_code)),
4068: g_conversion_precision);
4069:
4070:
4071: INSERT INTO wms_replenishment_details

Line 4106: inv_cache.item_rec.primary_uom_code, -- Primary_UOM,

4102: demand_line_id,
4103: demand_line_detail_id, -- stored as -9999 for next level
4104: demand_type_id, -- stored as 4 for next level
4105: p_consol_item_repl_tbl(i).item_id, -- Inventory_item_id,
4106: inv_cache.item_rec.primary_uom_code, -- Primary_UOM,
4107: l_txn_prim_qty, -- Primary_Quantity,
4108: repl_sequence_id , --demand_sort_order,
4109: repl_level,
4110: repl_type,

Line 4235: print_debug('Primary UOM code :'||inv_cache.item_rec.primary_uom_code);

4231:
4232: IF (l_debug = 1) THEN
4233: print_debug('primary l_quantity detailed is :'|| l_prim_quantity_detailed);
4234: print_debug('l_num_detail_recs is :'|| l_num_detail_recs);
4235: print_debug('Primary UOM code :'||inv_cache.item_rec.primary_uom_code);
4236: END IF;
4237:
4238: --Convert the MOL detailed qty into MOL UOM code qty
4239: IF inv_cache.item_rec.primary_uom_code <> p_consol_item_repl_tbl(i).repl_uom_code THEN

Line 4239: IF inv_cache.item_rec.primary_uom_code <> p_consol_item_repl_tbl(i).repl_uom_code THEN

4235: print_debug('Primary UOM code :'||inv_cache.item_rec.primary_uom_code);
4236: END IF;
4237:
4238: --Convert the MOL detailed qty into MOL UOM code qty
4239: IF inv_cache.item_rec.primary_uom_code <> p_consol_item_repl_tbl(i).repl_uom_code THEN
4240:
4241: l_quantity_detailed :=
4242: ROUND((l_prim_quantity_detailed* get_conversion_rate(p_consol_item_repl_tbl(i).item_id,
4243: inv_cache.item_rec.primary_uom_code,

Line 4243: inv_cache.item_rec.primary_uom_code,

4239: IF inv_cache.item_rec.primary_uom_code <> p_consol_item_repl_tbl(i).repl_uom_code THEN
4240:
4241: l_quantity_detailed :=
4242: ROUND((l_prim_quantity_detailed* get_conversion_rate(p_consol_item_repl_tbl(i).item_id,
4243: inv_cache.item_rec.primary_uom_code,
4244: p_consol_item_repl_tbl(i).Repl_UOM_Code )),
4245: g_conversion_precision);
4246:
4247: ELSE

Line 5167: IF inv_cache.set_item_rec(x_consol_item_repl_tbl(i).ORGANIZATION_ID, x_consol_item_repl_tbl(i).item_id) THEN

5163: l_prev_sub_code <> x_consol_item_repl_tbl(i).repl_to_subinventory_code ) THEN
5164:
5165: l_atr := 0;
5166: -- Get all item details
5167: IF inv_cache.set_item_rec(x_consol_item_repl_tbl(i).ORGANIZATION_ID, x_consol_item_repl_tbl(i).item_id) THEN
5168:
5169: IF (l_debug = 1) THEN
5170: print_debug('Getting Item Attribute Details' );
5171: END IF;

Line 5173: IF inv_cache.item_rec.revision_qty_control_code = 2 THEN

5169: IF (l_debug = 1) THEN
5170: print_debug('Getting Item Attribute Details' );
5171: END IF;
5172:
5173: IF inv_cache.item_rec.revision_qty_control_code = 2 THEN
5174: l_is_revision_ctrl := TRUE;
5175: ELSE
5176: l_is_revision_ctrl := FALSE;
5177: END IF;

Line 5179: IF inv_cache.item_rec.lot_control_code = 2 THEN

5175: ELSE
5176: l_is_revision_ctrl := FALSE;
5177: END IF;
5178:
5179: IF inv_cache.item_rec.lot_control_code = 2 THEN
5180: l_is_lot_ctrl := TRUE;
5181: ELSE
5182: l_is_lot_ctrl := FALSE;
5183: END IF;

Line 5185: IF inv_cache.item_rec.serial_number_control_code NOT IN (1,6) THEN

5181: ELSE
5182: l_is_lot_ctrl := FALSE;
5183: END IF;
5184:
5185: IF inv_cache.item_rec.serial_number_control_code NOT IN (1,6) THEN
5186: l_is_serial_ctrl := FALSE;
5187: ELSE
5188: l_is_serial_ctrl := TRUE;
5189: END IF;

Line 5197: END IF; -- for inv_cache.set_item_rec

5193: print_debug('Error: Item detail not found');
5194: END IF;
5195: l_return_status := fnd_api.g_ret_sts_error;
5196: GOTO next_onhd_consol_rec;
5197: END IF; -- for inv_cache.set_item_rec
5198:
5199:
5200: IF (l_debug = 1) THEN
5201: print_debug('Clearing Qty Tree' );

Line 7251: IF inv_cache.set_item_rec(l_open_repl_mo.organization_id, l_open_repl_mo.inventory_item_id) THEN

7247: -- Scan each locator in the sub for capacity
7248: L_CUR_SUB_HAS_CAPACITY := FALSE;
7249:
7250: -- Setting Item information in the Cache
7251: IF inv_cache.set_item_rec(l_open_repl_mo.organization_id, l_open_repl_mo.inventory_item_id) THEN
7252: NULL;
7253: IF (l_debug = 1) THEN
7254: print_debug('Primary UOM for the Item:' ||inv_cache.item_rec.primary_uom_code);
7255: END IF;

Line 7254: print_debug('Primary UOM for the Item:' ||inv_cache.item_rec.primary_uom_code);

7250: -- Setting Item information in the Cache
7251: IF inv_cache.set_item_rec(l_open_repl_mo.organization_id, l_open_repl_mo.inventory_item_id) THEN
7252: NULL;
7253: IF (l_debug = 1) THEN
7254: print_debug('Primary UOM for the Item:' ||inv_cache.item_rec.primary_uom_code);
7255: END IF;
7256: END IF;
7257:
7258: OPEN c_locators_in_sub(l_open_repl_mo.organization_id, l_open_repl_mo.TO_SUBINVENTORY_CODE);

Line 7321: , p_unit_volume => inv_cache.item_rec.unit_volume

7317: , p_organization_id => l_open_repl_mo.organization_id
7318: , p_subinventory_code => l_open_repl_mo.TO_SUBINVENTORY_CODE
7319: , p_locator_id => l_loc_id
7320: , p_inventory_item_id => l_open_repl_mo.inventory_item_id
7321: , p_unit_volume => inv_cache.item_rec.unit_volume
7322: , p_unit_volume_uom_code =>inv_cache.item_rec.volume_uom_code
7323: , p_unit_weight =>inv_cache.item_rec.unit_weight
7324: , p_unit_weight_uom_code =>inv_cache.item_rec.weight_uom_code
7325: , p_primary_uom =>inv_cache.item_rec.primary_uom_code

Line 7322: , p_unit_volume_uom_code =>inv_cache.item_rec.volume_uom_code

7318: , p_subinventory_code => l_open_repl_mo.TO_SUBINVENTORY_CODE
7319: , p_locator_id => l_loc_id
7320: , p_inventory_item_id => l_open_repl_mo.inventory_item_id
7321: , p_unit_volume => inv_cache.item_rec.unit_volume
7322: , p_unit_volume_uom_code =>inv_cache.item_rec.volume_uom_code
7323: , p_unit_weight =>inv_cache.item_rec.unit_weight
7324: , p_unit_weight_uom_code =>inv_cache.item_rec.weight_uom_code
7325: , p_primary_uom =>inv_cache.item_rec.primary_uom_code
7326: , p_transaction_uom => l_open_repl_mo.uom_code

Line 7323: , p_unit_weight =>inv_cache.item_rec.unit_weight

7319: , p_locator_id => l_loc_id
7320: , p_inventory_item_id => l_open_repl_mo.inventory_item_id
7321: , p_unit_volume => inv_cache.item_rec.unit_volume
7322: , p_unit_volume_uom_code =>inv_cache.item_rec.volume_uom_code
7323: , p_unit_weight =>inv_cache.item_rec.unit_weight
7324: , p_unit_weight_uom_code =>inv_cache.item_rec.weight_uom_code
7325: , p_primary_uom =>inv_cache.item_rec.primary_uom_code
7326: , p_transaction_uom => l_open_repl_mo.uom_code
7327: , p_base_uom => l_base_uom_code

Line 7324: , p_unit_weight_uom_code =>inv_cache.item_rec.weight_uom_code

7320: , p_inventory_item_id => l_open_repl_mo.inventory_item_id
7321: , p_unit_volume => inv_cache.item_rec.unit_volume
7322: , p_unit_volume_uom_code =>inv_cache.item_rec.volume_uom_code
7323: , p_unit_weight =>inv_cache.item_rec.unit_weight
7324: , p_unit_weight_uom_code =>inv_cache.item_rec.weight_uom_code
7325: , p_primary_uom =>inv_cache.item_rec.primary_uom_code
7326: , p_transaction_uom => l_open_repl_mo.uom_code
7327: , p_base_uom => l_base_uom_code
7328: , p_transaction_quantity => (l_open_repl_mo.mol_qty - l_open_repl_mo.mol_detailed_qty - l_open_repl_mo.mol_delivered_qty));

Line 7325: , p_primary_uom =>inv_cache.item_rec.primary_uom_code

7321: , p_unit_volume => inv_cache.item_rec.unit_volume
7322: , p_unit_volume_uom_code =>inv_cache.item_rec.volume_uom_code
7323: , p_unit_weight =>inv_cache.item_rec.unit_weight
7324: , p_unit_weight_uom_code =>inv_cache.item_rec.weight_uom_code
7325: , p_primary_uom =>inv_cache.item_rec.primary_uom_code
7326: , p_transaction_uom => l_open_repl_mo.uom_code
7327: , p_base_uom => l_base_uom_code
7328: , p_transaction_quantity => (l_open_repl_mo.mol_qty - l_open_repl_mo.mol_detailed_qty - l_open_repl_mo.mol_delivered_qty));
7329:

Line 7386: inv_cache.item_rec.primary_uom_code),

7382: END IF;
7383:
7384: L_UNIT_CONV_QTY := ROUND(1* get_conversion_rate(l_open_repl_mo.inventory_item_id,
7385: l_pick_uom_code,
7386: inv_cache.item_rec.primary_uom_code),
7387: g_conversion_precision);
7388:
7389: IF (l_debug = 1) THEN
7390: print_debug(' L_UNIT_CONV_QTY:' ||L_UNIT_CONV_QTY);

Line 7515: IF inv_cache.item_rec.primary_uom_code <> l_open_repl_mo.uom_code THEN

7511: END;
7512:
7513:
7514: --Convert the MOL detailed qty into MOL UOM code qty
7515: IF inv_cache.item_rec.primary_uom_code <> l_open_repl_mo.uom_code THEN
7516:
7517: l_quantity_detailed :=
7518: ROUND((l_prim_quantity_detailed* get_conversion_rate(l_open_repl_mo.inventory_item_id,
7519: inv_cache.item_rec.primary_uom_code,

Line 7519: inv_cache.item_rec.primary_uom_code,

7515: IF inv_cache.item_rec.primary_uom_code <> l_open_repl_mo.uom_code THEN
7516:
7517: l_quantity_detailed :=
7518: ROUND((l_prim_quantity_detailed* get_conversion_rate(l_open_repl_mo.inventory_item_id,
7519: inv_cache.item_rec.primary_uom_code,
7520: l_open_repl_mo.UOM_Code )),
7521: g_conversion_precision);
7522:
7523: ELSE