DBA Data[Home] [Help]

APPS.WMS_TXNRSN_ACTIONS_PUB dependencies on INV_CONTROL

Line 1240: IF (inv_control.g_current_release_level >= inv_release.g_j_release_level)

1236: is not there on the MTRL. This is just hack on pick_release_pub as
1237: pick release being pblic api and is not designed to allocate a move order line with
1238: partial delivered qty on it. */
1239: -- Bug 3278170 fix is below patchset 'J' level
1240: IF (inv_control.g_current_release_level >= inv_release.g_j_release_level)
1241: THEN
1242: -- For patchset 'J'
1243: UPDATE mtl_txn_request_lines
1244: SET quantity_detailed = quantity_detailed - l_mol_delta_qty

Line 1380: IF (inv_control.g_current_release_level < inv_release.g_j_release_level)

1376: end if;
1377: /* BUG3278170 values quantity, quantity_delivered, quantity_detailed
1378: set on MTRL before calling pick relase api are reset.*/
1379: -- this fix is for below J patchset
1380: IF (inv_control.g_current_release_level < inv_release.g_j_release_level)
1381: THEN
1382: SELECT sum(transaction_quantity)
1383: INTO l_new_mmtt_qty
1384: FROM mtl_material_transactions_temp