APPS.CSI_PROCESS_TXN_PVT dependencies on MTL_MATERIAL_TRANSACTIONS

Line 51: -- (SELECT TRANSACTION_TYPE_ID FROM MTL_MATERIAL_TRANSACTIONS

47: --SELECT 'Y' INTO p_serial_tagged FROM MTL_SERIAL_TAGGING_ASSIGNMENTS
48: -- WHERE INVENTORY_ITEM_ID = p_inventory_item_id
49: -- AND ORGANIZATION_ID = p_organization_id
50: -- AND TRANSACTION_TYPE_ID IN
51: -- (SELECT TRANSACTION_TYPE_ID FROM MTL_MATERIAL_TRANSACTIONS
52: -- WHERE TRANSACTION_ID = p_mtl_transaction_id);
53: SELECT TRANSACTION_TYPE_ID INTO l_mtl_txn_type_id FROM MTL_MATERIAL_TRANSACTIONS
54: WHERE TRANSACTION_ID = p_mtl_transaction_id;
55: ELSE

Line 53: SELECT TRANSACTION_TYPE_ID INTO l_mtl_txn_type_id FROM MTL_MATERIAL_TRANSACTIONS

49: -- AND ORGANIZATION_ID = p_organization_id
50: -- AND TRANSACTION_TYPE_ID IN
51: -- (SELECT TRANSACTION_TYPE_ID FROM MTL_MATERIAL_TRANSACTIONS
52: -- WHERE TRANSACTION_ID = p_mtl_transaction_id);
53: SELECT TRANSACTION_TYPE_ID INTO l_mtl_txn_type_id FROM MTL_MATERIAL_TRANSACTIONS
54: WHERE TRANSACTION_ID = p_mtl_transaction_id;
55: ELSE
56: l_mtl_txn_type_id := p_inv_txn_typeid_from_cs;
57: END IF;