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_CATCH_WEIGHT_PVT dependencies on DUAL

Line 94: dual_uom_deviation_high,

90: SELECT NVL(tracking_quantity_ind, G_TRACK_PRIMARY),
91: NVL(ont_pricing_qty_source, G_PRICE_PRIMARY),
92: secondary_default_ind,
93: secondary_uom_code,
94: dual_uom_deviation_high,
95: dual_uom_deviation_low
96: INTO x_tracking_quantity_ind,
97: x_ont_pricing_qty_source,
98: x_secondary_default_ind,

Line 95: dual_uom_deviation_low

91: NVL(ont_pricing_qty_source, G_PRICE_PRIMARY),
92: secondary_default_ind,
93: secondary_uom_code,
94: dual_uom_deviation_high,
95: dual_uom_deviation_low
96: INTO x_tracking_quantity_ind,
97: x_ont_pricing_qty_source,
98: x_secondary_default_ind,
99: x_secondary_uom_code,

Line 1071: FROM dual;

1067: SAVEPOINT process_ctwt_sp;
1068:
1069: SELECT mtl_material_transactions_s.NEXTVAL
1070: INTO l_txn_temp_id
1071: FROM dual;
1072:
1073: SELECT mtl_material_transactions_s.NEXTVAL
1074: INTO l_txn_hdr_id
1075: FROM dual;

Line 1075: FROM dual;

1071: FROM dual;
1072:
1073: SELECT mtl_material_transactions_s.NEXTVAL
1074: INTO l_txn_hdr_id
1075: FROM dual;
1076:
1077: IF p_lpn_id IS NOT NULL THEN
1078: SELECT lpn_context
1079: INTO l_orig_lpn_ctx

Line 1314: , p_max_pri_residual IN NUMBER

1310: , p_quantity IN NUMBER
1311: , p_uom_code IN VARCHAR2
1312: , p_secondary_quantity IN NUMBER
1313: , p_secondary_uom_code IN VARCHAR2
1314: , p_max_pri_residual IN NUMBER
1315: , p_ccnt_sec_residual IN VARCHAR2
1316: ) IS
1317:
1318: l_api_name CONSTANT VARCHAR2(30) := 'update_lpn_primary_quantity';

Line 1315: , p_ccnt_sec_residual IN VARCHAR2

1311: , p_uom_code IN VARCHAR2
1312: , p_secondary_quantity IN NUMBER
1313: , p_secondary_uom_code IN VARCHAR2
1314: , p_max_pri_residual IN NUMBER
1315: , p_ccnt_sec_residual IN VARCHAR2
1316: ) IS
1317:
1318: l_api_name CONSTANT VARCHAR2(30) := 'update_lpn_primary_quantity';
1319: l_api_version CONSTANT NUMBER := 1.0;

Line 1548: l_max_pri_residual NUMBER;

1544: l_pr_uom_code VARCHAR2(3);
1545: l_lot_control_code NUMBER := 1;
1546: l_lot_divisible_flag VARCHAR2(1) := 'Y';
1547:
1548: l_max_pri_residual NUMBER;
1549: l_primary_qty NUMBER;
1550: l_lpn_pri_qty NUMBER;
1551: l_lpn_sec_qty NUMBER;
1552: l_lpn_pck_qty NUMBER;

Line 1665: ', p_max_pri_residual=' || p_max_pri_residual ||

1661: ', p_quantity=' || p_quantity ||
1662: ', p_uom_code=' || p_uom_code ||
1663: ', p_secondary_quantity=' || p_secondary_quantity ||
1664: ', p_secondary_uom_code=' || p_secondary_uom_code ||
1665: ', p_max_pri_residual=' || p_max_pri_residual ||
1666: ', p_ccnt_sec_residual=' || p_ccnt_sec_residual
1667: , 4);
1668: END IF;
1669:

Line 1666: ', p_ccnt_sec_residual=' || p_ccnt_sec_residual

1662: ', p_uom_code=' || p_uom_code ||
1663: ', p_secondary_quantity=' || p_secondary_quantity ||
1664: ', p_secondary_uom_code=' || p_secondary_uom_code ||
1665: ', p_max_pri_residual=' || p_max_pri_residual ||
1666: ', p_ccnt_sec_residual=' || p_ccnt_sec_residual
1667: , 4);
1668: END IF;
1669:
1670: IF ROUND(NVL(p_max_pri_residual,0),5) > 0 THEN

Line 1670: IF ROUND(NVL(p_max_pri_residual,0),5) > 0 THEN

1666: ', p_ccnt_sec_residual=' || p_ccnt_sec_residual
1667: , 4);
1668: END IF;
1669:
1670: IF ROUND(NVL(p_max_pri_residual,0),5) > 0 THEN
1671: l_max_pri_residual := ROUND(p_max_pri_residual,5);
1672: ELSE
1673: l_max_pri_residual := 0;
1674: END IF;

Line 1671: l_max_pri_residual := ROUND(p_max_pri_residual,5);

1667: , 4);
1668: END IF;
1669:
1670: IF ROUND(NVL(p_max_pri_residual,0),5) > 0 THEN
1671: l_max_pri_residual := ROUND(p_max_pri_residual,5);
1672: ELSE
1673: l_max_pri_residual := 0;
1674: END IF;
1675:

Line 1673: l_max_pri_residual := 0;

1669:
1670: IF ROUND(NVL(p_max_pri_residual,0),5) > 0 THEN
1671: l_max_pri_residual := ROUND(p_max_pri_residual,5);
1672: ELSE
1673: l_max_pri_residual := 0;
1674: END IF;
1675:
1676: IF p_revision IS NOT NULL THEN
1677: l_rev_ctrl := TRUE;

Line 1736: print_debug('l_max_pri_residual: ' || l_max_pri_residual, 4);

1732: END IF;
1733: END IF;
1734:
1735: IF (l_debug = 1) THEN
1736: print_debug('l_max_pri_residual: ' || l_max_pri_residual, 4);
1737: print_debug('l_primary_qty: ' || l_primary_qty, 4);
1738: print_debug('l_pr_uom_code: ' || l_pr_uom_code, 4);
1739: END IF;
1740:

Line 2680: OR l_max_pri_residual > 0 OR NVL(p_ccnt_sec_residual,'N') = 'Y'

2676: print_debug('l_pri_qty_to_incr: ' || l_pri_qty_to_incr, 4);
2677: END IF;
2678:
2679: IF l_pri_qty_to_reduce > 0 OR l_pri_qty_to_incr > 0
2680: OR l_max_pri_residual > 0 OR NVL(p_ccnt_sec_residual,'N') = 'Y'
2681: THEN --{ qty adjustment or cycle count check required
2682: IF p_lot_number IS NOT NULL THEN
2683: OPEN c_lpn_mtlt;
2684: FETCH c_lpn_mtlt BULK COLLECT

Line 2909: IF l_max_pri_residual > 0 OR l_pri_qty_to_incr > 0

2905: NULL;
2906: END LOOP; --} end loop through rsv IDs
2907: END IF; --} end if qty to be reduced
2908:
2909: IF l_max_pri_residual > 0 OR l_pri_qty_to_incr > 0
2910: OR NVL(p_ccnt_sec_residual,'N') = 'Y'
2911: THEN
2912: --{ +ve adj or residual primary txns or cycle count check required
2913: IF (l_debug = 1) THEN

Line 2910: OR NVL(p_ccnt_sec_residual,'N') = 'Y'

2906: END LOOP; --} end loop through rsv IDs
2907: END IF; --} end if qty to be reduced
2908:
2909: IF l_max_pri_residual > 0 OR l_pri_qty_to_incr > 0
2910: OR NVL(p_ccnt_sec_residual,'N') = 'Y'
2911: THEN
2912: --{ +ve adj or residual primary txns or cycle count check required
2913: IF (l_debug = 1) THEN
2914: print_debug('Processing max residual/MMTT qty increase/cycle count', 4);

Line 2912: --{ +ve adj or residual primary txns or cycle count check required

2908:
2909: IF l_max_pri_residual > 0 OR l_pri_qty_to_incr > 0
2910: OR NVL(p_ccnt_sec_residual,'N') = 'Y'
2911: THEN
2912: --{ +ve adj or residual primary txns or cycle count check required
2913: IF (l_debug = 1) THEN
2914: print_debug('Processing max residual/MMTT qty increase/cycle count', 4);
2915: END IF;
2916: FOR j IN t_temp_id.FIRST..t_temp_id.LAST

Line 2914: print_debug('Processing max residual/MMTT qty increase/cycle count', 4);

2910: OR NVL(p_ccnt_sec_residual,'N') = 'Y'
2911: THEN
2912: --{ +ve adj or residual primary txns or cycle count check required
2913: IF (l_debug = 1) THEN
2914: print_debug('Processing max residual/MMTT qty increase/cycle count', 4);
2915: END IF;
2916: FOR j IN t_temp_id.FIRST..t_temp_id.LAST
2917: LOOP --{
2918: l_sku_pri_incr := 0;

Line 3092: IF l_max_pri_residual > 0 THEN --{

3088:
3089: END IF; --} end if l_sku_pri_incr > 0
3090: END IF; --} end if l_pri_qty_to_incr > 0
3091:
3092: IF l_max_pri_residual > 0 THEN --{
3093: --
3094: -- If the onhand secondary is being fully consumed, then check
3095: -- if there is a remaining primary qty left behind which is less
3096: -- than the threshold specified.

Line 3107: AND ((l_att - l_sku_pri_incr) <= l_max_pri_residual)

3103: -- as secondary, since the secondary onhand is already 0.
3104: --
3105: IF (l_sqoh = 0) AND (l_pri_increase = 0)
3106: AND ((l_att - l_sku_pri_incr) > 0)
3107: AND ((l_att - l_sku_pri_incr) <= l_max_pri_residual)
3108: THEN
3109: l_api_return_status := fnd_api.g_ret_sts_success;
3110: process_ctwt_adj(
3111: x_return_status => l_api_return_status

Line 3139: END IF; --} end if l_max_pri_residual > 0

3135: END IF;
3136: END IF;
3137: END IF;
3138:
3139: END IF; --} end if l_max_pri_residual > 0
3140:
3141: IF NVL(p_ccnt_sec_residual,'N') = 'Y' THEN --{
3142: --
3143: -- If the current transaction consumes the full primary

Line 3141: IF NVL(p_ccnt_sec_residual,'N') = 'Y' THEN --{

3137: END IF;
3138:
3139: END IF; --} end if l_max_pri_residual > 0
3140:
3141: IF NVL(p_ccnt_sec_residual,'N') = 'Y' THEN --{
3142: --
3143: -- If the current transaction consumes the full primary
3144: -- but leaves behind some secondary, this will get issued
3145: -- out via residual transaction. In such case we should

Line 3145: -- out via residual transaction. In such case we should

3141: IF NVL(p_ccnt_sec_residual,'N') = 'Y' THEN --{
3142: --
3143: -- If the current transaction consumes the full primary
3144: -- but leaves behind some secondary, this will get issued
3145: -- out via residual transaction. In such case we should
3146: -- create a cycle count entry for this SKU, since the
3147: -- that secondary qty represents actual physical onhand
3148: -- for fulfillment base secondary
3149: --

Line 3182: END IF; --} end if p_ccnt_sec_residual is Y

3178: RAISE fnd_api.g_exc_unexpected_error;
3179: END IF;
3180: END IF;
3181: END IF;
3182: END IF; --} end if p_ccnt_sec_residual is Y
3183: END LOOP; --} end loop through temp IDs
3184:
3185: IF l_pri_qty_to_incr > 0 THEN --{ increment rsv detailed qty
3186: t_proc_rsvs.DELETE;

Line 3259: END IF; --} end if +ve adj or residual primary txns or cycle count check required

3255: <>
3256: NULL;
3257: END LOOP; --} end loop through rsv IDs
3258: END IF; --} incr MR dtl qty if incr MMTT
3259: END IF; --} end if +ve adj or residual primary txns or cycle count check required
3260: END IF; --} end if qty adjustment or cycle count check required
3261: END IF; --} end if record source is MMTT
3262:
3263: -- End of API body

Line 3680: SELECT 1 INTO l_temp FROM DUAL

3676:
3677: -- Check LPN that all catch weight enabled items that are not defaultable have sec qty.
3678: -- bug 4918256 only for WDD lines that are part of sales orders (line_direction = 'O')
3679: BEGIN
3680: SELECT 1 INTO l_temp FROM DUAL
3681: WHERE EXISTS (
3682: SELECT 1
3683: FROM mtl_system_items msi,
3684: wsh_delivery_details wdd,

Line 3804: SELECT 1 INTO l_temp FROM DUAL

3800: l_return := G_CHECK_ERROR;
3801: END IF;
3802: ELSE -- Lot controlled item need to check MTLT for sec qty for
3803: BEGIN
3804: SELECT 1 INTO l_temp FROM DUAL
3805: WHERE EXISTS (
3806: SELECT 1
3807: FROM mtl_material_transactions_temp mmtt, mtl_transaction_lots_temp mtlt
3808: WHERE mmtt.organization_id = mmtt_item_rec.organization_id

Line 4368: , NVL(msiv.dual_uom_deviation_high,0)

4364: , NVL(msiv.lot_divisible_flag,'Y')
4365: , NVL(msiv.secondary_uom_code,'')
4366: , NVL(msiv.secondary_default_ind,'')
4367: , NVL(msiv.tracking_quantity_ind,'P')
4368: , NVL(msiv.dual_uom_deviation_high,0)
4369: , NVL(msiv.dual_uom_deviation_low,0)
4370: FROM mtl_system_items_kfv msiv,
4371: wms_lpn_contents wlc
4372: WHERE wlc.parent_lpn_id = p_lpn_id

Line 4369: , NVL(msiv.dual_uom_deviation_low,0)

4365: , NVL(msiv.secondary_uom_code,'')
4366: , NVL(msiv.secondary_default_ind,'')
4367: , NVL(msiv.tracking_quantity_ind,'P')
4368: , NVL(msiv.dual_uom_deviation_high,0)
4369: , NVL(msiv.dual_uom_deviation_low,0)
4370: FROM mtl_system_items_kfv msiv,
4371: wms_lpn_contents wlc
4372: WHERE wlc.parent_lpn_id = p_lpn_id
4373: AND wlc.organization_id = p_org_id

Line 4432: , NVL(msi.dual_uom_deviation_high,0)

4428: , NVL(msi.lot_divisible_flag,'Y')
4429: , NVL(msi.secondary_uom_code,'')
4430: , NVL(msi.secondary_default_ind,'')
4431: , NVL(msi.tracking_quantity_ind,'P')
4432: , NVL(msi.dual_uom_deviation_high,0)
4433: , NVL(msi.dual_uom_deviation_low,0)
4434: FROM mtl_system_items_kfv msi, wms_lpn_contents wlc
4435: WHERE wlc.parent_lpn_id = p_lpn_id
4436: AND wlc.inventory_item_id = msi.inventory_item_id

Line 4433: , NVL(msi.dual_uom_deviation_low,0)

4429: , NVL(msi.secondary_uom_code,'')
4430: , NVL(msi.secondary_default_ind,'')
4431: , NVL(msi.tracking_quantity_ind,'P')
4432: , NVL(msi.dual_uom_deviation_high,0)
4433: , NVL(msi.dual_uom_deviation_low,0)
4434: FROM mtl_system_items_kfv msi, wms_lpn_contents wlc
4435: WHERE wlc.parent_lpn_id = p_lpn_id
4436: AND wlc.inventory_item_id = msi.inventory_item_id
4437: AND wlc.organization_id = msi.organization_id

Line 4486: , NVL(msi.dual_uom_deviation_high,0)

4482: , NVL(msi.lot_divisible_flag,'Y')
4483: , NVL(msi.secondary_uom_code,'')
4484: , NVL(msi.secondary_default_ind,'')
4485: , NVL(msi.tracking_quantity_ind,'P')
4486: , NVL(msi.dual_uom_deviation_high,0)
4487: , NVL(msi.dual_uom_deviation_low,0)
4488: FROM mtl_system_items_kfv msi, mtl_material_transactions_temp mmtt
4489: WHERE (mmtt.content_lpn_id = p_lpn_id OR mmtt.transfer_lpn_id = p_lpn_id)
4490: AND mmtt.organization_id = p_org_id

Line 4487: , NVL(msi.dual_uom_deviation_low,0)

4483: , NVL(msi.secondary_uom_code,'')
4484: , NVL(msi.secondary_default_ind,'')
4485: , NVL(msi.tracking_quantity_ind,'P')
4486: , NVL(msi.dual_uom_deviation_high,0)
4487: , NVL(msi.dual_uom_deviation_low,0)
4488: FROM mtl_system_items_kfv msi, mtl_material_transactions_temp mmtt
4489: WHERE (mmtt.content_lpn_id = p_lpn_id OR mmtt.transfer_lpn_id = p_lpn_id)
4490: AND mmtt.organization_id = p_org_id
4491: AND mmtt.organization_id = msi.organization_id

Line 4545: , NVL(msi.dual_uom_deviation_high,0)

4541: , NVL(msi.lot_divisible_flag,'Y')
4542: , NVL(msi.secondary_uom_code,'')
4543: , NVL(msi.secondary_default_ind,'')
4544: , NVL(msi.tracking_quantity_ind,'P')
4545: , NVL(msi.dual_uom_deviation_high,0)
4546: , NVL(msi.dual_uom_deviation_low,0)
4547: FROM wms_license_plate_numbers wlpn,
4548: mtl_material_transactions_temp mmtt,
4549: mtl_system_items_kfv msi

Line 4546: , NVL(msi.dual_uom_deviation_low,0)

4542: , NVL(msi.secondary_uom_code,'')
4543: , NVL(msi.secondary_default_ind,'')
4544: , NVL(msi.tracking_quantity_ind,'P')
4545: , NVL(msi.dual_uom_deviation_high,0)
4546: , NVL(msi.dual_uom_deviation_low,0)
4547: FROM wms_license_plate_numbers wlpn,
4548: mtl_material_transactions_temp mmtt,
4549: mtl_system_items_kfv msi
4550: WHERE (mmtt.content_lpn_id = p_lpn_id OR mmtt.transfer_lpn_id = p_lpn_id)

Line 4608: , NVL(msi.dual_uom_deviation_high,0)

4604: , NVL(msi.lot_divisible_flag,'Y')
4605: , NVL(msi.secondary_uom_code,'')
4606: , NVL(msi.secondary_default_ind,'')
4607: , NVL(msi.tracking_quantity_ind,'P')
4608: , NVL(msi.dual_uom_deviation_high,0)
4609: , NVL(msi.dual_uom_deviation_low,0)
4610: FROM wms_lpn_contents wlc,
4611: mtl_system_items_kfv msi
4612: WHERE wlc.parent_lpn_id = p_lpn_id

Line 4609: , NVL(msi.dual_uom_deviation_low,0)

4605: , NVL(msi.secondary_uom_code,'')
4606: , NVL(msi.secondary_default_ind,'')
4607: , NVL(msi.tracking_quantity_ind,'P')
4608: , NVL(msi.dual_uom_deviation_high,0)
4609: , NVL(msi.dual_uom_deviation_low,0)
4610: FROM wms_lpn_contents wlc,
4611: mtl_system_items_kfv msi
4612: WHERE wlc.parent_lpn_id = p_lpn_id
4613: AND wlc.organization_id = p_org_id