DBA Data[Home] [Help]

APPS.WMS_DIRECT_SHIP_PVT dependencies on INV_CONVERT

Line 5158: ,GREATEST(INV_CONVERT.INV_UM_CONVERT(

5154: ,WDS.TRANSACTION_TEMP_ID
5155: ,WDD.DELIVERY_DETAIL_ID
5156: ,DECODE(WDD.REQUESTED_QUANTITY_UOM,MSI.PRIMARY_UOM_CODE
5157: ,WDD.REQUESTED_QUANTITY
5158: ,GREATEST(INV_CONVERT.INV_UM_CONVERT(
5159: null
5160: ,null
5161: ,WDD.REQUESTED_QUANTITY
5162: ,WDD.REQUESTED_QUANTITY_UOM

Line 5637: ' inv_convert.inv_um_convert(NULL, ' ||

5633: ' , DECODE( ' ||
5634: ' wdd.requested_quantity_uom ' ||
5635: ' , msi.primary_uom_code, wdd.requested_quantity ' ||
5636: ' , GREATEST( ' ||
5637: ' inv_convert.inv_um_convert(NULL, ' ||
5638: ' NULL, wdd.requested_quantity, wdd.requested_quantity_uom, ' ||
5639: ' msi.primary_uom_code, NULL , NULL) ' ||
5640: ' , 0 )) requested_quantity ' ||
5641: ' , msi.primary_uom_code ' ||

Line 6183: l_shipping_attr(1).picked_quantity2 := inv_convert.inv_um_convert (

6179: IF NVL(l_shipping_attr(1).picked_quantity2, fnd_api.g_miss_num) = fnd_api.g_miss_num THEN
6180: IF (l_debug = 1) THEN
6181: DEBUG('Dual UoM items but no entry in WMS_DS_CT_WT_GTEMP so use uom_convert to get picked_quantity2', 'stage_lpns');
6182: END IF;
6183: l_shipping_attr(1).picked_quantity2 := inv_convert.inv_um_convert (
6184: item_id => l_shipping_attr(1).inventory_item_id,
6185: lot_number => l_shipping_attr(1).lot_number,
6186: organization_id => l_shipping_attr(1).ship_from_org_id,
6187: precision => NULL,

Line 6280: l_delivery_detail_tab(i).requested_quantity2 - inv_convert.inv_um_convert (

6276: IF l_dual_uom_item THEN
6277: l_shipping_attr(1).pending_quantity2 :=
6278: -- l_delivery_detail_tab(i).requested_quantity2 - l_rsv_sec_qty; Commented for bug 14576405
6279: --Added for bug 14576405 start
6280: l_delivery_detail_tab(i).requested_quantity2 - inv_convert.inv_um_convert (
6281: item_id => l_mtl_reservation_tbl(j).inventory_item_id ,
6282: precision => null,
6283: from_quantity => l_mtl_reservation_tbl(j).primary_reservation_quantity,
6284: from_unit => l_mtl_reservation_tbl(j).PRIMARY_UOM_CODE,

Line 6587: l_shipping_attr(1).picked_quantity2 := inv_convert.inv_um_convert (

6583: IF NVL(l_shipping_attr(1).picked_quantity2, fnd_api.g_miss_num) = fnd_api.g_miss_num THEN
6584: IF (l_debug = 1) THEN
6585: DEBUG('Dual UoM items but no entry in WMS_DS_CT_WT_GTEMP so use uom_convert to get picked_quantity2', 'stage_lpns');
6586: END IF;
6587: l_shipping_attr(1).picked_quantity2 := inv_convert.inv_um_convert (
6588: item_id => l_shipping_attr(1).inventory_item_id,
6589: lot_number => l_shipping_attr(1).lot_number,
6590: organization_id => l_shipping_attr(1).ship_from_org_id,
6591: precision => NULL,

Line 7008: l_delivery_detail_tab(i).requested_quantity - inv_convert.inv_um_convert (

7004: IF l_delivery_detail_tab(i).requested_quantity2 - l_rsv_sec_qty > 0
7005: THEN
7006: l_shipping_attr(1).action_flag := 'M';
7007: l_shipping_attr(1).pending_quantity :=
7008: l_delivery_detail_tab(i).requested_quantity - inv_convert.inv_um_convert (
7009: item_id => l_mtl_reservation_tbl(j).inventory_item_id ,
7010: precision => null,
7011: from_quantity => l_mtl_reservation_tbl(j).secondary_reservation_quantity,
7012: from_unit => l_mtl_reservation_tbl(j).SECONDARY_UOM_CODE,

Line 9926: inv_convert.inv_um_convert(oel.inventory_item_id, NULL,

9922: , DECODE(
9923: oel.order_quantity_uom
9924: , msi.primary_uom_code, oel.ordered_quantity
9925: , GREATEST(
9926: inv_convert.inv_um_convert(oel.inventory_item_id, NULL,
9927: msi.organization_id, 5,
9928: oel.ordered_quantity, oel.order_quantity_uom, msi.primary_uom_code, NULL
9929: , NULL), 0)
9930: ) ordered_quantity

Line 10202: inv_convert.inv_um_convert(

10198: THEN
10199: l_new_upd_resv_rec.reservation_quantity := l_mtl_reservation_tab(resv_index).secondary_reservation_quantity;
10200: ELSE
10201: l_new_upd_resv_rec.reservation_quantity :=
10202: inv_convert.inv_um_convert(
10203: item_id => l_mtl_reservation_tab(resv_index).inventory_item_id
10204: , lot_number => l_mtl_reservation_tab(resv_index).lot_number
10205: , organization_id => l_mtl_reservation_tab(resv_index).organization_id
10206: , precision => NULL

Line 10265: inv_convert.inv_um_convert(

10261: ELSIF l_mtl_reservation_tab(resv_index).reservation_uom_code = l_mtl_reservation_tab(resv_index).primary_uom_code THEN
10262: l_new_upd_resv_rec.reservation_quantity := l_mtl_reservation_tab(resv_index).primary_reservation_quantity ;
10263: ELSE
10264: l_new_upd_resv_rec.reservation_quantity :=
10265: inv_convert.inv_um_convert(
10266: item_id => l_mtl_reservation_tab(resv_index).inventory_item_id
10267: , lot_number => l_mtl_reservation_tab(resv_index).lot_number
10268: , organization_id => l_mtl_reservation_tab(resv_index).organization_id
10269: , precision => NULL

Line 11296: inv_convert.inv_um_convert(

11292: l_new_resv_rec.reservation_quantity := l_new_resv_rec.secondary_reservation_quantity;
11293: ELSE
11294: IF g_fulfillment_base = 'S' THEN
11295: l_new_resv_rec.reservation_quantity :=
11296: inv_convert.inv_um_convert(
11297: item_id => p_inventory_item_id
11298: , lot_number => l_resv_rec.lot_number
11299: , organization_id => p_org_id
11300: , precision => NULL

Line 11308: inv_convert.inv_um_convert(

11304: , from_name => NULL
11305: , to_name => NULL);
11306: ELSE
11307: l_new_resv_rec.reservation_quantity :=
11308: inv_convert.inv_um_convert(
11309: item_id => p_inventory_item_id
11310: , lot_number => l_lpn_cont_rec.lot_number
11311: , organization_id => p_org_id
11312: , precision => NULL

Line 11641: inv_convert.inv_um_convert(

11637: l_reservation_record.primary_reservation_quantity :=
11638: LEAST(l_transactable_qty, l_quantity_create_resv); --Bug#5262108
11639: IF l_lot_conv_exists THEN
11640: l_reservation_record.secondary_reservation_quantity :=
11641: inv_convert.inv_um_convert(
11642: item_id => p_inventory_item_id
11643: , lot_number => l_lpn_cont_rec.lot_number
11644: , organization_id => p_org_id
11645: , precision => NULL

Line 12963: inv_convert.inv_um_convert(

12959: l_upd_resv_rec.reservation_quantity := l_sec_qty_updt_resv;
12960: ELSE
12961: IF g_fulfillment_base = 'S' THEN
12962: l_upd_resv_rec.reservation_quantity :=
12963: inv_convert.inv_um_convert(
12964: item_id => l_lpn_cont_rec.inventory_item_id
12965: , lot_number => l_lpn_cont_rec.lot_number
12966: , organization_id => p_org_id
12967: , precision => NULL

Line 12975: inv_convert.inv_um_convert(

12971: , from_name => NULL
12972: , to_name => NULL);
12973: ELSE
12974: l_upd_resv_rec.reservation_quantity :=
12975: inv_convert.inv_um_convert(
12976: item_id => l_lpn_cont_rec.inventory_item_id
12977: , lot_number => l_lpn_cont_rec.lot_number
12978: , organization_id => p_org_id
12979: , precision => NULL

Line 13885: ,GREATEST(inv_convert.inv_um_convert(NULL, NULL,

13881: ,t.INVENTORY_ITEM_ID
13882: ,t.REVISION
13883: ,t.LOT_NUMBER
13884: ,DECODE(t.PICKED_UOM_CODE, msi.primary_uom_code, t.PICKED_QUANTITY
13885: ,GREATEST(inv_convert.inv_um_convert(NULL, NULL,
13886: t.PICKED_QUANTITY, t.PICKED_UOM_CODE, msi.primary_uom_code,
13887: NULL, NULL), 0)) PICKED_QUANTITY_IN_PRI_UOM
13888: ,t.SECONDARY_UOM_CODE
13889: ,t.SECONDARY_QUANTITY