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_DETAIL_UTIL_PVT dependencies on WMS_ENGINE_PVT

Line 896: IF (NVL(wms_engine_pvt.g_fulfillment_base,'P') = 'P' AND l_reserved_qty <= 0)

892:
893: print_debug('in comupte detail , res qty '||l_reserved_qty);
894: print_debug('in comupte detail , res sec qty '||l_sec_reserved_qty);
895:
896: IF (NVL(wms_engine_pvt.g_fulfillment_base,'P') = 'P' AND l_reserved_qty <= 0)
897: OR (NVL(wms_engine_pvt.g_fulfillment_base,'P') = 'S' AND l_sec_reserved_qty <= 0)
898: THEN
899: GOTO next_rsv;
900: END IF;

Line 897: OR (NVL(wms_engine_pvt.g_fulfillment_base,'P') = 'S' AND l_sec_reserved_qty <= 0)

893: print_debug('in comupte detail , res qty '||l_reserved_qty);
894: print_debug('in comupte detail , res sec qty '||l_sec_reserved_qty);
895:
896: IF (NVL(wms_engine_pvt.g_fulfillment_base,'P') = 'P' AND l_reserved_qty <= 0)
897: OR (NVL(wms_engine_pvt.g_fulfillment_base,'P') = 'S' AND l_sec_reserved_qty <= 0)
898: THEN
899: GOTO next_rsv;
900: END IF;
901:

Line 902: IF (NVL(wms_engine_pvt.g_fulfillment_base,'P') = 'P' AND l_reserved_qty > l_remain_pri_qty)

898: THEN
899: GOTO next_rsv;
900: END IF;
901:
902: IF (NVL(wms_engine_pvt.g_fulfillment_base,'P') = 'P' AND l_reserved_qty > l_remain_pri_qty)
903: OR (NVL(wms_engine_pvt.g_fulfillment_base,'P') = 'S' AND l_sec_reserved_qty > l_remain_sec_qty)
904: THEN
905: l_pp_temp_qty := l_remain_pri_qty;
906: l_sec_pp_temp_qty := l_remain_sec_qty;

Line 903: OR (NVL(wms_engine_pvt.g_fulfillment_base,'P') = 'S' AND l_sec_reserved_qty > l_remain_sec_qty)

899: GOTO next_rsv;
900: END IF;
901:
902: IF (NVL(wms_engine_pvt.g_fulfillment_base,'P') = 'P' AND l_reserved_qty > l_remain_pri_qty)
903: OR (NVL(wms_engine_pvt.g_fulfillment_base,'P') = 'S' AND l_sec_reserved_qty > l_remain_sec_qty)
904: THEN
905: l_pp_temp_qty := l_remain_pri_qty;
906: l_sec_pp_temp_qty := l_remain_sec_qty;
907: l_remain_pri_qty := 0;

Line 995: IF NVL(wms_engine_pvt.g_fulfillment_base,'P') = 'S' THEN

991: x_detail_level_tbl(l_index).transaction_quantity := l_pp_temp_qty;
992: ELSIF p_request_context.transaction_uom_code = p_request_context.secondary_uom_code THEN
993: x_detail_level_tbl(l_index).transaction_quantity := l_sec_pp_temp_qty;
994: ELSE
995: IF NVL(wms_engine_pvt.g_fulfillment_base,'P') = 'S' THEN
996: x_detail_level_tbl(l_index).transaction_quantity :=
997: inv_convert.inv_um_convert(
998: item_id => p_request_line_rec.inventory_item_id
999: , lot_number => x_detail_level_tbl(l_index).lot_number

Line 1024: IF (NVL(wms_engine_pvt.g_fulfillment_base,'P') = 'P' AND l_remain_pri_qty = 0)

1020: );
1021: END IF;
1022: END IF;
1023:
1024: IF (NVL(wms_engine_pvt.g_fulfillment_base,'P') = 'P' AND l_remain_pri_qty = 0)
1025: OR (NVL(wms_engine_pvt.g_fulfillment_base,'P') = 'S' AND l_remain_sec_qty = 0)
1026: THEN
1027: EXIT;
1028: END IF;

Line 1025: OR (NVL(wms_engine_pvt.g_fulfillment_base,'P') = 'S' AND l_remain_sec_qty = 0)

1021: END IF;
1022: END IF;
1023:
1024: IF (NVL(wms_engine_pvt.g_fulfillment_base,'P') = 'P' AND l_remain_pri_qty = 0)
1025: OR (NVL(wms_engine_pvt.g_fulfillment_base,'P') = 'S' AND l_remain_sec_qty = 0)
1026: THEN
1027: EXIT;
1028: END IF;
1029: <>

Line 1038: IF ( (NVL(wms_engine_pvt.g_fulfillment_base,'P') = 'P' AND l_remain_pri_qty > 0)

1034: -- if reservation quantity is less than request quantity for detailing;
1035: -- Bug 1851999 - For staging transfers, we should only allocate
1036: -- the quantity that has been reserved. We need this check to handle
1037: -- WIP reservations for sales orders.
1038: IF ( (NVL(wms_engine_pvt.g_fulfillment_base,'P') = 'P' AND l_remain_pri_qty > 0)
1039: OR (NVL(wms_engine_pvt.g_fulfillment_base,'P') = 'S' AND l_remain_sec_qty > 0)
1040: )
1041: AND NOT
1042: (p_request_context.transaction_action_id = 28 AND p_reservations.COUNT > 0)

Line 1039: OR (NVL(wms_engine_pvt.g_fulfillment_base,'P') = 'S' AND l_remain_sec_qty > 0)

1035: -- Bug 1851999 - For staging transfers, we should only allocate
1036: -- the quantity that has been reserved. We need this check to handle
1037: -- WIP reservations for sales orders.
1038: IF ( (NVL(wms_engine_pvt.g_fulfillment_base,'P') = 'P' AND l_remain_pri_qty > 0)
1039: OR (NVL(wms_engine_pvt.g_fulfillment_base,'P') = 'S' AND l_remain_sec_qty > 0)
1040: )
1041: AND NOT
1042: (p_request_context.transaction_action_id = 28 AND p_reservations.COUNT > 0)
1043: THEN --{

Line 1055: IF NVL(wms_engine_pvt.g_fulfillment_base,'P') = 'S' THEN

1051: x_detail_level_tbl(l_index).transaction_quantity := l_remain_pri_qty;
1052: ELSIF p_request_context.transaction_uom_code = p_request_context.secondary_uom_code THEN
1053: x_detail_level_tbl(l_index).transaction_quantity := l_remain_sec_qty;
1054: ELSE
1055: IF NVL(wms_engine_pvt.g_fulfillment_base,'P') = 'S' THEN
1056: x_detail_level_tbl(l_index).transaction_quantity :=
1057: inv_convert.inv_um_convert(
1058: item_id => p_request_line_rec.inventory_item_id
1059: , lot_number => p_request_line_rec.lot_number

Line 3559: IF((NVL(wms_engine_pvt.g_fulfillment_base,'P') = 'S')) THEN

3555: ELSE
3556: -- Start 8498798: When the suggested qty is in decimals according to Txn Uom then convert the
3557: -- Uom to Primary Uom so that the qty is a integer.
3558:
3559: IF((NVL(wms_engine_pvt.g_fulfillment_base,'P') = 'S')) THEN
3560: l_lot_temp_qty_txn_uom := inv_convert.inv_um_convert
3561: (
3562: p_request_line_rec.inventory_item_id,
3563: NULL,

Line 3706: IF ((NVL(wms_engine_pvt.g_fulfillment_base,'P') = 'S')) THEN

3702: print_debug('process output before mmtt update, pri UOM:'||p_request_context.primary_uom_code||',txn uom:'||
3703: p_request_context.transaction_uom_code);
3704: --Start 8498798
3705:
3706: IF ((NVL(wms_engine_pvt.g_fulfillment_base,'P') = 'S')) THEN
3707: l_txn_temp_qty_txn_uom := inv_convert.inv_um_convert
3708: (
3709: p_request_line_rec.inventory_item_id,
3710: NULL,

Line 3778: IF ((NVL(wms_engine_pvt.g_fulfillment_base,'P') = 'S')) THEN

3774:
3775: END IF;
3776: END IF; --10067944 Ends
3777:
3778: IF ((NVL(wms_engine_pvt.g_fulfillment_base,'P') = 'S')) THEN
3779: l_mmtt_tbl(l_mmtt_tbl_size).fulfillment_base := 'S';
3780: ELSE
3781: l_mmtt_tbl(l_mmtt_tbl_size).fulfillment_base := 'P';
3782: END IF;

Line 3783: print_debug('process output before mmtt update , wms_engine_pvt.g_fulfillment_base value is '|| wms_engine_pvt.g_fulfillment_base);

3779: l_mmtt_tbl(l_mmtt_tbl_size).fulfillment_base := 'S';
3780: ELSE
3781: l_mmtt_tbl(l_mmtt_tbl_size).fulfillment_base := 'P';
3782: END IF;
3783: print_debug('process output before mmtt update , wms_engine_pvt.g_fulfillment_base value is '|| wms_engine_pvt.g_fulfillment_base);
3784: print_debug('process output before mmtt update , fulfillment_base value is '|| l_mmtt_tbl(l_mmtt_tbl_size).fulfillment_base);
3785:
3786: /* jxlu bug 1544670: need to populate column item_primary_uom_code */
3787: l_mmtt_tbl(l_mmtt_tbl_size).item_primary_uom_code := p_request_context.primary_uom_code;