DBA Data[Home] [Help]

APPS.CSI_ITEM_INSTANCE_PVT dependencies on MTL_MATERIAL_TRANSACTIONS

Line 5440: FROM mtl_material_transactions

5436: --Changes for bug 10114652
5437: IF(nvl(p_txn_rec.inv_material_transaction_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num) THEN
5438: BEGIN
5439: SELECT transaction_type_id INTO l_transaction_type_id
5440: FROM mtl_material_transactions
5441: WHERE transaction_id = p_txn_rec.inv_material_transaction_id;
5442: EXCEPTION
5443: WHEN NO_DATA_FOUND THEN
5444: csi_gen_utility_pvt.put_line('No data Found while fetching txn type id, from Inv Mtl txn id');

Line 13530: FROM mtl_material_transactions

13526: --Changes for bug 10114652
13527: IF(nvl(p_txn_rec.inv_material_transaction_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num) THEN
13528: BEGIN
13529: SELECT transaction_type_id INTO l_transaction_type_id
13530: FROM mtl_material_transactions
13531: WHERE transaction_id = p_txn_rec.inv_material_transaction_id;
13532: EXCEPTION
13533: WHEN NO_DATA_FOUND THEN
13534: csi_gen_utility_pvt.put_line('No data Found while fetching txn type id, from Inv Mtl txn id');